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_APPLY dependencies on ASG_BASE

Line 185: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||

181: l_select_sync_sqlstring VARCHAR2(512);
182: BEGIN
183: l_select_sync_sqlstring :=
184: 'SELECT count(distinct clid$$cs) ' ||
185: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||
186: 'WHERE clid$$cs = :1 AND ' ||
187: 'tranid$$ NOT IN ' ||
188: '(SELECT tranid ' ||
189: ' FROM asg_users_inqinfo ' ||

Line 210: l_cinq_table := asg_base.G_OLITE_SCHEMA || '.c$inq ';

206: ' Start TranID: ' || p_start_tranid ||
207: ' End TranID: ' || p_end_tranid ||
208: ' Compact TranID: ' || p_compact_tranid);
209:
210: l_cinq_table := asg_base.G_OLITE_SCHEMA || '.c$inq ';
211: l_sql := 'UPDATE ' || l_cinq_table ||
212: 'SET tranid$$ = :1 ' ||
213: 'WHERE clid$$cs = :2 AND ' ||
214: ' tranid$$ >= :3 AND ' ||

Line 280: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||

276: counter2:= 1;
277: curr_pubitem_length := 0;
278: l_select_store_sqlstring :=
279: 'SELECT store ' ||
280: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||
281: 'WHERE clid$$cs = :1 AND ' ||
282: ' tranid$$ = :2 ' ||
283: ' ORDER BY store';
284:

Line 356: l_inq_table := asg_base.G_OLITE_SCHEMA || '.cfm$' || p_curr_pubitem || ' ' ;

352: l_sql VARCHAR2(1024);
353: l_pk_clause VARCHAR2(1024) := NULL;
354: l_sql_count NUMBER;
355: BEGIN
356: l_inq_table := asg_base.G_OLITE_SCHEMA || '.cfm$' || p_curr_pubitem || ' ' ;
357: log('compact_curr_inqtable: Compacting inq table for User: ' || p_user_name ||
358: ' Start TranID: ' || p_start_tranid ||
359: ' End TranID: ' || p_end_tranid ||
360: ' Compact TranID: ' || p_compact_tranid ||

Line 423: l_sql := 'DELETE FROM '||asg_base.G_OLITE_SCHEMA||'.c$inq a '||

419: log('compact_curr_inqtable: No of Records Deleted : ' || l_sql_count);
420:
421: IF (l_sql_count > 0) THEN
422: /*remove C_inq record if INQ table curr_tranid records are purged by above query */
423: l_sql := 'DELETE FROM '||asg_base.G_OLITE_SCHEMA||'.c$inq a '||
424: 'WHERE STORE= '||''''||p_curr_pubitem||''' '||
425: 'AND tranid$$=:1 '||
426: 'AND NOT EXISTS (SELECT 1 FROM '||l_inq_table||' b WHERE a.tranid$$=b.tranid$$)' ;
427:

Line 503: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||

499:
500: counter := 1;
501: l_select_store_sqlstring :=
502: 'SELECT store ' ||
503: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||
504: 'WHERE clid$$cs = :1 AND ' ||
505: ' tranid$$ = :2 ' ||
506: ' ORDER BY store';
507:

Line 545: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||

541: l_tranid NUMBER;
542: BEGIN
543: l_select_tranid_sqlstring :=
544: 'SELECT distinct tranid$$ ' ||
545: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||
546: 'WHERE clid$$cs = :user_name AND '||
547: 'tranid$$ NOT IN ' ||
548: '(SELECT tranid ' ||
549: ' FROM asg_users_inqinfo ' ||

Line 689: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||

685:
686: x_return_status := FND_API.G_RET_STS_SUCCESS;
687: l_select_store_sqlstring :=
688: 'SELECT store ' ||
689: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||
690: 'WHERE clid$$cs = :1 AND ' ||
691: ' tranid$$ = :2 '||
692: ' ORDER BY store';
693:

Line 723: ' FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||

719: 'WHERE device_user_name = :user_name AND ' ||
720: ' deferred_tran_id = :tranid AND ' ||
721: ' object_name not in ' ||
722: ' (SELECT store ' ||
723: ' FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||
724: ' WHERE clid$$cs = :user_name AND ' ||
725: ' tranid$$ = :tranid) ' ||
726: ' ORDER BY object_name';
727:

Line 774: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||

770:
771: x_return_status := FND_API.G_RET_STS_SUCCESS;
772: l_select_store_sqlstring :=
773: 'SELECT store ' ||
774: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||
775: 'WHERE clid$$cs = :1 AND ' ||
776: ' tranid$$ = :2 AND ' ||
777: ' store in ' ||
778: ' (SELECT name ' ||

Line 817: ' FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||

813: ' FROM asg_pub_item ' ||
814: ' WHERE pub_name = :pubname) AND ' ||
815: ' object_name not in ' ||
816: ' (SELECT store ' ||
817: ' FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||
818: ' WHERE clid$$cs = :user_name AND ' ||
819: ' tranid$$ = :tranid) ' ||
820: ' ORDER BY object_name';
821:

Line 867: 'FROM ' || asg_base.G_OLITE_SCHEMA ||'.c$inq '||

863:
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865: l_select_store_sqlstring :=
866: 'SELECT store ' ||
867: 'FROM ' || asg_base.G_OLITE_SCHEMA ||'.c$inq '||
868: 'WHERE clid$$cs = :1 AND ' ||
869: ' tranid$$ = :2 AND ' ||
870: ' store not in ' ||
871: ' (SELECT object_name ' ||

Line 1130: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||

1126: END IF;
1127:
1128: x_return_status := FND_API.G_RET_STS_SUCCESS;
1129: inq_tbl_name := 'CFM$' || p_pubitem;
1130: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||
1131: '.' || inq_tbl_name ||
1132: ' WHERE clid$$cs = :1 AND ' ||
1133: ' tranid$$ = :2 AND ' ||
1134: ' seqno$$ = :3';

Line 1194: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||

1190: FOR curr_index in 1..num_pubitems LOOP
1191: curr_pubitem := p_pubitems_tbl(curr_index);
1192: inq_tbl_name := 'CFM$' || curr_pubitem;
1193: -- Should change this statement to use bind-variables
1194: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||
1195: '.' || inq_tbl_name ||
1196: ' WHERE clid$$cs = :1 AND ' ||
1197: ' tranid$$ = :2 AND ' ||
1198: ' seqno$$ NOT IN ' ||

Line 1208: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||

1204: EXECUTE IMMEDIATE sql_string
1205: USING p_user_name, p_tranid,
1206: p_user_name, curr_pubitem;
1207:
1208: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||
1209: '.' || 'c$inq ' ||
1210: 'WHERE clid$$cs = :1 AND ' ||
1211: ' tranid$$ = :2 AND ' ||
1212: ' store = :3';

Line 1296: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.' || inq_tbl_name ||

1292: 'SYSDATE,' ||
1293: '1,' ||
1294: 'SYSDATE,'||
1295: '1 ' ||
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 ' ||

Line 1321: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||

1317: log('purge_pubitems: Exception executing the SQL Command ' ||
1318: SQLERRM,g_err_level);
1319: END;
1320:
1321: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||
1322: '.' || 'c$inq ' ||
1323: 'WHERE clid$$cs = :1 AND ' ||
1324: ' tranid$$ = :2 AND ' ||
1325: ' store = :3';

Line 1365: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||

1361:
1362: x_return_status := FND_API.G_RET_STS_SUCCESS;
1363: l_select_store_sqlstring :=
1364: 'SELECT store ' ||
1365: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||
1366: 'WHERE clid$$cs = :1 AND ' ||
1367: ' tranid$$ = :2 ' ||
1368: ' ORDER BY store';
1369:

Line 1544: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq';

1540:
1541: -- Get the list of users with dirty data
1542: l_select_users_sqlstring :=
1543: 'SELECT distinct clid$$cs clientid ' ||
1544: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq';
1545:
1546: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1547: DBMS_SQL.PARSE (l_cursor_id, l_select_users_sqlstring, DBMS_SQL.v7);
1548: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_user_name, 30);

Line 1630: 'FROM ' || asg_base.G_OLITE_SCHEMA ||

1626: WHERE user_name = p_user_name;
1627:
1628: l_select_seq_sqlstring :=
1629: 'SELECT a.name name, a.curr_val curr_val '||
1630: 'FROM ' || asg_base.G_OLITE_SCHEMA ||
1631: '.' || 'cfm$c$all_sequence_partitions a, ' ||
1632: asg_base.G_OLITE_SCHEMA || '.' || 'c$inq b ' ||
1633: 'WHERE b.clid$$cs = :user_name AND ' ||
1634: 'b.tranid$$ = :tranid AND ' ||

Line 1632: asg_base.G_OLITE_SCHEMA || '.' || 'c$inq b ' ||

1628: l_select_seq_sqlstring :=
1629: 'SELECT a.name name, a.curr_val curr_val '||
1630: 'FROM ' || asg_base.G_OLITE_SCHEMA ||
1631: '.' || 'cfm$c$all_sequence_partitions a, ' ||
1632: asg_base.G_OLITE_SCHEMA || '.' || 'c$inq b ' ||
1633: 'WHERE b.clid$$cs = :user_name AND ' ||
1634: 'b.tranid$$ = :tranid AND ' ||
1635: 'b.store = :seq_name AND ' ||
1636: 'a.clid$$cs = b.clid$$cs AND ' ||

Line 1681: l_delete_sqlstring := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||

1677: END IF;
1678:
1679: IF counter >1 THEN
1680: -- Updated sequences
1681: l_delete_sqlstring := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||
1682: '.' || 'c$inq ' ||
1683: 'WHERE CLID$$CS = :1 AND ' ||
1684: 'TRANID$$ = :2 AND ' ||
1685: 'STORE = :3';

Line 1690: asg_base.G_OLITE_SCHEMA ||

1686: EXECUTE IMMEDIATE l_delete_sqlstring
1687: USING p_user_name, p_tranid, l_sequence;
1688:
1689: l_delete_sqlstring := 'DELETE FROM ' ||
1690: asg_base.G_OLITE_SCHEMA ||
1691: '.' ||'cfm$c$all_sequence_partitions ' ||
1692: 'WHERE CLID$$CS = :1 AND ' ||
1693: ' TRANID$$ = :2';
1694: EXECUTE IMMEDIATE l_delete_sqlstring

Line 1733: 'DELETE from ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||

1729:
1730: -- Remove any custom pub items from c$inq
1731: -- Custom pub items are processed directly by custom implementor.
1732: l_delete_inq_sqlstring :=
1733: 'DELETE from ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||
1734: 'WHERE store in ' ||
1735: ' (SELECT api.name ' ||
1736: ' FROM asg_pub ap, asg_pub_item api ' ||
1737: ' WHERE ap.custom = ''Y'' AND ' ||

Line 1743: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||

1739: EXECUTE IMMEDIATE l_delete_inq_sqlstring;
1740:
1741: l_select_inqcnt_sqlstring :=
1742: 'SELECT count(*) ' ||
1743: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||
1744: 'WHERE clid$$cs = :1 AND ' ||
1745: ' tranid$$ = :2';
1746: EXECUTE IMMEDIATE l_select_inqcnt_sqlstring
1747: INTO l_inq_count

Line 1794: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||

1790: counter2:= 1;
1791: curr_pubitem_length := 0;
1792: l_select_store_sqlstring :=
1793: 'SELECT store ' ||
1794: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||
1795: 'WHERE clid$$cs = :1 AND ' ||
1796: ' tranid$$ = :2 ' ||
1797: ' ORDER BY store';
1798:

Line 1913: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||

1909: -- will mark this transaction as not to be processed further
1910: -- Users can later rectify/purge through the def txn UI.
1911: l_select_inqcnt_sqlstring :=
1912: 'SELECT count(*) ' ||
1913: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||
1914: 'WHERE clid$$cs = :1 AND ' ||
1915: ' tranid$$ = :2';
1916: EXECUTE IMMEDIATE l_select_inqcnt_sqlstring
1917: INTO l_inq_count

Line 1934: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$all_subscriptions a, ' ||

1930: END IF;
1931:
1932: l_select_pub_sqlstring :=
1933: 'SELECT template, wrapper_name ' ||
1934: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$all_subscriptions a, ' ||
1935: ' asg_pub b ' ||
1936: 'WHERE a.clientid = :user_name AND ' ||
1937: ' a.template = b.name';
1938: