DBA Data[Home] [Help]

APPS.IBY_EXT_WRAP_PUB dependencies on XMLTYPE

Line 33: RETURN XMLTYPE

29: END IF;
30: END;
31:
32: FUNCTION Get_Ins_Ext_Agg(p_payment_instruction_id IN NUMBER)
33: RETURN XMLTYPE
34: IS
35: l_ins_ext_agg XMLTYPE;
36: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Ins_Ext_Agg';
37:

Line 35: l_ins_ext_agg XMLTYPE;

31:
32: FUNCTION Get_Ins_Ext_Agg(p_payment_instruction_id IN NUMBER)
33: RETURN XMLTYPE
34: IS
35: l_ins_ext_agg XMLTYPE;
36: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Ins_Ext_Agg';
37:
38: BEGIN
39: l_ins_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Ins_Ext_Agg(p_payment_instruction_id);

Line 66: RETURN XMLTYPE

62:
63:
64:
65: FUNCTION Get_Pmt_Ext_Agg(p_payment_id IN NUMBER)
66: RETURN XMLTYPE
67: IS
68: l_pmt_ext_agg XMLTYPE;
69: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Pmt_Ext_Agg';
70:

Line 68: l_pmt_ext_agg XMLTYPE;

64:
65: FUNCTION Get_Pmt_Ext_Agg(p_payment_id IN NUMBER)
66: RETURN XMLTYPE
67: IS
68: l_pmt_ext_agg XMLTYPE;
69: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Pmt_Ext_Agg';
70:
71: BEGIN
72: l_pmt_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Pmt_Ext_Agg(p_payment_id);

Line 98: RETURN XMLTYPE

94:
95:
96:
97: FUNCTION Get_Doc_Ext_Agg(p_document_payable_id IN NUMBER)
98: RETURN XMLTYPE
99: IS
100: l_doc_ext_agg XMLTYPE:=NULL;
101: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Doc_Ext_Agg';
102:

Line 100: l_doc_ext_agg XMLTYPE:=NULL;

96:
97: FUNCTION Get_Doc_Ext_Agg(p_document_payable_id IN NUMBER)
98: RETURN XMLTYPE
99: IS
100: l_doc_ext_agg XMLTYPE:=NULL;
101: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Doc_Ext_Agg';
102:
103: BEGIN
104: l_doc_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Doc_Ext_Agg(p_document_payable_id);

Line 130: RETURN XMLTYPE

126:
127:
128:
129: FUNCTION Get_Docline_Ext_Agg(p_document_payable_id IN NUMBER, p_line_number IN NUMBER)
130: RETURN XMLTYPE
131: IS
132: l_docline_ext_agg XMLTYPE;
133: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Docline_Ext_Agg';
134:

Line 132: l_docline_ext_agg XMLTYPE;

128:
129: FUNCTION Get_Docline_Ext_Agg(p_document_payable_id IN NUMBER, p_line_number IN NUMBER)
130: RETURN XMLTYPE
131: IS
132: l_docline_ext_agg XMLTYPE;
133: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Docline_Ext_Agg';
134:
135: BEGIN
136: l_docline_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Docline_Ext_Agg(p_document_payable_id,p_line_number);

Line 162: RETURN XMLTYPE

158: END Get_Docline_Ext_Agg;
159:
160:
161: FUNCTION Get_Ppr_Ext_Agg(p_payment_service_request_id IN NUMBER)
162: RETURN XMLTYPE
163: IS
164: l_ppr_ext_agg XMLTYPE;
165: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Ppr_Ext_Agg';
166:

Line 164: l_ppr_ext_agg XMLTYPE;

160:
161: FUNCTION Get_Ppr_Ext_Agg(p_payment_service_request_id IN NUMBER)
162: RETURN XMLTYPE
163: IS
164: l_ppr_ext_agg XMLTYPE;
165: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Ppr_Ext_Agg';
166:
167: BEGIN
168: l_ppr_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Ppr_Ext_Agg(p_payment_service_request_id);