1 PACKAGE IBY_EXTRACTGEN_PVT AS
2 /* $Header: ibyxgens.pls 120.10.12010000.1 2008/07/28 05:43:55 appldev ship $ */
3
4 G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_EXTRACTGEN_PVT';
5
6
7 -- Constants for generating Descriptive Flex Fields
8 -- In general value is the table name
9 G_DFF_FD_PAYMENT_METHOD VARCHAR2(30) := 'IBY_PAYMENT_METHODS_B';
10
11 G_DFF_FD_PAYMENT_PROFILE VARCHAR2(30) := 'IBY_SYS_PMT_PROFILES_B';
12
13 G_DFF_FD_PAY_INSTRUCTION VARCHAR2(30) := 'IBY_PAY_INSTRUCTIONS_ALL';
14
15 G_DFF_FD_PAYMENT VARCHAR2(30) := 'IBY_PAYMENTS_ALL';
16
17 G_DFF_FD_DOC_PAYABLE VARCHAR2(30) := 'IBY_DOCS_PAYABLE_ALL';
18
19 G_DFF_FORMAT VARCHAR2(30) := 'IBY_FORMATS_B';
20
21 G_DFF_BEP_ACCOUNT VARCHAR2(30) := 'IBY_BEPKEYS';
22
23 G_DFF_LEGAL_ENTITY VARCHAR2(30) := 'XLE_FIRSTPARTY_INFORMATION_V';
24
25 G_DFF_PARTY VARCHAR2(30) := 'HZ_PARTIES';
26
27 G_DFF_INT_BANK_ACCOUNT VARCHAR2(30) := 'CE_BANK_ACCOUNTS';
28
29 G_DFF_EXT_BANK_ACCOUNT VARCHAR2(30) := 'IBY_EXT_BANK_ACCOUNTS';
30
31 G_DFF_PO_VENDORS VARCHAR2(30) := 'PO_VENDORS';
32
33 G_DFF_PO_VENDOR_SITES VARCHAR2(30) := 'PO_VENDOR_SITES_ALL';
34
35 G_DFF_AP_DOC VARCHAR2(30) := 'AP_DOCUMENTS_PAYABLE';
36
37
38 --
39 -- Name: Create_Extract
40 -- Args: p_extract_code => code of the extract to create
41 -- p_extract_version => version of the extract type
42 -- p_params => IN parameters to the generator code-point ONLY!!;
43 -- the single OUT parameter should not be included
44 -- x_extract_code => the generated extract
45 --
46 -- Notes: The collection of code-point arguments in p_params
47 -- must be sorted in signature-order of the code-point.
48 -- Though the table contains strings, all scalar native types are
49 -- allowed provided they are in the correct lexical representation.
50 -- This is because the parameters will be used to create a dynamic
51 -- SQL call statement; this implies that string parameters must
52 -- appear properly quoted- i.e.
53 -- p_param(i) := '''CREDITCARD''';
54 --
55 PROCEDURE Create_Extract
56 (
57 p_extract_code IN iby_extracts_vl.extract_code%TYPE,
58 p_extract_version IN iby_extracts_vl.extract_version%TYPE,
59 p_params IN OUT NOCOPY JTF_VARCHAR2_TABLE_200,
60 x_extract_doc OUT NOCOPY CLOB
61 );
62
63 -- Use this function to get descriptive flex field elements
64 -- from various tables. This function is intended to be shared
65 -- between funds capture and fund disbursement extracts.
66 -- Depending on the type of PK of the entity table,
67 -- either the entity_id or entity_code should be passed in.
68 FUNCTION Get_Dffs(p_entity_table IN VARCHAR2, p_entity_id IN NUMBER, p_entity_code IN VARCHAR2)
69 RETURN XMLTYPE;
70
71 -- This function is general for the formatting of files
72 -- It allows passing parameters to the XDO template generator
73 -- Args: p_template_code. XDO template code
74 -- p_parameters_code. The code for the parameters we want to use in the
75 -- template during formatting
76 -- p_parameters_value. Value of the parameters
77 -- The 2 arrays should be defined with the same number of elements
78 PROCEDURE get_template_parameters
79 (
80 p_template_code IN iby_formats_b.format_template_code%TYPE,
81 p_pay_instruction IN VARCHAR2,
82 p_parameters_code OUT NOCOPY JTF_VARCHAR2_TABLE_200,
83 p_parameters_value OUT NOCOPY JTF_VARCHAR2_TABLE_200
84 );
85
86 END IBY_EXTRACTGEN_PVT;