1 PACKAGE IBY_FD_USER_API_PUB AS
2 /*$Header: ibyfduas.pls 120.7 2006/08/08 00:11:14 syidner noship $*/
3
4 --
5 -- Declaring Global variables
6 --
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_FD_USER_API_PUB';
8
9 --
10 -- module name used for the application debugging framework
11 --
12 G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_FD_USER_API_PUB';
13
14
15 Type Int_Bank_Acc_Tab_Type is Table of NUMBER INDEX by BINARY_INTEGER;
16
17 Type Legal_Entity_Tab_Type is Table of NUMBER INDEX by BINARY_INTEGER;
18
19 Type Org_Rec_Type is Record(
20 org_id number,
21 org_type varchar2(30)
22 );
23
24 Type Org_Tab_Type is Table of Org_Rec_Type INDEX by BINARY_INTEGER;
25
26 Type Currency_Tab_Type is Table of VARCHAR2(10) INDEX by BINARY_INTEGER;
27
28 PROCEDURE Validate_Method_and_Profile (
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
31 p_payment_method_code IN VARCHAR2,
32 p_ppp_id IN NUMBER,
33 p_payment_document_id IN NUMBER,
34 p_crt_instr_flag IN VARCHAR2,
35 p_int_bank_acc_arr IN Int_Bank_Acc_Tab_Type,
36 p_le_arr IN Legal_Entity_Tab_Type,
37 p_org_arr IN Org_Tab_Type,
38 p_curr_arr IN Currency_Tab_Type,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44 FUNCTION Payment_Instruction_Action (
45 p_instruction_status IN VARCHAR2
46 ) RETURN VARCHAR2;
47
48 FUNCTION Pmt_Instr_Action_Enabled (
49 p_instruction_status IN VARCHAR2,
50 p_org_id IN NUMBER,
51 p_instruction_id IN NUMBER,
52 p_request_id IN NUMBER DEFAULT NULL
53 ) RETURN VARCHAR2;
54
55 PROCEDURE retrieve_default_sra_format(
56 p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
58 p_instr_id IN NUMBER,
59 x_default_sra_format_code OUT NOCOPY VARCHAR2,
60 x_default_sra_format_name OUT NOCOPY VARCHAR2,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2
64 );
65
66 END IBY_FD_USER_API_PUB;