APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on IBY_DOCS_PAYABLE_ALL

Line 383: IBY_DOCS_PAYABLE_ALL

379: * group id. The calling application will identify rejected
380: * documents using this id.
381: */
382: UPDATE
383: IBY_DOCS_PAYABLE_ALL
384: SET
385: rejected_docs_group_id = l_rejection_id
386: WHERE
387: document_payable_id = p_doc_id AND

Line 401: IBY_DOCS_PAYABLE_ALL doc

397: INTO
398: l_app_short_name
399: FROM
400: FND_APPLICATION fnd,
401: IBY_DOCS_PAYABLE_ALL doc
402: WHERE
403: fnd.application_id = doc.calling_app_id AND
404: doc.document_payable_id = p_doc_id
405: ;

Line 762: IBY_DOCS_PAYABLE_ALL

758: * API Responsibility:
759: * document_status = REMOVED_PAYMENT_REMOVED
760: */
761: UPDATE
762: IBY_DOCS_PAYABLE_ALL
763: SET
764: document_status = DOC_STATUS_PMT_REMOVED,
765:
766: /*

Line 795: IBY_DOCS_PAYABLE_ALL

791: * group id. The calling application will identify rejected
792: * documents using this id.
793: */
794: UPDATE
795: IBY_DOCS_PAYABLE_ALL
796: SET
797: rejected_docs_group_id = l_rejection_id
798: WHERE
799: payment_id = p_pmt_id

Line 1143: IBY_DOCS_PAYABLE_ALL doc

1139: SELECT
1140: doc.document_payable_id,
1141: doc.document_status
1142: FROM
1143: IBY_DOCS_PAYABLE_ALL doc
1144: WHERE
1145: doc.payment_service_request_id = p_payreq_id
1146: ;
1147:

Line 1337: IBY_DOCS_PAYABLE_ALL

1333: * API Responsibility:
1334: * document_status = REMOVED_PAYMENT_STOPPED
1335: */
1336: UPDATE
1337: IBY_DOCS_PAYABLE_ALL
1338: SET
1339: document_status = DOC_STATUS_PMT_STOPPED
1340: WHERE
1341: payment_id = p_pmt_id

Line 1361: IBY_DOCS_PAYABLE_ALL

1357: * group id. The calling application will identify rejected
1358: * documents using this id.
1359: */
1360: UPDATE
1361: IBY_DOCS_PAYABLE_ALL
1362: SET
1363: rejected_docs_group_id = l_rejection_id
1364: WHERE
1365: payment_id = p_pmt_id

Line 1862: IBY_DOCS_PAYABLE_ALL

1858: *
1859: * Void the documents linked to this payment.
1860: */
1861: UPDATE
1862: IBY_DOCS_PAYABLE_ALL
1863: SET
1864: document_status = DOC_STATUS_PMT_VOIDED
1865: WHERE
1866: payment_id = p_pmt_id

Line 2357: IBY_DOCS_PAYABLE_ALL

2353: *
2354: * Void the documents linked to this payment.
2355: */
2356: UPDATE
2357: IBY_DOCS_PAYABLE_ALL
2358: SET
2359: document_status = DOC_STATUS_PMT_VOIDED
2360: WHERE
2361: payment_id = p_pmt_id

Line 3877: IBY_DOCS_PAYABLE_ALL

3873:
3874: BEGIN
3875:
3876: UPDATE
3877: IBY_DOCS_PAYABLE_ALL
3878: SET
3879: document_status = DOC_STATUS_INS_TERM,
3880:
3881: /*

Line 4151: IBY_DOCS_PAYABLE_ALL

4147: * application will identify rejected documents using
4148: * this id.
4149: */
4150: UPDATE
4151: IBY_DOCS_PAYABLE_ALL
4152: SET
4153: rejected_docs_group_id = l_rejection_id
4154: WHERE
4155: document_status = DOC_STATUS_INS_TERM AND

Line 4551: IBY_DOCS_PAYABLE_ALL

4547: */
4548: BEGIN
4549:
4550: UPDATE
4551: IBY_DOCS_PAYABLE_ALL
4552: SET
4553: document_status = DOC_STATUS_REQ_TERM,
4554:
4555: /*

Line 4643: IBY_DOCS_PAYABLE_ALL

4639: * group id. The calling application will identify rejected
4640: * documents using this id.
4641: */
4642: UPDATE
4643: IBY_DOCS_PAYABLE_ALL
4644: SET
4645: rejected_docs_group_id = l_rejection_id
4646: WHERE
4647: document_status = DOC_STATUS_REQ_TERM AND

Line 6216: IBY_DOCS_PAYABLE_ALL doc

6212: SELECT
6213: doc.document_payable_id,
6214: doc.document_status
6215: FROM
6216: IBY_DOCS_PAYABLE_ALL doc
6217: WHERE
6218: doc.payment_id = p_pmt_id
6219:
6220: ;

Line 6344: IBY_DOCS_PAYABLE_ALL

6340:
6341:
6342: print_debuginfo(l_module_name, 'Finished updating payments table');
6343: UPDATE
6344: IBY_DOCS_PAYABLE_ALL
6345: SET
6346: document_status = DOC_STATUS_PMT_SPOILED
6347: WHERE
6348: payment_id = p_used_docs_list(i)

Line 6697: IBY_DOCS_PAYABLE_ALL doc

6693: SELECT
6694: doc.document_payable_id,
6695: doc.document_status
6696: FROM
6697: IBY_DOCS_PAYABLE_ALL doc
6698: WHERE
6699: doc.payment_id = p_pmt_id
6700:
6701: ;

Line 6941: IBY_DOCS_PAYABLE_ALL

6937:
6938:
6939: print_debuginfo(l_module_name, 'Finished updating payments table');
6940: UPDATE
6941: IBY_DOCS_PAYABLE_ALL
6942: SET
6943: document_status = DOC_STATUS_PMT_SPOILED
6944: WHERE
6945: payment_id = p_used_pmts_list(i)

Line 8121: IBY_DOCS_PAYABLE_ALL doc

8117: pmt.payment_id IN
8118: (SELECT
8119: doc.payment_id
8120: FROM
8121: IBY_DOCS_PAYABLE_ALL doc
8122: WHERE
8123: doc.payment_id = pmt.payment_id AND
8124: doc.calling_app_id = l_appIdsTab(i)
8125: )

Line 8149: IBY_DOCS_PAYABLE_ALL doc

8145: pmt.payment_id IN
8146: (SELECT
8147: doc.payment_id
8148: FROM
8149: IBY_DOCS_PAYABLE_ALL doc
8150: WHERE
8151: doc.payment_id = pmt.payment_id AND
8152: doc.calling_app_id = l_appIdsTab(i)
8153: )

Line 8173: IBY_DOCS_PAYABLE_ALL doc

8169: * calling app to select the completed documents directly
8170: * if they so wish.
8171: */
8172: UPDATE
8173: IBY_DOCS_PAYABLE_ALL doc
8174: SET
8175: doc.completed_pmts_group_id = l_completion_id
8176: WHERE
8177: doc.document_status <> 'REMOVED' AND /* Bug 6388935- removed

Line 8230: IBY_DOCS_PAYABLE_ALL doc

8226: count(*)
8227: INTO
8228: l_doc_count
8229: FROM
8230: IBY_DOCS_PAYABLE_ALL doc
8231: WHERE
8232: doc.completed_pmts_group_id = l_completion_id
8233: ;
8234:

Line 11362: IBY_DOCS_PAYABLE_ALL doc

11358: IS
11359: SELECT
11360: doc.document_payable_id
11361: FROM
11362: IBY_DOCS_PAYABLE_ALL doc
11363: WHERE
11364: doc.completed_pmts_group_id = p_complete_id
11365: ;
11366:

Line 11511: FROM IBY_DOCS_PAYABLE_ALL docs

11507: x_return_status := FND_API.G_RET_STS_SUCCESS;
11508:
11509: select count(1)
11510: into l_doc_function_count
11511: FROM IBY_DOCS_PAYABLE_ALL docs
11512: where docs.document_status IN
11513: ( 'REJECTED',
11514: 'FAILED_BY_RELATED_DOCUMENT',
11515: 'FAILED_BY_REJECTION_LEVEL',

Line 11532: FROM IBY_DOCS_PAYABLE_ALL docs

11528: print_debuginfo(l_module_name, 'Number of Missing Payment Function for rejected documents:' ||l_doc_function_count);
11529:
11530: select count(1)
11531: into l_doc_org_count
11532: FROM IBY_DOCS_PAYABLE_ALL docs
11533: where docs.document_status IN
11534: ( 'REJECTED',
11535: 'FAILED_BY_RELATED_DOCUMENT',
11536: 'FAILED_BY_REJECTION_LEVEL',