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

Line 221: GBPA.last_updated_by = FND_GLOBAL.user_id,

217: WHERE CPA.po_header_id = GBPA.cpa_reference)),
218: GBPA.approved_flag = 'Y',
219: GBPA.approved_date = sysdate,
220: GBPA.last_update_date = sysdate,
221: GBPA.last_updated_by = FND_GLOBAL.user_id,
222: GBPA.last_update_login = FND_GLOBAL.login_id,
223: GBPA.cat_admin_auth_enabled_flag = 'Y' -- Part of ECO bug 4554461
224: WHERE po_header_id = l_po_header_ids(i);
225:

Line 222: GBPA.last_update_login = FND_GLOBAL.login_id,

218: GBPA.approved_flag = 'Y',
219: GBPA.approved_date = sysdate,
220: GBPA.last_update_date = sysdate,
221: GBPA.last_updated_by = FND_GLOBAL.user_id,
222: GBPA.last_update_login = FND_GLOBAL.login_id,
223: GBPA.cat_admin_auth_enabled_flag = 'Y' -- Part of ECO bug 4554461
224: WHERE po_header_id = l_po_header_ids(i);
225:
226: x_rows_processed := SQL%rowcount; --Bug#5156673 --TBD: What is the impact due to the loop ; mutiple loops doing multiple updates; x_rows_processed will not be the total rows proecssed by this worked then ?

Line 241: last_updated_by = FND_GLOBAL.user_id,

237: SET authorization_status = 'APPROVED',
238: approved_flag = 'Y',
239: approved_date = sysdate,
240: last_update_date = sysdate,
241: last_updated_by = FND_GLOBAL.user_id,
242: last_update_login = FND_GLOBAL.login_id
243: WHERE po_header_id = l_po_header_ids(i)
244: AND revision_num = 0;
245:

Line 242: last_update_login = FND_GLOBAL.login_id

238: approved_flag = 'Y',
239: approved_date = sysdate,
240: last_update_date = sysdate,
241: last_updated_by = FND_GLOBAL.user_id,
242: last_update_login = FND_GLOBAL.login_id
243: WHERE po_header_id = l_po_header_ids(i)
244: AND revision_num = 0;
245:
246: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'Number of rows of PO_HEADERS_ARCHIVE_ALL updated='||SQL%rowcount); END IF;

Line 399: FND_GLOBAL.user_id, -- last_updated_by

395: 'PA', -- object_type_code
396: 'BLANKET', -- object_sub_type_code
397: 1, -- sequence_num
398: sysdate, -- last_update_date
399: FND_GLOBAL.user_id, -- last_updated_by
400: sysdate, -- creation_date
401: PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER, -- created_by = -12
402: 'APPROVE', -- action_code
403: sysdate, -- action_date

Line 409: FND_GLOBAL.login_id, -- last_update_login

405: NULL, -- approval_path_id
406: NULL, -- note
407: 0, -- object_revision_num
408: NULL, -- offline_code
409: FND_GLOBAL.login_id, -- last_update_login
410: FND_GLOBAL.conc_request_id, -- request_id
411: NULL, -- program_application_id
412: NULL, -- program_id
413: NULL, -- program_update_date

Line 410: FND_GLOBAL.conc_request_id, -- request_id

406: NULL, -- note
407: 0, -- object_revision_num
408: NULL, -- offline_code
409: FND_GLOBAL.login_id, -- last_update_login
410: FND_GLOBAL.conc_request_id, -- request_id
411: NULL, -- program_application_id
412: NULL, -- program_id
413: NULL, -- program_update_date
414: NULL -- program_date

Line 2428: -- Instead, use FND_GLOBAL.local_chr(x)

2424: l_gbpa_info LONG;
2425:
2426: -- Bug 4941073:
2427: -- GSCC Error: File.SQL.10: Do not use CHR character function in sql scripts
2428: -- Instead, use FND_GLOBAL.local_chr(x)
2429: --l_eoln_char CONSTANT VARCHAR2(1) := chr(10);
2430: --l_tab_char CONSTANT VARCHAR2(1) := chr(09);
2431: l_eoln_char CONSTANT VARCHAR2(1) := FND_GLOBAL.local_chr(10);
2432: l_tab_char CONSTANT VARCHAR2(1) := FND_GLOBAL.local_chr(09);

Line 2431: l_eoln_char CONSTANT VARCHAR2(1) := FND_GLOBAL.local_chr(10);

2427: -- GSCC Error: File.SQL.10: Do not use CHR character function in sql scripts
2428: -- Instead, use FND_GLOBAL.local_chr(x)
2429: --l_eoln_char CONSTANT VARCHAR2(1) := chr(10);
2430: --l_tab_char CONSTANT VARCHAR2(1) := chr(09);
2431: l_eoln_char CONSTANT VARCHAR2(1) := FND_GLOBAL.local_chr(10);
2432: l_tab_char CONSTANT VARCHAR2(1) := FND_GLOBAL.local_chr(09);
2433:
2434: l_heading_global_blanket FND_NEW_MESSAGES.message_text%TYPE;
2435: l_heading_ou_name FND_NEW_MESSAGES.message_text%TYPE;

Line 2432: l_tab_char CONSTANT VARCHAR2(1) := FND_GLOBAL.local_chr(09);

2428: -- Instead, use FND_GLOBAL.local_chr(x)
2429: --l_eoln_char CONSTANT VARCHAR2(1) := chr(10);
2430: --l_tab_char CONSTANT VARCHAR2(1) := chr(09);
2431: l_eoln_char CONSTANT VARCHAR2(1) := FND_GLOBAL.local_chr(10);
2432: l_tab_char CONSTANT VARCHAR2(1) := FND_GLOBAL.local_chr(09);
2433:
2434: l_heading_global_blanket FND_NEW_MESSAGES.message_text%TYPE;
2435: l_heading_ou_name FND_NEW_MESSAGES.message_text%TYPE;
2436:

Line 2587: , x_created_by => FND_GLOBAL.user_id

2583: (
2584: x_rowid => l_rowid -- IN/OUT
2585: , x_document_id => l_document_id -- IN/OUT
2586: , x_creation_date => sysdate
2587: , x_created_by => FND_GLOBAL.user_id
2588: , x_last_update_date => sysdate
2589: , x_last_updated_by => FND_GLOBAL.user_id
2590: , x_last_update_login => FND_GLOBAL.login_id
2591: , x_datatype_id => 2 -- Long Text

Line 2589: , x_last_updated_by => FND_GLOBAL.user_id

2585: , x_document_id => l_document_id -- IN/OUT
2586: , x_creation_date => sysdate
2587: , x_created_by => FND_GLOBAL.user_id
2588: , x_last_update_date => sysdate
2589: , x_last_updated_by => FND_GLOBAL.user_id
2590: , x_last_update_login => FND_GLOBAL.login_id
2591: , x_datatype_id => 2 -- Long Text
2592: , x_category_id => 1 -- Miscellaneous
2593: , x_security_type => 1

Line 2590: , x_last_update_login => FND_GLOBAL.login_id

2586: , x_creation_date => sysdate
2587: , x_created_by => FND_GLOBAL.user_id
2588: , x_last_update_date => sysdate
2589: , x_last_updated_by => FND_GLOBAL.user_id
2590: , x_last_update_login => FND_GLOBAL.login_id
2591: , x_datatype_id => 2 -- Long Text
2592: , x_category_id => 1 -- Miscellaneous
2593: , x_security_type => 1
2594: , x_security_id => l_security_id

Line 2660: , FND_GLOBAL.user_id

2656: (
2657: FND_ATTACHED_DOCUMENTS_S.nextval
2658: , l_document_id
2659: , sysdate
2660: , FND_GLOBAL.user_id
2661: , sysdate
2662: , FND_GLOBAL.user_id
2663: , FND_GLOBAL.login_id
2664: , l_seq_num

Line 2662: , FND_GLOBAL.user_id

2658: , l_document_id
2659: , sysdate
2660: , FND_GLOBAL.user_id
2661: , sysdate
2662: , FND_GLOBAL.user_id
2663: , FND_GLOBAL.login_id
2664: , l_seq_num
2665: , l_to_entity_name
2666: , l_to_pk1_value

Line 2663: , FND_GLOBAL.login_id

2659: , sysdate
2660: , FND_GLOBAL.user_id
2661: , sysdate
2662: , FND_GLOBAL.user_id
2663: , FND_GLOBAL.login_id
2664: , l_seq_num
2665: , l_to_entity_name
2666: , l_to_pk1_value
2667: , 'N'