This discussion is archived
1 Reply Latest reply: Aug 13, 2013 12:01 AM by SanketZ RSS

Passing parameter for the Concurrent request in Web Adi

662449 Newbie
Currently Being Moderated
Hi all,

I have developed a custom integrator for Batch Element Entries in Web Adi.

Now i am using a wrapper procedure which creates batch header, batch lines. This procedure also has an OUT parameter BATCH_ID, which will give the batch id generated at the end of the proc.

After the Batch header and line is created this Batch Id would be generated which would be used by the concurrent program to do the validation in the interface tables.

I need to pass the Batch Id to the concurrent program parameter.
Right now i have hard coded Batch Id in the import parameter list to test the setup.

But i would like to get the value of batch ID from the OUT parameter of the procedure used in the interface.

Any idea as to how to do this?
  • 1. Re: Passing parameter for the Concurrent request in Web Adi
    SanketZ Newbie
    Currently Being Moderated

    Hi,

     

    Check the below insert script.

     

    BEGIN

    Insert into BNE_ATTRIBUTES

       (APPLICATION_ID, ATTRIBUTE_CODE, OBJECT_VERSION_NUMBER, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ_P1_ATT', 28, 'APPLICATION', 'VARCHAR2', 'IN', 'N', '''LLPA''', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_ATTRIBUTES

       (APPLICATION_ID, ATTRIBUTE_CODE, OBJECT_VERSION_NUMBER, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ_P2_ATT', 28, 'PROGRAM', 'VARCHAR2', 'IN', 'N', '''LLPAEXPWF''', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_ATTRIBUTES

       (APPLICATION_ID, ATTRIBUTE_CODE, OBJECT_VERSION_NUMBER, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

           (20025, 'LL014_IMP_CONC_REQ_P3_ATT', 28, 'DESCRIPTION', 'VARCHAR2', 'IN', 'N', '''''', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_ATTRIBUTES

       (APPLICATION_ID, ATTRIBUTE_CODE, OBJECT_VERSION_NUMBER, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ_P4_ATT', 28, 'RUN_DATE', 'VARCHAR2', 'IN', 'N', '''''', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_ATTRIBUTES

       (APPLICATION_ID, ATTRIBUTE_CODE, OBJECT_VERSION_NUMBER, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ_P5_ATT', 28, 'SUB_REQUEST', 'BOOLEAN', 'IN', 'N', 'FALSE', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    --

    Insert into BNE_ATTRIBUTES

       (APPLICATION_ID, ATTRIBUTE_CODE, OBJECT_VERSION_NUMBER, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE7, ATTRIBUTE8, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ_P6_ATT', 28, 'BATCH_ID', 'NUMBER', 'IN', 'N', 'IMPORT', 'START_PROCESS.REQUISITION_HEADER_ID', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

     

     

     

     

    /*

    Insert into BNE_ATTRIBUTES

       (APPLICATION_ID, ATTRIBUTE_CODE, OBJECT_VERSION_NUMBER, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE7, ATTRIBUTE8, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL015_IMP_CONC_REQ_P7_ATT', 28, 'ORG_ID', 'NUMBER', 'IN', 'N', 'IMPORT', 'START_PROCESS.ORG_ID', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_ATTRIBUTES

       (APPLICATION_ID, ATTRIBUTE_CODE, OBJECT_VERSION_NUMBER, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE7, ATTRIBUTE8, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20004, 'LL015_IMP_CONC_REQ_P8_ATT', 28, 'TRANSACTION_SOURCE', 'VARCHAR2', 'IN', 'N', 'IMPORT', 'START_PROCESS.TRANSACTION_SOURCE', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_ATTRIBUTES

       (APPLICATION_ID, ATTRIBUTE_CODE, OBJECT_VERSION_NUMBER, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE7, ATTRIBUTE8, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20004, 'LL015_IMP_CONC_REQ_P9_ATT', 28, 'BATCH_NAME', 'VARCHAR2', 'IN', 'N', 'IMPORT', 'START_PROCESS.BATCH_NAME', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_ATTRIBUTES

       (APPLICATION_ID, ATTRIBUTE_CODE, OBJECT_VERSION_NUMBER, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20004, 'LL015_IMP_CONC_REQ_P10_ATT', 28, 'END', 'VARCHAR2', 'IN', 'N', 'CHR(0)', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_ATTRIBUTES

       (APPLICATION_ID, ATTRIBUTE_CODE, OBJECT_VERSION_NUMBER, ATTRIBUTE1, ATTRIBUTE2, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20004, 'LL015_IMP_CONC_REQ_P11_ATT', 28, '''''', '91', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

     

     

       */

    END;

     

     

     

     

    ----

    BEGIN

     

     

     

     

    Insert into BNE_PARAM_LISTS_B

       (APPLICATION_ID, PARAM_LIST_CODE, OBJECT_VERSION_NUMBER, PERSISTENT_FLAG, COMMENTS, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMPORT', 2, 'Y', 'LL: PO Pay Item Upload Interface', -1, TO_DATE('03/15/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('03/15/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

     

     

      

    Insert into BNE_PARAM_LISTS_B

       (APPLICATION_ID, PARAM_LIST_CODE, OBJECT_VERSION_NUMBER, PERSISTENT_FLAG, COMMENTS, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 1, 'Y', 'LL: PO Pay Item Upload Interface', -1, TO_DATE('03/15/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('03/15/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

     

     

    END;

     

     

     

     

    BEGIN

     

     

    Insert into BNE_PARAM_LISTS_TL

       (APPLICATION_ID, PARAM_LIST_CODE, LANGUAGE, SOURCE_LANG, USER_NAME, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMPORT', 'US', 'US', 'LL: PO Pay Item Upload Interface', -1, TO_DATE('03/15/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('03/15/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

     

     

     

     

    Insert into BNE_PARAM_LISTS_TL

       (APPLICATION_ID, PARAM_LIST_CODE, LANGUAGE, SOURCE_LANG, USER_NAME, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 'US', 'US', 'LL: PO Pay Item Upload Interface', -1, TO_DATE('03/15/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('03/15/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

     

     

      

    END;

     

     

     

     

    BEGIN

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_NAME, STRING_VALUE, DESC_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMPORT', 1, 1, 'CONCURRENT_REQUEST', '20025:LL014_IMP_CONC_REQ', 'Submit request - LL: PO Pay Item Upload Interface', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_DEFN_APP_ID, PARAM_DEFN_CODE, PARAM_NAME, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMPORT', 2, 1, 20025, 'LL014_SUCCESS_MESSAGE', 'SUCCESS_MESSAGE', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 1, 1, 'Application', 20025, 'LL014_IMP_CONC_REQ_P1_ATT', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 2, 1, 'Program', 20025, 'LL014_IMP_CONC_REQ_P2_ATT', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 3, 1, 'Description', 20025, 'LL014_IMP_CONC_REQ_P3_ATT', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 4, 1, 'Run Date', 20025, 'LL014_IMP_CONC_REQ_P4_ATT', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 5, 1, 'Sub request', 20025, 'LL014_IMP_CONC_REQ_P5_ATT', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 6, 1, 'Batch Id', 20025, 'LL014_IMP_CONC_REQ_P6_ATT', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

     

     

    /*

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 7, 1, 'Org Id', 20025, 'LL014_IMP_CONC_REQ_P7_ATT', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 8, 1, 'Transaction Source', 20025, 'LL014_IMP_CONC_REQ_P8_ATT', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 9, 1, 'Batch Name', 20025, 'LL014_IMP_CONC_REQ_P9_ATT', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    */

     

     

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 10, 1, 'End Of Concurrent Request Parameters', 20025, 'LL014_IMP_CONC_REQ_P10_ATT', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_PARAM_LIST_ITEMS

       (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMP_CONC_REQ', 11, 1, 'Rest of Parameters Defaults', 20025, 'LL014_IMP_CONC_REQ_P11_ATT', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    END;

     

     

    BEGIN

    Insert into BNE_PARAM_DEFNS_B

       (APPLICATION_ID, PARAM_DEFN_CODE, OBJECT_VERSION_NUMBER, PARAM_NAME, PARAM_SOURCE, PARAM_CATEGORY, DATATYPE, DEFAULT_REQUIRED_FLAG, DEFAULT_VISIBLE_FLAG, DEFAULT_USER_MODIFYABLE_FLAG, DEFAULT_BOOLEAN_FLAG, VAL_TYPE, MAX_SIZE, DISPLAY_TYPE, DISPLAY_STYLE, DISPLAY_SIZE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMPORT', 3, 'bne:import', 'WEBADI:Upload', 6, 4, 'N', 'Y', 'Y', 'Y', '1', 100, 1, 1, 100, -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_PARAM_DEFNS_B

       (APPLICATION_ID, PARAM_DEFN_CODE, OBJECT_VERSION_NUMBER, PARAM_NAME, PARAM_SOURCE, PARAM_CATEGORY, DATATYPE, DEFAULT_REQUIRED_FLAG, DEFAULT_VISIBLE_FLAG, DEFAULT_USER_MODIFYABLE_FLAG, VAL_TYPE, MAX_SIZE, DISPLAY_TYPE, DISPLAY_STYLE, DISPLAY_SIZE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_SUCCESS_MESSAGE', 2, 'Success Message', 'WEBADI:ImporterSuccess', 5, 1, 'Y', 'Y', 'Y', '1', 100, 3, 1, 100, -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    END;

     

     

     

     

    BEGIN

    Insert into BNE_PARAM_DEFNS_TL

       (APPLICATION_ID, PARAM_DEFN_CODE, LANGUAGE, SOURCE_LANG, USER_NAME, DEFAULT_DESC, PROMPT_LEFT, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_IMPORT', 'US', 'US', 'bne:import', 'start', 'Submit Concurrent Request - LL: PO Pay Item Upload Interface', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    Insert into BNE_PARAM_DEFNS_TL

       (APPLICATION_ID, PARAM_DEFN_CODE, LANGUAGE, SOURCE_LANG, USER_NAME, DEFAULT_STRING, DEFAULT_DESC, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

    Values

       (20025, 'LL014_SUCCESS_MESSAGE', 'US', 'US', 'LL015 SUCCESS MESSAGE', 'LL: PO Pay Item Upload Interface - Request ID $import$.requestid', 'Success Message returned upon successful import', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

    END;

     

     

     

     

    update bne_integrators_b

         set IMPORT_PARAM_LIST_APP_ID = 20025,

             IMPORT_PARAM_LIST_CODE = 'LL014_IMPORT',

             IMPORT_TYPE = 1

      where integrator_code = 'LLPOPAY1_XINTG';

      

      

    select * from bne_interface_cols_b where application_id=20025

     

     

    SELECT * FROM bne_integrators_b WHERE application_id=20025  

     

    I am passing the batch_id from the webadi excel to the concurrent program which is getting triggered after the webadi upload.

     

    Regards,

    Sanket

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points