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_SUBMIT_PUB_PKG dependencies on IBY_PAY_SERVICE_REQUESTS

Line 255: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

251: l_msg_count NUMBER;
252: l_msg_data VARCHAR2(4000);
253:
254: l_payreq_status VARCHAR2 (100);
255: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
256: l_req_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
257: l_is_duplicate BOOLEAN := TRUE;
258:
259: l_profile_attribs profileProcessAttribs;

Line 256: l_req_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

252: l_msg_data VARCHAR2(4000);
253:
254: l_payreq_status VARCHAR2 (100);
255: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
256: l_req_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
257: l_is_duplicate BOOLEAN := TRUE;
258:
259: l_profile_attribs profileProcessAttribs;
260: l_pmtInstrTab IBY_PAYINSTR_PUB.pmtInstrTabType;

Line 276: l_create_instrs_flag IBY_PAY_SERVICE_REQUESTS.

272:
273: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
274: '.submit_payment_process_request';
275:
276: l_create_instrs_flag IBY_PAY_SERVICE_REQUESTS.
277: create_pmt_instructions_flag%TYPE;
278:
279: l_payment_doc_id IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE;
280:

Line 279: l_payment_doc_id IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE;

275:
276: l_create_instrs_flag IBY_PAY_SERVICE_REQUESTS.
277: create_pmt_instructions_flag%TYPE;
278:
279: l_payment_doc_id IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE;
280:
281: /*
282: * This flag indicates to the payment re-creation flow whether
283: * payments were just created in the payment creation flow.

Line 590: * Insert payment request into IBY_PAY_SERVICE_REQUESTS

586:
587: /*
588: * STEP 1:
589: *
590: * Insert payment request into IBY_PAY_SERVICE_REQUESTS
591: * table and generate payment request id.
592: */
593: BEGIN
594:

Line 845: FROM iby_pay_service_requests

841: /* 7492186 */
842: BEGIN
843: SELECT payment_service_request_id
844: INTO l_req_id
845: FROM iby_pay_service_requests
846: WHERE payment_service_request_id = l_payreq_id
847: AND payment_service_request_status = l_payreq_status
848: FOR UPDATE SKIP LOCKED;
849:

Line 968: FROM iby_pay_service_requests

964: /* 7492186 */
965: BEGIN
966: SELECT payment_service_request_id
967: INTO l_req_id
968: FROM iby_pay_service_requests
969: WHERE payment_service_request_id = l_payreq_id
970: AND payment_service_request_status = l_payreq_status
971: FOR UPDATE SKIP LOCKED;
972:

Line 1273: FROM iby_pay_service_requests

1269: /* 7492186 */
1270: BEGIN
1271: SELECT payment_service_request_id
1272: INTO l_req_id
1273: FROM iby_pay_service_requests
1274: WHERE payment_service_request_id = l_payreq_id
1275: AND payment_service_request_status = l_payreq_status
1276: FOR UPDATE SKIP LOCKED;
1277:

Line 1447: IBY_PAY_SERVICE_REQUESTS

1443: * Update the request status in the database so that
1444: * it is visible to the payment creation module.
1445: */
1446: UPDATE
1447: IBY_PAY_SERVICE_REQUESTS
1448: SET
1449: payment_service_request_status =
1450: REQ_STATUS_RETRY_PMT_CREAT
1451: WHERE

Line 1707: IBY_PAY_SERVICE_REQUESTS

1703: * allowed it to proceed. No need to revalidate. Simply
1704: * change the request status to CREATED and exit.
1705: */
1706: UPDATE
1707: IBY_PAY_SERVICE_REQUESTS
1708: SET
1709: payment_service_request_status = REQ_STATUS_PMT_CRTD
1710: WHERE
1711: payment_service_request_id = l_payreq_id;

Line 1829: * we have to check the IBY_PAY_SERVICE_REQUESTS to get the

1825: *
1826: * If this is a re-run of the build program (e.g., after
1827: * user has reviewed proposed payments, the create
1828: * instructions flag would not be again passed in; instead
1829: * we have to check the IBY_PAY_SERVICE_REQUESTS to get the
1830: * original value for this flag).
1831: *
1832: * Use the retrieved value to determine whether to kick off
1833: * the PICP (Fix for bug 4746624).

Line 1850: IBY_PAY_SERVICE_REQUESTS

1846: NVL(create_pmt_instructions_flag, 'N')
1847: INTO
1848: l_create_instrs_flag
1849: FROM
1850: IBY_PAY_SERVICE_REQUESTS
1851: WHERE
1852: PAYMENT_SERVICE_REQUEST_ID = l_payreq_id
1853: ;
1854:

Line 1906: * we have to check the IBY_PAY_SERVICE_REQUESTS to get the

1902: *
1903: * If this is a re-run of the build program (e.g., after
1904: * user has reviewed proposed payments, the payment doc
1905: * id would not be again passed in; instead
1906: * we have to check the IBY_PAY_SERVICE_REQUESTS to get the
1907: * original value for this param).
1908: */
1909: IF (p_payment_document_id IS NULL) THEN
1910:

Line 1924: IBY_PAY_SERVICE_REQUESTS

1920: payment_document_id
1921: INTO
1922: l_payment_doc_id
1923: FROM
1924: IBY_PAY_SERVICE_REQUESTS
1925: WHERE
1926: PAYMENT_SERVICE_REQUEST_ID = l_payreq_id
1927: ;
1928:

Line 2133: UPDATE iby_pay_service_requests

2129: -- Change this process parameter to the single distinct PPP value for later use.
2130: l_payment_profile_id := l_distinct_ppp;
2131:
2132: -- Stamp this single distinct PPP on PPR header as well.
2133: UPDATE iby_pay_service_requests
2134: SET payment_profile_id = l_distinct_ppp
2135: WHERE payment_service_request_id = l_payreq_id;
2136:
2137: ELSE

Line 2952: p_status IN IBY_PAY_SERVICE_REQUESTS.PAYMENT_SERVICE_REQUEST_STATUS%type)

2948: | NOTES:
2949: |
2950: *---------------------------------------------------------------------*/
2951: FUNCTION get_payreq_list (
2952: p_status IN IBY_PAY_SERVICE_REQUESTS.PAYMENT_SERVICE_REQUEST_STATUS%type)
2953: RETURN payreq_tbl_type
2954: IS
2955:
2956: payreq_list payreq_tbl_type;

Line 2960: c_status IN IBY_PAY_SERVICE_REQUESTS.PAYMENT_SERVICE_REQUEST_STATUS%type)

2956: payreq_list payreq_tbl_type;
2957: l_module_name VARCHAR2(200) := G_PKG_NAME || '.get_payreq_list';
2958:
2959: CURSOR c_pay_req_list (
2960: c_status IN IBY_PAY_SERVICE_REQUESTS.PAYMENT_SERVICE_REQUEST_STATUS%type)
2961: IS
2962: SELECT
2963: payment_service_request_id
2964: FROM

Line 2965: IBY_PAY_SERVICE_REQUESTS

2961: IS
2962: SELECT
2963: payment_service_request_id
2964: FROM
2965: IBY_PAY_SERVICE_REQUESTS
2966: WHERE
2967: payment_service_request_status=c_status;
2968:
2969: BEGIN

Line 3004: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

3000: | NOTES:
3001: |
3002: *---------------------------------------------------------------------*/
3003: FUNCTION get_payreq_status (
3004: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
3005: RETURN VARCHAR2
3006: IS
3007:
3008: l_payreq_status VARCHAR2(100);

Line 3019: IBY_PAY_SERVICE_REQUESTS

3015: payment_service_request_status
3016: INTO
3017: l_payreq_status
3018: FROM
3019: IBY_PAY_SERVICE_REQUESTS
3020: WHERE
3021: payment_service_request_id = l_payreq_id;
3022:
3023: RETURN l_payreq_status;

Line 3061: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

3057: | NOTES:
3058: |
3059: *---------------------------------------------------------------------*/
3060: FUNCTION checkIfPmtsInModifiedStatus(
3061: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
3062: RETURN BOOLEAN
3063: IS
3064:
3065: l_ret_flag BOOLEAN := FALSE;

Line 3150: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

3146: | NOTES:
3147: |
3148: *---------------------------------------------------------------------*/
3149: FUNCTION checkIfPmtsInModBankAccStatus(
3150: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
3151: RETURN BOOLEAN
3152: IS
3153:
3154: l_ret_flag BOOLEAN := FALSE;

Line 3238: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

3234: | NOTES:
3235: |
3236: *---------------------------------------------------------------------*/
3237: FUNCTION insert_payreq (
3238: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
3239: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
3240: call_app_pay_service_req_code%TYPE,
3241: p_internal_bank_account_id
3242: IN IBY_PAY_SERVICE_REQUESTS.

Line 3239: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

3235: |
3236: *---------------------------------------------------------------------*/
3237: FUNCTION insert_payreq (
3238: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
3239: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
3240: call_app_pay_service_req_code%TYPE,
3241: p_internal_bank_account_id
3242: IN IBY_PAY_SERVICE_REQUESTS.
3243: internal_bank_account_id%TYPE,

Line 3242: IN IBY_PAY_SERVICE_REQUESTS.

3238: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
3239: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
3240: call_app_pay_service_req_code%TYPE,
3241: p_internal_bank_account_id
3242: IN IBY_PAY_SERVICE_REQUESTS.
3243: internal_bank_account_id%TYPE,
3244: p_payment_profile_id
3245: IN IBY_PAY_SERVICE_REQUESTS.
3246: payment_profile_id%TYPE,

Line 3245: IN IBY_PAY_SERVICE_REQUESTS.

3241: p_internal_bank_account_id
3242: IN IBY_PAY_SERVICE_REQUESTS.
3243: internal_bank_account_id%TYPE,
3244: p_payment_profile_id
3245: IN IBY_PAY_SERVICE_REQUESTS.
3246: payment_profile_id%TYPE,
3247: p_allow_zero_payments_flag
3248: IN IBY_PAY_SERVICE_REQUESTS.
3249: allow_zero_payments_flag%TYPE,

Line 3248: IN IBY_PAY_SERVICE_REQUESTS.

3244: p_payment_profile_id
3245: IN IBY_PAY_SERVICE_REQUESTS.
3246: payment_profile_id%TYPE,
3247: p_allow_zero_payments_flag
3248: IN IBY_PAY_SERVICE_REQUESTS.
3249: allow_zero_payments_flag%TYPE,
3250: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
3251: maximum_payment_amount%TYPE,
3252: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.

Line 3250: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.

3246: payment_profile_id%TYPE,
3247: p_allow_zero_payments_flag
3248: IN IBY_PAY_SERVICE_REQUESTS.
3249: allow_zero_payments_flag%TYPE,
3250: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
3251: maximum_payment_amount%TYPE,
3252: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
3253: minimum_payment_amount%TYPE,
3254: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.

Line 3252: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.

3248: IN IBY_PAY_SERVICE_REQUESTS.
3249: allow_zero_payments_flag%TYPE,
3250: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
3251: maximum_payment_amount%TYPE,
3252: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
3253: minimum_payment_amount%TYPE,
3254: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
3255: document_rejection_level_code%TYPE,
3256: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.

Line 3254: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.

3250: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
3251: maximum_payment_amount%TYPE,
3252: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
3253: minimum_payment_amount%TYPE,
3254: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
3255: document_rejection_level_code%TYPE,
3256: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
3257: payment_rejection_level_code%TYPE,
3258: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.

Line 3256: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.

3252: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
3253: minimum_payment_amount%TYPE,
3254: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
3255: document_rejection_level_code%TYPE,
3256: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
3257: payment_rejection_level_code%TYPE,
3258: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
3259: require_prop_pmts_review_flag%TYPE,
3260: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.

Line 3258: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.

3254: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
3255: document_rejection_level_code%TYPE,
3256: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
3257: payment_rejection_level_code%TYPE,
3258: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
3259: require_prop_pmts_review_flag%TYPE,
3260: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
3261: create_pmt_instructions_flag%TYPE,
3262: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.

Line 3260: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.

3256: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
3257: payment_rejection_level_code%TYPE,
3258: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
3259: require_prop_pmts_review_flag%TYPE,
3260: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
3261: create_pmt_instructions_flag%TYPE,
3262: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
3263: payment_document_id%TYPE,
3264: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.

Line 3262: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.

3258: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
3259: require_prop_pmts_review_flag%TYPE,
3260: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
3261: create_pmt_instructions_flag%TYPE,
3262: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
3263: payment_document_id%TYPE,
3264: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
3265: attribute_category%TYPE,
3266: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.

Line 3264: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.

3260: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
3261: create_pmt_instructions_flag%TYPE,
3262: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
3263: payment_document_id%TYPE,
3264: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
3265: attribute_category%TYPE,
3266: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
3267: attribute1%TYPE,
3268: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.

Line 3266: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.

3262: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
3263: payment_document_id%TYPE,
3264: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
3265: attribute_category%TYPE,
3266: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
3267: attribute1%TYPE,
3268: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
3269: attribute2%TYPE,
3270: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.

Line 3268: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.

3264: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
3265: attribute_category%TYPE,
3266: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
3267: attribute1%TYPE,
3268: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
3269: attribute2%TYPE,
3270: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
3271: attribute3%TYPE,
3272: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.

Line 3270: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.

3266: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
3267: attribute1%TYPE,
3268: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
3269: attribute2%TYPE,
3270: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
3271: attribute3%TYPE,
3272: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
3273: attribute4%TYPE,
3274: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.

Line 3272: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.

3268: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
3269: attribute2%TYPE,
3270: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
3271: attribute3%TYPE,
3272: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
3273: attribute4%TYPE,
3274: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
3275: attribute5%TYPE,
3276: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.

Line 3274: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.

3270: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
3271: attribute3%TYPE,
3272: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
3273: attribute4%TYPE,
3274: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
3275: attribute5%TYPE,
3276: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
3277: attribute6%TYPE,
3278: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.

Line 3276: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.

3272: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
3273: attribute4%TYPE,
3274: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
3275: attribute5%TYPE,
3276: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
3277: attribute6%TYPE,
3278: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
3279: attribute7%TYPE,
3280: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.

Line 3278: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.

3274: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
3275: attribute5%TYPE,
3276: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
3277: attribute6%TYPE,
3278: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
3279: attribute7%TYPE,
3280: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
3281: attribute8%TYPE,
3282: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.

Line 3280: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.

3276: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
3277: attribute6%TYPE,
3278: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
3279: attribute7%TYPE,
3280: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
3281: attribute8%TYPE,
3282: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
3283: attribute9%TYPE,
3284: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.

Line 3282: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.

3278: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
3279: attribute7%TYPE,
3280: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
3281: attribute8%TYPE,
3282: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
3283: attribute9%TYPE,
3284: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
3285: attribute10%TYPE,
3286: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.

Line 3284: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.

3280: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
3281: attribute8%TYPE,
3282: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
3283: attribute9%TYPE,
3284: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
3285: attribute10%TYPE,
3286: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
3287: attribute11%TYPE,
3288: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.

Line 3286: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.

3282: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
3283: attribute9%TYPE,
3284: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
3285: attribute10%TYPE,
3286: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
3287: attribute11%TYPE,
3288: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
3289: attribute12%TYPE,
3290: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.

Line 3288: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.

3284: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
3285: attribute10%TYPE,
3286: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
3287: attribute11%TYPE,
3288: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
3289: attribute12%TYPE,
3290: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
3291: attribute13%TYPE,
3292: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.

Line 3290: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.

3286: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
3287: attribute11%TYPE,
3288: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
3289: attribute12%TYPE,
3290: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
3291: attribute13%TYPE,
3292: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
3293: attribute14%TYPE,
3294: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.

Line 3292: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.

3288: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
3289: attribute12%TYPE,
3290: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
3291: attribute13%TYPE,
3292: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
3293: attribute14%TYPE,
3294: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.
3295: attribute15%TYPE
3296: )

Line 3294: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.

3290: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
3291: attribute13%TYPE,
3292: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
3293: attribute14%TYPE,
3294: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.
3295: attribute15%TYPE
3296: )
3297: RETURN NUMBER
3298: IS

Line 3300: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

3296: )
3297: RETURN NUMBER
3298: IS
3299:
3300: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
3301: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.insert_payreq';
3302:
3303: BEGIN
3304:

Line 3317: * Insert the payment request into IBY_PAY_SERVICE_REQUESTS

3313: || l_payreq_id);
3314:
3315: END IF;
3316: /*
3317: * Insert the payment request into IBY_PAY_SERVICE_REQUESTS
3318: * table. Supply defaults for values not provided by the
3319: * calling app.
3320: */
3321: INSERT INTO IBY_PAY_SERVICE_REQUESTS (

Line 3321: INSERT INTO IBY_PAY_SERVICE_REQUESTS (

3317: * Insert the payment request into IBY_PAY_SERVICE_REQUESTS
3318: * table. Supply defaults for values not provided by the
3319: * calling app.
3320: */
3321: INSERT INTO IBY_PAY_SERVICE_REQUESTS (
3322: CALLING_APP_ID,
3323: CREATED_BY,
3324: CREATION_DATE,
3325: LAST_UPDATED_BY,

Line 3449: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

3445: | NOTES:
3446: |
3447: *---------------------------------------------------------------------*/
3448: FUNCTION checkIfDuplicate(
3449: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
3450: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
3451: call_app_pay_service_req_code%TYPE
3452: )
3453: RETURN NUMBER

Line 3450: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

3446: |
3447: *---------------------------------------------------------------------*/
3448: FUNCTION checkIfDuplicate(
3449: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
3450: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
3451: call_app_pay_service_req_code%TYPE
3452: )
3453: RETURN NUMBER
3454: IS

Line 3455: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

3451: call_app_pay_service_req_code%TYPE
3452: )
3453: RETURN NUMBER
3454: IS
3455: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
3456: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.checkIfDuplicate';
3457: BEGIN
3458:
3459: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3470: IBY_PAY_SERVICE_REQUESTS

3466: */
3467: SELECT
3468: payment_service_request_id INTO l_payreq_id
3469: FROM
3470: IBY_PAY_SERVICE_REQUESTS
3471: WHERE
3472: calling_app_id = p_calling_app_id
3473: AND
3474: call_app_pay_service_req_code = p_calling_app_payreq_cd;

Line 4149: SELECT IBY_PAY_SERVICE_REQUESTS_S.nextval INTO l_payreq_id

4145: l_payreq_id NUMBER(15);
4146:
4147: BEGIN
4148:
4149: SELECT IBY_PAY_SERVICE_REQUESTS_S.nextval INTO l_payreq_id
4150: FROM DUAL;
4151:
4152: RETURN l_payreq_id;
4153:

Line 4177: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

4173: | NOTES:
4174: |
4175: *---------------------------------------------------------------------*/
4176: FUNCTION insert_payreq_documents (
4177: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
4178: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
4179: call_app_pay_service_req_code%TYPE,
4180: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
4181: payment_service_request_id%TYPE

Line 4178: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

4174: |
4175: *---------------------------------------------------------------------*/
4176: FUNCTION insert_payreq_documents (
4177: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
4178: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
4179: call_app_pay_service_req_code%TYPE,
4180: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
4181: payment_service_request_id%TYPE
4182: )

Line 4180: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

4176: FUNCTION insert_payreq_documents (
4177: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
4178: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
4179: call_app_pay_service_req_code%TYPE,
4180: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
4181: payment_service_request_id%TYPE
4182: )
4183: RETURN NUMBER
4184: IS

Line 5092: IBY_PAY_SERVICE_REQUESTS

5088: * If the documents were inserted successfully, update the
5089: * status of the payment request to 'submitted'.
5090: */
5091: UPDATE
5092: IBY_PAY_SERVICE_REQUESTS
5093: SET
5094: payment_service_request_status = REQ_STATUS_SUBMITTED
5095: WHERE
5096: payment_service_request_id = p_payreq_id;

Line 5682: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

5678: | NOTES:
5679: |
5680: *---------------------------------------------------------------------*/
5681: PROCEDURE launchPPRStatusReport(
5682: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
5683: payment_service_request_id%TYPE
5684: )
5685: IS
5686: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 5693: l_ca_payreq_cd IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE;

5689: l_report_format IBY_INTERNAL_PAYERS_ALL.ppr_report_format%TYPE;
5690: l_report_flag IBY_INTERNAL_PAYERS_ALL.automatic_ppr_report_submit%TYPE;
5691:
5692: l_app_short_name VARCHAR2(200);
5693: l_ca_payreq_cd IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE;
5694: l_ca_id IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE;
5695: l_conc_req_id NUMBER(15);
5696:
5697: l_bool_val BOOLEAN; -- Bug 6411356

Line 5694: l_ca_id IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE;

5690: l_report_flag IBY_INTERNAL_PAYERS_ALL.automatic_ppr_report_submit%TYPE;
5691:
5692: l_app_short_name VARCHAR2(200);
5693: l_ca_payreq_cd IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE;
5694: l_ca_id IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE;
5695: l_conc_req_id NUMBER(15);
5696:
5697: l_bool_val BOOLEAN; -- Bug 6411356
5698:

Line 5765: IBY_PAY_SERVICE_REQUESTS req

5761: INTO
5762: l_app_short_name
5763: FROM
5764: FND_APPLICATION fnd,
5765: IBY_PAY_SERVICE_REQUESTS req
5766: WHERE
5767: fnd.application_id = req.calling_app_id AND
5768: req.payment_service_request_id = p_payreq_id
5769: ;

Line 6191: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,

6187: | NOTES:
6188: |
6189: *---------------------------------------------------------------------*/
6190: PROCEDURE update_payreq_status (
6191: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
6192: l_payreq_status IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_status%TYPE,
6193: x_return_status IN OUT NOCOPY VARCHAR2)
6194: IS
6195: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 6192: l_payreq_status IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_status%TYPE,

6188: |
6189: *---------------------------------------------------------------------*/
6190: PROCEDURE update_payreq_status (
6191: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
6192: l_payreq_status IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_status%TYPE,
6193: x_return_status IN OUT NOCOPY VARCHAR2)
6194: IS
6195: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
6196: '.update_payreq_status';

Line 6204: update iby_pay_service_requests

6200:
6201: END IF;
6202: x_return_status := FND_API.G_RET_STS_SUCCESS;
6203:
6204: update iby_pay_service_requests
6205: set payment_service_request_status = l_payreq_status
6206: where payment_service_request_id = l_payreq_id;
6207:
6208: COMMIT;