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 173: INSERT INTO csm_mtl_serial_numbers_acc(access_id, user_id, serial_number, inventory_item_id, current_organization_id,

169:
170: -- bulk insert into acc tables
171: IF l_access_id_tbl.count > 0 THEN
172: FORALL i IN 1..l_access_id_tbl.count
173: INSERT INTO csm_mtl_serial_numbers_acc(access_id, user_id, serial_number, inventory_item_id, current_organization_id,
174: counter, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
175: VALUES (l_access_id_tbl(i), p_user_id, l_serial_numbers_tbl(i), l_inventory_items_tbl(i), l_organizations_tbl(i),
176: 1, fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
177:

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

174: counter, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
175: VALUES (l_access_id_tbl(i), p_user_id, l_serial_numbers_tbl(i), l_inventory_items_tbl(i), l_organizations_tbl(i),
176: 1, fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
177:
178: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_access_id_tbl.count || ' records into csm_mtl_serial_numbers_acc for resource ' || p_resource_id ,
179: 'CSM_SERIAL_NUMBERS_EVENT_PKG.INSERT_MTL_SERIAL_NUMBERS',FND_LOG.LEVEL_STATEMENT);
180:
181: -- make dirty calls
182: FOR i IN 1..l_access_id_tbl.count LOOP

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

201: END INSERT_MTL_SERIAL_NUMBERS;
202:
203: 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)
204: IS
205: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_serial_numbers_acc.access_id%TYPE INDEX BY binary_integer;
206: l_access_id_tbl access_id_tbl_typ;
207: l_run_date DATE;
208: l_markdirty boolean;
209: l_sqlerrno varchar2(20);

Line 216: FROM csm_mtl_serial_numbers_acc acc

212: -- upd serial numbers whose locations have changed within the org to locations user has access to
213: CURSOR l_upd_mtl_serial_numbers_csr(p_lastrundate IN date, p_resourceid IN number, p_userid IN number)
214: IS
215: SELECT access_id
216: FROM csm_mtl_serial_numbers_acc acc
217: , mtl_serial_numbers msn
218: WHERE msn.inventory_item_id = acc.inventory_item_id
219: AND msn.serial_number = acc.serial_number
220: AND msn.current_organization_id = acc.current_organization_id

Line 235: FROM csm_mtl_serial_numbers_acc acc

231: -- decrement counter of serial numbers whose locations have changed within the org or that reside in a diff org
232: CURSOR l_del_mtl_serial_numbers_csr(p_resourceid IN number, p_userid IN number)
233: IS
234: SELECT access_id
235: FROM csm_mtl_serial_numbers_acc acc
236: , mtl_serial_numbers msn
237: WHERE msn.inventory_item_id = acc.inventory_item_id
238: AND msn.serial_number = acc.serial_number
239: AND msn.current_organization_id = acc.current_organization_id

Line 251: FROM csm_mtl_serial_numbers_acc acc

247: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE )
248: AND nvl( effective_date_end , SYSDATE ))
249: UNION
250: SELECT access_id
251: FROM csm_mtl_serial_numbers_acc acc
252: WHERE acc.user_id = p_user_id
253: AND NOT EXISTS
254: (SELECT 1
255: FROM mtl_serial_numbers msn

Line 282: FROM csm_mtl_serial_numbers_acc acc , mtl_serial_numbers msn

278:
279: CURSOR l_del_mtl_serial_numbers_csr5(p_resourceid IN number, p_userid IN number) --htm5 users only status=3 i.e no non-ib items
280: IS
281: SELECT access_id
282: FROM csm_mtl_serial_numbers_acc acc , mtl_serial_numbers msn
283: WHERE msn.inventory_item_id = acc.inventory_item_id
284: AND msn.serial_number = acc.serial_number
285: AND msn.current_organization_id = acc.current_organization_id
286: AND acc.user_id = p_userid

Line 294: FROM csm_mtl_serial_numbers_acc acc

290: FROM csp_inv_loc_assignments WHERE resource_id = p_resourceid
291: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE )AND nvl( effective_date_end , SYSDATE ))
292: UNION
293: SELECT access_id
294: FROM csm_mtl_serial_numbers_acc acc
295: WHERE acc.user_id = p_user_id
296: AND NOT EXISTS
297: (SELECT 1 FROM mtl_serial_numbers msn
298: WHERE msn.serial_number = acc.serial_number

Line 308: FROM csm_mtl_serial_numbers_acc

304:
305: CURSOR l_delete_serial_number_acc(p_userid IN number)
306: IS
307: SELECT access_id
308: FROM csm_mtl_serial_numbers_acc
309: WHERE user_id = p_userid
310: AND counter = 0;
311:
312: BEGIN

Line 359: UPDATE csm_mtl_serial_numbers_acc

355:
356: -- update counter for records to be deleted
357: IF l_access_id_tbl.count > 0 THEN
358: FORALL i IN 1..l_access_id_tbl.count
359: UPDATE csm_mtl_serial_numbers_acc
360: SET counter = counter - 1
361: ,last_update_date = SYSDATE
362: ,last_updated_by = fnd_global.user_id
363: WHERE access_id = l_access_id_tbl(i);

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

383: l_run_date);
384: END LOOP;
385:
386: FORALL i IN 1..l_access_id_tbl.count
387: DELETE csm_mtl_serial_numbers_acc WHERE ACCESS_ID = l_access_id_tbl(i);
388:
389: l_access_id_tbl.DELETE;
390: END IF;
391:

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

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

Line 523: FROM csm_mtl_serial_numbers_acc

519: CURSOR l_del_mtl_serial_numbers_csr(p_organizationid IN number,
520: p_userid IN number)
521: IS
522: SELECT access_id
523: FROM csm_mtl_serial_numbers_acc
524: WHERE user_id = p_userid
525: AND current_organization_id = p_organizationid
526: AND counter = 0;
527:

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

549: PROCEDURE GET_NEW_ORG_SERIAL_NUMBERS(p_organization_id IN number
550: , p_user_id IN number
551: , p_resource_id IN number)
552: IS
553: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_serial_numbers_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
554: l_access_id_tbl access_id_tbl_typ;
555: l_mark_dirty boolean;
556: l_run_date date;
557: l_sqlerrno varchar2(20);

Line 566: FROM csm_mtl_serial_numbers_acc

562: CURSOR l_del_mtl_serial_numbers_csr(p_organizationid IN number,
563: p_userid IN number)
564: IS
565: SELECT access_id
566: FROM csm_mtl_serial_numbers_acc
567: WHERE user_id = p_userid
568: AND current_organization_id = p_organizationid
569: AND counter = 1;
570:

Line 645: SELECT csm_mtl_serial_numbers_acc_s.nextval, inventory_item_id, serial_number, current_organization_id,au.user_id

641: PROCEDURE RECEIVED_MTL_SERIAL_NUM(p_org_id IN NUMBER,p_subinv_code IN VARCHAR2, p_item_id IN NUMBER,p_serial_number IN VARCHAR2,p_user_id IN NUMBER)
642: IS
643: CURSOR received_srl_item
644: IS
645: SELECT csm_mtl_serial_numbers_acc_s.nextval, inventory_item_id, serial_number, current_organization_id,au.user_id
646: FROM mtl_serial_numbers,asg_user au
647: WHERE current_status =3 -- html5 supports only 3
648: AND current_organization_id=p_org_id
649: AND current_subinventory_code = p_subinv_code

Line 661: FROM csm_mtl_serial_numbers_acc

657: AND resource_type='RS_EMPLOYEE'
658: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE ) AND nvl( effective_date_end , SYSDATE ))
659: AND ( inventory_item_id, serial_number, current_organization_id ) NOT IN (
660: SELECT inventory_item_id, serial_number, current_organization_id
661: FROM csm_mtl_serial_numbers_acc
662: WHERE user_id = au.user_id );
663:
664: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
665: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

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

679: CLOSE received_srl_item;
680:
681: IF l_tab_access_id.COUNT > 0 THEN
682: FORALL i IN 1..l_tab_access_id.count
683: INSERT INTO csm_mtl_serial_numbers_acc(access_id, user_id, serial_number, inventory_item_id, current_organization_id,
684: counter, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
685: VALUES (l_tab_access_id(i), l_tab_user_id(i), l_tab_srl(i), l_tab_item_id(i), l_tab_org_id(i),
686: 1, fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);
687:

Line 688: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_mtl_serial_numbers_acc ',

684: counter, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
685: VALUES (l_tab_access_id(i), l_tab_user_id(i), l_tab_srl(i), l_tab_item_id(i), l_tab_org_id(i),
686: 1, fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);
687:
688: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_mtl_serial_numbers_acc ',
689: 'CSM_SERIAL_NUMBERS_EVENT_PKG.RECEIVED_MTL_SERIAL_NUM',FND_LOG.LEVEL_STATEMENT);
690:
691: l_markdirty := asg_download.mark_dirty(
692: P_PUB_ITEM => g_pub_item