[Home] [Help]
PACKAGE: APPS.IBY_FNDCPT_PROFILE_PVT
Source
1 PACKAGE IBY_FNDCPT_PROFILE_PVT AUTHID CURRENT_USER AS
2 /* $Header: ibyfcpfs.pls 120.0 2005/05/03 22:41:54 jleybovi noship $ */
3
4 --
5 -- Name: Get_Profile_Code
6 --
7 --
8 PROCEDURE Get_Profile_Code
9 (
10 p_bepid IN iby_bepinfo.bepid%TYPE,
11 p_payeeid IN iby_bepkeys.ownerid%TYPE,
12 p_bepkey IN iby_bepkeys.key%TYPE,
13 p_instr_type IN VARCHAR2,
14 x_profile_code OUT NOCOPY VARCHAR2
15 );
16
17 PROCEDURE Create_User_Profiles
18 (
19 p_bepid IN iby_bepinfo.bepid%TYPE,
20 p_bep_acct_id IN iby_bepkeys.bep_account_id%TYPE,
21 p_cc_profile_code IN iby_fndcpt_user_cc_pf_vl.user_cc_profile_code%TYPE,
22 p_cc_profile_name IN iby_fndcpt_user_cc_pf_vl.user_cc_profile_name%TYPE,
23 p_eft_profile_code IN iby_fndcpt_user_eft_pf_vl.user_eft_profile_code%TYPE,
24 p_eft_profile_name IN iby_fndcpt_user_eft_pf_vl.user_eft_profile_name%TYPE,
25 p_dc_profile_code IN iby_fndcpt_user_dc_pf_vl.user_dc_profile_code%TYPE,
26 p_dc_profile_name IN iby_fndcpt_user_dc_pf_vl.user_dc_profile_name%TYPE,
27 x_cc_online_cfg_id OUT NOCOPY
28 iby_fndcpt_user_cc_pf_vl.online_auth_trans_config_id%TYPE,
29 x_cc_settle_cfg_id OUT NOCOPY
30 iby_fndcpt_user_cc_pf_vl.settlement_trans_config_id%TYPE,
31 x_cc_query_cfg_id OUT NOCOPY
32 iby_fndcpt_user_cc_pf_vl.query_trans_config_id%TYPE,
33 x_eft_verify_cfg_id OUT NOCOPY
34 iby_fndcpt_user_eft_pf_vl.verify_trans_config_id%TYPE,
35 x_eft_xfer_cfg_id OUT NOCOPY
36 iby_fndcpt_user_eft_pf_vl.funds_xfer_trans_config_id%TYPE,
37 x_eft_query_cfg_id OUT NOCOPY
38 iby_fndcpt_user_eft_pf_vl.query_trans_config_id%TYPE,
39 x_dc_online_cfg_id OUT NOCOPY
40 iby_fndcpt_user_dc_pf_vl.online_deb_trans_config_id%TYPE,
41 x_dc_settle_cfg_id OUT NOCOPY
42 iby_fndcpt_user_dc_pf_vl.settlement_trans_config_id%TYPE,
43 x_dc_query_cfg_id OUT NOCOPY
44 iby_fndcpt_user_dc_pf_vl.query_trans_config_id%TYPE
45 );
46
47 PROCEDURE Delete_User_Profiles
48 (
49 p_commit IN VARCHAR2,
50 p_cc_profile_code IN iby_fndcpt_user_cc_pf_vl.user_cc_profile_code%TYPE,
51 p_eft_profile_code IN iby_fndcpt_user_eft_pf_vl.user_eft_profile_code%TYPE,
52 p_dc_profile_code IN iby_fndcpt_user_dc_pf_vl.user_dc_profile_code%TYPE
53 );
54
55 END IBY_FNDCPT_PROFILE_PVT;