4: PROCEDURE Insert_Trans_Config
5: (
6: p_profile_name IN VARCHAR2,
7: p_protocol_code IN iby_transmit_configs_vl.transmit_protocol_code%TYPE,
8: x_config_id OUT NOCOPY iby_transmit_configs_b.transmit_configuration_id%TYPE
9: )
10: IS
11: l_rowid ROWID;
12: BEGIN
32: );
33: END Insert_Trans_Config;
34:
35: PROCEDURE Delete_Trans_Config
36: (p_config_id IN iby_transmit_configs_b.transmit_configuration_id%TYPE)
37: IS
38: BEGIN
39:
40: IF (p_config_id IS NULL) THEN
139: l_online_trans_code VARCHAR2(30);
140: l_settle_trans_code VARCHAR2(30);
141: l_query_trans_code VARCHAR2(30);
142:
143: l_online_trans_cfg_id iby_transmit_configs_b.transmit_configuration_id%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
140: l_settle_trans_code VARCHAR2(30);
141: l_query_trans_code VARCHAR2(30);
142:
143: l_online_trans_cfg_id iby_transmit_configs_b.transmit_configuration_id%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)
141: l_query_trans_code VARCHAR2(30);
142:
143: l_online_trans_cfg_id iby_transmit_configs_b.transmit_configuration_id%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
316: p_eft_profile_code IN iby_fndcpt_user_eft_pf_vl.user_eft_profile_code%TYPE,
317: p_dc_profile_code IN iby_fndcpt_user_dc_pf_vl.user_dc_profile_code%TYPE
318: )
319: IS
320: l_online_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
321: l_settle_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
322: l_query_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
323:
324: CURSOR c_cc_user_prof
317: p_dc_profile_code IN iby_fndcpt_user_dc_pf_vl.user_dc_profile_code%TYPE
318: )
319: IS
320: l_online_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
321: l_settle_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
322: l_query_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
323:
324: CURSOR c_cc_user_prof
325: (ci_profile_code iby_fndcpt_user_cc_pf_b.user_cc_profile_code%TYPE)
318: )
319: IS
320: l_online_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
321: l_settle_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
322: l_query_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
323:
324: CURSOR c_cc_user_prof
325: (ci_profile_code iby_fndcpt_user_cc_pf_b.user_cc_profile_code%TYPE)
326: IS