eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_MTL_SEC_INV_EVENT_PKG dependencies on CSM_MTL_SEC_INV_ACC

Line 16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC';

12: -- --------- ------ ------------------------------------------
13: -- Enter procedure, function bodies as shown below
14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_SEC_INVENTORIES';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SEC_INVENTORIES');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY_NAME';

Line 17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC_S';

13: -- Enter procedure, function bodies as shown below
14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_SEC_INVENTORIES';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SEC_INVENTORIES');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY_NAME';
21: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 161: FROM csm_mtl_sec_inv_acc acc

157:
158:
159: CURSOR c_del_cur IS
160: SELECT acc.access_id, acc.user_id
161: FROM csm_mtl_sec_inv_acc acc
162: WHERE not exists (Select 1 FROM CSM_INTERORG_PARAMETERS_ACC
163: WHERE acc.organization_id IN (FROM_ORGANIZATION_ID,TO_ORGANIZATION_ID) AND USER_ID=acc.user_id)
164: OR EXISTS(SELECT 1 FROM mtl_secondary_inventories msi WHERE acc.organization_id=msi.organization_id AND acc.secondary_inventory_name=msi.secondary_inventory_name
165: AND nvl(msi.disable_date,sysdate+1)

Line 171: csm_mtl_sec_inv_acc acc

167: CURSOR l_upd_mtl_sec_inv_csr(p_last_upd_date IN date)
168: IS
169: SELECT acc.access_id, acc.user_id
170: FROM csp_sec_inventories csi,
171: csm_mtl_sec_inv_acc acc
172: WHERE csi.secondary_inventory_name = acc.secondary_inventory_name
173: AND csi.organization_id = acc.organization_id
174: AND csi.last_update_date >= p_last_upd_date;
175:

Line 177: select CSM_MTL_SEC_INV_ACC_S.nextval as access_id,au.user_id , csi.organization_id,csi.secondary_inventory_name

173: AND csi.organization_id = acc.organization_id
174: AND csi.last_update_date >= p_last_upd_date;
175:
176: CURSOR c_ins_cur IS -- sub inventories of dest org
177: select CSM_MTL_SEC_INV_ACC_S.nextval as access_id,au.user_id , csi.organization_id,csi.secondary_inventory_name
178: from csp_sec_inventories csi,asg_user au
179: where au.enabled='Y' and au.multi_platform='Y'
180: --AND csi.CONDITION_TYPE='G'
181: AND EXISTS(SELECT 1 FROM mtl_secondary_inventories msi WHERE csi.organization_id=msi.organization_id AND csi.secondary_inventory_name=msi.secondary_inventory_name

Line 184: AND NOT EXISTS(SELECT 1 FROM csm_mtl_sec_inv_acc acc WHERE csi.organization_id=acc.organization_id

180: --AND csi.CONDITION_TYPE='G'
181: AND EXISTS(SELECT 1 FROM mtl_secondary_inventories msi WHERE csi.organization_id=msi.organization_id AND csi.secondary_inventory_name=msi.secondary_inventory_name
182: AND nvl(msi.disable_date,sysdate+1)>=sysdate)
183: AND EXISTS(SELECT 1 FROM CSM_INTERORG_PARAMETERS_ACC WHERE USER_ID=au.user_id AND csi.organization_id IN (FROM_ORGANIZATION_ID,TO_ORGANIZATION_ID))
184: AND NOT EXISTS(SELECT 1 FROM csm_mtl_sec_inv_acc acc WHERE csi.organization_id=acc.organization_id
185: AND csi.secondary_inventory_name=acc.secondary_inventory_name and acc.user_id=au.user_id);
186:
187: BEGIN
188: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',

Line 209: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_mtl_sec_inv_acc' ,

205:
206: FETCH c_del_cur BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
207: EXIT WHEN l_tab_access_id.COUNT = 0;
208:
209: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_mtl_sec_inv_acc' ,
210: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
211:
212: l_markdirty := asg_download.mark_dirty(
213: P_PUB_ITEM => g_pub_item

Line 221: DELETE FROM csm_mtl_sec_inv_acc WHERE access_id = l_tab_access_id(i);

217: , P_TIMESTAMP => sysdate
218: );
219:
220: FORALL i IN 1..l_tab_access_id.COUNT
221: DELETE FROM csm_mtl_sec_inv_acc WHERE access_id = l_tab_access_id(i);
222:
223: COMMIT;
224: END LOOP;
225: CLOSE c_del_cur;

Line 238: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records from csm_mtl_sec_inv_acc' ,

234:
235: FETCH l_upd_mtl_sec_inv_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
236: EXIT WHEN l_tab_access_id.COUNT = 0;
237:
238: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records from csm_mtl_sec_inv_acc' ,
239: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
240:
241: l_markdirty := asg_download.mark_dirty(
242: P_PUB_ITEM => g_pub_item

Line 269: INSERT INTO CSM_MTL_SEC_INV_ACC (access_id, user_id,organization_id, secondary_inventory_name,

265: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into CSM_INTERORG_FREIGHTS_ACC' ,
266: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
267:
268: FORALL i IN 1..l_tab_access_id.COUNT
269: INSERT INTO CSM_MTL_SEC_INV_ACC (access_id, user_id,organization_id, secondary_inventory_name,
270: counter, created_by, creation_date, last_updated_by, last_update_date ,lasT_update_login)
271: VALUES (l_tab_access_id(i), l_tab_user_id(i),l_tab_org_id(i),l_tab_sub_code(i),
272: 1,fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date,1);
273: