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.AMS_LISTGENERATION_PKG dependencies on FND_GLOBAL

Line 98: ,FND_GLOBAL.User_Id

94: )
95: VALUES (
96: ams_act_logs_s.NEXTVAL
97: ,g_date(i)
98: ,FND_GLOBAL.User_Id
99: ,g_date(i)
100: ,FND_GLOBAL.User_Id
101: ,FND_GLOBAL.Conc_Login_Id
102: ,1

Line 100: ,FND_GLOBAL.User_Id

96: ams_act_logs_s.NEXTVAL
97: ,g_date(i)
98: ,FND_GLOBAL.User_Id
99: ,g_date(i)
100: ,FND_GLOBAL.User_Id
101: ,FND_GLOBAL.Conc_Login_Id
102: ,1
103: ,g_list_header_id
104: ,'LIST'

Line 101: ,FND_GLOBAL.Conc_Login_Id

97: ,g_date(i)
98: ,FND_GLOBAL.User_Id
99: ,g_date(i)
100: ,FND_GLOBAL.User_Id
101: ,FND_GLOBAL.Conc_Login_Id
102: ,1
103: ,g_list_header_id
104: ,'LIST'
105: ,ams_act_logs_transaction_id_s.NEXTVAL

Line 207: ,FND_GLOBAL.User_Id

203: )
204: VALUES (
205: ams_act_logs_s.NEXTVAL
206: ,sysdate
207: ,FND_GLOBAL.User_Id
208: ,sysdate
209: ,FND_GLOBAL.User_Id
210: ,FND_GLOBAL.Conc_Login_Id
211: ,1

Line 209: ,FND_GLOBAL.User_Id

205: ams_act_logs_s.NEXTVAL
206: ,sysdate
207: ,FND_GLOBAL.User_Id
208: ,sysdate
209: ,FND_GLOBAL.User_Id
210: ,FND_GLOBAL.Conc_Login_Id
211: ,1
212: ,nvl(p_log_used_by_id,g_list_header_id)
213: ,'LIST'

Line 210: ,FND_GLOBAL.Conc_Login_Id

206: ,sysdate
207: ,FND_GLOBAL.User_Id
208: ,sysdate
209: ,FND_GLOBAL.User_Id
210: ,FND_GLOBAL.Conc_Login_Id
211: ,1
212: ,nvl(p_log_used_by_id,g_list_header_id)
213: ,'LIST'
214: ,ams_act_logs_transaction_id_s.NEXTVAL

Line 1222: FND_GLOBAL.USER_ID,

1218: )
1219: select
1220: AMS_LIST_SRC_TYPE_USAGES_S.NEXTVAL,
1221: SYSDATE,
1222: FND_GLOBAL.USER_ID,
1223: SYSDATE,
1224: FND_GLOBAL.USER_ID,
1225: FND_GLOBAL.USER_ID,
1226: 1,

Line 1224: FND_GLOBAL.USER_ID,

1220: AMS_LIST_SRC_TYPE_USAGES_S.NEXTVAL,
1221: SYSDATE,
1222: FND_GLOBAL.USER_ID,
1223: SYSDATE,
1224: FND_GLOBAL.USER_ID,
1225: FND_GLOBAL.USER_ID,
1226: 1,
1227: p_source_type_code,
1228: p_list_header_id

Line 1225: FND_GLOBAL.USER_ID,

1221: SYSDATE,
1222: FND_GLOBAL.USER_ID,
1223: SYSDATE,
1224: FND_GLOBAL.USER_ID,
1225: FND_GLOBAL.USER_ID,
1226: 1,
1227: p_source_type_code,
1228: p_list_header_id
1229: from dual

Line 1404: FND_GLOBAL.USER_ID,

1400: ''''||'N' ||''''|| ','||
1401: ''''||'Y' ||''''||',
1402: '||p_action_used_by_id || ',
1403: sysdate,
1404: FND_GLOBAL.USER_ID,
1405: sysdate,
1406: '||nvl(l_created_by,FND_GLOBAL.USER_ID)||',
1407: FND_GLOBAL.USER_ID,
1408: nvl(party_id,import_source_line_id), ' ||

Line 1406: '||nvl(l_created_by,FND_GLOBAL.USER_ID)||',

1402: '||p_action_used_by_id || ',
1403: sysdate,
1404: FND_GLOBAL.USER_ID,
1405: sysdate,
1406: '||nvl(l_created_by,FND_GLOBAL.USER_ID)||',
1407: FND_GLOBAL.USER_ID,
1408: nvl(party_id,import_source_line_id), ' ||
1409: ''''|| l_list_entry_source_type||''''|| ' , '||
1410: p_list_select_action_id || ' ,'||

Line 1407: FND_GLOBAL.USER_ID,

1403: sysdate,
1404: FND_GLOBAL.USER_ID,
1405: sysdate,
1406: '||nvl(l_created_by,FND_GLOBAL.USER_ID)||',
1407: FND_GLOBAL.USER_ID,
1408: nvl(party_id,import_source_line_id), ' ||
1409: ''''|| l_list_entry_source_type||''''|| ' , '||
1410: p_list_select_action_id || ' ,'||
1411: p_rank ||',

Line 1596: FND_GLOBAL.USER_ID,

1592: ''''||'N' ||''''|| ','||
1593: ''''||'Y' ||''''||',
1594: '||p_action_used_by_id || ',
1595: sysdate,
1596: FND_GLOBAL.USER_ID,
1597: sysdate,
1598: '||nvl(l_created_by,FND_GLOBAL.USER_ID)||',
1599: FND_GLOBAL.USER_ID,
1600: 1,

Line 1598: '||nvl(l_created_by,FND_GLOBAL.USER_ID)||',

1594: '||p_action_used_by_id || ',
1595: sysdate,
1596: FND_GLOBAL.USER_ID,
1597: sysdate,
1598: '||nvl(l_created_by,FND_GLOBAL.USER_ID)||',
1599: FND_GLOBAL.USER_ID,
1600: 1,
1601: nvl(party_id,import_source_line_id), ' ||
1602: ''''|| l_list_entry_source_type||''''|| ' , '||

Line 1599: FND_GLOBAL.USER_ID,

1595: sysdate,
1596: FND_GLOBAL.USER_ID,
1597: sysdate,
1598: '||nvl(l_created_by,FND_GLOBAL.USER_ID)||',
1599: FND_GLOBAL.USER_ID,
1600: 1,
1601: nvl(party_id,import_source_line_id), ' ||
1602: ''''|| l_list_entry_source_type||''''|| ' , '||
1603: p_list_select_action_id || ' ,'||

Line 2494: FND_GLOBAL.USER_ID,

2490: )
2491: select
2492: AMS_LIST_SRC_TYPE_USAGES_S.NEXTVAL,
2493: SYSDATE,
2494: FND_GLOBAL.USER_ID,
2495: SYSDATE,
2496: FND_GLOBAL.USER_ID,
2497: FND_GLOBAL.USER_ID,
2498: 1,

Line 2496: FND_GLOBAL.USER_ID,

2492: AMS_LIST_SRC_TYPE_USAGES_S.NEXTVAL,
2493: SYSDATE,
2494: FND_GLOBAL.USER_ID,
2495: SYSDATE,
2496: FND_GLOBAL.USER_ID,
2497: FND_GLOBAL.USER_ID,
2498: 1,
2499: als.source_type_code,
2500: p_action_used_by_id

Line 2497: FND_GLOBAL.USER_ID,

2493: SYSDATE,
2494: FND_GLOBAL.USER_ID,
2495: SYSDATE,
2496: FND_GLOBAL.USER_ID,
2497: FND_GLOBAL.USER_ID,
2498: 1,
2499: als.source_type_code,
2500: p_action_used_by_id
2501: from ams_list_src_type_usages als

Line 2594: elsif p_input_string = fnd_global.newline then

2590: ,p_valid_string OUT NOCOPY varchar2) IS
2591: BEGIN
2592: if p_input_string = ' ' then
2593: p_valid_string :='Y';
2594: elsif p_input_string = fnd_global.newline then
2595: p_valid_string :='Y';
2596: elsif p_input_string = fnd_global.tab then
2597: p_valid_string :='Y';
2598: elsif p_input_string = '

Line 2596: elsif p_input_string = fnd_global.tab then

2592: if p_input_string = ' ' then
2593: p_valid_string :='Y';
2594: elsif p_input_string = fnd_global.newline then
2595: p_valid_string :='Y';
2596: elsif p_input_string = fnd_global.tab then
2597: p_valid_string :='Y';
2598: elsif p_input_string = '
2599: ' then
2600: p_valid_string :='Y';

Line 2777: to_char(FND_GLOBAL.login_id )|| ',' ||''''||

2773: p_list_select_action_id || ',' ||
2774: p_rank || ',' ||
2775: to_char(p_action_used_by_id )|| ',' ||''''||
2776: to_char(sysdate )|| ''''||','||
2777: to_char(FND_GLOBAL.login_id )|| ',' ||''''||
2778: to_char(sysdate )|| ''''||','||
2779: to_char(nvl(l_created_by, FND_GLOBAL.login_id) )|| ',' ||
2780: 'ams_list_entries_s.nextval' || ','||
2781: 1 || ','||

Line 2779: to_char(nvl(l_created_by, FND_GLOBAL.login_id) )|| ',' ||

2775: to_char(p_action_used_by_id )|| ',' ||''''||
2776: to_char(sysdate )|| ''''||','||
2777: to_char(FND_GLOBAL.login_id )|| ',' ||''''||
2778: to_char(sysdate )|| ''''||','||
2779: to_char(nvl(l_created_by, FND_GLOBAL.login_id) )|| ',' ||
2780: 'ams_list_entries_s.nextval' || ','||
2781: 1 || ','||
2782: ''''||'NONE' ||'''' || ','||
2783: 0 || ',' ||

Line 2854: to_char(FND_GLOBAL.login_id )|| ',' ||''''||

2850: p_select_add_statement || ' ,' ||
2851: p_list_select_action_id || ',' ||
2852: to_char(p_action_used_by_id )|| ',' ||''''||
2853: to_char(sysdate )|| ''''||','||
2854: to_char(FND_GLOBAL.login_id )|| ',' ||''''||
2855: to_char(sysdate )|| ''''||','||
2856: to_char(FND_GLOBAL.login_id )|| ',' ||
2857: to_char( nvl(p_rank,9999999));
2858: --write_to_act_log(l_insert_sql);

Line 2856: to_char(FND_GLOBAL.login_id )|| ',' ||

2852: to_char(p_action_used_by_id )|| ',' ||''''||
2853: to_char(sysdate )|| ''''||','||
2854: to_char(FND_GLOBAL.login_id )|| ',' ||''''||
2855: to_char(sysdate )|| ''''||','||
2856: to_char(FND_GLOBAL.login_id )|| ',' ||
2857: to_char( nvl(p_rank,9999999));
2858: --write_to_act_log(l_insert_sql);
2859: */
2860: l_insert_sql := p_select_statement ;

Line 4682: fnd_global.user_id,

4678: object_version_number
4679: )
4680: ( select ams_list_entries_s.nextval,
4681: sysdate,
4682: fnd_global.user_id,
4683: sysdate,
4684: nvl(l_created_by, fnd_global.user_id),
4685: fnd_global.conc_login_id,
4686: p_list_header_id,

Line 4684: nvl(l_created_by, fnd_global.user_id),

4680: ( select ams_list_entries_s.nextval,
4681: sysdate,
4682: fnd_global.user_id,
4683: sysdate,
4684: nvl(l_created_by, fnd_global.user_id),
4685: fnd_global.conc_login_id,
4686: p_list_header_id,
4687: s.list_select_action_id,
4688: s.arc_incl_object_from,

Line 4685: fnd_global.conc_login_id,

4681: sysdate,
4682: fnd_global.user_id,
4683: sysdate,
4684: nvl(l_created_by, fnd_global.user_id),
4685: fnd_global.conc_login_id,
4686: p_list_header_id,
4687: s.list_select_action_id,
4688: s.arc_incl_object_from,
4689: s.incl_object_name,

Line 4696: fnd_global.conc_login_id,

4692: h.list_used_by_id,
4693: ams_list_entries_s.currval,
4694: t.list_entry_source_id,
4695: t.list_entry_source_type,
4696: fnd_global.conc_login_id,
4697: 'N',
4698: 'N',
4699: 'N',
4700: 'N',

Line 6999: l_request_id := nvl(FND_GLOBAL.conc_request_id, -1);

6995: -- This eliminates the need for passing variables across procedures
6996: -- Particularly for logging debug messages ams_act_logs
6997: -----------------------------------------------------------------------------
6998:
6999: l_request_id := nvl(FND_GLOBAL.conc_request_id, -1);
7000:
7001: g_remote_list := 'N';
7002: g_remote_list_gen := 'N';
7003: g_database_link := ' ';

Line 9618: --write_to_act_log(p_msg_data => 'Concurrent request id is '||fnd_global.conc_request_id,p_arc_log_used_by => 'LIST',p_log_used_by_id => p_list_header_id,p_level => 'HIGH');

9614: p_arc_log_used_by => 'LIST',
9615: p_log_used_by_id => p_list_header_id,
9616: p_level => 'HIGH');
9617:
9618: --write_to_act_log(p_msg_data => 'Concurrent request id is '||fnd_global.conc_request_id,p_arc_log_used_by => 'LIST',p_log_used_by_id => p_list_header_id,p_level => 'HIGH');
9619:
9620: write_to_act_log(p_msg_data => 'Work flow item key(list header id) is '||p_list_header_id||' Process type is AMS List Generation',p_arc_log_used_by => 'LIST',p_log_used_by_id => p_list_header_id,p_level => 'HIGH');
9621:
9622: -- SOLIN, bug 4410333

Line 10698: SET last_deduped_by_user_id = FND_GLOBAL.User_Id

10694:
10695: --recording who performed the deduplication and at what time.
10696: --recording the number of duplicates found.
10697: UPDATE ams_list_headers_all
10698: SET last_deduped_by_user_id = FND_GLOBAL.User_Id
10699: ,last_dedupe_date = SYSDATE
10700: ,no_of_rows_duplicates = l_total_dup_recs
10701: WHERE list_header_id = p_list_header_id;
10702: