APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on CE_PAYMENT_DOCUMENTS

Line 1684: CE_PAYMENT_DOCUMENTS

1680: * Done per bug 6852606
1681: */
1682: print_debuginfo(l_module_name, 'Trying to unlock the payment document as PI termination: ');
1683: UPDATE
1684: CE_PAYMENT_DOCUMENTS
1685: SET
1686: payment_instruction_id = NULL,
1687: /* Bug 6707369
1688: * If some of the documents are skipped, the payment

Line 2281: CE_PAYMENT_DOCUMENTS

2277: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2278: print_debuginfo(l_module_name, 'Trying to unlock the payment document as PI termination: ');
2279: END IF;
2280: UPDATE
2281: CE_PAYMENT_DOCUMENTS
2282: SET
2283: payment_instruction_id = NULL,
2284: /* Bug 6707369
2285: * If some of the documents are skipped, the payment

Line 2827: CE_PAYMENT_DOCUMENTS

2823: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2824: print_debuginfo(l_module_name, 'Trying to unlock the payment document as PI termination: ');
2825: END IF;
2826: UPDATE
2827: CE_PAYMENT_DOCUMENTS
2828: SET
2829: payment_instruction_id = NULL,
2830: /* Bug 6707369
2831: * If some of the documents are skipped, the payment

Line 3688: CE_PAYMENT_DOCUMENTS

3684: l_first_avail_check_num,
3685: l_last_avail_check_num,
3686: l_pmt_doc_name
3687: FROM
3688: CE_PAYMENT_DOCUMENTS
3689: WHERE
3690: payment_document_id = p_payment_doc_id
3691: ;
3692:

Line 3701: || ' was found in CE_PAYMENT_DOCUMENTS table.'

3697: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3698: print_debuginfo(l_module_name, 'No payment document '
3699: || 'with payment document id '
3700: || p_payment_doc_id
3701: || ' was found in CE_PAYMENT_DOCUMENTS table.'
3702: );
3703:
3704: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
3705: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);

Line 4230: CE_PAYMENT_DOCUMENTS

4226: payment_document_name, payment_instruction_id
4227: INTO
4228: l_pmt_doc_name, l_pmt_instr_id
4229: FROM
4230: CE_PAYMENT_DOCUMENTS
4231: WHERE
4232: payment_document_id = p_payment_doc_id;
4233: EXCEPTION
4234:

Line 4241: || ' was found in CE_PAYMENT_DOCUMENTS table.'

4237: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4238: print_debuginfo(l_module_name, 'No payment document '
4239: || 'with payment document id '
4240: || p_payment_doc_id
4241: || ' was found in CE_PAYMENT_DOCUMENTS table.'
4242: );
4243:
4244: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
4245: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);

Line 4367: CE_PAYMENT_DOCUMENTS

4363: payment_document_name
4364: INTO
4365: l_pmt_doc_name_dup
4366: FROM
4367: CE_PAYMENT_DOCUMENTS
4368: WHERE
4369: payment_document_id = p_payment_doc_id
4370: FOR UPDATE SKIP LOCKED;
4371: EXCEPTION

Line 4937: FROM ce_payment_documents WHERE payment_instruction_id = p_instr_id;

4933: /*Modified for Bug 7325373*/
4934: BEGIN
4935: BEGIN
4936: SELECT last_issued_document_number INTO l_last_issued
4937: FROM ce_payment_documents WHERE payment_instruction_id = p_instr_id;
4938: EXCEPTION
4939: WHEN No_Data_Found THEN
4940: l_document_locked := FALSE;
4941: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4964: CE_PAYMENT_DOCUMENTS

4960: RAISE l_irregular_document_numbers;
4961: END IF;
4962:
4963: UPDATE
4964: CE_PAYMENT_DOCUMENTS
4965: SET
4966: last_issued_document_number = l_last_issued_modified
4967: WHERE
4968: payment_instruction_id = p_instr_id

Line 5037: CE_PAYMENT_DOCUMENTS

5033: /* Unlocking the payment document*/
5034: BEGIN
5035:
5036: UPDATE
5037: CE_PAYMENT_DOCUMENTS
5038: SET
5039: payment_instruction_id = NULL
5040: WHERE
5041: payment_instruction_id = p_instr_id

Line 6740: * in CE_PAYMENT_DOCUMENTS table using the

6736: *
6737: * Fix for bug 5470041:
6738: *
6739: * Update the last issued document number
6740: * in CE_PAYMENT_DOCUMENTS table using the
6741: * greatest document number from the user
6742: * provided list of new document numbers
6743: * for reprinting.
6744: */

Line 6772: CE_PAYMENT_DOCUMENTS

6768: * provided list contains a doc number greater
6769: * than what is already stored in the database.
6770: */
6771: UPDATE
6772: CE_PAYMENT_DOCUMENTS
6773: SET
6774: last_issued_document_number =
6775: GREATEST(l_last_list_num, last_issued_document_number)
6776: WHERE

Line 9852: CE_PAYMENT_DOCUMENTS

9848: iby_debug_pub.log(debug_msg => 'Exit Paper Document Numbering: Timestamp:' || systimestamp,
9849: debug_level => FND_LOG.LEVEL_PROCEDURE,
9850: module => l_module_name);
9851: UPDATE
9852: CE_PAYMENT_DOCUMENTS
9853: SET
9854: payment_instruction_id = NULL,
9855: /* Bug 6707369
9856: * If some of the documents are skipped, the payment