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 113: RETURN XMLTYPE;

109: RETURN VARCHAR2;
110:
111:
112: FUNCTION Get_PayerContact(p_party_id IN NUMBER)
113: RETURN XMLTYPE;
114:
115: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER)
116: RETURN XMLTYPE;
117:

Line 116: RETURN XMLTYPE;

112: FUNCTION Get_PayerContact(p_party_id IN NUMBER)
113: RETURN XMLTYPE;
114:
115: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER)
116: RETURN XMLTYPE;
117:
118: FUNCTION format_hr_address(p_hr_location_id IN NUMBER,
119: p_style_code IN VARCHAR2 DEFAULT NULL)
120: RETURN VARCHAR2;

Line 132: RETURN XMLTYPE;

128: FUNCTION Get_Pmt_DocPayableCount(p_payment_id IN NUMBER)
129: RETURN NUMBER;
130:
131: FUNCTION Get_Ins_PayerInstrAgg(p_payment_instruction_id IN NUMBER)
132: RETURN XMLTYPE;
133:
134:
135: FUNCTION Get_Payer(p_legal_entity_id IN NUMBER)
136: RETURN XMLTYPE;

Line 136: RETURN XMLTYPE;

132: RETURN XMLTYPE;
133:
134:
135: FUNCTION Get_Payer(p_legal_entity_id IN NUMBER)
136: RETURN XMLTYPE;
137:
138: FUNCTION Get_PayerBankAccount(p_bank_account_id IN NUMBER)
139: RETURN XMLTYPE;
140:

Line 139: RETURN XMLTYPE;

135: FUNCTION Get_Payer(p_legal_entity_id IN NUMBER)
136: RETURN XMLTYPE;
137:
138: FUNCTION Get_PayerBankAccount(p_bank_account_id IN NUMBER)
139: RETURN XMLTYPE;
140:
141:
142: FUNCTION Get_Payer_Denorm(p_payment_id IN NUMBER)
143: RETURN XMLTYPE;

Line 143: RETURN XMLTYPE;

139: RETURN XMLTYPE;
140:
141:
142: FUNCTION Get_Payer_Denorm(p_payment_id IN NUMBER)
143: RETURN XMLTYPE;
144:
145: FUNCTION Get_PayerBankAccount_Denorm(p_payment_id IN NUMBER)
146: RETURN XMLTYPE;
147:

Line 146: RETURN XMLTYPE;

142: FUNCTION Get_Payer_Denorm(p_payment_id IN NUMBER)
143: RETURN XMLTYPE;
144:
145: FUNCTION Get_PayerBankAccount_Denorm(p_payment_id IN NUMBER)
146: RETURN XMLTYPE;
147:
148:
149: FUNCTION Get_PayerIns_Denorm(p_payment_instruction_id IN NUMBER)
150: RETURN XMLTYPE;

Line 150: RETURN XMLTYPE;

146: RETURN XMLTYPE;
147:
148:
149: FUNCTION Get_PayerIns_Denorm(p_payment_instruction_id IN NUMBER)
150: RETURN XMLTYPE;
151:
152: FUNCTION Get_PayerBankAccountIns_Denorm(p_payment_instruction_id IN NUMBER)
153: RETURN XMLTYPE;
154:

Line 153: RETURN XMLTYPE;

149: FUNCTION Get_PayerIns_Denorm(p_payment_instruction_id IN NUMBER)
150: RETURN XMLTYPE;
151:
152: FUNCTION Get_PayerBankAccountIns_Denorm(p_payment_instruction_id IN NUMBER)
153: RETURN XMLTYPE;
154:
155:
156: FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
157: RETURN XMLTYPE;

Line 157: RETURN XMLTYPE;

153: RETURN XMLTYPE;
154:
155:
156: FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
157: RETURN XMLTYPE;
158:
159: FUNCTION Get_Ins_AccountSettingsAgg(p_bep_account_id IN NUMBER)
160: RETURN XMLTYPE;
161:

Line 160: RETURN XMLTYPE;

156: FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
157: RETURN XMLTYPE;
158:
159: FUNCTION Get_Ins_AccountSettingsAgg(p_bep_account_id IN NUMBER)
160: RETURN XMLTYPE;
161:
162: FUNCTION Get_Pmt_DocPayableAgg(p_payment_id IN NUMBER)
163: RETURN XMLTYPE;
164:

Line 163: RETURN XMLTYPE;

159: FUNCTION Get_Ins_AccountSettingsAgg(p_bep_account_id IN NUMBER)
160: RETURN XMLTYPE;
161:
162: FUNCTION Get_Pmt_DocPayableAgg(p_payment_id IN NUMBER)
163: RETURN XMLTYPE;
164:
165: FUNCTION Get_Payee(p_payment_id IN NUMBER)
166: RETURN XMLTYPE;
167:

Line 166: RETURN XMLTYPE;

