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_DISBURSE_UI_API_PUB_PKG dependencies on IBY_PAYMENTS_ALL

Line 175: UPDATE iby_payments_all

171: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
172: print_debuginfo(l_module_name, 'ENTER');
173:
174: END IF;
175: UPDATE iby_payments_all
176: SET STOP_REQUEST_PLACED_FLAG = 'Y',
177: STOP_REQUEST_PLACED_BY = p_requested_by,
178: STOP_REQUEST_REASON = p_request_reason,
179: STOP_REQUEST_REFERENCE= p_request_reference,

Line 259: UPDATE iby_payments_all

255: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
256: print_debuginfo(l_module_name, 'ENTER');
257:
258: END IF;
259: UPDATE iby_payments_all
260: SET STOP_RELEASED_FLAG = 'Y',
261: STOP_RELEASED_BY = p_released_by,
262: STOP_RELEASE_DATE = p_release_date,
263: STOP_RELEASE_REASON = p_release_reason,

Line 1022: IBY_PAYMENTS_ALL pmt,

1018: INTO
1019: l_app_short_name
1020: FROM
1021: FND_APPLICATION fnd,
1022: IBY_PAYMENTS_ALL pmt,
1023: IBY_PAY_SERVICE_REQUESTS req
1024: WHERE
1025: fnd.application_id = req.calling_app_id AND
1026: req.payment_service_request_id = pmt.payment_service_request_id AND

Line 1628: IBY_PAYMENTS_ALL pmt

1624: INTO
1625: l_instr_id
1626: FROM
1627: IBY_PAY_INSTRUCTIONS_ALL instr,
1628: IBY_PAYMENTS_ALL pmt
1629: WHERE
1630: instr.payment_instruction_id = pmt.payment_instruction_id AND
1631: pmt.payment_id = p_pmt_id;
1632: EXCEPTION

Line 1651: IBY_PAYMENTS_ALL pmt

1647: count(*)
1648: INTO
1649: l_valid_pmts_count
1650: FROM
1651: IBY_PAYMENTS_ALL pmt
1652: WHERE
1653: pmt.payment_instruction_id = l_instr_id AND
1654: pmt.payment_reference_number is not null AND
1655: pmt.payment_status NOT IN

Line 1693: FROM iby_payments_all pmt

1689: * document's last issued check number must be updated
1690: */
1691: last_issued_document_number = nvl(
1692: (SELECT MAX(pmt.paper_document_number)
1693: FROM iby_payments_all pmt
1694: WHERE pmt.payment_instruction_id = l_instr_id)
1695: ,last_issued_document_number
1696: )
1697: WHERE

Line 1717: IBY_PAYMENTS_ALL pmt,

1713: INTO
1714: l_app_short_name
1715: FROM
1716: FND_APPLICATION fnd,
1717: IBY_PAYMENTS_ALL pmt,
1718: IBY_PAY_SERVICE_REQUESTS req
1719: WHERE
1720: fnd.application_id = req.calling_app_id AND
1721: req.payment_service_request_id = pmt.payment_service_request_id AND

Line 2029: | to IBY_PAYMENTS_ALL.PAYMENT_ID column.

Line 2127: IBY_PAYMENTS_ALL

2123: *
2124: * Void the specified payment.
2125: */
2126: UPDATE
2127: IBY_PAYMENTS_ALL
2128: SET
2129: payment_status = PAY_STATUS_VOID,
2130: voided_by = p_voided_by,
2131: void_date = p_void_date,

Line 2206: IBY_PAYMENTS_ALL pmt

2202: INTO
2203: l_instr_id
2204: FROM
2205: IBY_PAY_INSTRUCTIONS_ALL instr,
2206: IBY_PAYMENTS_ALL pmt
2207: WHERE
2208: instr.payment_instruction_id = pmt.payment_instruction_id AND
2209: pmt.payment_id = p_pmt_id
2210: ;

Line 2227: IBY_PAYMENTS_ALL pmt

