APPS.CSM_TXN_BILL_TYPES_EVENT_PKG dependencies on CSM_TXN_BILLING_TYPES_ACC

Line 12: 10/06/02 ANURAG added check before inserting into csm_txn_billing_types_acc

8: Refreshes for all the users
9: Also adds corresponding entries in to SDQ
10:
11: MODIFICATION HOSTORY:
12: 10/06/02 ANURAG added check before inserting into csm_txn_billing_types_acc
13: for already existing primary key value
14: */
15:
16: procedure Refresh_Acc (p_status OUT NOCOPY VARCHAR2,

Line 50: FROM CSM_TXN_BILLING_TYPES_ACC acc

46:
47: CURSOR l_deletes_cur
48: IS
49: SELECT acc.access_id
50: FROM CSM_TXN_BILLING_TYPES_ACC acc
51: WHERE NOT EXISTS
52: (select tbt.TXN_BILLING_TYPE_ID
53: from cs_txn_billing_types tbt,
54: cs_transaction_types_b ttb,

Line 81: cursor record_exists_csr( p_txn_billing_type_id csm_txn_billing_types_acc.txn_billing_type_id%TYPE,

77: SELECT tt_tl.LANGUAGE
78: FROM cs_transaction_types_tl tt_tl
79: WHERE tt_tl.transaction_type_id = p_transaction_type_id;
80:
81: cursor record_exists_csr( p_txn_billing_type_id csm_txn_billing_types_acc.txn_billing_type_id%TYPE,
82: p_business_process_id csm_txn_billing_types_acc.business_process_id%TYPE)
83: is
84: select 1
85: from csm_txn_billing_types_acc

Line 82: p_business_process_id csm_txn_billing_types_acc.business_process_id%TYPE)

78: FROM cs_transaction_types_tl tt_tl
79: WHERE tt_tl.transaction_type_id = p_transaction_type_id;
80:
81: cursor record_exists_csr( p_txn_billing_type_id csm_txn_billing_types_acc.txn_billing_type_id%TYPE,
82: p_business_process_id csm_txn_billing_types_acc.business_process_id%TYPE)
83: is
84: select 1
85: from csm_txn_billing_types_acc
86: where txn_billing_type_id = p_txn_billing_type_id

Line 85: from csm_txn_billing_types_acc

81: cursor record_exists_csr( p_txn_billing_type_id csm_txn_billing_types_acc.txn_billing_type_id%TYPE,
82: p_business_process_id csm_txn_billing_types_acc.business_process_id%TYPE)
83: is
84: select 1
85: from csm_txn_billing_types_acc
86: where txn_billing_type_id = p_txn_billing_type_id
87: and business_process_id = p_business_process_id;
88: l_dummy number;
89:

Line 120: DELETE FROM CSM_TXN_BILLING_TYPES_ACC

116: SYSDATE);
117: END LOOP;
118:
119: --remove from ACC
120: DELETE FROM CSM_TXN_BILLING_TYPES_ACC
121: WHERE ACCESS_ID = l_access_id;
122:
123: END LOOP;
124: --close the cursor

Line 130: from csm_txn_billing_types_acc acc,

126:
127: /******* UPDATES **********/
128: --generate sql for updates
129: l_dsql := 'select acc.access_id, tt_tl.language
130: from csm_txn_billing_types_acc acc,
131: cs_txn_billing_types tbt,
132: cs_transaction_types_b ttb,
133: cs_transaction_types_tl tt_tl,
134: cs_business_processes bpr,

Line 181: UPDATE csm_txn_billing_types_acc

177: ASG_DOWNLOAD.UPD, sysdate);
178: END IF;
179:
180: --update ACC
181: UPDATE csm_txn_billing_types_acc
182: SET LAST_UPDATE_DATE = l_run_date
183: WHERE ACCESS_ID = l_access_id;
184:
185: END LOOP;

Line 211: from csm_txn_billing_types_acc acc

207: AND bpr.business_process_id = bpt.business_process_id
208: AND bpr.field_service_flag = ''Y''
209: AND NOT EXISTS
210: (select 1
211: from csm_txn_billing_types_acc acc
212: where acc.txn_billing_type_id = tbt.txn_billing_type_id
213: and acc.business_process_id = bpt.business_process_id
214: )';
215:

Line 224: select csm_txn_billing_types_acc_s.NEXTVAL into l_access_id from dual;

220: FETCH l_inserts_cur INTO l_txn_billing_type_id, l_business_process_id, l_transaction_type_id;
221: EXIT WHEN l_inserts_cur%NOTFOUND;
222:
223: --generate access_id
224: select csm_txn_billing_types_acc_s.NEXTVAL into l_access_id from dual;
225:
226: FOR r_txn_types_tl_cur IN l_txn_types_tl_cur(l_transaction_type_id) LOOP
227: --get the users with this language
228: l_tl_omfs_palm_resource_list := l_null_resource_list;

Line 251: INSERT INTO csm_txn_billing_types_acc(access_id, txn_billing_type_id, business_process_id, CREATED_BY,

247: fetch record_exists_csr into l_dummy;
248:
249: if record_exists_csr%notfound then
250: --insert if the value does not already exists
251: INSERT INTO csm_txn_billing_types_acc(access_id, txn_billing_type_id, business_process_id, CREATED_BY,
252: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
253: VALUES (l_access_id,l_txn_billing_type_id, l_business_process_id, fnd_global.user_id, l_run_date,
254: fnd_global.user_id, l_run_date, fnd_global.login_id);
255: