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_DOCS_PAYABLE_ALL

Line 90: l_profile_id iby_docs_payable_all.payment_profile_id%TYPE := -1;

86: IS
87:
88: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
89: '.performAssignments';
90: l_profile_id iby_docs_payable_all.payment_profile_id%TYPE := -1;
91:
92: dummybankAccountsArray IBY_ASSIGN_PUB.bankAccounts;
93: bankAccountsArray CE_BANK_AND_ACCOUNT_UTIL.BankAcctIdTable;
94:

Line 108: doc_id iby_docs_payable_all.document_payable_id%TYPE;

104: l_trx_line_index BINARY_INTEGER;
105: l_no_rec_in_ppr BOOLEAN;
106:
107: /* variables for fields from document */
108: doc_id iby_docs_payable_all.document_payable_id%TYPE;
109: ca_doc_id1 iby_docs_payable_all.
110: calling_app_doc_unique_ref1%TYPE;
111: ca_doc_id2 iby_docs_payable_all.
112: calling_app_doc_unique_ref2%TYPE;

Line 109: ca_doc_id1 iby_docs_payable_all.

105: l_no_rec_in_ppr BOOLEAN;
106:
107: /* variables for fields from document */
108: doc_id iby_docs_payable_all.document_payable_id%TYPE;
109: ca_doc_id1 iby_docs_payable_all.
110: calling_app_doc_unique_ref1%TYPE;
111: ca_doc_id2 iby_docs_payable_all.
112: calling_app_doc_unique_ref2%TYPE;
113: ca_doc_id3 iby_docs_payable_all.

Line 111: ca_doc_id2 iby_docs_payable_all.

107: /* variables for fields from document */
108: doc_id iby_docs_payable_all.document_payable_id%TYPE;
109: ca_doc_id1 iby_docs_payable_all.
110: calling_app_doc_unique_ref1%TYPE;
111: ca_doc_id2 iby_docs_payable_all.
112: calling_app_doc_unique_ref2%TYPE;
113: ca_doc_id3 iby_docs_payable_all.
114: calling_app_doc_unique_ref3%TYPE;
115: ca_doc_id4 iby_docs_payable_all.

Line 113: ca_doc_id3 iby_docs_payable_all.

109: ca_doc_id1 iby_docs_payable_all.
110: calling_app_doc_unique_ref1%TYPE;
111: ca_doc_id2 iby_docs_payable_all.
112: calling_app_doc_unique_ref2%TYPE;
113: ca_doc_id3 iby_docs_payable_all.
114: calling_app_doc_unique_ref3%TYPE;
115: ca_doc_id4 iby_docs_payable_all.
116: calling_app_doc_unique_ref4%TYPE;
117: ca_doc_id5 iby_docs_payable_all.

Line 115: ca_doc_id4 iby_docs_payable_all.

111: ca_doc_id2 iby_docs_payable_all.
112: calling_app_doc_unique_ref2%TYPE;
113: ca_doc_id3 iby_docs_payable_all.
114: calling_app_doc_unique_ref3%TYPE;
115: ca_doc_id4 iby_docs_payable_all.
116: calling_app_doc_unique_ref4%TYPE;
117: ca_doc_id5 iby_docs_payable_all.
118: calling_app_doc_unique_ref5%TYPE;
119: ca_id iby_docs_payable_all.calling_app_id%TYPE;

Line 117: ca_doc_id5 iby_docs_payable_all.

113: ca_doc_id3 iby_docs_payable_all.
114: calling_app_doc_unique_ref3%TYPE;
115: ca_doc_id4 iby_docs_payable_all.
116: calling_app_doc_unique_ref4%TYPE;
117: ca_doc_id5 iby_docs_payable_all.
118: calling_app_doc_unique_ref5%TYPE;
119: ca_id iby_docs_payable_all.calling_app_id%TYPE;
120: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
121: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;

Line 119: ca_id iby_docs_payable_all.calling_app_id%TYPE;

115: ca_doc_id4 iby_docs_payable_all.
116: calling_app_doc_unique_ref4%TYPE;
117: ca_doc_id5 iby_docs_payable_all.
118: calling_app_doc_unique_ref5%TYPE;
119: ca_id iby_docs_payable_all.calling_app_id%TYPE;
120: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
121: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
122: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
123: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;

Line 120: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;

116: calling_app_doc_unique_ref4%TYPE;
117: ca_doc_id5 iby_docs_payable_all.
118: calling_app_doc_unique_ref5%TYPE;
119: ca_id iby_docs_payable_all.calling_app_id%TYPE;
120: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
121: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
122: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
123: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
124: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;

Line 121: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;

117: ca_doc_id5 iby_docs_payable_all.
118: calling_app_doc_unique_ref5%TYPE;
119: ca_id iby_docs_payable_all.calling_app_id%TYPE;
120: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
121: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
122: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
123: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
124: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
125: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;

Line 122: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;

118: calling_app_doc_unique_ref5%TYPE;
119: ca_id iby_docs_payable_all.calling_app_id%TYPE;
120: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
121: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
122: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
123: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
124: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
125: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
126: doc_org_id iby_docs_payable_all.org_id%TYPE;

Line 123: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;

119: ca_id iby_docs_payable_all.calling_app_id%TYPE;
120: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
121: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
122: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
123: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
124: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
125: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
126: doc_org_id iby_docs_payable_all.org_id%TYPE;
127: doc_org_type iby_docs_payable_all.org_type%TYPE;

Line 124: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;

120: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
121: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
122: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
123: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
124: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
125: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
126: doc_org_id iby_docs_payable_all.org_id%TYPE;
127: doc_org_type iby_docs_payable_all.org_type%TYPE;
128: doc_pmt_date iby_docs_payable_all.payment_date%TYPE;

Line 125: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;

121: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
122: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
123: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
124: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
125: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
126: doc_org_id iby_docs_payable_all.org_id%TYPE;
127: doc_org_type iby_docs_payable_all.org_type%TYPE;
128: doc_pmt_date iby_docs_payable_all.payment_date%TYPE;
129: doc_payee_id iby_docs_payable_all.ext_payee_id%TYPE;

Line 126: doc_org_id iby_docs_payable_all.org_id%TYPE;

122: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
123: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
124: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
125: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
126: doc_org_id iby_docs_payable_all.org_id%TYPE;
127: doc_org_type iby_docs_payable_all.org_type%TYPE;
128: doc_pmt_date iby_docs_payable_all.payment_date%TYPE;
129: doc_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
130:

Line 127: doc_org_type iby_docs_payable_all.org_type%TYPE;

123: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
124: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
125: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
126: doc_org_id iby_docs_payable_all.org_id%TYPE;
127: doc_org_type iby_docs_payable_all.org_type%TYPE;
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 */

Line 128: doc_pmt_date iby_docs_payable_all.payment_date%TYPE;

124: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
125: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
126: doc_org_id iby_docs_payable_all.org_id%TYPE;
127: doc_org_type iby_docs_payable_all.org_type%TYPE;
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.

Line 129: doc_payee_id iby_docs_payable_all.ext_payee_id%TYPE;

125: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
126: doc_org_id iby_docs_payable_all.org_id%TYPE;
127: doc_org_type iby_docs_payable_all.org_type%TYPE;
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;

Line 160: FROM IBY_DOCS_PAYABLE_ALL

156: org_id,
157: org_type,
158: payment_date,
159: NVL(ext_payee_id, -1) -- payee id
160: FROM IBY_DOCS_PAYABLE_ALL
161: WHERE payment_service_request_id = p_payment_request_id
162: AND (internal_bank_account_id IS NULL OR
163: payment_profile_id IS NULL)
164: ORDER BY document_payable_id;

Line 196: * will be used to update all documents in IBY_DOCS_PAYABLE_ALL

192:
193: /*-- REQUEST LEVEL DEFAULTING STARTS HERE --*/
194: /*
195: * Populate the updateDocAttributesRec record. This information
196: * will be used to update all documents in IBY_DOCS_PAYABLE_ALL
197: * that have this payment request id.
198: */
199:
200: IF (req_int_bank_acct_id IS NOT NULL) THEN

Line 219: * Update IBY_DOCS_PAYABLE_ALL table with the account id and

215: * Update the documents and exit.
216: */
217: IF (req_int_bank_acct_id IS NOT NULL AND req_profile_id IS NOT NULL) THEN
218: /*
219: * Update IBY_DOCS_PAYABLE_ALL table with the account id and
220: * profile id from request.
221: */
222: updateDocumentAssignments(l_updateDocsRec);
223:

Line 237: * Update IBY_DOCS_PAYABLE_ALL table with either the account

233: RETURN;
234:
235: ELSIF (req_int_bank_acct_id IS NOT NULL OR req_profile_id IS NOT NULL) THEN
236: /*
237: * Update IBY_DOCS_PAYABLE_ALL table with either the account
238: * id or the profile id (whichever was available).
239: *
240: * Then continue down the process to individually assign
241: * profile/account to the documents on a case-by-case basis.

Line 880: IBY_DOCS_PAYABLE_ALL

876: * string below.
877: */
878:
879: UPDATE
880: IBY_DOCS_PAYABLE_ALL
881: SET
882: internal_bank_account_id =
883: NVL(
884: p_updateDocsRec.int_bank_acct_id,

Line 938: IBY_DOCS_PAYABLE_ALL

934: END IF;
935:
936: /* Update document statuses */
937: UPDATE
938: IBY_DOCS_PAYABLE_ALL
939: SET
940: document_status = DOC_STATUS_FULL_ASSIGNED
941: WHERE
942: payment_service_request_id = p_payReqID

Line 985: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

981: | NOTES:
982: |
983: *---------------------------------------------------------------------*/
984: PROCEDURE dummyCEAPI(
985: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
986: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
987: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
988: x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
989: )

Line 986: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,

982: |
983: *---------------------------------------------------------------------*/
984: PROCEDURE dummyCEAPI(
985: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
986: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
987: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
988: x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
989: )
990: IS

Line 987: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

983: *---------------------------------------------------------------------*/
984: PROCEDURE dummyCEAPI(
985: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
986: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
987: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
988: x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
989: )
990: IS
991:

Line 1169: IBY_DOCS_PAYABLE_ALL

1165: );
1166: END IF;
1167:
1168: UPDATE
1169: IBY_DOCS_PAYABLE_ALL
1170: SET
1171: document_status = p_setDocAttribsTab(i).status,
1172: straight_through_flag = 'N'
1173: WHERE

Line 1185: l_sql_str := 'UPDATE IBY_DOCS_PAYABLE_ALL SET '

1181:
1182: /*
1183: * Form the complete SQL statement.
1184: */
1185: l_sql_str := 'UPDATE IBY_DOCS_PAYABLE_ALL SET '
1186: || l_update_str
1187: || ' WHERE document_payable_id = '
1188: || p_setDocAttribsTab(i).doc_id;
1189:

Line 1256: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

1252: | NOTES:
1253: |
1254: *---------------------------------------------------------------------*/
1255: FUNCTION getProfileFromProfileDrivers(
1256: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1257: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1258: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1259: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1260: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

Line 1257: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

1253: |
1254: *---------------------------------------------------------------------*/
1255: FUNCTION getProfileFromProfileDrivers(
1256: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1257: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1258: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1259: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1260: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1261: ) RETURN NUMBER

Line 1258: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

1254: *---------------------------------------------------------------------*/
1255: FUNCTION getProfileFromProfileDrivers(
1256: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1257: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1258: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1259: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1260: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1261: ) RETURN NUMBER
1262: IS

Line 1259: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

1255: FUNCTION getProfileFromProfileDrivers(
1256: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1257: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1258: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1259: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1260: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1261: ) RETURN NUMBER
1262: IS
1263: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 1260: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

1256: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1257: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1258: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1259: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1260: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1261: ) RETURN NUMBER
1262: IS
1263: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
1264: '.getProfileFromProfileDrivers';

Line 1409: FROM IBY_DOCS_PAYABLE_ALL

1405: calling_app_doc_unique_ref5, --| id a
1406: pay_proc_trxn_type_code, --| document
1407: NVL(internal_bank_account_id, -1),
1408: NVL(payment_profile_id, -1)
1409: FROM IBY_DOCS_PAYABLE_ALL
1410: WHERE payment_service_request_id = p_payment_request_id
1411: AND (internal_bank_account_id IS NULL OR
1412: payment_profile_id IS NULL)
1413: ORDER BY document_payable_id;

Line 1945: || 'FROM IBY_DOCS_PAYABLE_ALL '

1941: || 'calling_app_doc_unique_ref5, '
1942: || 'pay_proc_trxn_type_code, '
1943: || 'internal_bank_account_id, '
1944: || 'payment_profile_id '
1945: || 'FROM IBY_DOCS_PAYABLE_ALL '
1946: || 'WHERE payment_service_request_id = :payreq_id '
1947: || 'AND (internal_bank_account_id IS NULL '
1948: || 'OR payment_profile_id IS NULL)';
1949:

Line 2047: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE

2043: | NOTES:
2044: |
2045: *---------------------------------------------------------------------*/
2046: FUNCTION getProfileFromPayeeFormat(
2047: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
2048: ) RETURN NUMBER
2049: IS
2050: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
2051: '.getProfileFromPayeeFormat';