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 72: l_profile_id iby_docs_payable_all.payment_profile_id%TYPE := -1;

68: IS
69:
70: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
71: '.performAssignments';
72: l_profile_id iby_docs_payable_all.payment_profile_id%TYPE := -1;
73:
74: dummybankAccountsArray IBY_ASSIGN_PUB.bankAccounts;
75: bankAccountsArray CE_BANK_AND_ACCOUNT_UTIL.BankAcctIdTable;
76:

Line 90: doc_id iby_docs_payable_all.document_payable_id%TYPE;

86: l_trx_line_index BINARY_INTEGER;
87: l_no_rec_in_ppr BOOLEAN;
88:
89: /* variables for fields from document */
90: doc_id iby_docs_payable_all.document_payable_id%TYPE;
91: ca_doc_id1 iby_docs_payable_all.
92: calling_app_doc_unique_ref1%TYPE;
93: ca_doc_id2 iby_docs_payable_all.
94: calling_app_doc_unique_ref2%TYPE;

Line 91: ca_doc_id1 iby_docs_payable_all.

87: l_no_rec_in_ppr BOOLEAN;
88:
89: /* variables for fields from document */
90: doc_id iby_docs_payable_all.document_payable_id%TYPE;
91: ca_doc_id1 iby_docs_payable_all.
92: calling_app_doc_unique_ref1%TYPE;
93: ca_doc_id2 iby_docs_payable_all.
94: calling_app_doc_unique_ref2%TYPE;
95: ca_doc_id3 iby_docs_payable_all.

Line 93: ca_doc_id2 iby_docs_payable_all.

89: /* variables for fields from document */
90: doc_id iby_docs_payable_all.document_payable_id%TYPE;
91: ca_doc_id1 iby_docs_payable_all.
92: calling_app_doc_unique_ref1%TYPE;
93: ca_doc_id2 iby_docs_payable_all.
94: calling_app_doc_unique_ref2%TYPE;
95: ca_doc_id3 iby_docs_payable_all.
96: calling_app_doc_unique_ref3%TYPE;
97: ca_doc_id4 iby_docs_payable_all.

Line 95: ca_doc_id3 iby_docs_payable_all.

91: ca_doc_id1 iby_docs_payable_all.
92: calling_app_doc_unique_ref1%TYPE;
93: ca_doc_id2 iby_docs_payable_all.
94: calling_app_doc_unique_ref2%TYPE;
95: ca_doc_id3 iby_docs_payable_all.
96: calling_app_doc_unique_ref3%TYPE;
97: ca_doc_id4 iby_docs_payable_all.
98: calling_app_doc_unique_ref4%TYPE;
99: ca_doc_id5 iby_docs_payable_all.

Line 97: ca_doc_id4 iby_docs_payable_all.

93: ca_doc_id2 iby_docs_payable_all.
94: calling_app_doc_unique_ref2%TYPE;
95: ca_doc_id3 iby_docs_payable_all.
96: calling_app_doc_unique_ref3%TYPE;
97: ca_doc_id4 iby_docs_payable_all.
98: calling_app_doc_unique_ref4%TYPE;
99: ca_doc_id5 iby_docs_payable_all.
100: calling_app_doc_unique_ref5%TYPE;
101: ca_id iby_docs_payable_all.calling_app_id%TYPE;

Line 99: ca_doc_id5 iby_docs_payable_all.

95: ca_doc_id3 iby_docs_payable_all.
96: calling_app_doc_unique_ref3%TYPE;
97: ca_doc_id4 iby_docs_payable_all.
98: calling_app_doc_unique_ref4%TYPE;
99: ca_doc_id5 iby_docs_payable_all.
100: calling_app_doc_unique_ref5%TYPE;
101: ca_id iby_docs_payable_all.calling_app_id%TYPE;
102: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
103: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;

Line 101: ca_id iby_docs_payable_all.calling_app_id%TYPE;

97: ca_doc_id4 iby_docs_payable_all.
98: calling_app_doc_unique_ref4%TYPE;
99: ca_doc_id5 iby_docs_payable_all.
100: calling_app_doc_unique_ref5%TYPE;
101: ca_id iby_docs_payable_all.calling_app_id%TYPE;
102: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
103: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
104: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
105: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;

Line 102: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;

98: calling_app_doc_unique_ref4%TYPE;
99: ca_doc_id5 iby_docs_payable_all.
100: calling_app_doc_unique_ref5%TYPE;
101: ca_id iby_docs_payable_all.calling_app_id%TYPE;
102: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
103: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
104: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
105: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
106: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;

Line 103: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;

