APPS.ASG_APPLY dependencies on ASG_DEFER

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

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

Line 718: 'FROM asg_deferred_traninfo ' ||

714: END IF;
715:
716: l_select_obj_sqlstring :=
717: 'SELECT object_name ' ||
718: 'FROM asg_deferred_traninfo ' ||
719: 'WHERE device_user_name = :user_name AND ' ||
720: ' deferred_tran_id = :tranid AND ' ||
721: ' object_name not in ' ||
722: ' (SELECT store ' ||

Line 808: 'FROM asg_deferred_traninfo ' ||

804: END IF;
805:
806: l_select_obj_sqlstring :=
807: 'SELECT object_name ' ||
808: 'FROM asg_deferred_traninfo ' ||
809: 'WHERE device_user_name = :user_name AND ' ||
810: ' deferred_tran_id = :tranid AND ' ||
811: ' object_name IN ' ||
812: ' (SELECT name ' ||

Line 872: ' FROM asg_deferred_traninfo ' ||

868: 'WHERE clid$$cs = :1 AND ' ||
869: ' tranid$$ = :2 AND ' ||
870: ' store not in ' ||
871: ' (SELECT object_name ' ||
872: ' FROM asg_deferred_traninfo ' ||
873: ' WHERE device_user_name = :3 AND ' ||
874: ' deferred_tran_id = :4) AND ' ||
875: ' store in ' ||
876: ' (SELECT name ' ||

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

1143: x_return_status := FND_API.G_RET_STS_ERROR;
1144: log('delete_row: Exception: ', g_err_level);
1145: END;
1146:
1147: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,
1148: p_pubitem, p_sequence);
1149: -- Update status to processed or passed
1150: IF l_deferred_row = FND_API.G_TRUE THEN
1151: BEGIN

Line 1152: UPDATE asg_deferred_traninfo

1148: p_pubitem, p_sequence);
1149: -- Update status to processed or passed
1150: IF l_deferred_row = FND_API.G_TRUE THEN
1151: BEGIN
1152: UPDATE asg_deferred_traninfo
1153: SET status = 0
1154: WHERE device_user_name = p_user_name AND
1155: deferred_tran_id = p_tranid AND
1156: object_name = p_pubitem AND

Line 1200: ' FROM asg_deferred_traninfo ' ||

1196: ' WHERE clid$$cs = :1 AND ' ||
1197: ' tranid$$ = :2 AND ' ||
1198: ' seqno$$ NOT IN ' ||
1199: ' (SELECT sequence ' ||
1200: ' FROM asg_deferred_traninfo ' ||
1201: ' WHERE device_user_name = :3 AND '||
1202: ' object_name = :4)';
1203: print_string('purge_pubitems_internal: SQL Command: ' || sql_string);
1204: EXECUTE IMMEDIATE sql_string

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

1265: CLOSE c_resource_id;
1266:
1267: -- Defer those records that were not already deferred or deleted during
1268: -- processing by wrapper
1269: sql_string := 'INSERT INTO asg_deferred_traninfo ('||
1270: 'DEVICE_USER_NAME, ' ||
1271: 'RESOURCE_ID, ' ||
1272: 'DEFERRED_TRAN_ID, ' ||
1273: 'MOBILE_ERROR_ID, ' ||

Line 1300: 'FROM asg_deferred_traninfo ' ||

1296: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.' || inq_tbl_name ||
1297: ' b WHERE b.clid$$cs = :5 AND ' ||
1298: ' tranid$$ = :6 AND ' ||
1299: ' b.seqno$$ not in (SELECT sequence ' ||
1300: 'FROM asg_deferred_traninfo ' ||
1301: 'WHERE device_user_name = :7 AND ' ||
1302: ' deferred_tran_id = :8 '||
1303: ' AND object_name = :9)';
1304: --print_string('purge_pubitems: SQL Command: ' || sql_string);

Line 1399: FROM asg_deferred_traninfo

1395: WHERE device_user_name = p_user_name AND
1396: tranid = p_tranid AND
1397: tranid not IN
1398: (SELECT distinct deferred_tran_id
1399: FROM asg_deferred_traninfo
1400: WHERE device_user_name = p_user_name AND
1401: deferred_tran_id = p_tranid);
1402:
1403: END purge_pubitems;

Line 1535: FROM asg_deferred_traninfo;

1531: sql_string VARCHAR2(30);
1532: l_def_count PLS_INTEGER;
1533: CURSOR c_deferred IS
1534: SELECT count(*) def_trans
1535: FROM asg_deferred_traninfo;
1536: BEGIN
1537:
1538: x_begin_apply := FND_API.G_TRUE;
1539: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2135: from asg_deferred_traninfo

2131: select nvl(fnd_profile.value_specific('ASG_ENABLE_UPLOAD_EVENTS'),'N')
2132: into l_prof_value from dual;
2133: /*Check if any rows were deferred in the current run*/
2134: select count(*) into l_row_count
2135: from asg_deferred_traninfo
2136: where creation_date >= g_conc_start_time;
2137: if(l_prof_value = 'Y')
2138: then
2139: if(l_row_count > 0 )