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_FD_EXTRACT_GEN_PVT dependencies on XMLTYPE

Line 152: RETURN XMLTYPE;

148: RETURN VARCHAR2;
149:
150:
151: FUNCTION Get_PayerContact(p_party_id IN NUMBER)
152: RETURN XMLTYPE;
153:
154: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER)
155: RETURN XMLTYPE;
156: /*Overloaded Function*/

Line 155: RETURN XMLTYPE;

151: FUNCTION Get_PayerContact(p_party_id IN NUMBER)
152: RETURN XMLTYPE;
153:
154: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER)
155: RETURN XMLTYPE;
156: /*Overloaded Function*/
157: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER
158: ,p_remit_to_location_id IN iby_payments_all.remit_to_location_id%TYPE
159: ,p_party_site_id IN iby_payments_all.party_site_id%TYPE

Line 161: RETURN XMLTYPE;

157: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER
158: ,p_remit_to_location_id IN iby_payments_all.remit_to_location_id%TYPE
159: ,p_party_site_id IN iby_payments_all.party_site_id%TYPE
160: ,p_payee_party_id IN iby_payments_all.payee_party_id%TYPE)
161: RETURN XMLTYPE;
162:
163: FUNCTION format_hr_address(p_hr_location_id IN NUMBER,
164: p_style_code IN VARCHAR2 DEFAULT NULL)
165: RETURN VARCHAR2;

Line 177: RETURN XMLTYPE;

173: FUNCTION Get_Pmt_DocPayableCount(p_payment_id IN NUMBER)
174: RETURN NUMBER;
175:
176: FUNCTION Get_Ins_PayerInstrAgg(p_payment_instruction_id IN NUMBER)
177: RETURN XMLTYPE;
178:
179:
180: FUNCTION Get_Payer(p_legal_entity_id IN NUMBER)
181: RETURN XMLTYPE;

Line 181: RETURN XMLTYPE;

177: RETURN XMLTYPE;
178:
179:
180: FUNCTION Get_Payer(p_legal_entity_id IN NUMBER)
181: RETURN XMLTYPE;
182:
183: FUNCTION Get_PayerBankAccount(p_bank_account_id IN NUMBER)
184: RETURN XMLTYPE;
185:

Line 184: RETURN XMLTYPE;

180: FUNCTION Get_Payer(p_legal_entity_id IN NUMBER)
181: RETURN XMLTYPE;
182:
183: FUNCTION Get_PayerBankAccount(p_bank_account_id IN NUMBER)
184: RETURN XMLTYPE;
185:
186:
187: FUNCTION Get_Payer_Denorm(p_payment_id IN NUMBER)
188: RETURN XMLTYPE;

Line 188: RETURN XMLTYPE;

184: RETURN XMLTYPE;
185:
186:
187: FUNCTION Get_Payer_Denorm(p_payment_id IN NUMBER)
188: RETURN XMLTYPE;
189:
190: FUNCTION Get_PayerBankAccount_Denorm(p_payment_id IN NUMBER)
191: RETURN XMLTYPE;
192:

Line 191: RETURN XMLTYPE;

187: FUNCTION Get_Payer_Denorm(p_payment_id IN NUMBER)
188: RETURN XMLTYPE;
189:
190: FUNCTION Get_PayerBankAccount_Denorm(p_payment_id IN NUMBER)
191: RETURN XMLTYPE;
192:
193:
194: FUNCTION Get_PayerIns_Denorm(p_payment_instruction_id IN NUMBER)
195: RETURN XMLTYPE;

Line 195: RETURN XMLTYPE;

191: RETURN XMLTYPE;
192:
193:
194: FUNCTION Get_PayerIns_Denorm(p_payment_instruction_id IN NUMBER)
195: RETURN XMLTYPE;
196:
197: FUNCTION Get_PayerBankAccountIns_Denorm(p_payment_instruction_id IN NUMBER)
198: RETURN XMLTYPE;
199:

Line 198: RETURN XMLTYPE;

194: FUNCTION Get_PayerIns_Denorm(p_payment_instruction_id IN NUMBER)
195: RETURN XMLTYPE;
196:
197: FUNCTION Get_PayerBankAccountIns_Denorm(p_payment_instruction_id IN NUMBER)
198: RETURN XMLTYPE;
199:
200:
201: FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
202: RETURN XMLTYPE;

Line 202: RETURN XMLTYPE;

