APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on CE_PAYMENT_DOCUMENTS

Line 1432: CE_PAYMENT_DOCUMENTS

1428: * Done per bug 6852606
1429: */
1430: print_debuginfo(l_module_name, 'Trying to unlock the payment document as PI termination: ');
1431: UPDATE
1432: CE_PAYMENT_DOCUMENTS
1433: SET
1434: payment_instruction_id = NULL,
1435: /* Bug 6707369
1436: * If some of the documents are skipped, the payment

Line 1973: CE_PAYMENT_DOCUMENTS

1969: * Done per bug 6852606
1970: */
1971: print_debuginfo(l_module_name, 'Trying to unlock the payment document as PI termination: ');
1972: UPDATE
1973: CE_PAYMENT_DOCUMENTS
1974: SET
1975: payment_instruction_id = NULL,
1976: /* Bug 6707369
1977: * If some of the documents are skipped, the payment

Line 2447: CE_PAYMENT_DOCUMENTS

2443: * Done per bug 6852606
2444: */
2445: print_debuginfo(l_module_name, 'Trying to unlock the payment document as PI termination: ');
2446: UPDATE
2447: CE_PAYMENT_DOCUMENTS
2448: SET
2449: payment_instruction_id = NULL,
2450: /* Bug 6707369
2451: * If some of the documents are skipped, the payment

Line 3204: CE_PAYMENT_DOCUMENTS

3200: l_first_avail_check_num,
3201: l_last_avail_check_num,
3202: l_pmt_doc_name
3203: FROM
3204: CE_PAYMENT_DOCUMENTS
3205: WHERE
3206: payment_document_id = p_payment_doc_id
3207: ;
3208:

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

3212:
3213: print_debuginfo(l_module_name, 'No payment document '
3214: || 'with payment document id '
3215: || p_payment_doc_id
3216: || ' was found in CE_PAYMENT_DOCUMENTS table.'
3217: );
3218:
3219: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
3220: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);

Line 3961: FROM ce_payment_documents WHERE payment_instruction_id = p_instr_id;

3957: /*Modified for Bug 7325373*/
3958: BEGIN
3959: BEGIN
3960: SELECT last_issued_document_number INTO l_last_issued
3961: FROM ce_payment_documents WHERE payment_instruction_id = p_instr_id;
3962: EXCEPTION
3963: WHEN No_Data_Found THEN
3964: l_document_locked := FALSE;
3965: print_debuginfo(l_module_name, 'Payment Document is not locked by the instruction '

Line 3982: CE_PAYMENT_DOCUMENTS

3978: RAISE l_irregular_document_numbers;
3979: END IF;
3980:
3981: UPDATE
3982: CE_PAYMENT_DOCUMENTS
3983: SET
3984: last_issued_document_number = l_last_issued_modified
3985: WHERE
3986: payment_instruction_id = p_instr_id

Line 4027: CE_PAYMENT_DOCUMENTS

4023: /* Unlocking the payment document*/
4024: BEGIN
4025:
4026: UPDATE
4027: CE_PAYMENT_DOCUMENTS
4028: SET
4029: payment_instruction_id = NULL
4030: WHERE
4031: payment_instruction_id = p_instr_id

Line 5533: * in CE_PAYMENT_DOCUMENTS table using the

5529: *
5530: * Fix for bug 5470041:
5531: *
5532: * Update the last issued document number
5533: * in CE_PAYMENT_DOCUMENTS table using the
5534: * greatest document number from the user
5535: * provided list of new document numbers
5536: * for reprinting.
5537: */

Line 5563: CE_PAYMENT_DOCUMENTS

5559: * provided list contains a doc number greater
5560: * than what is already stored in the database.
5561: */
5562: UPDATE
5563: CE_PAYMENT_DOCUMENTS
5564: SET
5565: last_issued_document_number =
5566: GREATEST(l_last_list_num, last_issued_document_number)
5567: WHERE

Line 8381: CE_PAYMENT_DOCUMENTS

8377:
8378: BEGIN
8379:
8380: UPDATE
8381: CE_PAYMENT_DOCUMENTS
8382: SET
8383: payment_instruction_id = NULL,
8384: /* Bug 6707369
8385: * If some of the documents are skipped, the payment