1 PACKAGE IBY_EXTRACTGEN_PVT AUTHID CURRENT_USER AS
2 /* $Header: ibyxgens.pls 120.13.12020000.2 2012/07/12 15:10:04 sgogula 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_PAY_SERVICE_REQ VARCHAR2(30) := 'IBY_PAY_SERVICE_REQUESTS';
16
17 G_DFF_FD_PAYMENT VARCHAR2(30) := 'IBY_PAYMENTS_ALL';
18
19 G_DFF_AP_CHECK VARCHAR2(30) := 'AP_CHECKS_ALL';
20
21 G_DFF_FD_DOC_PAYABLE VARCHAR2(30) := 'IBY_DOCS_PAYABLE_ALL';
22
23 G_DFF_FORMAT VARCHAR2(30) := 'IBY_FORMATS_B';
24
25 G_DFF_BEP_ACCOUNT VARCHAR2(30) := 'IBY_BEPKEYS';
26
27 G_DFF_LEGAL_ENTITY VARCHAR2(30) := 'XLE_FIRSTPARTY_INFORMATION_V';
28
29 G_DFF_PARTY VARCHAR2(30) := 'HZ_PARTIES';
30
31 G_DFF_INT_BANK_ACCOUNT VARCHAR2(30) := 'CE_BANK_ACCOUNTS';
32
33 G_DFF_EXT_BANK_ACCOUNT VARCHAR2(30) := 'IBY_EXT_BANK_ACCOUNTS';
34
35 G_DFF_PO_VENDORS VARCHAR2(30) := 'PO_VENDORS';
36
37 G_DFF_PO_VENDOR_SITES VARCHAR2(30) := 'PO_VENDOR_SITES_ALL';
38
39 G_DFF_AP_DOC VARCHAR2(30) := 'AP_DOCUMENTS_PAYABLE';
40 G_DFF_PMT_INSTR_USES_ALL VARCHAR2(30) := 'IBY_PMT_INSTR_USES_ALL'; --Bug 11923557
41
42 TYPE g_flex_field_enabled_type IS TABLE OF BOOLEAN INDEX BY VARCHAR2(150);
43 g_flex_field_enabled g_flex_field_enabled_type;
44
45 --
46 -- Name: Create_Extract
47 -- Args: p_extract_code => code of the extract to create
48 -- p_extract_version => version of the extract type
49 -- p_params => IN parameters to the generator code-point ONLY!!;
50 -- the single OUT parameter should not be included
51 -- x_extract_code => the generated extract
52 --
53 -- Notes: The collection of code-point arguments in p_params
54 -- must be sorted in signature-order of the code-point.
55 -- Though the table contains strings, all scalar native types are
56 -- allowed provided they are in the correct lexical representation.
57 -- This is because the parameters will be used to create a dynamic
58 -- SQL call statement; this implies that string parameters must
59 -- appear properly quoted- i.e.
60 -- p_param(i) := '''CREDITCARD''';
61 --
62 PROCEDURE Create_Extract
63 (
64 p_extract_code IN iby_extracts_vl.extract_code%TYPE,
65 p_extract_version IN iby_extracts_vl.extract_version%TYPE,
66 p_params IN OUT NOCOPY JTF_VARCHAR2_TABLE_200,
67 x_extract_doc OUT NOCOPY CLOB
68 );
69
70 -- Use this function to get descriptive flex field elements
71 -- from various tables. This function is intended to be shared
72 -- between funds capture and fund disbursement extracts.
73 -- Depending on the type of PK of the entity table,
74 -- either the entity_id or entity_code should be passed in.
75 FUNCTION Get_Dffs(p_entity_table IN VARCHAR2, p_entity_id IN NUMBER, p_entity_code IN VARCHAR2)
76 RETURN XMLTYPE;
77
78 -- This function is general for the formatting of files
79 -- It allows passing parameters to the XDO template generator
80 -- Args: p_template_code. XDO template code
81 -- p_parameters_code. The code for the parameters we want to use in the
82 -- template during formatting
83 -- p_parameters_value. Value of the parameters
84 -- The 2 arrays should be defined with the same number of elements
85 PROCEDURE get_template_parameters
86 (
87 p_template_code IN iby_formats_b.format_template_code%TYPE,
88 p_pay_instruction IN VARCHAR2,
89 p_parameters_code OUT NOCOPY JTF_VARCHAR2_TABLE_200,
90 p_parameters_value OUT NOCOPY JTF_VARCHAR2_TABLE_200
91 );
92
93
94 FUNCTION Get_XML_Char_Encoding_Header
95 RETURN VARCHAR2;
96
97 FUNCTION Is_Flex_Field_Enabled
98 (
99 p_flex_field_name varchar2,
100 p_application_id number
101 )
102 RETURN BOOLEAN;
103
104 END IBY_EXTRACTGEN_PVT;