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_DEFERRED_TXNS_PKG dependencies on CSM_DEFERRED_NFN_INFO

Line 26: FROM CSM_DEFERRED_NFN_INFO nfn, ASG_PUB_ITEM pi

22: BEGIN
23: SELECT nfn.DEFERRED_TRAN_ID,nfn.CLIENT_ID, nfn.SEQUENCE,nfn.DML,
24: nfn.OBJECT_NAME,pi.PRIMARY_KEY_COLUMN,nfn.OBJECT_ID,instr(pi.PRIMARY_KEY_COLUMN,',')
25: INTO old_tranid, old_client_id,old_seq,old_dml,inq_table,inq_pk_col,inq_pk_value,l_proceed
26: FROM CSM_DEFERRED_NFN_INFO nfn, ASG_PUB_ITEM pi
27: WHERE nfn.tracking_id=p_tracking_id
28: AND nfn.OBJECT_NAME = pi.item_id;
29:
30: IF l_proceed > 0 THEN

Line 101: SELECT TRACKING_ID,CLIENT_ID FROM CSM_DEFERRED_NFN_INFO

97: AND clid$$cs = b_user_name;
98:
99: CURSOR c_tracking_tree(b_tracking_id number)
100: IS
101: SELECT TRACKING_ID,CLIENT_ID FROM CSM_DEFERRED_NFN_INFO
102: connect by prior tracking_id=parent_id
103: start with tracking_id=b_tracking_id;
104:
105: CURSOR c_reapply_txn(b_tranid NUMBER,b_name VARCHAR2)

Line 145: FOR rec IN (SELECT tracking_id FROM CSM_DEFERRED_NFN_INFO

141: WHERE tracking_id = dml_0_rec.tracking_id
142: AND USER_ID=asg_base.get_user_id(p_user_name);
143:
144: --delete children
145: FOR rec IN (SELECT tracking_id FROM CSM_DEFERRED_NFN_INFO
146: WHERE PARENT_ID=dml_0_rec.tracking_id AND CLIENT_ID=p_user_name)
147: LOOP
148: CSM_ACC_PKG.Delete_Acc
149: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')

Line 157: DELETE FROM CSM_DEFERRED_NFN_INFO WHERE dml_0_rec.tracking_id IN (TRACKING_ID,PARENT_ID) AND CLIENT_ID=p_user_name;

153: ,P_USER_ID => asg_base.get_user_id(p_user_name)
154: );
155: END LOOP;
156:
157: DELETE FROM CSM_DEFERRED_NFN_INFO WHERE dml_0_rec.tracking_id IN (TRACKING_ID,PARENT_ID) AND CLIENT_ID=p_user_name;
158:
159: CSM_UTIL_PKG.DELETE_RECORD
160: (
161: p_user_name,

Line 186: NOT EXISTS(SELECT 1 FROM CSM_DEFERRED_NFN_INFO b

182: AND
183: (
184: (ACTION IS NULL OR ACTION NOT IN ('C','D'))
185: OR
186: NOT EXISTS(SELECT 1 FROM CSM_DEFERRED_NFN_INFO b
187: WHERE b.tracking_id=inq.tracking_id)
188: OR
189: (
190: ACTION='C'

Line 191: AND EXISTS(SELECT 1 FROM CSM_DEFERRED_NFN_INFO b

187: WHERE b.tracking_id=inq.tracking_id)
188: OR
189: (
190: ACTION='C'
191: AND EXISTS(SELECT 1 FROM CSM_DEFERRED_NFN_INFO b
192: WHERE b.tracking_id=inq.tracking_id
193: AND PARENT_ID IS NOT NULL) /*REAPPLY supported only at ROOT level*/
194: )
195: ))

Line 211: FROM CSM_DEFERRED_NFN_INFO

207: );
208:
209: BEGIN
210: SELECT 'S' INTO l_process_status
211: FROM CSM_DEFERRED_NFN_INFO
212: WHERE tracking_id=clear_rec.tracking_id;
213: EXCEPTION
214: WHEN NO_DATA_FOUND THEN
215: /*Send a reject row for recs in INQ that don't exist in Base*/

Line 254: FOR disc_rec IN (SELECT * FROM CSM_DEFERRED_NFN_INFO

250: /*Take action*/
251: IF def_rec.ACTION = 'D' THEN
252: -- Discard root(need not be main root,can be partial) and all its related entries
253: l_cnt:=0;
254: FOR disc_rec IN (SELECT * FROM CSM_DEFERRED_NFN_INFO
255: connect by prior tracking_id=parent_id
256: start with tracking_id=def_rec.tracking_id)
257: LOOP
258: IF(disc_rec.dml='I') THEN

Line 291: DELETE FROM CSM_DEFERRED_NFN_INFO WHERE TRACKING_ID = l_track_tab(I);

287: END LOOP;
288:
289:
290: FORALL I IN 1..l_cnt
291: DELETE FROM CSM_DEFERRED_NFN_INFO WHERE TRACKING_ID = l_track_tab(I);
292:
293: ELSE /*IF def_rec.ACTION = 'C' THEN */
294:
295: /*correct inq*/

Line 319: DELETE FROM CSM_DEFERRED_NFN_INFO WHERE TRACKING_ID = l_track_tab(I);

315: ,P_PK1_NUM_VALUE => l_track_tab(I)
316: ,P_USER_ID => asg_base.get_user_id(l_uname_tab(I))
317: );
318:
319: DELETE FROM CSM_DEFERRED_NFN_INFO WHERE TRACKING_ID = l_track_tab(I);
320: END LOOP;
321:
322: END IF;
323:

Line 373: FOR root_rec IN (SELECT TRACKING_ID FROM CSM_DEFERRED_NFN_INFO

369: IS
370: BEGIN
371: BEGIN
372: /* process ROOT tracking records alone*/
373: FOR root_rec IN (SELECT TRACKING_ID FROM CSM_DEFERRED_NFN_INFO
374: WHERE CLIENT_ID=p_user_name AND DEFERRED_TRAN_ID=p_tranid
375: AND PARENT_ID IS NULL)
376: LOOP
377: FOR disc_rec IN (SELECT * FROM CSM_DEFERRED_NFN_INFO

Line 377: FOR disc_rec IN (SELECT * FROM CSM_DEFERRED_NFN_INFO

373: FOR root_rec IN (SELECT TRACKING_ID FROM CSM_DEFERRED_NFN_INFO
374: WHERE CLIENT_ID=p_user_name AND DEFERRED_TRAN_ID=p_tranid
375: AND PARENT_ID IS NULL)
376: LOOP
377: FOR disc_rec IN (SELECT * FROM CSM_DEFERRED_NFN_INFO
378: connect by prior tracking_id=parent_id
379: start with tracking_id=root_rec.tracking_id)
380: LOOP
381: IF(disc_rec.dml='I') THEN

Line 401: DELETE FROM CSM_DEFERRED_NFN_INFO

397:
398: END LOOP;
399: END LOOP;
400:
401: DELETE FROM CSM_DEFERRED_NFN_INFO
402: WHERE CLIENT_ID=p_user_name
403: AND DEFERRED_TRAN_ID=p_tranid;
404:
405: END; --processed tracking records

Line 431: FROM CSM_DEFERRED_NFN_INFO

427: BEGIN
428:
429: BEGIN --process tracking records
430: SELECT TRACKING_ID INTO l_tracking_id
431: FROM CSM_DEFERRED_NFN_INFO
432: WHERE CLIENT_ID=p_user_name
433: AND DEFERRED_TRAN_ID=p_tranid
434: AND SEQUENCE = p_sequence
435: AND OBJECT_NAME = p_pubitem;

Line 438: FOR disc_rec IN (SELECT * FROM CSM_DEFERRED_NFN_INFO

434: AND SEQUENCE = p_sequence
435: AND OBJECT_NAME = p_pubitem;
436:
437: l_cnt:=0;
438: FOR disc_rec IN (SELECT * FROM CSM_DEFERRED_NFN_INFO
439: connect by prior tracking_id=parent_id
440: start with tracking_id=l_tracking_id)
441: LOOP
442: IF(disc_rec.dml='I') THEN

Line 465: DELETE FROM CSM_DEFERRED_NFN_INFO WHERE TRACKING_ID = l_track_tab(I);

461:
462: END LOOP;
463:
464: FORALL I IN 1..l_cnt
465: DELETE FROM CSM_DEFERRED_NFN_INFO WHERE TRACKING_ID = l_track_tab(I);
466: EXCEPTION
467: WHEN NO_DATA_FOUND THEN
468: NULL;
469: END; --processed tracking records