APPS.ASG_APPLY dependencies on ASG_DEFER

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

111: begin
112: log('Begin raise_row_deferred',g_stmt_level);
113: l_qry := 'select DEVICE_USER_NAME user_name,DEFERRED_TRAN_ID tran_id ,'
114: ||'ERROR_DESCRIPTION ,OBJECT_NAME pub_item,SEQUENCE '
115: ||'from asg_deferred_traninfo where CREATION_DATE >= to_date('''
116: ||to_char(p_start_time,'mm-dd-yyyy hh24:mi:ss')
117: ||''',''mm-dd-yyyy hh24:mi:ss'') ';
118: log('Query :'||l_qry,g_stmt_level);
119: l_ctx := dbms_xmlquery.newContext(l_qry);

Line 724: 'FROM asg_deferred_traninfo ' ||

720: END IF;
721:
722: l_select_obj_sqlstring :=
723: 'SELECT object_name ' ||
724: 'FROM asg_deferred_traninfo ' ||
725: 'WHERE device_user_name = :user_name AND ' ||
726: ' deferred_tran_id = :tranid AND ' ||
727: ' object_name not in ' ||
728: ' (SELECT store ' ||

Line 814: 'FROM asg_deferred_traninfo ' ||

810: END IF;
811:
812: l_select_obj_sqlstring :=
813: 'SELECT object_name ' ||
814: 'FROM asg_deferred_traninfo ' ||
815: 'WHERE device_user_name = :user_name AND ' ||
816: ' deferred_tran_id = :tranid AND ' ||
817: ' object_name IN ' ||
818: ' (SELECT name ' ||

Line 878: ' FROM asg_deferred_traninfo ' ||

874: 'WHERE clid$$cs = :1 AND ' ||
875: ' tranid$$ = :2 AND ' ||
876: ' store not in ' ||
877: ' (SELECT object_name ' ||
878: ' FROM asg_deferred_traninfo ' ||
879: ' WHERE device_user_name = :3 AND ' ||
880: ' deferred_tran_id = :4) AND ' ||
881: ' store in ' ||
882: ' (SELECT name ' ||

Line 1159: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,

1155: x_return_status := FND_API.G_RET_STS_ERROR;
1156: log('delete_row: Exception: ', g_err_level);
1157: END;
1158:
1159: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,
1160: p_pubitem, p_sequence);
1161: -- Update status to processed or passed
1162: IF l_deferred_row = FND_API.G_TRUE THEN
1163: BEGIN

Line 1164: UPDATE asg_deferred_traninfo

1160: p_pubitem, p_sequence);
1161: -- Update status to processed or passed
1162: IF l_deferred_row = FND_API.G_TRUE THEN
1163: BEGIN
1164: UPDATE asg_deferred_traninfo
1165: SET status = 0
1166: WHERE device_user_name = p_user_name AND
1167: deferred_tran_id = p_tranid AND
1168: object_name = p_pubitem AND

Line 1212: ' FROM asg_deferred_traninfo ' ||

1208: ' WHERE clid$$cs = :1 AND ' ||
1209: ' tranid$$ = :2 AND ' ||
1210: ' seqno$$ NOT IN ' ||
1211: ' (SELECT sequence ' ||
1212: ' FROM asg_deferred_traninfo ' ||
1213: ' WHERE device_user_name = :3 AND '||
1214: ' object_name = :4)';
1215: print_string('purge_pubitems_internal: SQL Command: ' || sql_string);
1216: EXECUTE IMMEDIATE sql_string

Line 1281: sql_string := 'INSERT INTO asg_deferred_traninfo ('||

1277: CLOSE c_resource_id;
1278:
1279: -- Defer those records that were not already deferred or deleted during
1280: -- processing by wrapper
1281: sql_string := 'INSERT INTO asg_deferred_traninfo ('||
1282: 'DEVICE_USER_NAME, ' ||
1283: 'RESOURCE_ID, ' ||
1284: 'DEFERRED_TRAN_ID, ' ||
1285: 'MOBILE_ERROR_ID, ' ||

Line 1312: 'FROM asg_deferred_traninfo ' ||

1308: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.' || inq_tbl_name ||
1309: ' b WHERE b.clid$$cs = :5 AND ' ||
1310: ' tranid$$ = :6 AND ' ||
1311: ' b.seqno$$ not in (SELECT sequence ' ||
1312: 'FROM asg_deferred_traninfo ' ||
1313: 'WHERE device_user_name = :7 AND ' ||
1314: ' deferred_tran_id = :8 '||
1315: ' AND object_name = :9)';
1316: --print_string('purge_pubitems: SQL Command: ' || sql_string);

Line 1412: FROM asg_deferred_traninfo

1408: WHERE device_user_name = p_user_name AND
1409: tranid = p_tranid AND
1410: tranid not IN
1411: (SELECT distinct deferred_tran_id
1412: FROM asg_deferred_traninfo
1413: WHERE device_user_name = p_user_name AND
1414: deferred_tran_id = p_tranid);
1415:
1416: END purge_pubitems;

Line 1548: FROM asg_deferred_traninfo;

1544: sql_string VARCHAR2(30);
1545: l_def_count PLS_INTEGER;
1546: CURSOR c_deferred IS
1547: SELECT count(*) def_trans
1548: FROM asg_deferred_traninfo;
1549: BEGIN
1550:
1551: x_begin_apply := FND_API.G_TRUE;
1552: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2367: from asg_deferred_traninfo

2363: select nvl(fnd_profile.value_specific('ASG_ENABLE_UPLOAD_EVENTS'),'N')
2364: into l_prof_value from dual;
2365: /*Check if any rows were deferred in the current run*/
2366: select count(*) into l_row_count
2367: from asg_deferred_traninfo
2368: where creation_date >= g_conc_start_time;
2369: if(l_prof_value = 'Y')
2370: then
2371: if(l_row_count > 0 )