DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_EXT_PUB dependencies on XMLTYPE

Line 16: RETURN XMLTYPE

12: --
13: -- Below is an example implementation:
14: /*
15: FUNCTION Get_Ins_Ext_Agg(p_payment_instruction_id IN NUMBER)
16: RETURN XMLTYPE
17: IS
18: l_ins_ext_agg XMLTYPE;
19:
20: CURSOR l_ins_ext_csr (p_payment_instruction_id IN NUMBER) IS

Line 18: l_ins_ext_agg XMLTYPE;

14: /*
15: FUNCTION Get_Ins_Ext_Agg(p_payment_instruction_id IN NUMBER)
16: RETURN XMLTYPE
17: IS
18: l_ins_ext_agg XMLTYPE;
19:
20: CURSOR l_ins_ext_csr (p_payment_instruction_id IN NUMBER) IS
21: SELECT XMLConcat(
22: XMLElement("Extend",

Line 43: RETURN XMLTYPE;

39:
40: END Get_Ins_Ext_Agg;
41: */
42: FUNCTION Get_Ins_Ext_Agg(p_payment_instruction_id IN NUMBER)
43: RETURN XMLTYPE;
44:
45:
46: --
47: -- This API is called once per payment.

Line 53: RETURN XMLTYPE;

49: -- at the payment level as a SQLX XML Aggregate
50: -- and return the aggregate.
51: --
52: FUNCTION Get_Pmt_Ext_Agg(p_payment_id IN NUMBER)
53: RETURN XMLTYPE;
54:
55:
56: --
57: -- This API is called once per document payable.

Line 63: RETURN XMLTYPE;

59: -- at the document level as a SQLX XML Aggregate
60: -- and return the aggregate.
61: --
62: FUNCTION Get_Doc_Ext_Agg(p_document_payable_id IN NUMBER)
63: RETURN XMLTYPE;
64:
65:
66: --
67: -- This API is called once per document payable line.

Line 86: RETURN XMLTYPE;

82: -- which is ap_invoice_all.invoice_id. The combination of invoice_id and
83: -- p_line_number will uniquely identify the doc line.
84: --
85: FUNCTION Get_Docline_Ext_Agg(p_document_payable_id IN NUMBER, p_line_number IN NUMBER)
86: RETURN XMLTYPE;
87:
88:
89: --
90: -- This API is called once only for the payment process request.

Line 96: RETURN XMLTYPE;

92: -- at the payment request level as a SQLX XML Aggregate
93: -- and return the aggregate.
94: --
95: FUNCTION Get_Ppr_Ext_Agg(p_payment_service_request_id IN NUMBER)
96: RETURN XMLTYPE;
97:
98:
99: END IBY_FD_EXTRACT_EXT_PUB;
100: