DBA Data[Home] [Help]

APPS.IBY_FNDCPT_PROFILE_PVT dependencies on IBY_BEPINFO

Line 54: p_bepid IN iby_bepinfo.bepid%TYPE,

50: END Delete_Trans_Config;
51:
52: PROCEDURE Get_Profile_Code
53: (
54: p_bepid IN iby_bepinfo.bepid%TYPE,
55: p_payeeid IN iby_bepkeys.ownerid%TYPE,
56: p_bepkey IN iby_bepkeys.key%TYPE,
57: p_instr_type IN VARCHAR2,
58: x_profile_code OUT NOCOPY VARCHAR2

Line 108: p_bepid IN iby_bepinfo.bepid%TYPE,

104: END Get_Profile_Code;
105:
106: PROCEDURE Create_User_Profiles
107: (
108: p_bepid IN iby_bepinfo.bepid%TYPE,
109: p_bep_acct_id IN iby_bepkeys.bep_account_id%TYPE,
110: p_cc_profile_code IN iby_fndcpt_user_cc_pf_vl.user_cc_profile_code%TYPE,
111: p_cc_profile_name IN iby_fndcpt_user_cc_pf_vl.user_cc_profile_name%TYPE,
112: p_eft_profile_code IN iby_fndcpt_user_eft_pf_vl.user_eft_profile_code%TYPE,

Line 148: (ci_bepid iby_bepinfo.bepid%TYPE)

144: l_settle_trans_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
145: l_query_trans_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
146:
147: CURSOR c_sys_cc_profile
148: (ci_bepid iby_bepinfo.bepid%TYPE)
149: IS
150: SELECT sys_cc_profile_code,online_auth_trans_prtcl_code,
151: settlement_trans_prtcl_code,query_trans_prtcl_code
152: FROM iby_fndcpt_sys_cc_pf_b profs

Line 157: (ci_bepid iby_bepinfo.bepid%TYPE)

153: WHERE profs.payment_system_id = ci_bepid
154: AND NVL(inactive_date,SYSDATE+30)>SYSDATE;
155:
156: CURSOR c_sys_eft_profile
157: (ci_bepid iby_bepinfo.bepid%TYPE)
158: IS
159: SELECT sys_eft_profile_code,verify_trans_prtcl_code,
160: funds_xfer_trans_prtcl_code,query_trans_prtcl_code
161: FROM iby_fndcpt_sys_eft_pf_b profs

Line 166: (ci_bepid iby_bepinfo.bepid%TYPE)

162: WHERE profs.payment_system_id = ci_bepid
163: AND NVL(inactive_date,SYSDATE+30)>SYSDATE;
164:
165: CURSOR c_sys_dc_profile
166: (ci_bepid iby_bepinfo.bepid%TYPE)
167: IS
168: SELECT sys_dc_profile_code,online_deb_trans_prtcl_code,
169: settlement_trans_prtcl_code,query_trans_prtcl_code
170: FROM iby_fndcpt_sys_dc_pf_b profs