eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_BUILD_INSTRUCTIONS_PUB_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 119


     /*-- selection criteria --*/
     p_calling_app_id             IN         VARCHAR2 DEFAULT NULL,
     p_calling_app_payreq_cd      IN         VARCHAR2 DEFAULT NULL,
     p_le_id                      IN         VARCHAR2 DEFAULT NULL,
     p_org_id                     IN         VARCHAR2 DEFAULT NULL,
     p_org_type                   IN         VARCHAR2 DEFAULT NULL,
     p_payment_from_date          IN         VARCHAR2 DEFAULT NULL,
     p_payment_to_date            IN         VARCHAR2 DEFAULT NULL,

     p_arg19  IN VARCHAR2 DEFAULT NULL,
     p_arg20  IN VARCHAR2 DEFAULT NULL, p_arg21  IN VARCHAR2 DEFAULT NULL,
     p_arg22  IN VARCHAR2 DEFAULT NULL, p_arg23  IN VARCHAR2 DEFAULT NULL,
     p_arg24  IN VARCHAR2 DEFAULT NULL, p_arg25  IN VARCHAR2 DEFAULT NULL,
     p_arg26  IN VARCHAR2 DEFAULT NULL, p_arg27  IN VARCHAR2 DEFAULT NULL,
     p_arg28  IN VARCHAR2 DEFAULT NULL, p_arg29  IN VARCHAR2 DEFAULT NULL,
     p_arg30  IN VARCHAR2 DEFAULT NULL, p_arg31  IN VARCHAR2 DEFAULT NULL,
     p_arg32  IN VARCHAR2 DEFAULT NULL, p_arg33  IN VARCHAR2 DEFAULT NULL,
     p_arg34  IN VARCHAR2 DEFAULT NULL, p_arg35  IN VARCHAR2 DEFAULT NULL,
     p_arg36  IN VARCHAR2 DEFAULT NULL, p_arg37  IN VARCHAR2 DEFAULT NULL,
     p_arg38  IN VARCHAR2 DEFAULT NULL, p_arg39  IN VARCHAR2 DEFAULT NULL,
     p_arg40  IN VARCHAR2 DEFAULT NULL, p_arg41  IN VARCHAR2 DEFAULT NULL,
     p_arg42  IN VARCHAR2 DEFAULT NULL, p_arg43  IN VARCHAR2 DEFAULT NULL,
     p_arg44  IN VARCHAR2 DEFAULT NULL, p_arg45  IN VARCHAR2 DEFAULT NULL,
     p_arg46  IN VARCHAR2 DEFAULT NULL, p_arg47  IN VARCHAR2 DEFAULT NULL,
     p_arg48  IN VARCHAR2 DEFAULT NULL, p_arg49  IN VARCHAR2 DEFAULT NULL,
     p_arg50  IN VARCHAR2 DEFAULT NULL, p_arg51  IN VARCHAR2 DEFAULT NULL,
     p_arg52  IN VARCHAR2 DEFAULT NULL, p_arg53  IN VARCHAR2 DEFAULT NULL,
     p_arg54  IN VARCHAR2 DEFAULT NULL, p_arg55  IN VARCHAR2 DEFAULT NULL,
     p_arg56  IN VARCHAR2 DEFAULT NULL, p_arg57  IN VARCHAR2 DEFAULT NULL,
     p_arg58  IN VARCHAR2 DEFAULT NULL, p_arg59  IN VARCHAR2 DEFAULT NULL,
     p_arg60  IN VARCHAR2 DEFAULT NULL, p_arg61  IN VARCHAR2 DEFAULT NULL,
     p_arg62  IN VARCHAR2 DEFAULT NULL, p_arg63  IN VARCHAR2 DEFAULT NULL,
     p_arg64  IN VARCHAR2 DEFAULT NULL, p_arg65  IN VARCHAR2 DEFAULT NULL,
     p_arg66  IN VARCHAR2 DEFAULT NULL, p_arg67  IN VARCHAR2 DEFAULT NULL,
     p_arg68  IN VARCHAR2 DEFAULT NULL, p_arg69  IN VARCHAR2 DEFAULT NULL,
     p_arg70  IN VARCHAR2 DEFAULT NULL, p_arg71  IN VARCHAR2 DEFAULT NULL,
     p_arg72  IN VARCHAR2 DEFAULT NULL, p_arg73  IN VARCHAR2 DEFAULT NULL,
     p_arg74  IN VARCHAR2 DEFAULT NULL, p_arg75  IN VARCHAR2 DEFAULT NULL,
     p_arg76  IN VARCHAR2 DEFAULT NULL, p_arg77  IN VARCHAR2 DEFAULT NULL,
     p_arg78  IN VARCHAR2 DEFAULT NULL, p_arg79  IN VARCHAR2 DEFAULT NULL,
     p_arg80  IN VARCHAR2 DEFAULT NULL, p_arg81  IN VARCHAR2 DEFAULT NULL,
     p_arg82  IN VARCHAR2 DEFAULT NULL, p_arg83  IN VARCHAR2 DEFAULT NULL,
     p_arg84  IN VARCHAR2 DEFAULT NULL, p_arg85  IN VARCHAR2 DEFAULT NULL,
     p_arg86  IN VARCHAR2 DEFAULT NULL, p_arg87  IN VARCHAR2 DEFAULT NULL,
     p_arg88  IN VARCHAR2 DEFAULT NULL, p_arg89  IN VARCHAR2 DEFAULT NULL,
     p_arg90  IN VARCHAR2 DEFAULT NULL, p_arg91  IN VARCHAR2 DEFAULT NULL,
     p_arg92  IN VARCHAR2 DEFAULT NULL, p_arg93  IN VARCHAR2 DEFAULT NULL,
     p_arg94  IN VARCHAR2 DEFAULT NULL, p_arg95  IN VARCHAR2 DEFAULT NULL,
     p_arg96  IN VARCHAR2 DEFAULT NULL, p_arg97  IN VARCHAR2 DEFAULT NULL,
     p_arg98  IN VARCHAR2 DEFAULT NULL, p_arg99  IN VARCHAR2 DEFAULT NULL,
     p_arg100 IN VARCHAR2 DEFAULT NULL
     )
 IS

 l_return_status  VARCHAR2 (100);

Line: 237


	         print_debuginfo(l_module_name, 'Provided selection criteria - ');

Line: 280


	                 print_debuginfo(l_module_name, 'Invalid selection '
	                     || 'criteria provided; calling app payment '

Line: 284


	                     || 'For selection by payment service request, '
	                     || 'the calling app id needs to be provided.'
	                     );

Line: 294


                      || 'SELECTION CRITERIA PROVIDED';

Line: 1038


              * Therefore, the payment instruction status needs to be updated.
              */
             l_instr_tab(l_instr_tab.COUNT + 1) := l_instr_rec;

Line: 1041


             IBY_PAYINSTR_PUB.updatePaymentInstructions(l_instr_tab);

Line: 1048


             IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',
                 l_doc_error_tab, l_doc_token_tab);

Line: 1730


             SELECT
                   send_to_file_flag, processing_type
               INTO
                   l_send_to_file_flag, l_processing_type
               FROM
                   IBY_PAYMENT_PROFILES
               WHERE
                   payment_profile_id = p_pmtInstrTab(i).payment_profile_id
               ;

Line: 1749


               UPDATE
                   IBY_PAY_INSTRUCTIONS_ALL
               SET
                   payment_instruction_status = l_instr_status
               WHERE
                   payment_instruction_id = p_pmtInstrTab(i).
                                                payment_instruction_id;

Line: 1758


	             print_debuginfo(l_module_name, 'Updated payment '
	                 || 'instruction '
	                 || p_pmtInstrTab(i).payment_instruction_id
	                 || ' to '
	                 || l_instr_status
	                 || ' status.'
	                 );

Line: 1769


              UPDATE
                   IBY_PAY_INSTRUCTIONS_ALL
               SET
                   payment_instruction_status = l_instr_status
               WHERE
                   payment_instruction_id = p_pmtInstrTab(i).
                                                payment_instruction_id;

Line: 1778


	             print_debuginfo(l_module_name, 'Updated payment '
	                 || 'instruction '
	                 || p_pmtInstrTab(i).payment_instruction_id
	                 || ' to '
	                 || l_instr_status
	                 || ' status.'
	                 );

Line: 1845


     SELECT
         payment_service_request_id
     INTO
         l_payreq_id
     FROM
         IBY_PAY_SERVICE_REQUESTS
     WHERE
         calling_app_id = l_ca_id
     AND
         call_app_pay_service_req_code = l_ca_payreq_cd;

Line: 1919


     SELECT
         payment_document_id
     INTO
         l_paydoc_id
     FROM
         IBY_PAY_SERVICE_REQUESTS
     WHERE
         payment_service_request_id = l_payreq_id;

Line: 1991


     SELECT
         internal_bank_account_id
     INTO
         l_int_bank_acct_id
     FROM
         IBY_PAY_SERVICE_REQUESTS
     WHERE
         payment_service_request_id = l_payreq_id;

Line: 2059


     SELECT
         payment_instruction_id,
         payment_profile_id,
         process_type,
         payment_instruction_status,
         payments_complete_code,
         generate_sep_remit_advice_flag,
         remittance_advice_created_flag,
         regulatory_report_created_flag,
         bill_payable_flag,
         legal_entity_id,
         payment_count,
         positive_pay_file_created_flag,
         print_instruction_immed_flag,
         transmit_instr_immed_flag,
         created_by,
         creation_date,
         last_updated_by,
         last_update_date,
         last_update_login,
         object_version_number,
         internal_bank_account_id,
         pay_admin_assigned_ref_code,
         transmission_date,
         acknowledgement_date,
         comments,
         bank_assigned_ref_code,
         org_id,
         org_type,
         payment_date,
         payment_currency_code,
         payment_service_request_id,
         payment_function,
         payment_reason_code,
         rfc_identifier,
         payment_reason_comments,
         payment_document_id,
         printer_name,
         attribute_category,
         attribute1,
         attribute2,
         attribute3,
         attribute4,
         attribute5,
         attribute6,
         attribute7,
         attribute8,
         attribute9,
         attribute10,
         attribute11,
         attribute12,
         attribute13,
         attribute14,
         attribute15
     INTO
         l_instr_rec.payment_instruction_id,
         l_instr_rec.payment_profile_id,
         l_instr_rec.process_type,
         l_instr_rec.payment_instruction_status,
         l_instr_rec.payments_complete_code,
         l_instr_rec.generate_sep_remit_advice_flag,
         l_instr_rec.remittance_advice_created_flag,
         l_instr_rec.regulatory_report_created_flag,
         l_instr_rec.bill_payable_flag,
         l_instr_rec.legal_entity_id,
         l_instr_rec.payment_count,
         l_instr_rec.positive_pay_file_created_flag,
         l_instr_rec.print_instruction_immed_flag,
         l_instr_rec.transmit_instr_immed_flag,
         l_instr_rec.created_by,
         l_instr_rec.creation_date,
         l_instr_rec.last_updated_by,
         l_instr_rec.last_update_date,
         l_instr_rec.last_update_login,
         l_instr_rec.object_version_number,
         l_instr_rec.internal_bank_account_id,
         l_instr_rec.pay_admin_assigned_ref_code,
         l_instr_rec.transmission_date,
         l_instr_rec.acknowledgement_date,
         l_instr_rec.comments,
         l_instr_rec.bank_assigned_ref_code,
         l_instr_rec.org_id,
         l_instr_rec.org_type,
         l_instr_rec.payment_date,
         l_instr_rec.payment_currency_code,
         l_instr_rec.payment_service_request_id,
         l_instr_rec.payment_function,
         l_instr_rec.payment_reason_code,
         l_instr_rec.rfc_identifier,
         l_instr_rec.payment_reason_comments,
         l_instr_rec.payment_document_id,
         l_instr_rec.printer_name,
         l_instr_rec.attribute_category,
         l_instr_rec.attribute1,
         l_instr_rec.attribute2,
         l_instr_rec.attribute3,
         l_instr_rec.attribute4,
         l_instr_rec.attribute5,
         l_instr_rec.attribute6,
         l_instr_rec.attribute7,
         l_instr_rec.attribute8,
         l_instr_rec.attribute9,
         l_instr_rec.attribute10,
         l_instr_rec.attribute11,
         l_instr_rec.attribute12,
         l_instr_rec.attribute13,
         l_instr_rec.attribute14,
         l_instr_rec.attribute15
     FROM
         IBY_PAY_INSTRUCTIONS_ALL
     WHERE
         payment_instruction_id = l_pmt_instr_id
     ;

Line: 2267


     /*-- selection criteria --*/
     p_payment_profile_id         IN         VARCHAR2 DEFAULT NULL,
     p_payment_currency           IN         VARCHAR2 DEFAULT NULL,
     p_internal_bank_account_id   IN         VARCHAR2 DEFAULT NULL,
     p_payment_document_id    	  IN         VARCHAR2 DEFAULT NULL, --Bug 11059189
     p_calling_app_id             IN         VARCHAR2 DEFAULT NULL,
     p_calling_app_payreq_cd      IN         VARCHAR2 DEFAULT NULL,
     p_le_id                      IN         VARCHAR2 DEFAULT NULL,
     p_org_type                   IN         VARCHAR2 DEFAULT NULL,
     p_org_id                     IN         VARCHAR2 DEFAULT NULL,
     p_payment_from_date          IN         VARCHAR2 DEFAULT NULL,
     p_payment_to_date            IN         VARCHAR2 DEFAULT NULL,
     p_transmit_now_flag          IN         VARCHAR2 DEFAULT NULL,
     p_sys_key  IN VARCHAR2 DEFAULT NULL, p_arg17  IN VARCHAR2 DEFAULT NULL,
     p_arg18  IN VARCHAR2 DEFAULT NULL, p_arg19  IN VARCHAR2 DEFAULT NULL,
     p_arg20  IN VARCHAR2 DEFAULT NULL, p_arg21  IN VARCHAR2 DEFAULT NULL,
     p_arg22  IN VARCHAR2 DEFAULT NULL, p_arg23  IN VARCHAR2 DEFAULT NULL,
     p_arg24  IN VARCHAR2 DEFAULT NULL, p_arg25  IN VARCHAR2 DEFAULT NULL,
     p_arg26  IN VARCHAR2 DEFAULT NULL, p_arg27  IN VARCHAR2 DEFAULT NULL,
     p_arg28  IN VARCHAR2 DEFAULT NULL, p_arg29  IN VARCHAR2 DEFAULT NULL,
     p_arg30  IN VARCHAR2 DEFAULT NULL, p_arg31  IN VARCHAR2 DEFAULT NULL,
     p_arg32  IN VARCHAR2 DEFAULT NULL, p_arg33  IN VARCHAR2 DEFAULT NULL,
     p_arg34  IN VARCHAR2 DEFAULT NULL, p_arg35  IN VARCHAR2 DEFAULT NULL,
     p_arg36  IN VARCHAR2 DEFAULT NULL, p_arg37  IN VARCHAR2 DEFAULT NULL,
     p_arg38  IN VARCHAR2 DEFAULT NULL, p_arg39  IN VARCHAR2 DEFAULT NULL,
     p_arg40  IN VARCHAR2 DEFAULT NULL, p_arg41  IN VARCHAR2 DEFAULT NULL,
     p_arg42  IN VARCHAR2 DEFAULT NULL, p_arg43  IN VARCHAR2 DEFAULT NULL,
     p_arg44  IN VARCHAR2 DEFAULT NULL, p_arg45  IN VARCHAR2 DEFAULT NULL,
     p_arg46  IN VARCHAR2 DEFAULT NULL, p_arg47  IN VARCHAR2 DEFAULT NULL,
     p_arg48  IN VARCHAR2 DEFAULT NULL, p_arg49  IN VARCHAR2 DEFAULT NULL,
     p_arg50  IN VARCHAR2 DEFAULT NULL, p_arg51  IN VARCHAR2 DEFAULT NULL,
     p_arg52  IN VARCHAR2 DEFAULT NULL, p_arg53  IN VARCHAR2 DEFAULT NULL,
     p_arg54  IN VARCHAR2 DEFAULT NULL, p_arg55  IN VARCHAR2 DEFAULT NULL,
     p_arg56  IN VARCHAR2 DEFAULT NULL, p_arg57  IN VARCHAR2 DEFAULT NULL,
     p_arg58  IN VARCHAR2 DEFAULT NULL, p_arg59  IN VARCHAR2 DEFAULT NULL,
     p_arg60  IN VARCHAR2 DEFAULT NULL, p_arg61  IN VARCHAR2 DEFAULT NULL,
     p_arg62  IN VARCHAR2 DEFAULT NULL, p_arg63  IN VARCHAR2 DEFAULT NULL,
     p_arg64  IN VARCHAR2 DEFAULT NULL, p_arg65  IN VARCHAR2 DEFAULT NULL,
     p_arg66  IN VARCHAR2 DEFAULT NULL, p_arg67  IN VARCHAR2 DEFAULT NULL,
     p_arg68  IN VARCHAR2 DEFAULT NULL, p_arg69  IN VARCHAR2 DEFAULT NULL,
     p_arg70  IN VARCHAR2 DEFAULT NULL, p_arg71  IN VARCHAR2 DEFAULT NULL,
     p_arg72  IN VARCHAR2 DEFAULT NULL, p_arg73  IN VARCHAR2 DEFAULT NULL,
     p_arg74  IN VARCHAR2 DEFAULT NULL, p_arg75  IN VARCHAR2 DEFAULT NULL,
     p_arg76  IN VARCHAR2 DEFAULT NULL, p_arg77  IN VARCHAR2 DEFAULT NULL,
     p_arg78  IN VARCHAR2 DEFAULT NULL, p_arg79  IN VARCHAR2 DEFAULT NULL,
     p_arg80  IN VARCHAR2 DEFAULT NULL, p_arg81  IN VARCHAR2 DEFAULT NULL,
     p_arg82  IN VARCHAR2 DEFAULT NULL, p_arg83  IN VARCHAR2 DEFAULT NULL,
     p_arg84  IN VARCHAR2 DEFAULT NULL, p_arg85  IN VARCHAR2 DEFAULT NULL,
     p_arg86  IN VARCHAR2 DEFAULT NULL, p_arg87  IN VARCHAR2 DEFAULT NULL,
     p_arg88  IN VARCHAR2 DEFAULT NULL, p_arg89  IN VARCHAR2 DEFAULT NULL,
     p_arg90  IN VARCHAR2 DEFAULT NULL, p_arg91  IN VARCHAR2 DEFAULT NULL,
     p_arg92  IN VARCHAR2 DEFAULT NULL, p_arg93  IN VARCHAR2 DEFAULT NULL,
     p_arg94  IN VARCHAR2 DEFAULT NULL, p_arg95  IN VARCHAR2 DEFAULT NULL,
     p_arg96  IN VARCHAR2 DEFAULT NULL, p_arg97  IN VARCHAR2 DEFAULT NULL,
     p_arg98  IN VARCHAR2 DEFAULT NULL, p_arg99  IN VARCHAR2 DEFAULT NULL,
     p_arg100 IN VARCHAR2 DEFAULT NULL
     )
 IS
 l_module_name    VARCHAR2(200) := G_PKG_NAME
                                       || '.build_electronic_instructions';

Line: 2354


         /*-- selection criteria --*/
         p_calling_app_id,
         p_calling_app_payreq_cd,
         p_le_id,
         p_org_id,
         p_org_type,
         p_payment_from_date,
         p_payment_to_date
         );

Line: 2401


     /*-- selection criteria --*/
     p_payment_profile_id         IN         VARCHAR2 DEFAULT NULL,
     p_payment_currency           IN         VARCHAR2 DEFAULT NULL,
     p_internal_bank_account_id   IN         VARCHAR2 DEFAULT NULL,
     p_pmt_document_id            IN         VARCHAR2 DEFAULT NULL,
     p_calling_app_id             IN         VARCHAR2 DEFAULT NULL,
     p_calling_app_payreq_cd      IN         VARCHAR2 DEFAULT NULL,
     p_le_id                      IN         VARCHAR2 DEFAULT NULL,
     p_org_type                   IN         VARCHAR2 DEFAULT NULL,
     p_org_id                     IN         VARCHAR2 DEFAULT NULL,
     p_payment_from_date          IN         VARCHAR2 DEFAULT NULL,
     p_payment_to_date            IN         VARCHAR2 DEFAULT NULL,
     p_print_now_flag             IN         VARCHAR2 DEFAULT NULL,
     p_printer_name               IN         VARCHAR2 DEFAULT NULL,

     p_sys_key  IN VARCHAR2 DEFAULT NULL, p_arg19  IN VARCHAR2 DEFAULT NULL,
     p_arg20  IN VARCHAR2 DEFAULT NULL, p_arg21  IN VARCHAR2 DEFAULT NULL,
     p_arg22  IN VARCHAR2 DEFAULT NULL, p_arg23  IN VARCHAR2 DEFAULT NULL,
     p_arg24  IN VARCHAR2 DEFAULT NULL, p_arg25  IN VARCHAR2 DEFAULT NULL,
     p_arg26  IN VARCHAR2 DEFAULT NULL, p_arg27  IN VARCHAR2 DEFAULT NULL,
     p_arg28  IN VARCHAR2 DEFAULT NULL, p_arg29  IN VARCHAR2 DEFAULT NULL,
     p_arg30  IN VARCHAR2 DEFAULT NULL, p_arg31  IN VARCHAR2 DEFAULT NULL,
     p_arg32  IN VARCHAR2 DEFAULT NULL, p_arg33  IN VARCHAR2 DEFAULT NULL,
     p_arg34  IN VARCHAR2 DEFAULT NULL, p_arg35  IN VARCHAR2 DEFAULT NULL,
     p_arg36  IN VARCHAR2 DEFAULT NULL, p_arg37  IN VARCHAR2 DEFAULT NULL,
     p_arg38  IN VARCHAR2 DEFAULT NULL, p_arg39  IN VARCHAR2 DEFAULT NULL,
     p_arg40  IN VARCHAR2 DEFAULT NULL, p_arg41  IN VARCHAR2 DEFAULT NULL,
     p_arg42  IN VARCHAR2 DEFAULT NULL, p_arg43  IN VARCHAR2 DEFAULT NULL,
     p_arg44  IN VARCHAR2 DEFAULT NULL, p_arg45  IN VARCHAR2 DEFAULT NULL,
     p_arg46  IN VARCHAR2 DEFAULT NULL, p_arg47  IN VARCHAR2 DEFAULT NULL,
     p_arg48  IN VARCHAR2 DEFAULT NULL, p_arg49  IN VARCHAR2 DEFAULT NULL,
     p_arg50  IN VARCHAR2 DEFAULT NULL, p_arg51  IN VARCHAR2 DEFAULT NULL,
     p_arg52  IN VARCHAR2 DEFAULT NULL, p_arg53  IN VARCHAR2 DEFAULT NULL,
     p_arg54  IN VARCHAR2 DEFAULT NULL, p_arg55  IN VARCHAR2 DEFAULT NULL,
     p_arg56  IN VARCHAR2 DEFAULT NULL, p_arg57  IN VARCHAR2 DEFAULT NULL,
     p_arg58  IN VARCHAR2 DEFAULT NULL, p_arg59  IN VARCHAR2 DEFAULT NULL,
     p_arg60  IN VARCHAR2 DEFAULT NULL, p_arg61  IN VARCHAR2 DEFAULT NULL,
     p_arg62  IN VARCHAR2 DEFAULT NULL, p_arg63  IN VARCHAR2 DEFAULT NULL,
     p_arg64  IN VARCHAR2 DEFAULT NULL, p_arg65  IN VARCHAR2 DEFAULT NULL,
     p_arg66  IN VARCHAR2 DEFAULT NULL, p_arg67  IN VARCHAR2 DEFAULT NULL,
     p_arg68  IN VARCHAR2 DEFAULT NULL, p_arg69  IN VARCHAR2 DEFAULT NULL,
     p_arg70  IN VARCHAR2 DEFAULT NULL, p_arg71  IN VARCHAR2 DEFAULT NULL,
     p_arg72  IN VARCHAR2 DEFAULT NULL, p_arg73  IN VARCHAR2 DEFAULT NULL,
     p_arg74  IN VARCHAR2 DEFAULT NULL, p_arg75  IN VARCHAR2 DEFAULT NULL,
     p_arg76  IN VARCHAR2 DEFAULT NULL, p_arg77  IN VARCHAR2 DEFAULT NULL,
     p_arg78  IN VARCHAR2 DEFAULT NULL, p_arg79  IN VARCHAR2 DEFAULT NULL,
     p_arg80  IN VARCHAR2 DEFAULT NULL, p_arg81  IN VARCHAR2 DEFAULT NULL,
     p_arg82  IN VARCHAR2 DEFAULT NULL, p_arg83  IN VARCHAR2 DEFAULT NULL,
     p_arg84  IN VARCHAR2 DEFAULT NULL, p_arg85  IN VARCHAR2 DEFAULT NULL,
     p_arg86  IN VARCHAR2 DEFAULT NULL, p_arg87  IN VARCHAR2 DEFAULT NULL,
     p_arg88  IN VARCHAR2 DEFAULT NULL, p_arg89  IN VARCHAR2 DEFAULT NULL,
     p_arg90  IN VARCHAR2 DEFAULT NULL, p_arg91  IN VARCHAR2 DEFAULT NULL,
     p_arg92  IN VARCHAR2 DEFAULT NULL, p_arg93  IN VARCHAR2 DEFAULT NULL,
     p_arg94  IN VARCHAR2 DEFAULT NULL, p_arg95  IN VARCHAR2 DEFAULT NULL,
     p_arg96  IN VARCHAR2 DEFAULT NULL, p_arg97  IN VARCHAR2 DEFAULT NULL,
     p_arg98  IN VARCHAR2 DEFAULT NULL, p_arg99  IN VARCHAR2 DEFAULT NULL,
     p_arg100 IN VARCHAR2 DEFAULT NULL
     )
 IS
 l_module_name    VARCHAR2(200) := G_PKG_NAME
                                       || '.build_printed_instructions';

Line: 2490


         /*-- selection criteria --*/
         p_calling_app_id,
         p_calling_app_payreq_cd,
         p_le_id,
         p_org_id,
         p_org_type,
         p_payment_from_date,
         p_payment_to_date
         );