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

Line 65: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

61: | NOTES:
62: |
63: *---------------------------------------------------------------------*/
64: PROCEDURE performAssignments(
65: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
66: payment_service_request_id%type,
67: x_return_status IN OUT NOCOPY VARCHAR2)
68: IS
69:

Line 114: req_ca_payreq_id iby_pay_service_requests.

110: doc_pmt_date iby_docs_payable_all.payment_date%TYPE;
111: doc_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
112:
113: /* variables for fields from payment request */
114: req_ca_payreq_id iby_pay_service_requests.
115: call_app_pay_service_req_code%TYPE;
116: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;
117: req_int_bank_acct_id iby_pay_service_requests.internal_bank_account_id%TYPE;
118: req_profile_id iby_pay_service_requests.payment_profile_id%TYPE;

Line 116: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;

112:
113: /* variables for fields from payment request */
114: req_ca_payreq_id iby_pay_service_requests.
115: call_app_pay_service_req_code%TYPE;
116: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;
117: req_int_bank_acct_id iby_pay_service_requests.internal_bank_account_id%TYPE;
118: req_profile_id iby_pay_service_requests.payment_profile_id%TYPE;
119:
120: /*

Line 117: req_int_bank_acct_id iby_pay_service_requests.internal_bank_account_id%TYPE;

113: /* variables for fields from payment request */
114: req_ca_payreq_id iby_pay_service_requests.
115: call_app_pay_service_req_code%TYPE;
116: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;
117: req_int_bank_acct_id iby_pay_service_requests.internal_bank_account_id%TYPE;
118: req_profile_id iby_pay_service_requests.payment_profile_id%TYPE;
119:
120: /*
121: * Cursor to pick up the documents of a given payment request.

Line 118: req_profile_id iby_pay_service_requests.payment_profile_id%TYPE;

114: req_ca_payreq_id iby_pay_service_requests.
115: call_app_pay_service_req_code%TYPE;
116: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;
117: req_int_bank_acct_id iby_pay_service_requests.internal_bank_account_id%TYPE;
118: req_profile_id iby_pay_service_requests.payment_profile_id%TYPE;
119:
120: /*
121: * Cursor to pick up the documents of a given payment request.
122: */

Line 680: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,

676: | NOTES:
677: |
678: *---------------------------------------------------------------------*/
679: PROCEDURE getRequestAttributes(
680: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
681: x_caPayReqCd IN OUT NOCOPY
682: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
683: x_caId IN OUT NOCOPY
684: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

Line 682: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,

678: *---------------------------------------------------------------------*/
679: PROCEDURE getRequestAttributes(
680: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
681: x_caPayReqCd IN OUT NOCOPY
682: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
683: x_caId IN OUT NOCOPY
684: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
685: x_bankAcctId IN OUT NOCOPY
686: IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE,

Line 684: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

680: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
681: x_caPayReqCd IN OUT NOCOPY
682: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
683: x_caId IN OUT NOCOPY
684: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
685: x_bankAcctId IN OUT NOCOPY
686: IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE,
687: x_profileId IN OUT NOCOPY
688: IBY_PAY_SERVICE_REQUESTS.payment_profile_id%TYPE

Line 686: IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE,

682: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
683: x_caId IN OUT NOCOPY
684: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
685: x_bankAcctId IN OUT NOCOPY
686: IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE,
687: x_profileId IN OUT NOCOPY
688: IBY_PAY_SERVICE_REQUESTS.payment_profile_id%TYPE
689: )
690: IS

Line 688: IBY_PAY_SERVICE_REQUESTS.payment_profile_id%TYPE

684: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
685: x_bankAcctId IN OUT NOCOPY
686: IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE,
687: x_profileId IN OUT NOCOPY
688: IBY_PAY_SERVICE_REQUESTS.payment_profile_id%TYPE
689: )
690: IS
691: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.getRequestAttributes';
692: BEGIN

Line 702: FROM IBY_PAY_SERVICE_REQUESTS

698: INTO x_caPayReqCd,
699: x_caId,
700: x_bankAcctId,
701: x_profileId
702: FROM IBY_PAY_SERVICE_REQUESTS
703: WHERE payment_service_request_id = p_payReqId;
704:
705: END getRequestAttributes;
706:

Line 813: p_payReqID IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,

809: | NOTES:
810: |
811: *---------------------------------------------------------------------*/
812: PROCEDURE finalizeStatuses(
813: p_payReqID IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
814: x_req_status IN OUT NOCOPY VARCHAR2
815: )
816: IS
817:

Line 835: IBY_PAY_SERVICE_REQUESTS

831: ;
832:
833: /* Update payment request statuse */
834: UPDATE
835: IBY_PAY_SERVICE_REQUESTS
836: SET
837: payment_service_request_status = REQ_STATUS_FULL_ASSIGNED
838: WHERE
839: payment_service_request_id = p_payReqID

Line 1223: p_payReqID IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,

1219: | NOTES:
1220: |
1221: *---------------------------------------------------------------------*/
1222: PROCEDURE updateRequestStatus(
1223: p_payReqID IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
1224: x_req_status IN OUT NOCOPY VARCHAR2
1225: )
1226: IS
1227:

Line 1280: IBY_PAY_SERVICE_REQUESTS

1276:
1277: x_req_status := REQ_STATUS_FULL_ASSIGNED;
1278:
1279: UPDATE
1280: IBY_PAY_SERVICE_REQUESTS
1281: SET
1282: payment_service_request_status = REQ_STATUS_FULL_ASSIGNED
1283: WHERE
1284: payment_service_request_id = p_payreqID

Line 1445: IBY_PAY_SERVICE_REQUESTS

1441: /*
1442: * Update the payment request status appropriately.
1443: */
1444: UPDATE
1445: IBY_PAY_SERVICE_REQUESTS
1446: SET
1447: payment_service_request_status = l_request_status
1448: WHERE
1449: payment_service_request_id = p_payreqID