99: ca_doc_id5 iby_docs_payable_all.
100: calling_app_doc_unique_ref5%TYPE;
101: ca_id iby_docs_payable_all.calling_app_id%TYPE;
102: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
103: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
104: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
105: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
106: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
107: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;

Line 104: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;

100: calling_app_doc_unique_ref5%TYPE;
101: ca_id iby_docs_payable_all.calling_app_id%TYPE;
102: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
103: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
104: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
105: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
106: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
107: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
108: doc_org_id iby_docs_payable_all.org_id%TYPE;

Line 105: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;

101: ca_id iby_docs_payable_all.calling_app_id%TYPE;
102: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
103: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
104: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
105: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
106: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
107: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
108: doc_org_id iby_docs_payable_all.org_id%TYPE;
109: doc_org_type iby_docs_payable_all.org_type%TYPE;

Line 106: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;

102: pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
103: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
104: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
105: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
106: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
107: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
108: doc_org_id iby_docs_payable_all.org_id%TYPE;
109: doc_org_type iby_docs_payable_all.org_type%TYPE;
110: doc_pmt_date iby_docs_payable_all.payment_date%TYPE;

Line 107: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;

103: doc_int_bank_acct_id iby_docs_payable_all.internal_bank_account_id%TYPE;
104: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
105: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
106: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
107: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
108: doc_org_id iby_docs_payable_all.org_id%TYPE;
109: doc_org_type iby_docs_payable_all.org_type%TYPE;
110: doc_pmt_date iby_docs_payable_all.payment_date%TYPE;
111: doc_payee_id iby_docs_payable_all.ext_payee_id%TYPE;

Line 108: doc_org_id iby_docs_payable_all.org_id%TYPE;

104: doc_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
105: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
106: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
107: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
108: doc_org_id iby_docs_payable_all.org_id%TYPE;
109: doc_org_type iby_docs_payable_all.org_type%TYPE;
110: doc_pmt_date iby_docs_payable_all.payment_date%TYPE;
111: doc_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
112:

Line 109: doc_org_type iby_docs_payable_all.org_type%TYPE;

105: doc_pay_currency iby_docs_payable_all.payment_currency_code%TYPE;
106: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
107: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
108: doc_org_id iby_docs_payable_all.org_id%TYPE;
109: doc_org_type iby_docs_payable_all.org_type%TYPE;
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 */

Line 110: doc_pmt_date iby_docs_payable_all.payment_date%TYPE;

106: doc_pmt_method iby_docs_payable_all.payment_method_code%TYPE;
107: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
108: doc_org_id iby_docs_payable_all.org_id%TYPE;
109: doc_org_type iby_docs_payable_all.org_type%TYPE;
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.

Line 111: doc_payee_id iby_docs_payable_all.ext_payee_id%TYPE;

107: doc_pmt_format iby_docs_payable_all.payment_format_code%TYPE;
108: doc_org_id iby_docs_payable_all.org_id%TYPE;
109: doc_org_type iby_docs_payable_all.org_type%TYPE;
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;

Line 142: FROM IBY_DOCS_PAYABLE_ALL

138: org_id,
139: org_type,
140: payment_date,
141: NVL(ext_payee_id, -1) -- payee id
142: FROM IBY_DOCS_PAYABLE_ALL
143: WHERE payment_service_request_id = p_payment_request_id
144: AND (internal_bank_account_id IS NULL OR
145: payment_profile_id IS NULL)
146: ORDER BY document_payable_id;

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

168:
169: /*-- REQUEST LEVEL DEFAULTING STARTS HERE --*/
170: /*
171: * Populate the updateDocAttributesRec record. This information
172: * will be used to update all documents in IBY_DOCS_PAYABLE_ALL
173: * that have this payment request id.
174: */
175:
176: IF (req_int_bank_acct_id IS NOT NULL) THEN

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

191: * Update the documents and exit.
192: */
193: IF (req_int_bank_acct_id IS NOT NULL AND req_profile_id IS NOT NULL) THEN
194: /*
195: * Update IBY_DOCS_PAYABLE_ALL table with the account id and
196: * profile id from request.
197: */
198: updateDocumentAssignments(l_updateDocsRec);
199:

Line 213: * Update IBY_DOCS_PAYABLE_ALL table with either the account

209: RETURN;
210:
211: ELSIF (req_int_bank_acct_id IS NOT NULL OR req_profile_id IS NOT NULL) THEN
212: /*
213: * Update IBY_DOCS_PAYABLE_ALL table with either the account
214: * id or the profile id (whichever was available).
215: *
216: * Then continue down the process to individually assign
217: * profile/account to the documents on a case-by-case basis.

Line 772: IBY_DOCS_PAYABLE_ALL

768: * string below.
769: */
770:
771: UPDATE
772: IBY_DOCS_PAYABLE_ALL
773: SET
774: internal_bank_account_id =
775: NVL(
776: p_updateDocsRec.int_bank_acct_id,

Line 826: IBY_DOCS_PAYABLE_ALL

822: print_debuginfo(l_module_name, 'ENTER');
823:
824: /* Update document statuses */
825: UPDATE
826: IBY_DOCS_PAYABLE_ALL
827: SET
828: document_status = DOC_STATUS_FULL_ASSIGNED
829: WHERE
830: payment_service_request_id = p_payReqID

Line 871: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

867: | NOTES:
868: |
869: *---------------------------------------------------------------------*/
870: PROCEDURE dummyCEAPI(
871: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
872: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
873: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
874: x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
875: )

Line 872: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,

868: |
869: *---------------------------------------------------------------------*/
870: PROCEDURE dummyCEAPI(
871: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
872: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
873: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
874: x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
875: )
876: IS

Line 873: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

869: *---------------------------------------------------------------------*/
870: PROCEDURE dummyCEAPI(
871: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
872: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
873: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
874: x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
875: )
876: IS
877:

Line 1036: IBY_DOCS_PAYABLE_ALL

1032: || p_setDocAttribsTab(i).status
1033: );
1034:
1035: UPDATE
1036: IBY_DOCS_PAYABLE_ALL
1037: SET
1038: document_status = p_setDocAttribsTab(i).status,
1039: straight_through_flag = 'N'
1040: WHERE

Line 1052: l_sql_str := 'UPDATE IBY_DOCS_PAYABLE_ALL SET '

1048:
1049: /*
1050: * Form the complete SQL statement.
1051: */
1052: l_sql_str := 'UPDATE IBY_DOCS_PAYABLE_ALL SET '
1053: || l_update_str
1054: || ' WHERE document_payable_id = '
1055: || p_setDocAttribsTab(i).doc_id;
1056:

Line 1116: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

1112: | NOTES:
1113: |
1114: *---------------------------------------------------------------------*/
1115: FUNCTION getProfileFromProfileDrivers(
1116: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1117: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1118: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1119: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1120: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

Line 1117: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

1113: |
1114: *---------------------------------------------------------------------*/
1115: FUNCTION getProfileFromProfileDrivers(
1116: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1117: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1118: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1119: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1120: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1121: ) RETURN NUMBER

Line 1118: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

1114: *---------------------------------------------------------------------*/
1115: FUNCTION getProfileFromProfileDrivers(
1116: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1117: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1118: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1119: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1120: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1121: ) RETURN NUMBER
1122: IS

Line 1119: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

1115: FUNCTION getProfileFromProfileDrivers(
1116: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1117: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1118: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1119: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1120: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1121: ) RETURN NUMBER
1122: IS
1123: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 1120: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

1116: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1117: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1118: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1119: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1120: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1121: ) RETURN NUMBER
1122: IS
1123: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
1124: '.getProfileFromProfileDrivers';

Line 1253: FROM IBY_DOCS_PAYABLE_ALL

1249: calling_app_doc_unique_ref5, --| id a
1250: pay_proc_trxn_type_code, --| document
1251: NVL(internal_bank_account_id, -1),
1252: NVL(payment_profile_id, -1)
1253: FROM IBY_DOCS_PAYABLE_ALL
1254: WHERE payment_service_request_id = p_payment_request_id
1255: AND (internal_bank_account_id IS NULL OR
1256: payment_profile_id IS NULL)
1257: ORDER BY document_payable_id;

Line 1837: || 'FROM IBY_DOCS_PAYABLE_ALL '

1833: || 'calling_app_doc_unique_ref5, '
1834: || 'pay_proc_trxn_type_code, '
1835: || 'internal_bank_account_id, '
1836: || 'payment_profile_id '
1837: || 'FROM IBY_DOCS_PAYABLE_ALL '
1838: || 'WHERE payment_service_request_id = :payreq_id '
1839: || 'AND (internal_bank_account_id IS NULL '
1840: || 'OR payment_profile_id IS NULL)';
1841:

Line 1919: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE

1915: | NOTES:
1916: |
1917: *---------------------------------------------------------------------*/
1918: FUNCTION getProfileFromPayeeFormat(
1919: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
1920: ) RETURN NUMBER
1921: IS
1922: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
1923: '.getProfileFromPayeeFormat';