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

Line 290: p_user_name => fnd_global.user_name,

286: p_operation_code => 'UPDATE',
287: p_db_object_name => 'HZ_RELATIONSHIPS',
288: p_instance_pk1_value => l_relationship_id(i),
289: p_instance_pk2_value => 'F',
290: p_user_name => fnd_global.user_name,
291: x_return_status => dss_return_status,
292: x_msg_count => dss_msg_count,
293: x_msg_data => dss_msg_data);
294:

Line 1181: fnd_global.lookup_security_group(''PARTY_RELATIONS_TYPE'', 222)

1177: and party_rel_type_l.lookup_type (+) = ''PARTY_RELATIONS_TYPE''
1178: and party_rel_type_l.language (+) = userenv(''LANG'')
1179: and party_rel_type_l.view_application_id (+) = 222
1180: and party_rel_type_l.security_group_id (+) =
1181: fnd_global.lookup_security_group(''PARTY_RELATIONS_TYPE'', 222)
1182: -- validate department_code
1183: and dept_l.lookup_code (+) = ocint.department_code
1184: and dept_l.lookup_type (+) = ''DEPARTMENT_TYPE''
1185: and dept_l.language (+) = userenv(''LANG'')

Line 1188: fnd_global.lookup_security_group(''DEPARTMENT_TYPE'', 222)

1184: and dept_l.lookup_type (+) = ''DEPARTMENT_TYPE''
1185: and dept_l.language (+) = userenv(''LANG'')
1186: and dept_l.view_application_id (+) = 222
1187: and dept_l.security_group_id (+) =
1188: fnd_global.lookup_security_group(''DEPARTMENT_TYPE'', 222)
1189: -- validate title
1190: and title_l.lookup_code (+) = ocint.title
1191: and title_l.lookup_type (+) = ''CONTACT_TITLE''
1192: and title_l.language (+) = userenv(''LANG'')

Line 1195: fnd_global.lookup_security_group(''CONTACT_TITLE'', 222)

1191: and title_l.lookup_type (+) = ''CONTACT_TITLE''
1192: and title_l.language (+) = userenv(''LANG'')
1193: and title_l.view_application_id (+) = 222
1194: and title_l.security_group_id (+) =
1195: fnd_global.lookup_security_group(''CONTACT_TITLE'', 222)
1196: -- validate job_title_code
1197: and job_title_code_l.lookup_code (+) = ocint.job_title_code
1198: and job_title_code_l.lookup_type (+) = ''RESPONSIBILITY''
1199: and job_title_code_l.language (+) = userenv(''LANG'')

Line 1202: fnd_global.lookup_security_group(''RESPONSIBILITY'', 222)

1198: and job_title_code_l.lookup_type (+) = ''RESPONSIBILITY''
1199: and job_title_code_l.language (+) = userenv(''LANG'')
1200: and job_title_code_l.view_application_id (+) = 222
1201: and job_title_code_l.security_group_id (+) =
1202: fnd_global.lookup_security_group(''RESPONSIBILITY'', 222)
1203: and createdby_l.lookup_code (+) = ocint.created_by_module
1204: and createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''
1205: and createdby_l.language (+) = userenv(''LANG'')
1206: and createdby_l.view_application_id (+) = 222

Line 1208: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)

1204: and createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''
1205: and createdby_l.language (+) = userenv(''LANG'')
1206: and createdby_l.view_application_id (+) = 222
1207: and createdby_l.security_group_id (+) =
1208: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)
1209: and tc.a = (select count(*) ---- check relationship duplicate, 0 indicates no error
1210: from hz_relationships r1
1211: where r1.subject_id = ocsg.sub_id
1212: and r1.subject_table_name = ''HZ_PARTIES''