1 PACKAGE BODY IBY_FD_EXTRACT_EXT_PUB AS
2 /* $Header: ibyfdxeb.pls 120.2 2006/09/20 18:52:12 frzhang noship $ */
3
4
5 --
6 -- This API is called once only for the payment instruction.
7 -- Implementor should construct the extract extension elements
8 -- at the payment instruction level as a SQLX XML Aggregate
9 -- and return the aggregate.
10 --
11 -- Below is an example implementation:
12 /*
13 FUNCTION Get_Ins_Ext_Agg(p_payment_instruction_id IN NUMBER)
14 RETURN XMLTYPE
15 IS
16 l_ins_ext_agg XMLTYPE;
17
18 CURSOR l_ins_ext_csr (p_payment_instruction_id IN NUMBER) IS
19 SELECT XMLConcat(
20 XMLElement("Extend",
21 XMLElement("Name", ext_table.attr_name1),
22 XMLElement("Value", ext_table.attr_value1)),
23 XMLElement("Extend",
24 XMLElement("Name", ext_table.attr_name2),
25 XMLElement("Value", ext_table.attr_value2))
26 )
27 FROM your_pay_instruction_lvl_table ext_table
28 WHERE ext_table.payment_instruction_id = p_payment_instruction_id;
29
30 BEGIN
31
32 OPEN l_ins_ext_csr (p_payment_instruction_id);
33 FETCH l_ins_ext_csr INTO l_ins_ext_agg;
34 CLOSE l_ins_ext_csr;
35
36 RETURN l_ins_ext_agg;
37
38 END Get_Ins_Ext_Agg;
39 */
40 FUNCTION Get_Ins_Ext_Agg(p_payment_instruction_id IN NUMBER)
41 RETURN XMLTYPE
42 IS
43 BEGIN
44 RETURN NULL;
45 END Get_Ins_Ext_Agg;
46
47
48 --
49 -- This API is called once per payment.
50 -- Implementor should construct the extract extension elements
51 -- at the payment level as a SQLX XML Aggregate
52 -- and return the aggregate.
53 --
54 FUNCTION Get_Pmt_Ext_Agg(p_payment_id IN NUMBER)
55 RETURN XMLTYPE
56 IS
57 BEGIN
58 RETURN NULL;
59 END Get_Pmt_Ext_Agg;
60
61
62 --
63 -- This API is called once per document payable.
64 -- Implementor should construct the extract extension elements
65 -- at the document level as a SQLX XML Aggregate
66 -- and return the aggregate.
67 --
68 FUNCTION Get_Doc_Ext_Agg(p_document_payable_id IN NUMBER)
69 RETURN XMLTYPE
70 IS
71 BEGIN
72 RETURN NULL;
73 END Get_Doc_Ext_Agg;
74
75
76 --
77 -- This API is called once per document payable line.
78 -- Implementor should construct the extract extension elements
79 -- at the doc line level as a SQLX XML Aggregate
80 -- and return the aggregate.
81 --
82 -- Parameters:
83 -- p_document_payable_id: primary key of IBY iby_docs_payable_all table
84 -- p_line_number: calling app doc line number. For AP this is
85 -- ap_invoice_lines_all.line_number.
86 --
87 -- The combination of p_document_payable_id and p_line_number
88 -- can uniquely locate a document line.
89 -- For example if the calling product of a doc is AP
90 -- p_document_payable_id can locate
91 -- iby_docs_payable_all/ap_documents_payable.calling_app_doc_unique_ref2,
92 -- which is ap_invoice_all.invoice_id. The combination of invoice_id and
93 -- p_line_number will uniquely identify the doc line.
94 --
95 FUNCTION Get_Docline_Ext_Agg(p_document_payable_id IN NUMBER, p_line_number IN NUMBER)
96 RETURN XMLTYPE
97 IS
98 BEGIN
99 RETURN NULL;
100 END Get_Docline_Ext_Agg;
101
102
103 --
104 -- This API is called once only for the payment process request.
105 -- Implementor should construct the extract extension elements
106 -- at the payment request level as a SQLX XML Aggregate
107 -- and return the aggregate.
108 --
109 FUNCTION Get_Ppr_Ext_Agg(p_payment_service_request_id IN NUMBER)
110 RETURN XMLTYPE
111 IS
112 BEGIN
113 RETURN NULL;
114 END Get_Ppr_Ext_Agg;
115
116
117 END IBY_FD_EXTRACT_EXT_PUB;
118
119