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_DOWNLOAD dependencies on ASG_PUB

Line 65: ' and pub_item in ( select item_id from asg_pub_item '||

61: ' from asg_system_dirty_queue '||
62: ' where download_flag=''Y'' and client_id=asg_base.get_user_name'||
63: ' and transaction_id = asg_base.get_current_tranid '||
64: ' and dml_type <> 0 '||
65: ' and pub_item in ( select item_id from asg_pub_item '||
66: ' where nvl(enable_download_events,''N'') = ''Y'' )'||
67: ' UNION ALL '||
68: ' select client_id,pub_item,access_id,dml_type, '||
69: ' transaction_id , asg_download.get_pk(pub_item,sdq.qid) pk_val, '||

Line 75: ' and pub_item in ( select item_id from asg_pub_item '||

71: ' from asg_system_dirty_queue sdq,asg_delete_queue dq '||
72: ' where download_flag=''Y'' and client_id=asg_base.get_user_name'||
73: ' and transaction_id = asg_base.get_current_tranid '||
74: ' and dml_type = 0 '||
75: ' and pub_item in ( select item_id from asg_pub_item '||
76: ' where nvl(enable_download_events,''N'') = ''Y'' ) '||
77: ' and sdq.qid=dq.qid ';
78: select count(*) into l_ct
79: from asg_system_dirty_queue

Line 84: ( select item_id from asg_pub_item

80: where download_flag='Y'
81: and client_id = asg_base.get_user_name
82: and transaction_id = asg_base.get_current_tranid
83: and pub_item in
84: ( select item_id from asg_pub_item
85: where nvl(enable_download_events,'N') = 'Y');
86:
87: if(l_ct <> 0 )
88: then

Line 129: ' and pub_item in ( select item_id from asg_pub_item '||

125: ' from asg_system_dirty_queue '||
126: ' where download_flag=''Y'' and client_id=asg_base.get_user_name'||
127: ' and transaction_id <= asg_base.get_last_tranid '||
128: ' and dml_type <> 0 '||
129: ' and pub_item in ( select item_id from asg_pub_item '||
130: ' where nvl(enable_download_events,''N'') = ''Y'' )'||
131: ' UNION ALL '||
132: ' select client_id,pub_item,access_id,dml_type, '||
133: ' transaction_id last_tran_id,asg_base.get_current_tranid '||

Line 140: ' and pub_item in ( select item_id from asg_pub_item '||

136: ' from asg_system_dirty_queue sdq,asg_delete_queue dq '||
137: ' where download_flag=''Y'' and client_id=asg_base.get_user_name'||
138: ' and transaction_id <= asg_base.get_last_tranid '||
139: ' and dml_type = 0 '||
140: ' and pub_item in ( select item_id from asg_pub_item '||
141: ' where nvl(enable_download_events,''N'') = ''Y'' )'||
142: ' and sdq.qid=dq.qid ';
143: select count(*) into l_ct
144: from asg_system_dirty_queue

Line 149: ( select item_id from asg_pub_item

145: where download_flag='Y'
146: and client_id = asg_base.get_user_name
147: and transaction_id <= asg_base.get_last_tranid
148: and pub_item in
149: ( select item_id from asg_pub_item
150: where nvl(enable_download_events,'N') = 'Y');
151:
152: if(l_ct <> 0)
153: then

Line 296: l_base_owner asg_pub_item.base_owner%TYPE;

292: l_pk_cnt NUMBER := 0;
293: l_att_col_list VARCHAR2(500);
294: l_rc BOOLEAN;
295: l_dml VARCHAR2(2000);
296: l_base_owner asg_pub_item.base_owner%TYPE;
297: l_base_object asg_pub_item.base_object_name%TYPE;
298: l_access_owner asg_pub_item.access_owner%TYPE;
299: l_access_name asg_pub_item.access_name%TYPE;
300: l_accessList dbms_sql.Number_table;

Line 297: l_base_object asg_pub_item.base_object_name%TYPE;

293: l_att_col_list VARCHAR2(500);
294: l_rc BOOLEAN;
295: l_dml VARCHAR2(2000);
296: l_base_owner asg_pub_item.base_owner%TYPE;
297: l_base_object asg_pub_item.base_object_name%TYPE;
298: l_access_owner asg_pub_item.access_owner%TYPE;
299: l_access_name asg_pub_item.access_name%TYPE;
300: l_accessList dbms_sql.Number_table;
301: l_qidList dbms_sql.Number_table;

Line 298: l_access_owner asg_pub_item.access_owner%TYPE;

294: l_rc BOOLEAN;
295: l_dml VARCHAR2(2000);
296: l_base_owner asg_pub_item.base_owner%TYPE;
297: l_base_object asg_pub_item.base_object_name%TYPE;
298: l_access_owner asg_pub_item.access_owner%TYPE;
299: l_access_name asg_pub_item.access_name%TYPE;
300: l_accessList dbms_sql.Number_table;
301: l_qidList dbms_sql.Number_table;
302: l_cur_id NUMBER;

Line 299: l_access_name asg_pub_item.access_name%TYPE;

295: l_dml VARCHAR2(2000);
296: l_base_owner asg_pub_item.base_owner%TYPE;
297: l_base_object asg_pub_item.base_object_name%TYPE;
298: l_access_owner asg_pub_item.access_owner%TYPE;
299: l_access_name asg_pub_item.access_name%TYPE;
300: l_accessList dbms_sql.Number_table;
301: l_qidList dbms_sql.Number_table;
302: l_cur_id NUMBER;
303: l_cur_rc NUMBER;

Line 327: ' FROM asg_pub_item WHERE name=:1';

323: END LOOP;
324:
325: -- Get the Base Table to Select From
326: l_dml := 'SELECT base_owner, base_object_name, access_owner, access_name '||
327: ' FROM asg_pub_item WHERE name=:1';
328: EXECUTE IMMEDIATE l_dml INTO l_base_owner, l_base_object, l_access_owner,
329: l_access_name USING p_pub_item;
330:
331: l_cur_id := DBMS_SQL.OPEN_CURSOR;

Line 428: l_inq_owner asg_pub_item.inq_owner%TYPE;

424: l_pk_cnt NUMBER := 0;
425: l_att_col_list VARCHAR2(500);
426: l_rc BOOLEAN;
427: l_dml VARCHAR2(4000);
428: l_inq_owner asg_pub_item.inq_owner%TYPE;
429: l_inq_name asg_pub_item.inq_name%TYPE;
430:
431: BEGIN
432:

Line 429: l_inq_name asg_pub_item.inq_name%TYPE;

425: l_att_col_list VARCHAR2(500);
426: l_rc BOOLEAN;
427: l_dml VARCHAR2(4000);
428: l_inq_owner asg_pub_item.inq_owner%TYPE;
429: l_inq_name asg_pub_item.inq_name%TYPE;
430:
431: BEGIN
432:
433: log ('Function storeDeletedPK - Reject Record');

Line 444: l_dml := 'SELECT inq_owner, inq_name FROM asg_pub_item '||

440: LOOP
441: l_att_col_list := l_att_col_list || ', attribute'||i;
442: END LOOP;
443:
444: l_dml := 'SELECT inq_owner, inq_name FROM asg_pub_item '||
445: ' WHERE name=:1';
446: EXECUTE IMMEDIATE l_dml INTO l_inq_owner, l_inq_name USING p_pub_item;
447:
448: IF (l_inq_owner IS NULL) THEN

Line 1078: || ' FROM ASG_PUB_ITEM WHERE name = :pi '

1074: BEGIN
1075:
1076: log('Function getPrimaryKeys ');
1077: EXECUTE IMMEDIATE 'SELECT primary_key_column, base_owner, base_object_name '
1078: || ' FROM ASG_PUB_ITEM WHERE name = :pi '
1079: INTO l_pk_list, l_base_owner, l_base_object_name
1080: USING upper(p_pub_item);
1081:
1082: x_pk_cnt := 0;

Line 1145: 'FROM ' || CONS_SCHEMA || '.c$pub_list_q a, asg_pub_item b ' ||

1141:
1142: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1143:
1144: l_dml := 'SELECT a.name, a.comp_ref, b.online_query ' ||
1145: 'FROM ' || CONS_SCHEMA || '.c$pub_list_q a, asg_pub_item b ' ||
1146: 'WHERE a.name = b.name ' ||
1147: 'ORDER by online_query desc, comp_ref desc';
1148:
1149: DBMS_SQL.PARSE (l_cursor_id, l_dml, DBMS_SQL.v7);

Line 1441: FROM asg_pub_item WHERE name=l_compref_list(i);

1437: NVL(QUERY_ACCESS_TABLE, 'N'), ACCESS_TABLE_PREDICATE_LIST,
1438: access_owner, access_name
1439: INTO l_base_owner, l_base_object, l_query_access, l_predicate_list,
1440: l_access_owner, l_access_name
1441: FROM asg_pub_item WHERE name=l_compref_list(i);
1442: /* The second condition actually implies an error in seed data but we
1443: tolerate it */
1444: IF ((l_query_access = 'N') OR
1445: (l_access_owner IS NULL OR l_access_name IS NULL)) THEN

Line 1493: 'WHERE name in (select name from asg_pub_item)';

1489: IF ( l_webtogo_list IS NULL ) THEN
1490:
1491: l_dml := 'DELETE FROM '||CONS_SCHEMA||'.c$pub_list_q ' ||
1492:
1493: 'WHERE name in (select name from asg_pub_item)';
1494:
1495: ELSE
1496:
1497: l_dml := 'DELETE FROM '||CONS_SCHEMA||'.c$pub_list_q '

Line 1501: ' name in (select name from asg_pub_item)';

1497: l_dml := 'DELETE FROM '||CONS_SCHEMA||'.c$pub_list_q '
1498:
1499: || ' WHERE name NOT IN (' || l_webtogo_list || ') AND ' ||
1500:
1501: ' name in (select name from asg_pub_item)';
1502:
1503: END IF;
1504: EXECUTE IMMEDIATE l_dml;
1505:

Line 1897: (select name from asg_pub where nvl(custom,'N') = 'N' )

1893: ( SELECT user_name,pub_name ,sysdate,1,sysdate,1
1894: FROM asg_user_pub_resps
1895: WHERE user_name = l_user_name
1896: AND pub_name IN
1897: (select name from asg_pub where nvl(custom,'N') = 'N' )
1898: );
1899: commit;
1900: log_concprogram('Done setting user '||l_user_name ||' to first synch '||
1901: l_user_name,'asg_download',

Line 1969: AND pub_name IN ( SELECT NAME FROM asg_pub WHERE nvl(custom,'N') = 'N' )

1965: SELECT user_name,pub_name
1966: FROM asg_user_pub_resps
1967: WHERE trunc( sysdate - NVL(synch_date,to_date('1', 'J')) )
1968: > l_dormancy_period
1969: AND pub_name IN ( SELECT NAME FROM asg_pub WHERE nvl(custom,'N') = 'N' )
1970: and user_name > l_last_processed
1971: and user_name <=l_last_user
1972: ORDER BY user_name;
1973:

Line 2211: (SELECT item_id FROM asg_pub_item

2207: ( SELECT qid
2208: FROM asg_system_dirty_queue
2209: WHERE client_id = l_dormant_rec.user_name
2210: AND pub_item in
2211: (SELECT item_id FROM asg_pub_item
2212: WHERE pub_name=l_dormant_rec.pub_name));
2213:
2214: log_concprogram('Done deleting DQ for '||l_tmp_user||' '||
2215: SQL%ROWCOUNT||' rows',

Line 2222: (SELECT item_id FROM asg_pub_item

2218:
2219: DELETE FROM asg_system_dirty_queue
2220: WHERE client_id = l_dormant_rec.user_name
2221: AND pub_item in
2222: (SELECT item_id FROM asg_pub_item
2223: WHERE pub_name=l_dormant_rec.pub_name);
2224: log_concprogram('Done deleting SDQ for '||l_tmp_user||' '||
2225: SQL%ROWCOUNT||' rows',
2226: 'asg_download',FND_LOG.LEVEL_STATEMENT);

Line 2231: (SELECT item_id FROM asg_pub_item

2227:
2228: DELETE FROM asg_complete_refresh
2229: WHERE user_name = l_dormant_rec.user_name
2230: AND publication_item IN
2231: (SELECT item_id FROM asg_pub_item
2232: WHERE pub_name = l_dormant_rec.pub_name);
2233:
2234: DELETE FROM asg_purge_sdq
2235: WHERE user_name = l_dormant_rec.user_name

Line 2289: SELECT pub_name FROM asg_pub_item WHERE item_id = p_pub_item;

2285: FUNCTION insert_sdq(p_pub_item varchar2,p_user_name varchar2) RETURN boolean
2286: IS
2287: CURSOR c_pub_name(l_pub_item varchar2)
2288: IS
2289: SELECT pub_name FROM asg_pub_item WHERE item_id = p_pub_item;
2290: CURSOR c_exists_compref(l_pi varchar2,l_un varchar2)
2291: IS
2292: SELECT user_name FROM asg_complete_refresh
2293: WHERE user_name = l_un AND publication_item = l_pi