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_ODI_PUB dependencies on FND_GLOBAL

Line 1152: FND_GLOBAL.APPS_INITIALIZE(

1148: */
1149:
1150:
1151: --Initializing security context
1152: FND_GLOBAL.APPS_INITIALIZE(
1153: USER_ID=>l_user_id,
1154: RESP_ID=>l_responsibility_id,
1155: RESP_APPL_ID=>l_application_id
1156: );

Line 1158: --FND_GLOBAL.Apps_Initialize(user_id => 1006535, resp_id => 24089, resp_appl_id => 431);

1154: RESP_ID=>l_responsibility_id,
1155: RESP_APPL_ID=>l_application_id
1156: );
1157:
1158: --FND_GLOBAL.Apps_Initialize(user_id => 1006535, resp_id => 24089, resp_appl_id => 431);
1159: --Dbms_Output.put_line('FND_GLOBAL.User_Id: ' || FND_GLOBAL.User_Id);
1160: --Dbms_Output.put_line('FND_GLOBAL.Login_Id: ' || FND_GLOBAL.Login_Id);
1161:
1162: END Init_Security_Structure;

Line 1159: --Dbms_Output.put_line('FND_GLOBAL.User_Id: ' || FND_GLOBAL.User_Id);

1155: RESP_APPL_ID=>l_application_id
1156: );
1157:
1158: --FND_GLOBAL.Apps_Initialize(user_id => 1006535, resp_id => 24089, resp_appl_id => 431);
1159: --Dbms_Output.put_line('FND_GLOBAL.User_Id: ' || FND_GLOBAL.User_Id);
1160: --Dbms_Output.put_line('FND_GLOBAL.Login_Id: ' || FND_GLOBAL.Login_Id);
1161:
1162: END Init_Security_Structure;
1163:

Line 1160: --Dbms_Output.put_line('FND_GLOBAL.Login_Id: ' || FND_GLOBAL.Login_Id);

1156: );
1157:
1158: --FND_GLOBAL.Apps_Initialize(user_id => 1006535, resp_id => 24089, resp_appl_id => 431);
1159: --Dbms_Output.put_line('FND_GLOBAL.User_Id: ' || FND_GLOBAL.User_Id);
1160: --Dbms_Output.put_line('FND_GLOBAL.Login_Id: ' || FND_GLOBAL.Login_Id);
1161:
1162: END Init_Security_Structure;
1163:
1164:

Line 1210: ,p_user_name => 'HZ_PARTY:'||TO_CHAR(FND_GLOBAL.PARTY_ID)

1206: EGO_DATA_SECURITY.get_security_predicate
1207: (p_api_version => 1.0
1208: ,p_function => p_priv_check
1209: ,p_object_name => 'EGO_ITEM'
1210: ,p_user_name => 'HZ_PARTY:'||TO_CHAR(FND_GLOBAL.PARTY_ID)
1211: ,p_statement_type => 'EXISTS'
1212: ,p_pk1_alias => 'i.ITEM_ID'
1213: ,p_pk2_alias => 'i.ITEM_ORG_ID'
1214: ,p_pk3_alias => NULL

Line 1377: FROM EGO_USER_V WHERE USER_ID = FND_GLOBAL.USER_ID;

1373: AND PK2_VALUE = i.item_org_id
1374: AND PK3_VALUE = i.item_rev;
1375:
1376: SELECT party_name INTO l_user_name
1377: FROM EGO_USER_V WHERE USER_ID = FND_GLOBAL.USER_ID;
1378:
1379: SELECT CHAR_VALUE INTO l_structure_name FROM EGO_PUB_BAT_PARAMS_B
1380: WHERE type_id=l_batch_id AND Upper(parameter_name) ='STRUCTURE_NAME';
1381:

Line 1449: ,p_user_name => 'HZ_PARTY:'||TO_CHAR(FND_GLOBAL.PARTY_ID)

1445: EGO_DATA_SECURITY.get_security_predicate
1446: (p_api_version => 1.0
1447: ,p_function => p_priv_check
1448: ,p_object_name => 'EGO_ITEM'
1449: ,p_user_name => 'HZ_PARTY:'||TO_CHAR(FND_GLOBAL.PARTY_ID)
1450: ,p_statement_type => 'EXISTS'
1451: ,p_pk1_alias => 'e.COMPONENT_ITEM_ID'
1452: ,p_pk2_alias => 'e.ORGANIZATION_ID'
1453: ,p_pk3_alias => NULL

Line 1617: ,p_user_name => 'HZ_PARTY:'||TO_CHAR(FND_GLOBAL.PARTY_ID)

1613: EGO_DATA_SECURITY.get_security_predicate
1614: (p_api_version => 1.0
1615: ,p_function => p_priv_check
1616: ,p_object_name => 'EGO_ITEM'
1617: ,p_user_name => 'HZ_PARTY:'||TO_CHAR(FND_GLOBAL.PARTY_ID)
1618: ,p_statement_type => 'EXISTS'
1619: ,p_pk1_alias => 'e.COMPONENT_ITEM_ID'
1620: ,p_pk2_alias => 'e.ORGANIZATION_ID'
1621: ,p_pk3_alias => NULL

Line 4353: ,p_user_name => 'HZ_PARTY:'||TO_CHAR(FND_GLOBAL.PARTY_ID) --FND_GLOBAL.PARTY_ID --'HZ_PARTY:'||TO_CHAR(G_PARTY_ID)

4349: EGO_DATA_SECURITY.get_security_predicate
4350: (p_api_version => 1.0
4351: ,p_function => p_priv_check -- 'EGO_VIEW_ITEM'
4352: ,p_object_name => 'EGO_ITEM'
4353: ,p_user_name => 'HZ_PARTY:'||TO_CHAR(FND_GLOBAL.PARTY_ID) --FND_GLOBAL.PARTY_ID --'HZ_PARTY:'||TO_CHAR(G_PARTY_ID)
4354: ,p_statement_type => 'EXISTS'
4355: ,p_pk1_alias => 'i.pk1_value'
4356: ,p_pk2_alias => 'i.pk2_value'
4357: ,p_pk3_alias => NULL

Line 4368: -- values (p_session_id, 'p_user_name: ' || 'HZ_PARTY:'||TO_CHAR(FND_GLOBAL.PARTY_ID));

4364: --INSERT INTO emt_temp (Session_id, message)
4365: -- values (p_session_id, 'x_return_status: ' || x_return_status);
4366:
4367: --INSERT INTO emt_temp (Session_id, message)
4368: -- values (p_session_id, 'p_user_name: ' || 'HZ_PARTY:'||TO_CHAR(FND_GLOBAL.PARTY_ID));
4369:
4370: --debugging statement remove
4371: -- INSERT INTO emt_temp (Session_id, message)
4372: -- values (p_session_id, 'l_sec_predicate: ' || l_sec_predicate);

Line 5201: l_cr VARCHAR2(10) := fnd_global.local_chr(10);

5197: l_entity_type VARCHAR2(100) := NULL;
5198: l_xml CLOB;
5199:
5200: l_output_xml XmlType;
5201: l_cr VARCHAR2(10) := fnd_global.local_chr(10);
5202: l_qm VARCHAR2(1) := '?'; -- Question mark in a string may be interpreted by ODI
5203:
5204: l_level_stack dbms_sql.number_table;
5205: l_tags_stack dbms_sql.varchar2_table;

Line 7050: FND_GLOBAL.APPS_INITIALIZE( USER_ID=>l_user_id,

7046: END IF;
7047:
7048:
7049: /*Initialize apps context*/
7050: FND_GLOBAL.APPS_INITIALIZE( USER_ID=>l_user_id,
7051: RESP_ID=>l_resp_id,
7052: RESP_APPL_ID=>l_application_id);
7053:
7054: