[Home] [Help]
407: * group id. The calling application will identify rejected
408: * documents using this id.
409: */
410: UPDATE
411: IBY_DOCS_PAYABLE_ALL
412: SET
413: rejected_docs_group_id = l_rejection_id
414: WHERE
415: document_payable_id = p_doc_id AND
425: INTO
426: l_app_short_name
427: FROM
428: FND_APPLICATION fnd,
429: IBY_DOCS_PAYABLE_ALL doc
430: WHERE
431: fnd.application_id = doc.calling_app_id AND
432: doc.document_payable_id = p_doc_id
433: ;
697: FOR i IN p_doc_list.FIRST .. p_doc_list.LAST LOOP
698:
699:
700: UPDATE
701: IBY_DOCS_PAYABLE_ALL
702: SET
703: rejected_docs_group_id = l_rejection_id
704: WHERE
705: document_payable_id = p_doc_list(i) AND
725: INTO
726: l_app_short_name
727: FROM
728: FND_APPLICATION fnd,
729: IBY_DOCS_PAYABLE_ALL doc
730: WHERE
731: fnd.application_id = doc.calling_app_id AND
732: doc.rejected_docs_group_id = l_rejection_id
733: ;
968: * API Responsibility:
969: * document_status = REMOVED_PAYMENT_REMOVED
970: */
971: UPDATE
972: IBY_DOCS_PAYABLE_ALL
973: SET
974: document_status = DOC_STATUS_PMT_REMOVED,
975:
976: /*
1001: * group id. The calling application will identify rejected
1002: * documents using this id.
1003: */
1004: UPDATE
1005: IBY_DOCS_PAYABLE_ALL
1006: SET
1007: rejected_docs_group_id = l_rejection_id
1008: WHERE
1009: payment_id = p_pmt_id
1381: SELECT
1382: doc.document_payable_id,
1383: doc.document_status
1384: FROM
1385: IBY_DOCS_PAYABLE_ALL doc
1386: WHERE
1387: doc.payment_service_request_id = p_payreq_id
1388: ;
1389:
1585: * API Responsibility:
1586: * document_status = REMOVED_PAYMENT_STOPPED
1587: */
1588: UPDATE
1589: IBY_DOCS_PAYABLE_ALL
1590: SET
1591: document_status = DOC_STATUS_PMT_STOPPED
1592: WHERE
1593: payment_id = p_pmt_id
1609: * group id. The calling application will identify rejected
1610: * documents using this id.
1611: */
1612: UPDATE
1613: IBY_DOCS_PAYABLE_ALL
1614: SET
1615: rejected_docs_group_id = l_rejection_id
1616: WHERE
1617: payment_id = p_pmt_id
2150: *
2151: * Void the documents linked to this payment.
2152: */
2153: UPDATE
2154: IBY_DOCS_PAYABLE_ALL
2155: SET
2156: document_status = DOC_STATUS_PMT_VOIDED,
2157: last_update_date = sysdate,
2158: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2704: *
2705: * Void the documents linked to this payment.
2706: */
2707: UPDATE
2708: IBY_DOCS_PAYABLE_ALL
2709: SET
2710: document_status = DOC_STATUS_PMT_VOIDED,
2711: last_update_date = sysdate,
2712: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
4840:
4841: BEGIN
4842:
4843: UPDATE
4844: IBY_DOCS_PAYABLE_ALL
4845: SET
4846: document_status = DOC_STATUS_INS_TERM,
4847:
4848: /*
5167: * application will identify rejected documents using
5168: * this id.
5169: */
5170: UPDATE
5171: IBY_DOCS_PAYABLE_ALL
5172: SET
5173: rejected_docs_group_id = l_rejection_id
5174: WHERE
5175: document_status = DOC_STATUS_INS_TERM AND
5683: */
5684: BEGIN
5685:
5686: UPDATE
5687: IBY_DOCS_PAYABLE_ALL
5688: SET
5689: document_status = DOC_STATUS_REQ_TERM,
5690:
5691: /*
5781: * group id. The calling application will identify rejected
5782: * documents using this id.
5783: */
5784: UPDATE
5785: IBY_DOCS_PAYABLE_ALL
5786: SET
5787: rejected_docs_group_id = l_rejection_id
5788: WHERE
5789: document_status = DOC_STATUS_REQ_TERM AND
8089: SELECT
8090: doc.document_payable_id,
8091: doc.document_status
8092: FROM
8093: IBY_DOCS_PAYABLE_ALL doc
8094: WHERE
8095: doc.payment_id = p_pmt_id
8096: AND doc.document_status <> DOC_STATUS_VOID_SETUP --Bug 14661977
8097:
8454: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8455: print_debuginfo(l_module_name, 'Finished updating payments table');
8456: END IF;
8457: UPDATE
8458: IBY_DOCS_PAYABLE_ALL
8459: SET
8460: document_status = DOC_STATUS_PMT_SPOILED
8461: WHERE
8462: payment_id = l_used_pmts_list(i)
9429: pmt.payment_id IN
9430: (SELECT
9431: doc.payment_id
9432: FROM
9433: IBY_DOCS_PAYABLE_ALL doc
9434: WHERE
9435: doc.payment_id = pmt.payment_id AND
9436: doc.calling_app_id = l_appIdsTab(i)
9437: )
9462: AND pmt.payment_id IN
9463: (SELECT
9464: doc.payment_id
9465: FROM
9466: IBY_DOCS_PAYABLE_ALL doc
9467: WHERE
9468: doc.payment_id = pmt.payment_id AND
9469: doc.calling_app_id = l_appIdsTab(i)
9470: )
9488: * calling app to select the completed documents directly
9489: * if they so wish.
9490: */
9491: UPDATE
9492: IBY_DOCS_PAYABLE_ALL doc
9493: SET
9494: doc.completed_pmts_group_id = l_completion_id
9495: WHERE
9496: doc.document_status <> 'REMOVED' AND /* Bug 6388935- removed
9549: count(*)
9550: INTO
9551: l_doc_count
9552: FROM
9553: IBY_DOCS_PAYABLE_ALL doc
9554: WHERE
9555: doc.completed_pmts_group_id = l_completion_id
9556: ;
9557:
13220: IS
13221: SELECT
13222: doc.document_payable_id
13223: FROM
13224: IBY_DOCS_PAYABLE_ALL doc
13225: WHERE
13226: doc.completed_pmts_group_id = p_complete_id
13227: ;
13228:
13383: x_return_status := FND_API.G_RET_STS_SUCCESS;
13384:
13385: select count(1)
13386: into l_doc_function_count
13387: FROM IBY_DOCS_PAYABLE_ALL docs
13388: where docs.document_status IN
13389: ( 'REJECTED',
13390: 'FAILED_BY_RELATED_DOCUMENT',
13391: 'FAILED_BY_REJECTION_LEVEL',
13406:
13407: END IF;
13408: select count(1)
13409: into l_doc_org_count
13410: FROM IBY_DOCS_PAYABLE_ALL docs
13411: where docs.document_status IN
13412: ( 'REJECTED',
13413: 'FAILED_BY_RELATED_DOCUMENT',
13414: 'FAILED_BY_REJECTION_LEVEL',