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

Line 296: p_user_name => fnd_global.user_name,

292: p_instance_pk2_value => null,
293: p_instance_pk3_value => null,
294: p_instance_pk4_value => null,
295: p_instance_pk5_value => null,
296: p_user_name => fnd_global.user_name,
297: x_return_status => dss_return_status,
298: x_msg_count => dss_msg_count,
299: x_msg_data => dss_msg_data);
300: END LOOP;

Line 1025: fnd_global.lookup_security_group(''COMMUNICATION_TYPE'', 222)

1021: and contact_point_type_l.lookup_type (+) = ''COMMUNICATION_TYPE''
1022: and contact_point_type_l.language (+) = userenv(''LANG'')
1023: and contact_point_type_l.view_application_id (+) = 222
1024: and contact_point_type_l.security_group_id (+) =
1025: fnd_global.lookup_security_group(''COMMUNICATION_TYPE'', 222)
1026: and cp_purpose_l.lookup_code (+) = pi.contact_point_purpose
1027: and cp_purpose_l.lookup_type (+) = ''CONTACT_POINT_PURPOSE''
1028: and cp_purpose_l.language (+) = userenv(''LANG'')
1029: and cp_purpose_l.view_application_id (+) = 222

Line 1031: fnd_global.lookup_security_group(''CONTACT_POINT_PURPOSE'', 222)

1027: and cp_purpose_l.lookup_type (+) = ''CONTACT_POINT_PURPOSE''
1028: and cp_purpose_l.language (+) = userenv(''LANG'')
1029: and cp_purpose_l.view_application_id (+) = 222
1030: and cp_purpose_l.security_group_id (+) =
1031: fnd_global.lookup_security_group(''CONTACT_POINT_PURPOSE'', 222)
1032: and cp_purpose_web_l.lookup_code (+) = pi.contact_point_purpose
1033: and cp_purpose_web_l.lookup_type (+) = ''CONTACT_POINT_PURPOSE_WEB''
1034: and cp_purpose_web_l.language (+) = userenv(''LANG'')
1035: and cp_purpose_web_l.view_application_id (+) = 222

Line 1037: fnd_global.lookup_security_group(''CONTACT_POINT_PURPOSE_WEB'', 222)

1033: and cp_purpose_web_l.lookup_type (+) = ''CONTACT_POINT_PURPOSE_WEB''
1034: and cp_purpose_web_l.language (+) = userenv(''LANG'')
1035: and cp_purpose_web_l.view_application_id (+) = 222
1036: and cp_purpose_web_l.security_group_id (+) =
1037: fnd_global.lookup_security_group(''CONTACT_POINT_PURPOSE_WEB'', 222)
1038: and email_format_l.lookup_code (+) = pi.email_format
1039: and email_format_l.lookup_type (+) = ''EMAIL_FORMAT''
1040: and email_format_l.language (+) = userenv(''LANG'')
1041: and email_format_l.view_application_id (+) = 222

Line 1043: fnd_global.lookup_security_group(''EMAIL_FORMAT'', 222)

1039: and email_format_l.lookup_type (+) = ''EMAIL_FORMAT''
1040: and email_format_l.language (+) = userenv(''LANG'')
1041: and email_format_l.view_application_id (+) = 222
1042: and email_format_l.security_group_id (+) =
1043: fnd_global.lookup_security_group(''EMAIL_FORMAT'', 222)
1044: and phone_line_type_l.lookup_code (+) = pi.phone_line_type
1045: and phone_line_type_l.lookup_type (+) = ''PHONE_LINE_TYPE''
1046: and phone_line_type_l.language (+) = userenv(''LANG'')
1047: and phone_line_type_l.view_application_id (+) = 222

Line 1049: fnd_global.lookup_security_group(''PHONE_LINE_TYPE'', 222)

1045: and phone_line_type_l.lookup_type (+) = ''PHONE_LINE_TYPE''
1046: and phone_line_type_l.language (+) = userenv(''LANG'')
1047: and phone_line_type_l.view_application_id (+) = 222
1048: and phone_line_type_l.security_group_id (+) =
1049: fnd_global.lookup_security_group(''PHONE_LINE_TYPE'', 222)
1050: and pi.timezone_code = ht.timezone_code (+)
1051: --and pi.phone_country_code = hpc.phone_country_code (+) --3401319
1052: and tc.a = (select count(*) from hz_phone_country_codes hpc --3401319
1053: where pi.phone_country_code = hpc.phone_country_code

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

1056: and createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''
1057: and createdby_l.language (+) = userenv(''LANG'')
1058: and createdby_l.view_application_id (+) = 222
1059: and createdby_l.security_group_id (+) =
1060: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)
1061: and ps.batch_id = :l_batch_id
1062: and ps.party_orig_system = :l_os
1063: and ps.party_orig_system_reference between :l_from_osr and :l_to_osr
1064: and ps.batch_mode_flag = :l_batch_mode_flag

Line 1499: fnd_global.lookup_security_group(''COMMUNICATION_TYPE'', 222)

1495: and contact_point_type_l.lookup_type(+) = ''COMMUNICATION_TYPE''
1496: and contact_point_type_l.language (+) = userenv(''LANG'')
1497: and contact_point_type_l.view_application_id (+) = 222
1498: and contact_point_type_l.security_group_id (+) =
1499: fnd_global.lookup_security_group(''COMMUNICATION_TYPE'', 222)
1500: and pi.CONTACT_POINT_PURPOSE = cp_purpose_l.lookup_code(+)
1501: and cp_purpose_l.lookup_type(+) = ''CONTACT_POINT_PURPOSE''
1502: and cp_purpose_l.language (+) = userenv(''LANG'')
1503: and cp_purpose_l.view_application_id (+) = 222

Line 1505: fnd_global.lookup_security_group(''CONTACT_POINT_PURPOSE'', 222)

1501: and cp_purpose_l.lookup_type(+) = ''CONTACT_POINT_PURPOSE''
1502: and cp_purpose_l.language (+) = userenv(''LANG'')
1503: and cp_purpose_l.view_application_id (+) = 222
1504: and cp_purpose_l.security_group_id (+) =
1505: fnd_global.lookup_security_group(''CONTACT_POINT_PURPOSE'', 222)
1506: and pi.CONTACT_POINT_PURPOSE = cp_purpose_web_l.lookup_code(+)
1507: and cp_purpose_web_l.lookup_type(+) = ''CONTACT_POINT_PURPOSE_WEB''
1508: and cp_purpose_web_l.language (+) = userenv(''LANG'')
1509: and cp_purpose_web_l.view_application_id (+) = 222

Line 1511: fnd_global.lookup_security_group(''CONTACT_POINT_PURPOSE_WEB'', 222)

1507: and cp_purpose_web_l.lookup_type(+) = ''CONTACT_POINT_PURPOSE_WEB''
1508: and cp_purpose_web_l.language (+) = userenv(''LANG'')
1509: and cp_purpose_web_l.view_application_id (+) = 222
1510: and cp_purpose_web_l.security_group_id (+) =
1511: fnd_global.lookup_security_group(''CONTACT_POINT_PURPOSE_WEB'', 222)
1512: and pi.EMAIL_FORMAT = email_format_l.lookup_code(+)
1513: and email_format_l.lookup_type(+) = ''EMAIL_FORMAT''
1514: and email_format_l.language (+) = userenv(''LANG'')
1515: and email_format_l.view_application_id (+) = 222

Line 1517: fnd_global.lookup_security_group(''EMAIL_FORMAT'', 222)

1513: and email_format_l.lookup_type(+) = ''EMAIL_FORMAT''
1514: and email_format_l.language (+) = userenv(''LANG'')
1515: and email_format_l.view_application_id (+) = 222
1516: and email_format_l.security_group_id (+) =
1517: fnd_global.lookup_security_group(''EMAIL_FORMAT'', 222)
1518: and pi.PHONE_LINE_TYPE = phone_line_type_l.lookup_code(+)
1519: and phone_line_type_l.lookup_type(+) = ''PHONE_LINE_TYPE''
1520: and phone_line_type_l.language (+) = userenv(''LANG'')
1521: and phone_line_type_l.view_application_id (+) = 222

Line 1523: fnd_global.lookup_security_group(''PHONE_LINE_TYPE'', 222)

1519: and phone_line_type_l.lookup_type(+) = ''PHONE_LINE_TYPE''
1520: and phone_line_type_l.language (+) = userenv(''LANG'')
1521: and phone_line_type_l.view_application_id (+) = 222
1522: and phone_line_type_l.security_group_id (+) =
1523: fnd_global.lookup_security_group(''PHONE_LINE_TYPE'', 222)
1524: and pi.TIMEZONE_CODE = ht.timezone_code(+)
1525: --and pi.PHONE_COUNTRY_CODE = hpc.phone_country_code(+)--3401319
1526: and createdby_l.lookup_code (+) = pi.created_by_module
1527: and createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''

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

1527: and createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''
1528: and createdby_l.language (+) = userenv(''LANG'')
1529: and createdby_l.view_application_id (+) = 222
1530: and createdby_l.security_group_id (+) =
1531: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)
1532: and tc.a = (select count(*) from hz_phone_country_codes hpc --3401319
1533: where pi.phone_country_code = hpc.phone_country_code
1534: and rownum < 2)
1535: and ps.batch_id = :l_batch_id