APPS.CSM_MTL_PARAMETERS_EVENT_PKG dependencies on CSM_MTL_PARAMETERS_ACC

Line 15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS_ACC';

11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_PARAMETERS';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_PARAMETERS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS_ACC_S';

12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_PARAMETERS';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_PARAMETERS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
20: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS';

Line 56: FROM csm_mtl_parameters_acc acc

52: SELECT mtlp.organization_id
53: FROM mtl_parameters mtlp
54: WHERE NOT EXISTS
55: (SELECT 1
56: FROM csm_mtl_parameters_acc acc
57: WHERE acc.organization_id = mtlp.organization_id
58: );
59:
60: -- updates cur

Line 65: csm_mtl_parameters_acc acc

61: CURSOR l_mtl_parameters_upd_csr(p_last_upd_date date)
62: IS
63: SELECT acc.access_id, mtlp.organization_id
64: FROM mtl_parameters mtlp,
65: csm_mtl_parameters_acc acc
66: WHERE (mtlp.creation_date < p_last_upd_date AND mtlp.last_update_date > p_last_upd_date)
67: AND acc.organization_id = mtlp.organization_id;
68:
69: -- deletes cur

Line 73: FROM csm_mtl_parameters_acc acc

69: -- deletes cur
70: CURSOR l_mtl_parameters_del_csr
71: IS
72: SELECT acc.access_id, acc.organization_id
73: FROM csm_mtl_parameters_acc acc
74: WHERE NOT EXISTS
75: (SELECT 1
76: FROM mtl_parameters mtlp
77: WHERE mtlp.organization_id = acc.organization_id

Line 112: DELETE FROM csm_mtl_parameters_acc WHERE access_id = l_access_id;

108: ASG_DOWNLOAD.DEL, sysdate);
109: END IF;
110:
111: -- delete from acc table
112: DELETE FROM csm_mtl_parameters_acc WHERE access_id = l_access_id;
113: END LOOP;
114:
115: -- process all updates
116: FOR r_mtl_parameters_upd_rec IN l_mtl_parameters_upd_csr(l_prog_update_date) LOOP

Line 146: SELECT csm_mtl_parameters_acc_s.nextval

142: --get the users with this language
143: l_all_omfs_palm_resource_list := l_null_resource_list;
144: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
145:
146: SELECT csm_mtl_parameters_acc_s.nextval
147: INTO l_access_id
148: FROM dual;
149:
150: --nullify the access list

Line 163: INSERT INTO csm_mtl_parameters_acc (access_id,

159: l_single_access_id_list, l_all_omfs_palm_resource_list,
160: ASG_DOWNLOAD.INS, sysdate);
161: END IF;
162:
163: INSERT INTO csm_mtl_parameters_acc (access_id,
164: organization_id,
165: counter,
166: created_by,
167: creation_date,