1 PACKAGE IBY_FNDCPT_EXTRACT_GEN_PVT AUTHID CURRENT_USER AS
2 /* $Header: ibyfcxgs.pls 120.10.12020000.1 2012/06/27 12:09:50 appldev ship $ */
3
4 -- Various parameters used by the extract-generating XML views
5 --
6
7 -- xml base; sets
8 --
9 G_VP_XML_BASE CONSTANT VARCHAR2(30) := 'XML_BASE';
10
11 -- payee security key; for payee trxn data decryption
12 --
13 G_VP_PAYEE_KEY CONSTANT VARCHAR2(30) := 'PAYEE_KEY';
14
15 -- system security key- for registered instrument decryption
16 --
17 G_VP_SYS_KEY CONSTANT VARCHAR2(30) := 'SYS_KEY';
18
19 -- CVV2 value
20
21 G_VP_SEC_VAL CONSTANT VARCHAR2(30) :='SEC_VAL';
22
23 G_VP_EXTRACT_MODE CONSTANT VARCHAR2(30) :='EXTRACT_MODE';
24
25 -- bug 5115161: payer notification
26 PROCEDURE Create_Payer_Notif_Extract_1_0
27 (
28 p_mbatchid IN VARCHAR2,
29 p_fromDate IN VARCHAR2,
30 p_toDate IN VARCHAR2,
31 p_fromPSON IN VARCHAR2,
32 p_toPSON IN VARCHAR2,
33 p_delivery_method IN VARCHAR2,
34 p_format_code IN VARCHAR2,
35 p_txn_id IN NUMBER,
36 p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
37 x_extract_doc OUT NOCOPY CLOB
38 );
39
40 --
41 -- Name: Create_Extract_1_0
42 -- Args: p_instr_type => primary instrument type of the extract
43 -- p_req_type => type of requrest for the extract
44 -- p_txn_id => identifier of the extract "transaction"; in the
45 -- case of batch extracts this may refer to an entity
46 -- in the IBY_BATCHES_ALL table
47 -- p_sys_key => system security key; used for instrument decryption
48 -- x_extract_doc => the resultant extract
49 --
50 PROCEDURE Create_Extract_1_0
51 (
52 p_instr_type IN VARCHAR2,
53 p_req_type IN VARCHAR2,
54 p_txn_id IN NUMBER,
55 p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
56 x_extract_doc OUT NOCOPY CLOB
57 );
58
59 --
60 -- Name: Create_Extract_1_0
61 -- Args: p_instr_type => primary instrument type of the extract
62 -- p_req_type => type of requrest for the extract
63 -- p_txn_id => identifier of the extract "transaction"; in the
64 -- case of batch extracts this may refer to an entity
65 -- in the IBY_BATCHES_ALL table
66 -- p_payee_key => payee security key; used for data decryption
67 -- p_sys_key => system security key; used for instrument decryption
68 -- p_sec_val => transaction CVV2 value
69 -- x_extract_doc => the resultant extract
70 --
71 PROCEDURE Create_Extract_1_0
72 (
73 p_instr_type IN VARCHAR2,
74 p_req_type IN VARCHAR2,
75 p_txn_id IN NUMBER,
76 p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
77 p_sec_val IN VARCHAR2,
78 x_extract_doc OUT NOCOPY CLOB
79 );
80
81 FUNCTION Get_Ins_PayeeAcctAgg(p_mbatch_id IN NUMBER)
82 RETURN XMLTYPE;
83
84 FUNCTION Get_SRA_Attribute(p_trxnmid IN NUMBER, p_attribute_type IN NUMBER)
85 RETURN VARCHAR2;
86
87 FUNCTION Get_Payer_Default_Attribute(p_trxnmid IN NUMBER, p_attribute_type IN NUMBER)
88 RETURN VARCHAR2;
89
90 FUNCTION Get_Batch_Format(p_batchid IN VARCHAR2, p_format_type IN VARCHAR2)
91 RETURN VARCHAR2;
92
93 PROCEDURE Update_Pmt_SRA_Attr_Prt
94 (
95 p_mbatchid IN VARCHAR2,
96 p_fromDate IN VARCHAR2,
97 p_toDate IN VARCHAR2,
98 p_fromPSON IN VARCHAR2,
99 p_toPSON IN VARCHAR2,
100 p_delivery_method IN VARCHAR2,
101 p_format_code IN VARCHAR2
102 );
103
104 PROCEDURE Update_Pmt_SRA_Attr_Ele
105 (
106 p_trxnmid IN NUMBER,
107 p_delivery_method IN VARCHAR2,
108 p_recipient_email IN VARCHAR2,
109 p_recipient_fax IN VARCHAR2
110 );
111
112 FUNCTION submit_payer_notification
113 (
114 p_bep_type IN VARCHAR2,
115 p_settlement_batch IN VARCHAR2 DEFAULT NULL,
116 p_from_settlement_date IN DATE DEFAULT NULL,
117 p_to_settlement_date IN DATE DEFAULT NULL,
118 p_from_PSON IN VARCHAR2 DEFAULT NULL,
119 p_to_PSON IN VARCHAR2 DEFAULT NULL
120 ) RETURN NUMBER;
121
122 FUNCTION submit_accompany_letter
123 (
124 p_settlement_batch IN VARCHAR2
125 ) RETURN NUMBER;
126
127 FUNCTION is_amended
128 ( p_mandate_id IN iby_debit_authorizations.debit_authorization_id%TYPE )
129 RETURN varchar2;
130
131 FUNCTION get_assignment_iban
132 ( p_assign_id IN iby_debit_authorizations.external_bank_account_use_id%TYPE )
133 RETURN varchar2;
134
135 FUNCTION get_mandate_details
136 ( p_mandate_id IN iby_debit_authorizations.debit_authorization_id%TYPE )
137 RETURN XMLType;
138
139 END IBY_FNDCPT_EXTRACT_GEN_PVT;
140