198: RETURN XMLTYPE;
199:
200:
201: FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
202: RETURN XMLTYPE;
203:
204: FUNCTION Get_Ins_AccountSettingsAgg(p_bep_account_id IN NUMBER)
205: RETURN XMLTYPE;
206:

Line 205: RETURN XMLTYPE;

201: FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
202: RETURN XMLTYPE;
203:
204: FUNCTION Get_Ins_AccountSettingsAgg(p_bep_account_id IN NUMBER)
205: RETURN XMLTYPE;
206:
207: FUNCTION Get_Pmt_DocPayableAgg(p_payment_id IN NUMBER)
208: RETURN XMLTYPE;
209:

Line 208: RETURN XMLTYPE;

204: FUNCTION Get_Ins_AccountSettingsAgg(p_bep_account_id IN NUMBER)
205: RETURN XMLTYPE;
206:
207: FUNCTION Get_Pmt_DocPayableAgg(p_payment_id IN NUMBER)
208: RETURN XMLTYPE;
209:
210: FUNCTION Get_Payee(p_payment_id IN NUMBER)
211: RETURN XMLTYPE;
212:

Line 211: RETURN XMLTYPE;

207: FUNCTION Get_Pmt_DocPayableAgg(p_payment_id IN NUMBER)
208: RETURN XMLTYPE;
209:
210: FUNCTION Get_Payee(p_payment_id IN NUMBER)
211: RETURN XMLTYPE;
212:
213:
214: --Overloaded Function
215: FUNCTION Get_Payee(p_payment_id IN NUMBER, p_pmt_func IN VARCHAR2)

Line 216: RETURN XMLTYPE;

212:
213:
214: --Overloaded Function
215: FUNCTION Get_Payee(p_payment_id IN NUMBER, p_pmt_func IN VARCHAR2)
216: RETURN XMLTYPE;
217:
218: /* TPP - Start */
219: FUNCTION Get_InvPayee(p_payment_id IN NUMBER)
220: RETURN XMLTYPE;

Line 220: RETURN XMLTYPE;

216: RETURN XMLTYPE;
217:
218: /* TPP - Start */
219: FUNCTION Get_InvPayee(p_payment_id IN NUMBER)
220: RETURN XMLTYPE;
221:
222: FUNCTION get_rel_add_info(
223: payee_party_id IN NUMBER,
224: supplier_site_id IN NUMBER,

Line 238: RETURN XMLTYPE;

234: RETURN NUMBER;
235: /* TPP - End */
236:
237: FUNCTION Get_PayeeBankAccount(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
238: RETURN XMLTYPE;
239:
240: FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
241: RETURN XMLTYPE;
242:

Line 241: RETURN XMLTYPE;

237: FUNCTION Get_PayeeBankAccount(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
238: RETURN XMLTYPE;
239:
240: FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
241: RETURN XMLTYPE;
242:
243: FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER
244: , p_external_bank_account_id IN NUMBER
245: ,p_pmt_func IN VARCHAR2)

Line 246: RETURN XMLTYPE;

242:
243: FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER
244: , p_external_bank_account_id IN NUMBER
245: ,p_pmt_func IN VARCHAR2)
246: RETURN XMLTYPE;
247:
248: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER)
249: RETURN XMLTYPE;
250: -- Overloaded function Citi Perf issues.

Line 249: RETURN XMLTYPE;

245: ,p_pmt_func IN VARCHAR2)
246: RETURN XMLTYPE;
247:
248: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER)
249: RETURN XMLTYPE;
250: -- Overloaded function Citi Perf issues.
251: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER,
252: p_call_app_doc_unique_ref2 IN ap_invoices_all.invoice_id%TYPE,
253: p_doc_currency_code IN iby_docs_payable_all.document_currency_code%TYPE,

Line 255: RETURN XMLTYPE;

251: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER,
252: p_call_app_doc_unique_ref2 IN ap_invoices_all.invoice_id%TYPE,
253: p_doc_currency_code IN iby_docs_payable_all.document_currency_code%TYPE,
254: p_calling_app_id IN iby_docs_payable_all.calling_app_id%TYPE)
255: RETURN XMLTYPE;
256: --Overloaded function Citi perf
257:
258: FUNCTION Get_SRA_Attribute(p_payment_id IN NUMBER, p_attribute_type IN NUMBER)
259: RETURN VARCHAR2;

Line 296: RETURN XMLTYPE;

292:
293:
294: -- Payment process request extract functions
295: FUNCTION Get_Ppr_PmtAgg(p_payment_service_request_id IN NUMBER)
296: RETURN XMLTYPE;
297:
298: FUNCTION Get_Ppr_PmtCount(p_payment_service_request_id IN NUMBER)
299: RETURN NUMBER;
300:

Line 302: RETURN XMLTYPE;

298: FUNCTION Get_Ppr_PmtCount(p_payment_service_request_id IN NUMBER)
299: RETURN NUMBER;
300:
301: FUNCTION Get_Ppr_PreBuildDocAgg(p_payment_service_request_id IN NUMBER)
302: RETURN XMLTYPE;
303:
304: FUNCTION Get_Ppr_PreBuildDocCount(p_payment_service_request_id IN NUMBER)
305: RETURN NUMBER;
306:

Line 308: RETURN XMLTYPE;

304: FUNCTION Get_Ppr_PreBuildDocCount(p_payment_service_request_id IN NUMBER)
305: RETURN NUMBER;
306:
307: FUNCTION Get_Pmt_PmtErrAgg(p_payment_id IN NUMBER)
308: RETURN XMLTYPE;
309:
310: FUNCTION Get_Doc_DocErrAgg(p_document_payable_id IN NUMBER)
311: RETURN XMLTYPE;
312:

Line 311: RETURN XMLTYPE;

307: FUNCTION Get_Pmt_PmtErrAgg(p_payment_id IN NUMBER)
308: RETURN XMLTYPE;
309:
310: FUNCTION Get_Doc_DocErrAgg(p_document_payable_id IN NUMBER)
311: RETURN XMLTYPE;
312:
313: PROCEDURE Update_Pmt_SRA_Attr_Prt
314: (
315: p_payment_instruction_id IN NUMBER

Line 328: RETURN XMLTYPE;

324: );
325:
326: PROCEDURE initialize;
327: FUNCTION Get_Hz_Address(p_location_id IN NUMBER)
328: RETURN XMLTYPE;
329:
330: FUNCTION Get_Account_Address(p_location_id IN NUMBER, p_country IN VARCHAR2)
331: RETURN XMLTYPE;
332:

Line 331: RETURN XMLTYPE;

327: FUNCTION Get_Hz_Address(p_location_id IN NUMBER)
328: RETURN XMLTYPE;
329:
330: FUNCTION Get_Account_Address(p_location_id IN NUMBER, p_country IN VARCHAR2)
331: RETURN XMLTYPE;
332:
333: FUNCTION Get_Hr_Address(p_location_id IN NUMBER)
334: RETURN XMLTYPE;
335:

Line 334: RETURN XMLTYPE;

330: FUNCTION Get_Account_Address(p_location_id IN NUMBER, p_country IN VARCHAR2)
331: RETURN XMLTYPE;
332:
333: FUNCTION Get_Hr_Address(p_location_id IN NUMBER)
334: RETURN XMLTYPE;
335:
336: FUNCTION Get_Ins_TotalAmt(p_payment_instruction_id IN NUMBER)
337: RETURN NUMBER;
338:

Line 343: RETURN XMLTYPE;

339: FUNCTION Get_Expense_Rpt_CC_Num(p_document_payable_id IN NUMBER)
340: RETURN VARCHAR2;
341:
342: FUNCTION Get_CC_Num_For_Issuer_Pmt_Agg(p_document_payable_id IN NUMBER)
343: RETURN XMLTYPE;
344:
345: FUNCTION Replace_Special_Characters(p_base_string IN varchar2)
346: RETURN VARCHAR2;
347:

Line 350: RETURN XMLTYPE;

346: RETURN VARCHAR2;
347:
348: /* Bug 9266772*/
349: FUNCTION Get_Intermediary_Bank_Accts(p_bank_acct_id IN NUMBER)
350: RETURN XMLTYPE;
351: /* Bug 9266772*/
352:
353: /*Bug 11923557 */
354: FUNCTION get_PayeeBankAccountAssignment(p_pmt_id IN Number,p_ext_bank_acct_id IN Number)

Line 355: RETURN XMLTYPE;

351: /* Bug 9266772*/
352:
353: /*Bug 11923557 */
354: FUNCTION get_PayeeBankAccountAssignment(p_pmt_id IN Number,p_ext_bank_acct_id IN Number)
355: RETURN XMLTYPE;
356: /*Bug 11923557 */
357: END IBY_FD_EXTRACT_GEN_PVT;
358:
359: