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_BASE

Line 5: CONS_SCHEMA CONSTANT VARCHAR2(30) := ASG_BASE.G_OLITE_SCHEMA;

1: PACKAGE BODY asg_download AS
2: /* $Header: asgdwldb.pls 120.10.12020000.5 2013/04/09 11:56:11 saradhak ship $*/
3:
4: /** CONSTANTS */
5: CONS_SCHEMA CONSTANT VARCHAR2(30) := ASG_BASE.G_OLITE_SCHEMA;
6: OLITE_SEQUENCE CONSTANT VARCHAR2(30) := 'C$ALL_SEQUENCE_PARTITIONS';
7: LOG_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8:
9:

Line 62: ' where download_flag=''Y'' and client_id=asg_base.get_user_name'||

58: log('Start raise_data_downloaded');
59: l_qry := 'select client_id,pub_item,access_id,dml_type, '||
60: ' transaction_id,null pk_val,sysdate synch_time '||
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'' )'||

Line 63: ' and transaction_id = asg_base.get_current_tranid '||

59: l_qry := 'select client_id,pub_item,access_id,dml_type, '||
60: ' transaction_id,null pk_val,sysdate synch_time '||
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 '||

Line 72: ' where download_flag=''Y'' and client_id=asg_base.get_user_name'||

68: ' select client_id,pub_item,access_id,dml_type, '||
69: ' transaction_id , asg_download.get_pk(pub_item,sdq.qid) pk_val, '||
70: ' sysdate synch_time '||
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'' ) '||

Line 73: ' and transaction_id = asg_base.get_current_tranid '||

69: ' transaction_id , asg_download.get_pk(pub_item,sdq.qid) pk_val, '||
70: ' sysdate synch_time '||
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 ';

Line 81: and client_id = asg_base.get_user_name

77: ' and sdq.qid=dq.qid ';
78: select count(*) into l_ct
79: from asg_system_dirty_queue
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');

Line 82: and transaction_id = asg_base.get_current_tranid

78: select count(*) into l_ct
79: from asg_system_dirty_queue
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:

Line 123: ' transaction_id last_tran_id,asg_base.get_current_tranid '||

119: l_ct number;
120: begin
121: log('Start raise_data_download_confirmed');
122: l_qry := 'select client_id,pub_item,access_id,dml_type, '||
123: ' transaction_id last_tran_id,asg_base.get_current_tranid '||
124: ' curr_tran_id ,null pk_val,sysdate synch_time '||
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 '||

Line 126: ' where download_flag=''Y'' and client_id=asg_base.get_user_name'||

122: l_qry := 'select client_id,pub_item,access_id,dml_type, '||
123: ' transaction_id last_tran_id,asg_base.get_current_tranid '||
124: ' curr_tran_id ,null pk_val,sysdate synch_time '||
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'' )'||

Line 127: ' and transaction_id <= asg_base.get_last_tranid '||

123: ' transaction_id last_tran_id,asg_base.get_current_tranid '||
124: ' curr_tran_id ,null pk_val,sysdate synch_time '||
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 '||

Line 133: ' transaction_id last_tran_id,asg_base.get_current_tranid '||

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 '||
134: ' curr_tran_id, asg_download.get_pk(pub_item,sdq.qid) pk_val, '||
135: ' sysdate synch_time '||
136: ' from asg_system_dirty_queue sdq,asg_delete_queue dq '||
137: ' where download_flag=''Y'' and client_id=asg_base.get_user_name'||

Line 137: ' where download_flag=''Y'' and client_id=asg_base.get_user_name'||

133: ' transaction_id last_tran_id,asg_base.get_current_tranid '||
134: ' curr_tran_id, asg_download.get_pk(pub_item,sdq.qid) pk_val, '||
135: ' sysdate synch_time '||
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'' )'||

Line 138: ' and transaction_id <= asg_base.get_last_tranid '||

134: ' curr_tran_id, asg_download.get_pk(pub_item,sdq.qid) pk_val, '||
135: ' sysdate synch_time '||
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 ';

Line 146: and client_id = asg_base.get_user_name

142: ' and sdq.qid=dq.qid ';
143: select count(*) into l_ct
144: from asg_system_dirty_queue
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');

Line 147: and transaction_id <= asg_base.get_last_tranid

143: select count(*) into l_ct
144: from asg_system_dirty_queue
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:

Line 229: l_predicate_clause := ' resource_id = asg_base.get_resource_id() ';

225: /* We support three predicate clauses
226: -- resource_id, user_id, language */
227: l_predicate_list := upper(p_predicate_list);
228: IF (instr(l_predicate_list, 'RESOURCE_ID') <> 0) THEN
229: l_predicate_clause := ' resource_id = asg_base.get_resource_id() ';
230: END IF;
231: IF (instr(l_predicate_list, 'USER_ID') <> 0) THEN
232: IF(l_predicate_clause IS NOT NULL) THEN
233: l_predicate_clause := l_predicate_clause || ' AND ' ||

Line 234: ' user_id = asg_base.get_user_id() ';

230: END IF;
231: IF (instr(l_predicate_list, 'USER_ID') <> 0) THEN
232: IF(l_predicate_clause IS NOT NULL) THEN
233: l_predicate_clause := l_predicate_clause || ' AND ' ||
234: ' user_id = asg_base.get_user_id() ';
235: ELSE
236: l_predicate_clause := ' user_id = asg_base.get_user_id() ';
237: END IF;
238: END IF;

Line 236: l_predicate_clause := ' user_id = asg_base.get_user_id() ';

232: IF(l_predicate_clause IS NOT NULL) THEN
233: l_predicate_clause := l_predicate_clause || ' AND ' ||
234: ' user_id = asg_base.get_user_id() ';
235: ELSE
236: l_predicate_clause := ' user_id = asg_base.get_user_id() ';
237: END IF;
238: END IF;
239: IF (instr(l_predicate_list, 'LANGUAGE') <> 0) THEN
240: IF(l_predicate_clause IS NOT NULL) THEN

Line 242: ' language = asg_base.get_language() ';

238: END IF;
239: IF (instr(l_predicate_list, 'LANGUAGE') <> 0) THEN
240: IF(l_predicate_clause IS NOT NULL) THEN
241: l_predicate_clause := l_predicate_clause || ' AND ' ||
242: ' language = asg_base.get_language() ';
243: ELSE
244: l_predicate_clause := ' language = asg_base.get_language() ';
245: END IF;
246: END IF;

Line 244: l_predicate_clause := ' language = asg_base.get_language() ';

240: IF(l_predicate_clause IS NOT NULL) THEN
241: l_predicate_clause := l_predicate_clause || ' AND ' ||
242: ' language = asg_base.get_language() ';
243: ELSE
244: l_predicate_clause := ' language = asg_base.get_language() ';
245: END IF;
246: END IF;
247:
248: return l_predicate_clause;

Line 533: --l_mobile_user := asg_base.get_user_name; ---modify this logic

529: l_qidlist qid_list;
530: l_qid NUMBER;
531: BEGIN
532: log ('Function mark_dirty_internal - Reject Record ');
533: --l_mobile_user := asg_base.get_user_name; ---modify this logic
534: --select user_name into l_mobile_user from asg_user where user_id=p_userid;
535: -- Mark Publication Item Dirty
536: IF (insert_sdq(p_pub_item,p_username) AND
537: is_exists(p_username,p_pub_item,p_accessid,p_dml))

Line 579: l_mobile_user := asg_base.get_user_name(p_resourceid);

575: l_mobile_user VARCHAR2(100);
576: l_retval BOOLEAN;
577: BEGIN
578: log ('Function markDirty - single row ');
579: l_mobile_user := asg_base.get_user_name(p_resourceid);
580: if(l_mobile_user is null) then
581: log('Invalid mobile user with resource ID : '||p_resourceid||' ');
582: return FAIL;
583: end if;

Line 650: l_mobile_user := asg_base.get_user_name(p_resourceid);

646: l_mobile_user VARCHAR2(100);
647: l_retval BOOLEAN;
648: BEGIN
649: log ('Function markDirty - single row with PK Values given');
650: l_mobile_user := asg_base.get_user_name(p_resourceid);
651: if(l_mobile_user is null) then
652: log('Invalid mobile user with resource ID : '||p_resourceid||' ');
653: return FAIL;
654: end if;

Line 774: l_user_name := asg_base.get_user_name(p_resourceList(i));

770: END IF;
771:
772: FOR i in 1..p_resourceList.count
773: LOOP
774: l_user_name := asg_base.get_user_name(p_resourceList(i));
775: if(l_user_name is null) then
776: if(l_flag = 0 ) then
777: l_invalid_reslist := ''''||p_resourceList(i)||'''';
778: l_flag := 1;

Line 894: l_user_name := asg_base.get_user_name(p_resourceList(i));

890: RAISE PARAMETER_COUNT_MISMATCH;
891: END IF;
892: FOR i in 1..p_resourceList.count
893: LOOP
894: l_user_name := asg_base.get_user_name(p_resourceList(i));
895: if(l_user_name is null) then
896: if(l_flag = 0 ) then
897: l_invalid_reslist := ''''||p_resourceList(i)||'''';
898: l_flag := 1;

Line 948: -- l_mobile_user := asg_base.get_user_name(p_resourceList(i));

944: THEN
945: log ('Function mark dirty internal - Accessid-Resourceid - Many-Many ');
946: FOR i IN 1..p_username_list.COUNT
947: LOOP
948: -- l_mobile_user := asg_base.get_user_name(p_resourceList(i));
949: l_mobile_user:=p_username_list(i);
950: l_ctr := 1;
951: l_tmp_access_list := l_empty_access_list;
952: l_qid_list := l_empty_qid_list;

Line 1025: l_user_name := asg_base.get_user_name(p_resourceList(i));

1021: l_ctr := 1;
1022: l_flag := 0;
1023: FOR i in 1..p_resourceList.count
1024: LOOP
1025: l_user_name := asg_base.get_user_name(p_resourceList(i));
1026: if(l_user_name is null) then
1027: if(l_flag = 0 ) then
1028: l_invalid_reslist := ''''||p_resourceList(i)||'''';
1029: l_flag := 1;

Line 1610: -- to be replaced with asg_base.get_user_name(user_id)

1606: END log;
1607:
1608:
1609:
1610: -- to be replaced with asg_base.get_user_name(user_id)
1611: FUNCTION get_username_from_userid ( p_userid IN NUMBER )
1612: RETURN VARCHAR2 IS
1613: CURSOR C_USER_NAME(p_userid NUMBER) IS
1614: SELECT user_name