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

Line 57: fnd_global.user_id,

53: SELECT auction_header_id,
54: team_id,
55: user_id,
56: 'C',
57: fnd_global.user_id,
58: SYSDATE,
59: fnd_global.user_id,
60: SYSDATE,
61: fnd_global.login_id

Line 59: fnd_global.user_id,

55: user_id,
56: 'C',
57: fnd_global.user_id,
58: SYSDATE,
59: fnd_global.user_id,
60: SYSDATE,
61: fnd_global.login_id
62: FROM pon_evaluation_team_members
63: WHERE auction_header_id = p_auction_header_id;

Line 61: fnd_global.login_id

57: fnd_global.user_id,
58: SYSDATE,
59: fnd_global.user_id,
60: SYSDATE,
61: fnd_global.login_id
62: FROM pon_evaluation_team_members
63: WHERE auction_header_id = p_auction_header_id;
64:
65: INSERT INTO pon_mng_eval_team_sections

Line 83: fnd_global.user_id,

79: pets.team_id,
80: pet.team_name,
81: pets.section_id,
82: 'C',
83: fnd_global.user_id,
84: SYSDATE,
85: fnd_global.user_id,
86: SYSDATE,
87: fnd_global.login_id

Line 85: fnd_global.user_id,

81: pets.section_id,
82: 'C',
83: fnd_global.user_id,
84: SYSDATE,
85: fnd_global.user_id,
86: SYSDATE,
87: fnd_global.login_id
88: FROM pon_evaluation_team_sections pets,
89: pon_evaluation_teams pet

Line 87: fnd_global.login_id

83: fnd_global.user_id,
84: SYSDATE,
85: fnd_global.user_id,
86: SYSDATE,
87: fnd_global.login_id
88: FROM pon_evaluation_team_sections pets,
89: pon_evaluation_teams pet
90: WHERE pets.auction_header_id = p_auction_header_id
91: AND pet.auction_header_id = p_auction_header_id

Line 151: fnd_global.user_id,

147: VALUES (p_auction_header_id,
148: bs_deleted.bid_number,
149: bs_deleted.section_id,
150: 'D',
151: fnd_global.user_id,
152: SYSDATE,
153: fnd_global.user_id,
154: SYSDATE,
155: fnd_global.login_id

Line 153: fnd_global.user_id,

149: bs_deleted.section_id,
150: 'D',
151: fnd_global.user_id,
152: SYSDATE,
153: fnd_global.user_id,
154: SYSDATE,
155: fnd_global.login_id
156: );
157:

Line 155: fnd_global.login_id

151: fnd_global.user_id,
152: SYSDATE,
153: fnd_global.user_id,
154: SYSDATE,
155: fnd_global.login_id
156: );
157:
158:
159: -- 2. Track new sections for the evaluations

Line 207: fnd_global.user_id,

203: VALUES (p_auction_header_id,
204: bs_added.bid_number,
205: bs_added.section_id,
206: 'A',
207: fnd_global.user_id,
208: SYSDATE,
209: fnd_global.user_id,
210: SYSDATE,
211: fnd_global.login_id

Line 209: fnd_global.user_id,

205: bs_added.section_id,
206: 'A',
207: fnd_global.user_id,
208: SYSDATE,
209: fnd_global.user_id,
210: SYSDATE,
211: fnd_global.login_id
212: );
213:

Line 211: fnd_global.login_id

207: fnd_global.user_id,
208: SYSDATE,
209: fnd_global.user_id,
210: SYSDATE,
211: fnd_global.login_id
212: );
213:
214:
215: -- 3. Track changes in team members

Line 243: fnd_global.user_id,

239: SELECT auction_header_id,
240: team_id,
241: user_id,
242: 'A',
243: fnd_global.user_id,
244: SYSDATE,
245: fnd_global.user_id,
246: SYSDATE,
247: fnd_global.login_id

Line 245: fnd_global.user_id,

241: user_id,
242: 'A',
243: fnd_global.user_id,
244: SYSDATE,
245: fnd_global.user_id,
246: SYSDATE,
247: fnd_global.login_id
248: FROM pon_evaluation_team_members
249: WHERE auction_header_id = p_auction_header_id

Line 247: fnd_global.login_id

243: fnd_global.user_id,
244: SYSDATE,
245: fnd_global.user_id,
246: SYSDATE,
247: fnd_global.login_id
248: FROM pon_evaluation_team_members
249: WHERE auction_header_id = p_auction_header_id
250: AND (team_id, user_id) NOT IN
251: (SELECT team_id,

Line 288: fnd_global.user_id,

284: pets.team_id,
285: pet.team_name,
286: pets.section_id,
287: 'A',
288: fnd_global.user_id,
289: SYSDATE,
290: fnd_global.user_id,
291: SYSDATE,
292: fnd_global.login_id

Line 290: fnd_global.user_id,

286: pets.section_id,
287: 'A',
288: fnd_global.user_id,
289: SYSDATE,
290: fnd_global.user_id,
291: SYSDATE,
292: fnd_global.login_id
293: FROM pon_evaluation_team_sections pets,
294: pon_evaluation_teams pet

Line 292: fnd_global.login_id

288: fnd_global.user_id,
289: SYSDATE,
290: fnd_global.user_id,
291: SYSDATE,
292: fnd_global.login_id
293: FROM pon_evaluation_team_sections pets,
294: pon_evaluation_teams pet
295: WHERE pets.auction_header_id = p_auction_header_id
296: AND pet.auction_header_id = p_auction_header_id

Line 494: avalue => fnd_global.user_name);

490:
491: wf_engine.SetItemAttrText(itemtype => l_itemtype,
492: itemkey => l_itemkey,
493: aname => 'ORIGIN_USER_NAME',
494: avalue => fnd_global.user_name);
495:
496: wf_engine.SetItemAttrText(itemtype => l_itemtype,
497: itemkey => l_itemkey,
498: aname => 'RECIPIENT_ROLE',

Line 523: owner => fnd_global.user_name);

519:
520:
521: wf_engine.SetItemOwner(itemtype => l_itemtype,
522: itemkey => l_itemkey,
523: owner => fnd_global.user_name);
524:
525: wf_engine.StartProcess(itemtype => l_itemtype,
526: itemkey => l_itemkey);
527:

Line 661: l_document VARCHAR2(32000) := fnd_global.newline;

657: l_has_full_access VARCHAR2(1);
658:
659: l_language_code VARCHAR2(3);
660: l_msg_name VARCHAR2(30);
661: l_document VARCHAR2(32000) := fnd_global.newline;
662:
663: BEGIN
664:
665: l_itemtype := SUBSTR(p_document_id, 1, INSTR(p_document_id, ':') - 1);

Line 1052: avalue => fnd_global.user_name);

1048:
1049: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1050: itemkey => l_itemkey,
1051: aname => 'ORIGIN_USER_NAME',
1052: avalue => fnd_global.user_name);
1053:
1054: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1055: itemkey => l_itemkey,
1056: aname => 'RECIPIENT_ROLE',

Line 1086: owner => fnd_global.user_name);

1082:
1083:
1084: wf_engine.SetItemOwner(itemtype => l_itemtype,
1085: itemkey => l_itemkey,
1086: owner => fnd_global.user_name);
1087:
1088: wf_engine.StartProcess(itemtype => l_itemtype,
1089: itemkey => l_itemkey);
1090: