1 PACKAGE IBY_FD_EXTRACT_EXT_PUB AUTHID CURRENT_USER AS
2 /* $Header: ibyfdxes.pls 120.2 2006/09/20 18:52:23 frzhang noship $ */
3
4
5 G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_FD_EXTRACT_EXT_PUB';
6
7 --
8 -- This API is called once only for the payment instruction.
9 -- Implementor should construct the extract extension elements
10 -- at the payment instruction level as a SQLX XML Aggregate
11 -- and return the aggregate.
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
21 SELECT XMLConcat(
22 XMLElement("Extend",
23 XMLElement("Name", ext_table.attr_name1),
24 XMLElement("Value", ext_table.attr_value1)),
25 XMLElement("Extend",
26 XMLElement("Name", ext_table.attr_name2),
27 XMLElement("Value", ext_table.attr_value2))
28 )
29 FROM your_pay_instruction_lvl_table ext_table
30 WHERE ext_table.payment_instruction_id = p_payment_instruction_id;
31
32 BEGIN
33
34 OPEN l_ins_ext_csr (p_payment_instruction_id);
35 FETCH l_ins_ext_csr INTO l_ins_ext_agg;
36 CLOSE l_ins_ext_csr;
37
38 RETURN l_ins_ext_agg;
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.
48 -- Implementor should construct the extract extension elements
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.
58 -- Implementor should construct the extract extension elements
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.
68 -- Implementor should construct the extract extension elements
69 -- at the doc line level as a SQLX XML Aggregate
70 -- and return the aggregate.
71 --
72 -- Parameters:
73 -- p_document_payable_id: primary key of IBY iby_docs_payable_all table
74 -- p_line_number: calling app doc line number. For AP this is
75 -- ap_invoice_lines_all.line_number.
76 --
77 -- The combination of p_document_payable_id and p_line_number
78 -- can uniquely locate a document line.
79 -- For example if the calling product of a doc is AP
80 -- p_document_payable_id can locate
81 -- iby_docs_payable_all/ap_documents_payable.calling_app_doc_unique_ref2,
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.
91 -- Implementor should construct the extract extension elements
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
101