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

Line 30: -- fnd_global.apps_initialize(1068, 431, 24089);

26: */
27: PROCEDURE set_globals
28: IS
29: BEGIN
30: -- fnd_global.apps_initialize(1068, 431, 24089);
31: --
32: -- file names
33: --
34: G_FILE_NAME := NVL(G_FILE_NAME,'EGOVIAUB.pls');

Line 39: G_USER_ID := FND_GLOBAL.user_id;

35: G_PKG_NAME := NVL(G_PKG_NAME,'EGO_ITEM_ASSOCIATONS_UTIL');
36: --
37: -- user values
38: --
39: G_USER_ID := FND_GLOBAL.user_id;
40: G_LOGIN_ID := FND_GLOBAL.login_id;
41: G_SESSION_LANG := USERENV('LANG');
42: BEGIN
43: SELECT party_id

Line 40: G_LOGIN_ID := FND_GLOBAL.login_id;

36: --
37: -- user values
38: --
39: G_USER_ID := FND_GLOBAL.user_id;
40: G_LOGIN_ID := FND_GLOBAL.login_id;
41: G_SESSION_LANG := USERENV('LANG');
42: BEGIN
43: SELECT party_id
44: INTO G_PARTY_ID

Line 52: WHERE USER_NAME = FND_GLOBAL.USER_NAME;

48: WHEN NO_DATA_FOUND THEN
49: SELECT party_id, user_id
50: INTO G_PARTY_ID, G_USER_ID
51: FROM ego_user_v
52: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
53: END;
54: END set_globals;
55:
56:

Line 202: l_select_clause := ' SELECT fnd_global.USER_ID, sysdate, fnd_global.USER_ID, sysdate, ''Y'', :batch_id, aas.vendor_id, aas.segment1, aas.vendor_name, hp.duns_number_c, aas.num_1099, aas.vat_registration_num ';

198: -- construct the search result query dynamically
199: -- dbms_output.put_line(' Called search_supplier_and_sites' );
200: l_insert_clause := ' INSERT INTO ego_suppliersite_tmp ( created_by, creation_date, last_updated_by, last_update_date, select_flag, batch_id, supplier_id, supplier_number, supplier_name, duns_number, tax_payer_id, tax_registration_num ';
201: l_suppl_insert_clause := ' INSERT INTO ego_suppliersite_tmp ( created_by, creation_date, last_updated_by, last_update_date, select_flag, batch_id, supplier_id, supplier_number, supplier_name, duns_number, tax_payer_id, tax_registration_num ) ';
202: l_select_clause := ' SELECT fnd_global.USER_ID, sysdate, fnd_global.USER_ID, sysdate, ''Y'', :batch_id, aas.vendor_id, aas.segment1, aas.vendor_name, hp.duns_number_c, aas.num_1099, aas.vat_registration_num ';
203: l_suppl_select_clause := ' SELECT fnd_global.USER_ID, sysdate, fnd_global.USER_ID, sysdate, ''Y'', :batch_id, aas.vendor_id, aas.segment1, aas.vendor_name, hp.duns_number_c, aas.num_1099, aas.vat_registration_num ';
204: l_from_clause := ' FROM ap_suppliers aas, hz_parties hp ';
205: l_suppl_from_clause := ' FROM ap_suppliers aas, hz_parties hp ';
206: l_where_clause := ' WHERE aas.party_id = hp.party_id AND NVL(aas.end_date_active,SYSDATE+1) > SYSDATE ';

Line 203: l_suppl_select_clause := ' SELECT fnd_global.USER_ID, sysdate, fnd_global.USER_ID, sysdate, ''Y'', :batch_id, aas.vendor_id, aas.segment1, aas.vendor_name, hp.duns_number_c, aas.num_1099, aas.vat_registration_num ';

199: -- dbms_output.put_line(' Called search_supplier_and_sites' );
200: l_insert_clause := ' INSERT INTO ego_suppliersite_tmp ( created_by, creation_date, last_updated_by, last_update_date, select_flag, batch_id, supplier_id, supplier_number, supplier_name, duns_number, tax_payer_id, tax_registration_num ';
201: l_suppl_insert_clause := ' INSERT INTO ego_suppliersite_tmp ( created_by, creation_date, last_updated_by, last_update_date, select_flag, batch_id, supplier_id, supplier_number, supplier_name, duns_number, tax_payer_id, tax_registration_num ) ';
202: l_select_clause := ' SELECT fnd_global.USER_ID, sysdate, fnd_global.USER_ID, sysdate, ''Y'', :batch_id, aas.vendor_id, aas.segment1, aas.vendor_name, hp.duns_number_c, aas.num_1099, aas.vat_registration_num ';
203: l_suppl_select_clause := ' SELECT fnd_global.USER_ID, sysdate, fnd_global.USER_ID, sysdate, ''Y'', :batch_id, aas.vendor_id, aas.segment1, aas.vendor_name, hp.duns_number_c, aas.num_1099, aas.vat_registration_num ';
204: l_from_clause := ' FROM ap_suppliers aas, hz_parties hp ';
205: l_suppl_from_clause := ' FROM ap_suppliers aas, hz_parties hp ';
206: l_where_clause := ' WHERE aas.party_id = hp.party_id AND NVL(aas.end_date_active,SYSDATE+1) > SYSDATE ';
207: l_suppl_where_clause := ' WHERE aas.party_id = hp.party_id AND NVL(aas.end_date_active,SYSDATE+1) > SYSDATE ';