162: FUNCTION Get_Pmt_DocPayableAgg(p_payment_id IN NUMBER)
163: RETURN XMLTYPE;
164:
165: FUNCTION Get_Payee(p_payment_id IN NUMBER)
166: RETURN XMLTYPE;
167:
168: /* TPP - Start */
169: FUNCTION Get_InvPayee(p_payment_id IN NUMBER)
170: RETURN XMLTYPE;

Line 170: RETURN XMLTYPE;

166: RETURN XMLTYPE;
167:
168: /* TPP - Start */
169: FUNCTION Get_InvPayee(p_payment_id IN NUMBER)
170: RETURN XMLTYPE;
171:
172: FUNCTION get_rel_add_info(
173: payee_party_id IN NUMBER,
174: supplier_site_id IN NUMBER,

Line 188: RETURN XMLTYPE;

184: RETURN NUMBER;
185: /* TPP - End */
186:
187: FUNCTION Get_PayeeBankAccount(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
188: RETURN XMLTYPE;
189:
190: FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
191: RETURN XMLTYPE;
192:

Line 191: RETURN XMLTYPE;

187: FUNCTION Get_PayeeBankAccount(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
188: RETURN XMLTYPE;
189:
190: FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
191: RETURN XMLTYPE;
192:
193: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER)
194: RETURN XMLTYPE;
195:

Line 194: RETURN XMLTYPE;

190: FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
191: RETURN XMLTYPE;
192:
193: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER)
194: RETURN XMLTYPE;
195:
196: FUNCTION Get_SRA_Attribute(p_payment_id IN NUMBER, p_attribute_type IN NUMBER)
197: RETURN VARCHAR2;
198:

Line 234: RETURN XMLTYPE;

230:
231:
232: -- Payment process request extract functions
233: FUNCTION Get_Ppr_PmtAgg(p_payment_service_request_id IN NUMBER)
234: RETURN XMLTYPE;
235:
236: FUNCTION Get_Ppr_PmtCount(p_payment_service_request_id IN NUMBER)
237: RETURN NUMBER;
238:

Line 240: RETURN XMLTYPE;

236: FUNCTION Get_Ppr_PmtCount(p_payment_service_request_id IN NUMBER)
237: RETURN NUMBER;
238:
239: FUNCTION Get_Ppr_PreBuildDocAgg(p_payment_service_request_id IN NUMBER)
240: RETURN XMLTYPE;
241:
242: FUNCTION Get_Ppr_PreBuildDocCount(p_payment_service_request_id IN NUMBER)
243: RETURN NUMBER;
244:

Line 246: RETURN XMLTYPE;

242: FUNCTION Get_Ppr_PreBuildDocCount(p_payment_service_request_id IN NUMBER)
243: RETURN NUMBER;
244:
245: FUNCTION Get_Pmt_PmtErrAgg(p_payment_id IN NUMBER)
246: RETURN XMLTYPE;
247:
248: FUNCTION Get_Doc_DocErrAgg(p_document_payable_id IN NUMBER)
249: RETURN XMLTYPE;
250:

Line 249: RETURN XMLTYPE;

245: FUNCTION Get_Pmt_PmtErrAgg(p_payment_id IN NUMBER)
246: RETURN XMLTYPE;
247:
248: FUNCTION Get_Doc_DocErrAgg(p_document_payable_id IN NUMBER)
249: RETURN XMLTYPE;
250:
251: PROCEDURE Update_Pmt_SRA_Attr_Prt
252: (
253: p_payment_instruction_id IN NUMBER

Line 266: RETURN XMLTYPE;

262: );
263:
264: PROCEDURE initialize;
265: FUNCTION Get_Hz_Address(p_location_id IN NUMBER)
266: RETURN XMLTYPE;
267:
268: FUNCTION Get_Account_Address(p_location_id IN NUMBER, p_country IN VARCHAR2)
269: RETURN XMLTYPE;
270:

Line 269: RETURN XMLTYPE;

265: FUNCTION Get_Hz_Address(p_location_id IN NUMBER)
266: RETURN XMLTYPE;
267:
268: FUNCTION Get_Account_Address(p_location_id IN NUMBER, p_country IN VARCHAR2)
269: RETURN XMLTYPE;
270:
271: FUNCTION Get_Hr_Address(p_location_id IN NUMBER)
272: RETURN XMLTYPE;
273:

Line 272: RETURN XMLTYPE;

268: FUNCTION Get_Account_Address(p_location_id IN NUMBER, p_country IN VARCHAR2)
269: RETURN XMLTYPE;
270:
271: FUNCTION Get_Hr_Address(p_location_id IN NUMBER)
272: RETURN XMLTYPE;
273:
274: FUNCTION Get_Ins_TotalAmt(p_payment_instruction_id IN NUMBER)
275: RETURN NUMBER;
276: