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_SERIAL_NUMBERS_EVENT_PKG dependencies on CSM_MTL_SERIAL_NUMBERS_ACC

Line 21: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_serial_numbers_acc.access_id%TYPE INDEX BY binary_integer;

17: IS
18: TYPE inventory_items_tbl_typ IS TABLE OF mtl_serial_numbers.inventory_item_id%TYPE INDEX BY binary_integer;
19: TYPE serial_numbers_tbl_typ IS TABLE OF mtl_serial_numbers.serial_number%TYPE INDEX BY binary_integer;
20: TYPE organizations_tbl_typ IS TABLE OF mtl_serial_numbers.current_organization_id%TYPE INDEX BY binary_integer;
21: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_serial_numbers_acc.access_id%TYPE INDEX BY binary_integer;
22:
23: l_inventory_items_tbl inventory_items_tbl_typ;
24: l_serial_numbers_tbl serial_numbers_tbl_typ;
25: l_organizations_tbl organizations_tbl_typ;

Line 36: FROM csm_mtl_serial_numbers_acc acc

32: -- update counter of records that may already exist in acc table
33: CURSOR l_upd_mtl_serial_numbers_csr(p_organization_id in number, p_resourceid IN number, p_userid in number, p_lastrundate IN date)
34: IS
35: SELECT acc.access_id
36: FROM csm_mtl_serial_numbers_acc acc
37: WHERE acc.user_id = p_userid
38: --AND acc.current_organization_id = p_organization_id
39: AND (acc.inventory_item_id, acc.serial_number, acc.current_organization_id) IN (
40: SELECT inventory_item_id, serial_number, current_organization_id

Line 56: SELECT csm_mtl_serial_numbers_acc_s.nextval, inventory_item_id, serial_number, current_organization_id

52:
53: -- get all new serial numbers that do not exist in acc table
54: CURSOR l_ins_mtl_serial_numbers_csr(p_organization_id in number, p_resourceid IN number, p_userid in number, p_lastrundate IN date)
55: IS--select serial numbers in status 3 for both ib non ib items
56: SELECT csm_mtl_serial_numbers_acc_s.nextval, inventory_item_id, serial_number, current_organization_id
57: FROM mtl_serial_numbers
58: WHERE current_status =3 -- resides in stores + issued out of subinv
59: AND ( current_subinventory_code, current_organization_id ) IN (
60: SELECT subinventory_code

Line 68: FROM csm_mtl_serial_numbers_acc

64: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE )
65: AND nvl( effective_date_end , SYSDATE ))
66: AND ( inventory_item_id, serial_number, current_organization_id ) NOT IN (
67: SELECT inventory_item_id, serial_number, current_organization_id
68: FROM csm_mtl_serial_numbers_acc
69: WHERE user_id = p_userid );
70:
71: CURSOR l_ins_mtl_ser_num_fornonib_csr(p_organization_id in number, p_resourceid IN number, p_userid in number, p_lastrundate IN date)
72: IS--select serial numbers in status 1,4 for non ib items only

Line 73: SELECT csm_mtl_serial_numbers_acc_s.nextval,

69: WHERE user_id = p_userid );
70:
71: CURSOR l_ins_mtl_ser_num_fornonib_csr(p_organization_id in number, p_resourceid IN number, p_userid in number, p_lastrundate IN date)
72: IS--select serial numbers in status 1,4 for non ib items only
73: SELECT csm_mtl_serial_numbers_acc_s.nextval,
74: ser.inventory_item_id,
75: ser.serial_number,
76: ser.current_organization_id
77: FROM mtl_serial_numbers ser

Line 92: FROM csm_mtl_serial_numbers_acc sacc

88: AND NVL(sys.COMMS_NL_TRACKABLE_FLAG,'N') ='N'
89: )
90: AND NOT EXISTS (
91: SELECT 'x'
92: FROM csm_mtl_serial_numbers_acc sacc
93: WHERE user_id = p_userid
94: AND sacc.inventory_item_id = ser.inventory_item_id
95: AND sacc.serial_number = ser.serial_number
96: AND sacc.current_organization_id = ser.current_organization_id);

Line 115: UPDATE csm_mtl_serial_numbers_acc

111: CLOSE l_upd_mtl_serial_numbers_csr;
112:
113: IF l_access_id_tbl.count > 0 THEN
114: FORALL i IN 1..l_access_id_tbl.count
115: UPDATE csm_mtl_serial_numbers_acc
116: SET counter = counter + 1
117: ,last_update_date = SYSDATE
118: ,last_updated_by = fnd_global.user_id
119: WHERE access_id = l_access_id_tbl(i);

Line 132: INSERT INTO csm_mtl_serial_numbers_acc(access_id, user_id, serial_number, inventory_item_id, current_organization_id,

128:
129: -- bulk insert into acc tables
130: IF l_access_id_tbl.count > 0 THEN
131: FORALL i IN 1..l_access_id_tbl.count
132: INSERT INTO csm_mtl_serial_numbers_acc(access_id, user_id, serial_number, inventory_item_id, current_organization_id,
133: counter, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
134: VALUES (l_access_id_tbl(i), p_user_id, l_serial_numbers_tbl(i), l_inventory_items_tbl(i), l_organizations_tbl(i),
135: 1, fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
136:

Line 137: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_access_id_tbl.count || ' records into csm_mtl_serial_numbers_acc for resource ' || p_resource_id ,

133: counter, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
134: VALUES (l_access_id_tbl(i), p_user_id, l_serial_numbers_tbl(i), l_inventory_items_tbl(i), l_organizations_tbl(i),
135: 1, fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
136:
137: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_access_id_tbl.count || ' records into csm_mtl_serial_numbers_acc for resource ' || p_resource_id ,
138: 'CSM_SERIAL_NUMBERS_EVENT_PKG.INSERT_MTL_SERIAL_NUMBERS',FND_LOG.LEVEL_STATEMENT);
139:
140: -- make dirty calls
141: FOR i IN 1..l_access_id_tbl.count LOOP

Line 166: INSERT INTO csm_mtl_serial_numbers_acc(access_id, user_id, serial_number, inventory_item_id, current_organization_id,

162:
163: -- bulk insert into acc tables
164: IF l_access_id_tbl.count > 0 THEN
165: FORALL i IN 1..l_access_id_tbl.count
166: INSERT INTO csm_mtl_serial_numbers_acc(access_id, user_id, serial_number, inventory_item_id, current_organization_id,
167: counter, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
168: VALUES (l_access_id_tbl(i), p_user_id, l_serial_numbers_tbl(i), l_inventory_items_tbl(i), l_organizations_tbl(i),
169: 1, fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
170:

Line 171: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_access_id_tbl.count || ' records into csm_mtl_serial_numbers_acc for resource ' || p_resource_id ,

167: counter, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
168: VALUES (l_access_id_tbl(i), p_user_id, l_serial_numbers_tbl(i), l_inventory_items_tbl(i), l_organizations_tbl(i),
169: 1, fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
170:
171: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_access_id_tbl.count || ' records into csm_mtl_serial_numbers_acc for resource ' || p_resource_id ,
172: 'CSM_SERIAL_NUMBERS_EVENT_PKG.INSERT_MTL_SERIAL_NUMBERS',FND_LOG.LEVEL_STATEMENT);
173:
174: -- make dirty calls
175: FOR i IN 1..l_access_id_tbl.count LOOP

Line 198: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_serial_numbers_acc.access_id%TYPE INDEX BY binary_integer;

194: END INSERT_MTL_SERIAL_NUMBERS;
195:
196: PROCEDURE update_mtl_serial_numbers(p_organization_id IN number, p_last_run_date IN date, p_resource_id IN number, p_user_id IN number)
197: IS
198: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_serial_numbers_acc.access_id%TYPE INDEX BY binary_integer;
199: l_access_id_tbl access_id_tbl_typ;
200: l_run_date DATE;
201: l_markdirty boolean;
202: l_sqlerrno varchar2(20);

Line 209: FROM csm_mtl_serial_numbers_acc acc

205: -- upd serial numbers whose locations have changed within the org to locations user has access to
206: CURSOR l_upd_mtl_serial_numbers_csr(p_lastrundate IN date, p_resourceid IN number, p_userid IN number)
207: IS
208: SELECT access_id
209: FROM csm_mtl_serial_numbers_acc acc
210: , mtl_serial_numbers msn
211: WHERE msn.inventory_item_id = acc.inventory_item_id
212: AND msn.serial_number = acc.serial_number
213: AND msn.current_organization_id = acc.current_organization_id

Line 228: FROM csm_mtl_serial_numbers_acc acc

224: -- decrement counter of serial numbers whose locations have changed within the org or that reside in a diff org
225: CURSOR l_del_mtl_serial_numbers_csr(p_lastrundate IN date, p_resourceid IN number, p_userid IN number)
226: IS
227: SELECT access_id
228: FROM csm_mtl_serial_numbers_acc acc
229: , mtl_serial_numbers msn
230: WHERE msn.inventory_item_id = acc.inventory_item_id
231: AND msn.serial_number = acc.serial_number
232: AND msn.current_organization_id = acc.current_organization_id

Line 244: FROM csm_mtl_serial_numbers_acc acc

240: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE )
241: AND nvl( effective_date_end , SYSDATE ))
242: UNION
243: SELECT access_id
244: FROM csm_mtl_serial_numbers_acc acc
245: WHERE acc.user_id = p_user_id
246: AND NOT EXISTS
247: (SELECT 1
248: FROM mtl_serial_numbers msn

Line 275: FROM csm_mtl_serial_numbers_acc

271:
272: CURSOR l_delete_serial_number_acc(p_userid IN number)
273: IS
274: SELECT access_id
275: FROM csm_mtl_serial_numbers_acc
276: WHERE user_id = p_userid
277: AND counter = 0;
278:
279: BEGIN

Line 318: UPDATE csm_mtl_serial_numbers_acc

314:
315: -- update counter for records to be deleted
316: IF l_access_id_tbl.count > 0 THEN
317: FORALL i IN 1..l_access_id_tbl.count
318: UPDATE csm_mtl_serial_numbers_acc
319: SET counter = counter - 1
320: ,last_update_date = SYSDATE
321: ,last_updated_by = fnd_global.user_id
322: WHERE access_id = l_access_id_tbl(i);

Line 346: DELETE csm_mtl_serial_numbers_acc WHERE ACCESS_ID = l_access_id_tbl(i);

342: l_run_date);
343: END LOOP;
344:
345: FORALL i IN 1..l_access_id_tbl.count
346: DELETE csm_mtl_serial_numbers_acc WHERE ACCESS_ID = l_access_id_tbl(i);
347:
348: l_access_id_tbl.DELETE;
349: END IF;
350:

Line 464: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_serial_numbers_acc.access_id%TYPE INDEX BY BINARY_INTEGER;

460: PROCEDURE DELETE_OLD_ORG_SERIAL_NUMBERS(p_organization_id IN number
461: , p_user_id IN number
462: , p_resource_id IN number)
463: IS
464: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_serial_numbers_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
465: l_access_id_tbl access_id_tbl_typ;
466: l_mark_dirty boolean;
467: l_run_date date;
468: l_sqlerrno varchar2(20);

Line 477: FROM csm_mtl_serial_numbers_acc

473: CURSOR l_del_mtl_serial_numbers_csr(p_organizationid IN number,
474: p_userid IN number)
475: IS
476: SELECT access_id
477: FROM csm_mtl_serial_numbers_acc
478: WHERE user_id = p_userid
479: AND current_organization_id = p_organizationid
480: AND counter = 0;
481:

Line 507: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_serial_numbers_acc.access_id%TYPE INDEX BY BINARY_INTEGER;

503: PROCEDURE GET_NEW_ORG_SERIAL_NUMBERS(p_organization_id IN number
504: , p_user_id IN number
505: , p_resource_id IN number)
506: IS
507: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_serial_numbers_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
508: l_access_id_tbl access_id_tbl_typ;
509: l_mark_dirty boolean;
510: l_run_date date;
511: l_sqlerrno varchar2(20);

Line 520: FROM csm_mtl_serial_numbers_acc

516: CURSOR l_del_mtl_serial_numbers_csr(p_organizationid IN number,
517: p_userid IN number)
518: IS
519: SELECT access_id
520: FROM csm_mtl_serial_numbers_acc
521: WHERE user_id = p_userid
522: AND current_organization_id = p_organizationid
523: AND counter = 1;
524: