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 83: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

79: | NOTES:
80: |
81: *---------------------------------------------------------------------*/
82: PROCEDURE performAssignments(
83: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
84: payment_service_request_id%type,
85: x_return_status IN OUT NOCOPY VARCHAR2)
86: IS
87:

Line 132: req_ca_payreq_id iby_pay_service_requests.

128: doc_pmt_date iby_docs_payable_all.payment_date%TYPE;
129: doc_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
130:
131: /* variables for fields from payment request */
132: req_ca_payreq_id iby_pay_service_requests.
133: call_app_pay_service_req_code%TYPE;
134: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;
135: req_int_bank_acct_id iby_pay_service_requests.internal_bank_account_id%TYPE;
136: req_profile_id iby_pay_service_requests.payment_profile_id%TYPE;

Line 134: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;

130:
131: /* variables for fields from payment request */
132: req_ca_payreq_id iby_pay_service_requests.
133: call_app_pay_service_req_code%TYPE;
134: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;
135: req_int_bank_acct_id iby_pay_service_requests.internal_bank_account_id%TYPE;
136: req_profile_id iby_pay_service_requests.payment_profile_id%TYPE;
137:
138: /*

Line 135: req_int_bank_acct_id iby_pay_service_requests.internal_bank_account_id%TYPE;

131: /* variables for fields from payment request */
132: req_ca_payreq_id iby_pay_service_requests.
133: call_app_pay_service_req_code%TYPE;
134: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;
135: req_int_bank_acct_id iby_pay_service_requests.internal_bank_account_id%TYPE;
136: req_profile_id iby_pay_service_requests.payment_profile_id%TYPE;
137:
138: /*
139: * Cursor to pick up the documents of a given payment request.

Line 136: req_profile_id iby_pay_service_requests.payment_profile_id%TYPE;

132: req_ca_payreq_id iby_pay_service_requests.
133: call_app_pay_service_req_code%TYPE;
134: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;
135: req_int_bank_acct_id iby_pay_service_requests.internal_bank_account_id%TYPE;
136: req_profile_id iby_pay_service_requests.payment_profile_id%TYPE;
137:
138: /*
139: * Cursor to pick up the documents of a given payment request.
140: */

Line 782: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,

778: | NOTES:
779: |
780: *---------------------------------------------------------------------*/
781: PROCEDURE getRequestAttributes(
782: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
783: x_caPayReqCd IN OUT NOCOPY
784: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
785: x_caId IN OUT NOCOPY
786: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

Line 784: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,

780: *---------------------------------------------------------------------*/
781: PROCEDURE getRequestAttributes(
782: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
783: x_caPayReqCd IN OUT NOCOPY
784: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
785: x_caId IN OUT NOCOPY
786: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
787: x_bankAcctId IN OUT NOCOPY
788: IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE,

Line 786: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

782: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
783: x_caPayReqCd IN OUT NOCOPY
784: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
785: x_caId IN OUT NOCOPY
786: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
787: x_bankAcctId IN OUT NOCOPY
788: IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE,
789: x_profileId IN OUT NOCOPY
790: IBY_PAY_SERVICE_REQUESTS.payment_profile_id%TYPE

Line 788: IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE,

784: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
785: x_caId IN OUT NOCOPY
786: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
787: x_bankAcctId IN OUT NOCOPY
788: IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE,
789: x_profileId IN OUT NOCOPY
790: IBY_PAY_SERVICE_REQUESTS.payment_profile_id%TYPE
791: )
792: IS

Line 790: IBY_PAY_SERVICE_REQUESTS.payment_profile_id%TYPE

786: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
787: x_bankAcctId IN OUT NOCOPY
788: IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE,
789: x_profileId IN OUT NOCOPY
790: IBY_PAY_SERVICE_REQUESTS.payment_profile_id%TYPE
791: )
792: IS
793: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.getRequestAttributes';
794: BEGIN

Line 804: FROM IBY_PAY_SERVICE_REQUESTS

800: INTO x_caPayReqCd,
801: x_caId,
802: x_bankAcctId,
803: x_profileId
804: FROM IBY_PAY_SERVICE_REQUESTS
805: WHERE payment_service_request_id = p_payReqId;
806:
807: END getRequestAttributes;
808:

Line 923: p_payReqID IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,

919: | NOTES:
920: |
921: *---------------------------------------------------------------------*/
922: PROCEDURE finalizeStatuses(
923: p_payReqID IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
924: x_req_status IN OUT NOCOPY VARCHAR2
925: )
926: IS
927:

Line 947: IBY_PAY_SERVICE_REQUESTS

943: ;
944:
945: /* Update payment request statuse */
946: UPDATE
947: IBY_PAY_SERVICE_REQUESTS
948: SET
949: payment_service_request_status = REQ_STATUS_FULL_ASSIGNED
950: WHERE
951: payment_service_request_id = p_payReqID

Line 1376: p_payReqID IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,

1372: | NOTES:
1373: |
1374: *---------------------------------------------------------------------*/
1375: PROCEDURE updateRequestStatus(
1376: p_payReqID IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
1377: x_req_status IN OUT NOCOPY VARCHAR2
1378: )
1379: IS
1380:

Line 1440: IBY_PAY_SERVICE_REQUESTS

1436:
1437: x_req_status := REQ_STATUS_FULL_ASSIGNED;
1438:
1439: UPDATE
1440: IBY_PAY_SERVICE_REQUESTS
1441: SET
1442: payment_service_request_status = REQ_STATUS_FULL_ASSIGNED
1443: WHERE
1444: payment_service_request_id = p_payreqID

Line 1568: IBY_PAY_SERVICE_REQUESTS

1564: /*
1565: * Update the payment request status appropriately.
1566: */
1567: UPDATE
1568: IBY_PAY_SERVICE_REQUESTS
1569: SET
1570: payment_service_request_status = l_request_status
1571: WHERE
1572: payment_service_request_id = p_payreqID