APPS.IBY_TUNNEL_CONFIG_UPG_PKG dependencies on IBY_TRANSMIT_CONFIGS_B

Line 32: UPDATE iby_transmit_configs_b

28:
29: SELECT iby_transmit_configs_s.nextval INTO l_config_id FROM DUAL;
30:
31: -- cc profiles
32: UPDATE iby_transmit_configs_b
33: SET tunneling_trans_config_id=l_config_id
34: WHERE transmit_configuration_id IN
35: (SELECT online_auth_trans_config_id
36: FROM iby_fndcpt_user_cc_pf_b p, iby_bepkeys k

Line 42: UPDATE iby_transmit_configs_b

38: AND (k.bepid = bep_rec.bepid)
39: )
40: AND (tunneling_trans_config_id IS NULL);
41: l_update_count := SQL%ROWCOUNT;
42: UPDATE iby_transmit_configs_b
43: SET tunneling_trans_config_id=l_config_id
44: WHERE transmit_configuration_id IN
45: (SELECT settlement_trans_config_id
46: FROM iby_fndcpt_user_cc_pf_b p, iby_bepkeys k

Line 52: UPDATE iby_transmit_configs_b

48: AND (k.bepid = bep_rec.bepid)
49: )
50: AND (tunneling_trans_config_id IS NULL);
51: l_update_count := l_update_count + SQL%ROWCOUNT;
52: UPDATE iby_transmit_configs_b
53: SET tunneling_trans_config_id=l_config_id
54: WHERE transmit_configuration_id IN
55: (SELECT query_trans_config_id
56: FROM iby_fndcpt_user_cc_pf_b p, iby_bepkeys k

Line 64: UPDATE iby_transmit_configs_b

60: AND (tunneling_trans_config_id IS NULL);
61: l_update_count := l_update_count + SQL%ROWCOUNT;
62:
63: -- debit card profiles
64: UPDATE iby_transmit_configs_b
65: SET tunneling_trans_config_id=l_config_id
66: WHERE transmit_configuration_id IN
67: (SELECT online_deb_trans_config_id
68: FROM iby_fndcpt_user_dc_pf_b p, iby_bepkeys k

Line 74: UPDATE iby_transmit_configs_b

70: AND (k.bepid = bep_rec.bepid)
71: )
72: AND (tunneling_trans_config_id IS NULL);
73: l_update_count := l_update_count + SQL%ROWCOUNT;
74: UPDATE iby_transmit_configs_b
75: SET tunneling_trans_config_id=l_config_id
76: WHERE transmit_configuration_id IN
77: (SELECT settlement_trans_config_id
78: FROM iby_fndcpt_user_dc_pf_b p, iby_bepkeys k

Line 84: UPDATE iby_transmit_configs_b

80: AND (k.bepid = bep_rec.bepid)
81: )
82: AND (tunneling_trans_config_id IS NULL);
83: l_update_count := l_update_count + SQL%ROWCOUNT;
84: UPDATE iby_transmit_configs_b
85: SET tunneling_trans_config_id=l_config_id
86: WHERE transmit_configuration_id IN
87: (SELECT query_trans_config_id
88: FROM iby_fndcpt_user_dc_pf_b p, iby_bepkeys k

Line 96: UPDATE iby_transmit_configs_b

92: AND (tunneling_trans_config_id IS NULL);
93: l_update_count := l_update_count + SQL%ROWCOUNT;
94:
95: -- eft profiles
96: UPDATE iby_transmit_configs_b
97: SET tunneling_trans_config_id=l_config_id
98: WHERE transmit_configuration_id IN
99: (SELECT verify_trans_config_id
100: FROM iby_fndcpt_user_eft_pf_b p, iby_bepkeys k

Line 106: UPDATE iby_transmit_configs_b

102: AND (k.bepid = bep_rec.bepid)
103: )
104: AND (tunneling_trans_config_id IS NULL);
105: l_update_count := l_update_count + SQL%ROWCOUNT;
106: UPDATE iby_transmit_configs_b
107: SET tunneling_trans_config_id=l_config_id
108: WHERE transmit_configuration_id IN
109: (SELECT funds_xfer_trans_config_id
110: FROM iby_fndcpt_user_eft_pf_b p, iby_bepkeys k

Line 116: UPDATE iby_transmit_configs_b

112: AND (k.bepid = bep_rec.bepid)
113: )
114: AND (tunneling_trans_config_id IS NULL);
115: l_update_count := l_update_count + SQL%ROWCOUNT;
116: UPDATE iby_transmit_configs_b
117: SET tunneling_trans_config_id=l_config_id
118: WHERE transmit_configuration_id IN
119: (SELECT query_trans_config_id
120: FROM iby_fndcpt_user_eft_pf_b p, iby_bepkeys k