2223: count(*)
2224: INTO
2225: l_valid_pmts_count
2226: FROM
2227: IBY_PAYMENTS_ALL pmt
2228: WHERE
2229: pmt.payment_instruction_id = l_instr_id AND
2230: pmt.payment_status NOT IN
2231: (

Line 2290: FROM iby_payments_all pmt

2286: * document's last issued check number must be updated
2287: */
2288: last_issued_document_number = nvl(
2289: (SELECT MAX(pmt.paper_document_number)
2290: FROM iby_payments_all pmt
2291: WHERE pmt.payment_instruction_id = l_instr_id)
2292: ,last_issued_document_number
2293: )
2294: WHERE

Line 2387: | to IBY_PAYMENTS_ALL.PAYMENT_ID column.

Line 2605: IBY_PAYMENTS_ALL pmt

2601: pmt.payment_status
2602: INTO
2603: l_curr_pmt_status
2604: FROM
2605: IBY_PAYMENTS_ALL pmt
2606: WHERE
2607: payment_id = p_pmt_id
2608: ;
2609:

Line 2688: IBY_PAYMENTS_ALL

2684: *
2685: * Void the specified payment.
2686: */
2687: UPDATE
2688: IBY_PAYMENTS_ALL
2689: SET
2690: payment_status = PAY_STATUS_VOID,
2691: voided_by = p_voided_by,
2692: void_date = p_void_date,

Line 2753: IBY_PAYMENTS_ALL pmt

2749: INTO
2750: l_instr_id
2751: FROM
2752: IBY_PAY_INSTRUCTIONS_ALL instr,
2753: IBY_PAYMENTS_ALL pmt
2754: WHERE
2755: instr.payment_instruction_id = pmt.payment_instruction_id AND
2756: pmt.payment_id = p_pmt_id
2757: ;

Line 2773: IBY_PAYMENTS_ALL pmt

2769: count(*)
2770: INTO
2771: l_valid_pmts_count
2772: FROM
2773: IBY_PAYMENTS_ALL pmt
2774: WHERE
2775: pmt.payment_instruction_id = l_instr_id AND
2776: pmt.payment_status NOT IN
2777: (

Line 2836: FROM iby_payments_all pmt

2832: * document's last issued check number must be updated
2833: */
2834: last_issued_document_number = nvl(
2835: (SELECT MAX(pmt.paper_document_number)
2836: FROM iby_payments_all pmt
2837: WHERE pmt.payment_instruction_id = l_instr_id)
2838: ,last_issued_document_number
2839: )
2840: WHERE

Line 2882: IBY_PAYMENTS_ALL pmt,

2878: INTO
2879: l_app_short_name
2880: FROM
2881: FND_APPLICATION fnd,
2882: IBY_PAYMENTS_ALL pmt,
2883: IBY_PAY_SERVICE_REQUESTS req
2884: WHERE
2885: fnd.application_id = req.calling_app_id AND
2886: req.payment_service_request_id = pmt.payment_service_request_id AND

Line 3163: IBY_PAYMENTS_ALL pmt,

3159: INTO
3160: l_app_short_name
3161: FROM
3162: FND_APPLICATION fnd,
3163: IBY_PAYMENTS_ALL pmt,
3164: IBY_PAY_SERVICE_REQUESTS req
3165: WHERE
3166: fnd.application_id = req.calling_app_id AND
3167: req.payment_service_request_id = pmt.payment_service_request_id AND

Line 3399: IBY_PAYMENTS_ALL

3395: IS
3396: SELECT
3397: payment_id
3398: FROM
3399: IBY_PAYMENTS_ALL
3400: WHERE
3401: payment_instruction_id = p_instr_id AND
3402: payments_complete_flag = 'Y'
3403: ;

Line 3421: FROM iby_payments_all

3417: /* Bug 9850931 - Truncating the payment date before checking it with
3418: void date as void date is not stored with timestamps. */
3419: SELECT Max(trunc(payment_date))
3420: INTO l_pmt_date
3421: FROM iby_payments_all
3422: WHERE payment_instruction_id = p_instr_id AND
3423: payments_complete_flag = 'Y';
3424:
3425: IF(p_void_date < l_pmt_date) THEN

Line 4532: IBY_PAYMENTS_ALL pmt,

4528: SELECT DISTINCT
4529: fnd.application_short_name
4530: FROM
4531: FND_APPLICATION fnd,
4532: IBY_PAYMENTS_ALL pmt,
4533: IBY_PAY_SERVICE_REQUESTS req,
4534: IBY_PAY_INSTRUCTIONS_ALL ins
4535: WHERE
4536: pmt.payment_instruction_id = ins.payment_instruction_id AND

Line 4552: IBY_PAYMENTS_ALL pmt,

4548: SELECT
4549: fnd.application_id
4550: FROM
4551: FND_APPLICATION fnd,
4552: IBY_PAYMENTS_ALL pmt,
4553: IBY_PAY_SERVICE_REQUESTS req,
4554: IBY_PAY_INSTRUCTIONS_ALL ins
4555: WHERE
4556: pmt.payment_instruction_id = ins.payment_instruction_id AND

Line 4616: IBY_PAYMENTS_ALL pmt

4612: count(*)
4613: INTO
4614: l_valid_pmts_count
4615: FROM
4616: IBY_PAYMENTS_ALL pmt
4617: WHERE
4618: pmt.payment_instruction_id = p_instr_id AND
4619: pmt.payment_status NOT IN
4620: (

Line 4787: IBY_PAYMENTS_ALL

4783:
4784: BEGIN
4785:
4786: UPDATE
4787: IBY_PAYMENTS_ALL
4788: SET
4789: payment_status = PAY_STATUS_INS_TERM
4790: WHERE
4791: payment_instruction_id = p_instr_id AND

Line 4863: IBY_PAYMENTS_ALL

4859: (
4860: SELECT
4861: payment_id
4862: FROM
4863: IBY_PAYMENTS_ALL
4864: WHERE
4865: payment_instruction_id = p_instr_id AND
4866: payment_status = PAY_STATUS_INS_TERM
4867: )

Line 4953: FROM iby_payments_all WHERE payment_instruction_id = p_instr_id;

4949: IF(l_document_locked = TRUE) THEN
4950:
4951: SELECT Max(paper_document_number), Min(paper_document_number), Count(*)
4952: INTO l_max_paper_document_number, l_min_paper_document_number, l_number_of_payments
4953: FROM iby_payments_all WHERE payment_instruction_id = p_instr_id;
4954:
4955: l_last_issued_modified := l_last_issued - l_number_of_payments;
4956:
4957: IF ((l_last_issued <> l_max_paper_document_number)

Line 4990: IBY_PAYMENTS_ALL

4986:
4987: /* Updating payments table to clear the paper document numbers Bug 8412987*/
4988: /* bug : 8787079 Including 'Void_by_overflow' and 'Void_by_setup' statuses */
4989: UPDATE
4990: IBY_PAYMENTS_ALL
4991: SET
4992: paper_document_number = null
4993: WHERE
4994: payment_instruction_id = p_instr_id AND

Line 5002: print_debuginfo(l_module_name, 'nulled out paper document numbers in iby_payments_all');

4998: PAY_STATUS_VOID_OVERFLOW)
4999: ;
5000:
5001: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5002: print_debuginfo(l_module_name, 'nulled out paper document numbers in iby_payments_all');
5003:
5004: END IF;
5005: END IF;
5006: EXCEPTION

Line 5181: IBY_PAYMENTS_ALL

5177: payment_id IN
5178: (SELECT
5179: payment_id
5180: FROM
5181: IBY_PAYMENTS_ALL
5182: WHERE
5183: payment_instruction_id = p_instr_id AND
5184: payment_status = PAY_STATUS_INS_TERM
5185: )

Line 5394: where exists (select 'Payment' from iby_payments_all pmt

5390: CURSOR pmt_instructions(l_ppr_id number)
5391: is
5392: select instr.payment_instruction_id, instr.payment_instruction_status
5393: from iby_pay_instructions_all instr
5394: where exists (select 'Payment' from iby_payments_all pmt
5395: where pmt.payment_service_request_id = l_ppr_id
5396: and pmt.payment_instruction_id = instr.payment_instruction_id);
5397:
5398:

Line 5624: IBY_PAYMENTS_ALL

5620:
5621: BEGIN
5622:
5623: UPDATE
5624: IBY_PAYMENTS_ALL
5625: SET
5626: payment_status = PAY_STATUS_REQ_TERM
5627: WHERE
5628: payment_service_request_id = p_req_id AND

Line 6421: | IBY_PAYMENTS_ALL table with the new paper document numbers for

6417: | The list of used paper documents numbers will be used to insert
6418: | records into the IBY_USED_PAYMENT_DOCS table.
6419: |
6420: | The list of new paper document numbers will be used to update the
6421: | IBY_PAYMENTS_ALL table with the new paper document numbers for
6422: | the corresponding paments. The payment status will then be set to
6423: | READY_FOR_REPRINT.
6424: |
6425: | Finally, this API will invoke the paper printing flow.

Line 6654: * Update the IBY_PAYMENTS_ALL table with the list of

6650:
6651: /*
6652: * STEP 2:
6653: *
6654: * Update the IBY_PAYMENTS_ALL table with the list of
6655: * new paper document numbers. The payment ids and new
6656: * paper document numbers have been provided in matching
6657: * order. The status of the payment also needs to be
6658: * updated to READY_FOR_REPRINT.

Line 6672: IBY_PAYMENTS_ALL pmt

6668: pmt.payment_status
6669: INTO
6670: l_curr_pmt_status
6671: FROM
6672: IBY_PAYMENTS_ALL pmt
6673: WHERE
6674: payment_id = p_pmt_list(i)
6675: ;
6676:

Line 6715: IBY_PAYMENTS_ALL

6711: * payment is a setup / overflow payment and
6712: * it must be reprinted.
6713: */
6714: UPDATE
6715: IBY_PAYMENTS_ALL
6716: SET
6717: paper_document_number = p_new_ppr_docs_list(i),
6718: payment_status = DECODE(
6719: l_curr_pmt_status,

Line 7051: * Update the IBY_PAYMENTS_ALL table with the new status.

7047:
7048: /*
7049: * STEP 2:
7050: *
7051: * Update the IBY_PAYMENTS_ALL table with the new status.
7052: * The status of the payment needs to be READY_FOR_REPRINT.
7053: */
7054: FOR i IN p_pmt_list.FIRST .. p_pmt_list.LAST LOOP
7055:

Line 7065: IBY_PAYMENTS_ALL pmt

7061: pmt.payment_status
7062: INTO
7063: l_curr_pmt_status
7064: FROM
7065: IBY_PAYMENTS_ALL pmt
7066: WHERE
7067: payment_id = p_pmt_list(i)
7068: ;
7069:

Line 7082: IBY_PAYMENTS_ALL

7078: * payment is a setup / overflow payment and
7079: * it must be reprinted.
7080: */
7081: UPDATE
7082: IBY_PAYMENTS_ALL
7083: SET
7084: payment_status = DECODE(
7085: l_curr_pmt_status,
7086: PAY_STATUS_VOID_SETUP,

Line 7206: IBY_PAYMENTS_ALL

7202: );
7203:
7204: END IF;
7205: UPDATE
7206: IBY_PAYMENTS_ALL
7207: SET
7208: payment_status = PAY_STATUS_FORMATTED
7209: WHERE
7210: payment_instruction_id = p_instr_id AND

Line 8051: l_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;

8047: l_request_id NUMBER;
8048: l_return_status VARCHAR2(4000);
8049: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME
8050: || '.record_print_status';
8051: l_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;
8052: l_payment_status_list docPayStatusTab;
8053: l_pmtDocsTab paperDocNumTab;
8054: l_skipped_document_number IBY_PAYMENTS_ALL.paper_document_number%TYPE;
8055: l_pmt_doc_id NUMBER(15);

Line 8054: l_skipped_document_number IBY_PAYMENTS_ALL.paper_document_number%TYPE;

8050: || '.record_print_status';
8051: l_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;
8052: l_payment_status_list docPayStatusTab;
8053: l_pmtDocsTab paperDocNumTab;
8054: l_skipped_document_number IBY_PAYMENTS_ALL.paper_document_number%TYPE;
8055: l_pmt_doc_id NUMBER(15);
8056:
8057: /* used in invocation of callout procedure */
8058: l_api_version CONSTANT NUMBER := 1.0;

Line 8086: CURSOR c_docs (p_pmt_id IBY_PAYMENTS_ALL.

8082: j NUMBER := 1;
8083:
8084: x_return_status_remove_doc VARCHAR2(200);
8085:
8086: CURSOR c_docs (p_pmt_id IBY_PAYMENTS_ALL.
8087: payment_id%TYPE)
8088: IS
8089: SELECT
8090: doc.document_payable_id,

Line 8129: IBY_PAYMENTS_ALL pmt

8125: IS
8126: SELECT
8127: pmt.paper_document_number
8128: FROM
8129: IBY_PAYMENTS_ALL pmt
8130: WHERE
8131: pmt.payment_instruction_id = p_instr_id AND
8132: (
8133: (

Line 8149: FROM IBY_PAYMENTS_ALL

8145: -- Cursor for collecting used documents from the payments all table
8146: CURSOR c_used_payments (p_instr_id NUMBER)
8147: IS
8148: SELECT payment_status, paper_document_number, payment_id
8149: FROM IBY_PAYMENTS_ALL
8150: WHERE payment_instruction_id = p_instr_id
8151: ORDER BY paper_document_number, payment_id;
8152:
8153: /*

Line 8442: -- No point in doing this, becoz IBY_PAYMENTS_ALL is our source of data for spoiled checks

8438: l_paper_doc_num := l_used_docs_list(i);
8439: print_debuginfo(l_module_name, 'In the loop, spoiled document number : ('||i||') :' || l_used_pmts_list(i) );
8440:
8441: -- Bug 9781541
8442: -- No point in doing this, becoz IBY_PAYMENTS_ALL is our source of data for spoiled checks
8443: --
8444: -- UPDATE
8445: -- IBY_PAYMENTS_ALL
8446: -- SET

Line 8445: -- IBY_PAYMENTS_ALL

8441: -- Bug 9781541
8442: -- No point in doing this, becoz IBY_PAYMENTS_ALL is our source of data for spoiled checks
8443: --
8444: -- UPDATE
8445: -- IBY_PAYMENTS_ALL
8446: -- SET
8447: -- payment_status = PAY_STATUS_SPOILED
8448: -- WHERE
8449: -- payment_instruction_id = p_instr_id AND

Line 8643: IBY_PAYMENTS_ALL

8639: * paper payment; the payment must be in ISSUED status in order to
8640: * be marked complete.
8641: */
8642: UPDATE
8643: IBY_PAYMENTS_ALL
8644: SET
8645: payment_status = PAY_STATUS_ISSUED
8646: WHERE
8647: payment_instruction_id = p_instr_id AND

Line 8970: FROM IBY_PAYMENTS_ALL PMT

8966: CURSOR c_ppr_ids (p_instr_id NUMBER)
8967: IS
8968: SELECT DISTINCT
8969: PMT.PAYMENT_SERVICE_REQUEST_ID
8970: FROM IBY_PAYMENTS_ALL PMT
8971: WHERE PMT.PAYMENT_INSTRUCTION_ID = p_instr_id;
8972:
8973:
8974: /*

Line 8996: IBY_PAYMENTS_ALL pmt,

8992: INTO
8993: l_app_short_name
8994: FROM
8995: FND_APPLICATION fnd,
8996: IBY_PAYMENTS_ALL pmt,
8997: IBY_PAY_SERVICE_REQUESTS req,
8998: IBY_PAY_INSTRUCTIONS_ALL ins
8999: WHERE
9000: pmt.payment_instruction_id = ins.payment_instruction_id AND

Line 9016: IBY_PAYMENTS_ALL pmt,

9012: SELECT
9013: fnd.application_id
9014: FROM
9015: FND_APPLICATION fnd,
9016: IBY_PAYMENTS_ALL pmt,
9017: IBY_PAY_SERVICE_REQUESTS req,
9018: IBY_PAY_INSTRUCTIONS_ALL ins
9019: WHERE
9020: pmt.payment_instruction_id = ins.payment_instruction_id AND

Line 9033: IBY_PAYMENTS_ALL pmt

9029: IS
9030: SELECT
9031: pmt.paper_document_number
9032: FROM
9033: IBY_PAYMENTS_ALL pmt
9034: WHERE
9035: pmt.payment_instruction_id = p_instr_id AND
9036: pmt.payment_status = PAY_STATUS_FORMATTED;*/
9037:

Line 9200: IBY_PAYMENTS_ALL

9196: */
9197: IF (l_processing_type = P_TYPE_PRINTED) THEN
9198:
9199: UPDATE
9200: IBY_PAYMENTS_ALL
9201: SET
9202: payments_complete_flag = 'Y'
9203: WHERE
9204: payment_instruction_id = p_instr_id

Line 9218: IBY_PAYMENTS_ALL

9214:
9215: /* batch payment(s) */
9216:
9217: UPDATE
9218: IBY_PAYMENTS_ALL
9219: SET
9220: payments_complete_flag = 'Y'
9221: WHERE
9222: payment_instruction_id = p_instr_id

Line 9274: IBY_PAYMENTS_ALL

9270:
9271: l_completion_point := IBY_DISBURSE_UI_API_PUB_PKG.Get_Pmt_Completion_Point(p_instr_id);
9272:
9273: UPDATE
9274: IBY_PAYMENTS_ALL
9275: SET
9276: payments_complete_flag = 'Y'
9277: WHERE
9278: payment_instruction_id = p_instr_id

Line 9422: IBY_PAYMENTS_ALL pmt

9418: */
9419: IF (l_processing_type = P_TYPE_PRINTED) THEN
9420:
9421: UPDATE
9422: IBY_PAYMENTS_ALL pmt
9423: SET
9424: pmt.completed_pmts_group_id = l_completion_id
9425: WHERE
9426: pmt.payment_instruction_id = p_instr_id AND

Line 9445: IBY_PAYMENTS_ALL pmt

9441:
9442: l_completion_point := IBY_DISBURSE_UI_API_PUB_PKG.Get_Pmt_Completion_Point(p_instr_id);
9443:
9444: UPDATE
9445: IBY_PAYMENTS_ALL pmt
9446: SET
9447: pmt.completed_pmts_group_id = l_completion_id
9448: WHERE
9449: pmt.payment_instruction_id = p_instr_id AND

Line 9502: IBY_PAYMENTS_ALL pmt

9498: doc.payment_id IN
9499: (SELECT
9500: pmt.payment_id
9501: FROM
9502: IBY_PAYMENTS_ALL pmt
9503: WHERE
9504: pmt.completed_pmts_group_id = l_completion_id
9505: )
9506: ;

Line 9543: IBY_PAYMENTS_ALL pmt

9539: count(*)
9540: INTO
9541: l_pmt_count
9542: FROM
9543: IBY_PAYMENTS_ALL pmt
9544: WHERE
9545: pmt.completed_pmts_group_id = l_completion_id
9546: ;
9547:

Line 9744: from iby_payments_all where

9740: print_debuginfo(l_module_name, 'PPR ID::'||l_pprIdsTab(i));
9741: END IF;
9742: select count(*)
9743: into l_incomplete_pmts
9744: from iby_payments_all where
9745: payment_service_request_id = l_pprIdsTab(i)
9746: and payments_complete_flag = 'N'
9747: and payment_status not in
9748: ('REMOVED_INSTRUCTION_TERMINATED',

Line 9840: FROM iby_payments_all

9836: fnd_global.user_id LAST_UPDATED_BY,
9837: sysdate LAST_UPDATE_DATE,
9838: fnd_global.login_id LAST_UPDATE_LOGIN,
9839: 1 OBJECT_VERSION_NUMBER
9840: FROM iby_payments_all
9841: WHERE payment_instruction_id = p_instr_id AND
9842: payment_status = PAY_STATUS_FORMATTED AND paper_document_number is not null);
9843: END IF;
9844:

Line 9861: FROM iby_payments_all pmt

9857: * document's last issued check number must be updated
9858: */
9859: last_issued_document_number = nvl(
9860: (SELECT MAX(pmt.paper_document_number)
9861: FROM iby_payments_all pmt
9862: WHERE pmt.payment_instruction_id = p_instr_id)
9863: ,last_issued_document_number
9864: )
9865: WHERE

Line 11443: IBY_PAYMENTS_ALL pmt

11439:
11440: ELSIF (p_object_type = 'PAYMENT') THEN
11441:
11442: UPDATE
11443: IBY_PAYMENTS_ALL pmt
11444: SET
11445: pmt.request_id = l_conc_request_id
11446: WHERE
11447: pmt.payment_id = p_object_id

Line 11641: IBY_PAYMENTS_ALL pmt

11637:
11638: ELSIF (p_object_type = 'PAYMENT') THEN
11639:
11640: UPDATE
11641: IBY_PAYMENTS_ALL pmt
11642: SET
11643: pmt.request_id = NULL
11644: WHERE
11645: pmt.payment_id = p_object_id

Line 12038: IBY_PAYMENTS_ALL pmt

12034: COUNT(*)
12035: INTO
12036: l_all_pmts_count
12037: FROM
12038: IBY_PAYMENTS_ALL pmt
12039: WHERE
12040: pmt.payment_instruction_id = p_instr_id
12041: ;
12042:

Line 12057: IBY_PAYMENTS_ALL pmt

12053: COUNT(*)
12054: INTO
12055: l_term_pmts_count
12056: FROM
12057: IBY_PAYMENTS_ALL pmt
12058: WHERE
12059: pmt.payment_instruction_id = p_instr_id
12060: AND
12061: pmt.payment_status = PAY_STATUS_REQ_TERM

Line 12159: | This method locks rows in the IBY_PAYMENTS_ALL table and

12155: | method for other general purposes.
12156: |
12157: |
12158: | -- IMPORTANT --
12159: | This method locks rows in the IBY_PAYMENTS_ALL table and
12160: | expects that the caller will commit/rollback to release lock.
12161: |
12162: *---------------------------------------------------------------------*/
12163: FUNCTION checkIfPmtInInstExists(

Line 12218: -- LOCK TABLE IBY_PAYMENTS_ALL IN EXCLUSIVE MODE;

12214: /*
12215: * Instead of locking the entire table only lock the
12216: * rows that we are interested in (explicit locking).
12217: */
12218: -- LOCK TABLE IBY_PAYMENTS_ALL IN EXCLUSIVE MODE;
12219:
12220: SELECT
12221: pmt.payment_id
12222: INTO

Line 12225: IBY_PAYMENTS_ALL pmt

12221: pmt.payment_id
12222: INTO
12223: l_test
12224: FROM
12225: IBY_PAYMENTS_ALL pmt
12226: WHERE
12227: pmt.payment_instruction_id IS NOT NULL
12228: AND
12229: pmt.payment_service_request_id = p_payreq_id

Line 12249: IBY_PAYMENTS_ALL pmt

12245: (
12246: SELECT
12247: pmt.payment_id
12248: FROM
12249: IBY_PAYMENTS_ALL pmt
12250: WHERE
12251: pmt.payment_instruction_id IS NOT NULL
12252: AND
12253: pmt.payment_service_request_id = p_payreq_id

Line 12393: IBY_PAYMENTS_ALL pmt

12389: inst.payment_instruction_id = p_instr_id
12390: ;
12391:
12392: UPDATE
12393: IBY_PAYMENTS_ALL pmt
12394: SET
12395: pmt.payment_status = PAY_STATUS_FORMATTED
12396: WHERE
12397: pmt.payment_instruction_id = p_instr_id

Line 12411: IBY_PAYMENTS_ALL pmt

12407: inst.payment_instruction_id = p_instr_id
12408: ;
12409:
12410: UPDATE
12411: IBY_PAYMENTS_ALL pmt
12412: SET
12413: pmt.payment_status = PAY_STATUS_TRANSMITTED
12414: WHERE
12415: pmt.payment_instruction_id = p_instr_id

Line 12688: IBY_PAYMENTS_ALL pmt

12684: (
12685: SELECT
12686: pmt.payment_id
12687: FROM
12688: IBY_PAYMENTS_ALL pmt
12689: WHERE
12690: pmt.payment_id = p_object_id
12691: AND
12692: pmt.request_id IS NOT NULL

Line 13039: v_request_id iby_payments_all.request_id%TYPE;

13035: v_req_status_t VARCHAR2(80);
13036: v_req_phase_c VARCHAR2(30);
13037: v_req_status_c VARCHAR2(30);
13038: v_message VARCHAR2(240);
13039: v_request_id iby_payments_all.request_id%TYPE;
13040:
13041: x_return_status VARCHAR2(30) := 'PENDING';
13042:
13043: BEGIN

Line 13113: IBY_PAYMENTS_ALL pmt

13109: IS
13110: SELECT
13111: pmt.payment_id
13112: FROM
13113: IBY_PAYMENTS_ALL pmt
13114: WHERE
13115: pmt.completed_pmts_group_id = p_complete_id
13116: ;
13117:

Line 13436: FROM iby_payments_all payments

13432:
13433: END IF;
13434: select count(1)
13435: into l_pmt_org_count
13436: FROM iby_payments_all payments
13437: where payments.payment_status IN
13438: ('FAILED_BY_REJECTION_LEVEL',
13439: 'FAILED_BY_CALLING_APP',
13440: 'REMOVED',