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.ASG_DEFER dependencies on ASG_DEFERRED_TRANINFO

Line 54: ||'from asg_deferred_traninfo where CREATION_DATE >= to_date('''

50: ||''''||p_pubitem||''' pub_item ,'''||p_sequence||''' SEQUENCE '
51: ||' from dual';
52: /*l_qry := 'select DEVICE_USER_NAME user_name,DEFERRED_TRAN_ID tran_id ,'
53: ||'ERROR_DESCRIPTION ,OBJECT_NAME pub_item,SEQUENCE '
54: ||'from asg_deferred_traninfo where CREATION_DATE >= to_date('''
55: ||to_char(p_start_time,'mm-dd-yyyy hh24:mi:ss')
56: ||''',''mm-dd-yyyy hh24:mi:ss'') ';*/
57: if(asg_helper.check_is_log_enabled(g_stmt_level))
58: then

Line 177: UPDATE asg_deferred_traninfo

173: end if;
174: end if;
175: -- First try to update if that fails, insert.
176: -- #$% Should use table handler
177: UPDATE asg_deferred_traninfo
178: SET failures = failures +1, error_description = l_error_msg,
179: last_update_date = SYSDATE
180: WHERE device_user_name = p_user_name AND
181: deferred_tran_id = p_tranid AND

Line 193: INSERT INTO asg_deferred_traninfo (DEVICE_USER_NAME,

189: x_return_status := FND_API.G_RET_STS_ERROR;
190: return;
191: END IF;
192: CLOSE c_resource_id;
193: INSERT INTO asg_deferred_traninfo (DEVICE_USER_NAME,
194: RESOURCE_ID,
195: DEFERRED_TRAN_ID,
196: MOBILE_ERROR_ID,
197: ERROR_DESCRIPTION,

Line 274: -- Delete any reference in asg_deferred_traninfo

270: 'asg_defer', g_err_level);
271: END IF;
272: END;
273:
274: -- Delete any reference in asg_deferred_traninfo
275: -- #$% Should use table handler
276: -- Should also optimize based on whether tranid is deferred or not
277: BEGIN
278: DELETE FROM asg_deferred_traninfo

Line 278: DELETE FROM asg_deferred_traninfo

274: -- Delete any reference in asg_deferred_traninfo
275: -- #$% Should use table handler
276: -- Should also optimize based on whether tranid is deferred or not
277: BEGIN
278: DELETE FROM asg_deferred_traninfo
279: WHERE device_user_name = p_user_name AND
280: deferred_tran_id = p_tranid AND
281: object_name = p_pubitem;
282: EXCEPTION

Line 341: -- Delete any reference in asg_deferred_traninfo

337: 'asg_defer', g_err_level);
338: END IF;
339: END;
340:
341: -- Delete any reference in asg_deferred_traninfo
342: -- #$% Should use table handler
343: -- Should also optimize based on whether tranid is deferred or not
344: BEGIN
345: DELETE FROM asg_deferred_traninfo

Line 345: DELETE FROM asg_deferred_traninfo

341: -- Delete any reference in asg_deferred_traninfo
342: -- #$% Should use table handler
343: -- Should also optimize based on whether tranid is deferred or not
344: BEGIN
345: DELETE FROM asg_deferred_traninfo
346: WHERE device_user_name = p_user_name AND
347: deferred_tran_id = p_tranid AND
348: object_name = p_pubitem AND
349: sequence = p_sequence;

Line 502: FROM asg_deferred_traninfo

498: l_user_name VARCHAR2(30);
499: CURSOR c_isdeferred(p_user_name VARCHAR2, p_tranid NUMBER,
500: p_pubitem VARCHAR2, p_sequence NUMBER) IS
501: SELECT device_user_name
502: FROM asg_deferred_traninfo
503: WHERE device_user_name = p_user_name AND
504: deferred_tran_id = p_tranid AND
505: object_name = p_pubitem AND
506: sequence = p_sequence;

Line 572: FROM asg_deferred_traninfo

568: IS
569: l_def_count PLS_INTEGER;
570: CURSOR c_deferred_discarded (p_user_name VARCHAR2, p_tranid NUMBER) IS
571: SELECT count(*) count
572: FROM asg_deferred_traninfo
573: WHERE device_user_name = p_user_name AND
574: deferred_tran_id = p_tranid;
575: BEGIN
576: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 619: FROM asg_pub a, asg_pub_item b, asg_deferred_traninfo c

615: l_orig_resp_id NUMBER;
616: l_orig_app_id NUMBER;
617: CURSOR c_pub_wrapper(p_user_name VARCHAR2, p_tranid NUMBER) IS
618: SELECT distinct a.wrapper_name, a.name
619: FROM asg_pub a, asg_pub_item b, asg_deferred_traninfo c
620: WHERE device_user_name = p_user_name AND
621: deferred_tran_id = p_tranid AND
622: c.object_name = b.name AND
623: b.pub_name = a.name

Line 627: FROM asg_deferred_traninfo

623: b.pub_name = a.name
624: ORDER BY a.name;
625: CURSOR c_deferred_processed (p_user_name VARCHAR2, p_tranid NUMBER) IS
626: SELECT count(*) count
627: FROM asg_deferred_traninfo
628: WHERE device_user_name = p_user_name AND
629: deferred_tran_id = p_tranid AND
630: status <> 0;
631: BEGIN

Line 805: -- Delete rows in asg_deferred_traninfo/asg_users_inqinfo with no data in INQ.

801: 'asg_defer',g_stmt_level);
802: END IF;
803: END purge_transaction;
804:
805: -- Delete rows in asg_deferred_traninfo/asg_users_inqinfo with no data in INQ.
806: PROCEDURE delete_deferred(p_status OUT NOCOPY VARCHAR2,
807: p_message OUT NOCOPY VARCHAR2)
808: IS
809: CURSOR c_deferred_lines

Line 812: from asg_deferred_traninfo;

808: IS
809: CURSOR c_deferred_lines
810: IS
811: select distinct object_name
812: from asg_deferred_traninfo;
813: l_sql VARCHAR2(512);
814: l_row_count NUMBER;
815: l_inq_table_name VARCHAR2(128);
816: BEGIN

Line 832: l_sql := 'DELETE FROM asg_deferred_traninfo ' ||

828: 'asg_defer',g_stmt_level);
829: END IF;
830:
831: l_inq_table_name := asg_base.G_OLITE_SCHEMA || '.CFM$' || cdl.object_name;
832: l_sql := 'DELETE FROM asg_deferred_traninfo ' ||
833: 'WHERE object_name = :1 AND ' ||
834: '(device_user_name, deferred_tran_id, sequence) NOT IN ' ||
835: ' (SELECT clid$$cs, tranid$$, seqno$$ ' ||
836: ' FROM ' || l_inq_table_name || ' )';

Line 860: FROM asg_deferred_traninfo);

856: -- Delete any deferred headers
857: DELETE FROM asg_users_inqinfo
858: WHERE (device_user_name, tranid) NOT IN
859: (SELECT device_user_name, deferred_tran_id
860: FROM asg_deferred_traninfo);
861:
862: p_status := 'Fine';
863: p_message := 'Purging deferred transaction metadata completed successfully.';
864: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN