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.IGS_AD_IMP_002 dependencies on HZ_PARTY_SITE_USES

Line 2162: -- local procedure to check whether duplicate record exists for hz_party_site_uses for a party site id

2158: l_request_id NUMBER(10);
2159: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
2160: l_location_ovn hz_locations.object_version_number%TYPE;
2161:
2162: -- local procedure to check whether duplicate record exists for hz_party_site_uses for a party site id
2163: PROCEDURE check_dup_addr_usage(l_party_site_id IN HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE,
2164: l_site_use_code IN HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE,
2165: l_dup_var OUT NOCOPY VARCHAR2 ) AS
2166:

Line 2163: PROCEDURE check_dup_addr_usage(l_party_site_id IN HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE,

2159: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
2160: l_location_ovn hz_locations.object_version_number%TYPE;
2161:
2162: -- local procedure to check whether duplicate record exists for hz_party_site_uses for a party site id
2163: PROCEDURE check_dup_addr_usage(l_party_site_id IN HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE,
2164: l_site_use_code IN HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE,
2165: l_dup_var OUT NOCOPY VARCHAR2 ) AS
2166:
2167: l_var varchar2(5);

Line 2164: l_site_use_code IN HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE,

2160: l_location_ovn hz_locations.object_version_number%TYPE;
2161:
2162: -- local procedure to check whether duplicate record exists for hz_party_site_uses for a party site id
2163: PROCEDURE check_dup_addr_usage(l_party_site_id IN HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE,
2164: l_site_use_code IN HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE,
2165: l_dup_var OUT NOCOPY VARCHAR2 ) AS
2166:
2167: l_var varchar2(5);
2168:

Line 2169: CURSOR check_dup_cur(cp_party_site_id HZ_PARTY_SITE_USES.party_site_id%TYPE,

2165: l_dup_var OUT NOCOPY VARCHAR2 ) AS
2166:
2167: l_var varchar2(5);
2168:
2169: CURSOR check_dup_cur(cp_party_site_id HZ_PARTY_SITE_USES.party_site_id%TYPE,
2170: cp_site_use_code HZ_PARTY_SITE_USES.site_use_type%TYPE) IS
2171: SELECT 'X'
2172: FROM HZ_PARTY_SITE_USES
2173: WHERE party_site_id = cp_party_site_id

Line 2170: cp_site_use_code HZ_PARTY_SITE_USES.site_use_type%TYPE) IS

2166:
2167: l_var varchar2(5);
2168:
2169: CURSOR check_dup_cur(cp_party_site_id HZ_PARTY_SITE_USES.party_site_id%TYPE,
2170: cp_site_use_code HZ_PARTY_SITE_USES.site_use_type%TYPE) IS
2171: SELECT 'X'
2172: FROM HZ_PARTY_SITE_USES
2173: WHERE party_site_id = cp_party_site_id
2174: AND site_use_type = cp_site_use_code;

Line 2172: FROM HZ_PARTY_SITE_USES

2168:
2169: CURSOR check_dup_cur(cp_party_site_id HZ_PARTY_SITE_USES.party_site_id%TYPE,
2170: cp_site_use_code HZ_PARTY_SITE_USES.site_use_type%TYPE) IS
2171: SELECT 'X'
2172: FROM HZ_PARTY_SITE_USES
2173: WHERE party_site_id = cp_party_site_id
2174: AND site_use_type = cp_site_use_code;
2175:
2176: BEGIN

Line 2252: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(

2248:
2249: l_party_site_use_id := NULL;
2250: l_rowid := NULL;
2251:
2252: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(
2253: p_action => 'INSERT',
2254: p_rowid => l_rowid,
2255: p_party_site_use_id => l_party_site_use_id,
2256: p_party_site_id => l_party_site_id,

Line 2590: -- local procedure to check whether duplicate record exists for hz_party_site_uses for a party site id

2586: l_last_update_date DATE;
2587: p_status VARCHAR2(1);
2588: p_error_code VARCHAR2(100);
2589:
2590: -- local procedure to check whether duplicate record exists for hz_party_site_uses for a party site id
2591: PROCEDURE check_dup_addr_usage(l_party_site_id IN HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE,
2592: l_site_use_code IN HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE,
2593: l_dup_var OUT NOCOPY VARCHAR2 ) AS
2594:

Line 2591: PROCEDURE check_dup_addr_usage(l_party_site_id IN HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE,

2587: p_status VARCHAR2(1);
2588: p_error_code VARCHAR2(100);
2589:
2590: -- local procedure to check whether duplicate record exists for hz_party_site_uses for a party site id
2591: PROCEDURE check_dup_addr_usage(l_party_site_id IN HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE,
2592: l_site_use_code IN HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE,
2593: l_dup_var OUT NOCOPY VARCHAR2 ) AS
2594:
2595: l_var VARCHAR2(5);

Line 2592: l_site_use_code IN HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE,

2588: p_error_code VARCHAR2(100);
2589:
2590: -- local procedure to check whether duplicate record exists for hz_party_site_uses for a party site id
2591: PROCEDURE check_dup_addr_usage(l_party_site_id IN HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE,
2592: l_site_use_code IN HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE,
2593: l_dup_var OUT NOCOPY VARCHAR2 ) AS
2594:
2595: l_var VARCHAR2(5);
2596:

Line 2597: CURSOR check_dup_cur (cp_party_site_id hz_party_site_uses.party_site_id%TYPE,

2593: l_dup_var OUT NOCOPY VARCHAR2 ) AS
2594:
2595: l_var VARCHAR2(5);
2596:
2597: CURSOR check_dup_cur (cp_party_site_id hz_party_site_uses.party_site_id%TYPE,
2598: cp_site_use_code hz_party_site_uses.site_use_type%TYPE) IS
2599: SELECT 'X'
2600: FROM HZ_PARTY_SITE_USES
2601: WHERE party_site_id = cp_party_site_id

Line 2598: cp_site_use_code hz_party_site_uses.site_use_type%TYPE) IS

2594:
2595: l_var VARCHAR2(5);
2596:
2597: CURSOR check_dup_cur (cp_party_site_id hz_party_site_uses.party_site_id%TYPE,
2598: cp_site_use_code hz_party_site_uses.site_use_type%TYPE) IS
2599: SELECT 'X'
2600: FROM HZ_PARTY_SITE_USES
2601: WHERE party_site_id = cp_party_site_id
2602: AND site_use_type = cp_site_use_code;

Line 2600: FROM HZ_PARTY_SITE_USES

2596:
2597: CURSOR check_dup_cur (cp_party_site_id hz_party_site_uses.party_site_id%TYPE,
2598: cp_site_use_code hz_party_site_uses.site_use_type%TYPE) IS
2599: SELECT 'X'
2600: FROM HZ_PARTY_SITE_USES
2601: WHERE party_site_id = cp_party_site_id
2602: AND site_use_type = cp_site_use_code;
2603:
2604: BEGIN

Line 2680: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(

2676:
2677: l_party_site_use_id := NULL;
2678: l_rowid := NULL;
2679:
2680: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(
2681: p_action => 'INSERT',
2682: p_rowid => l_rowid,
2683: p_party_site_use_id => l_party_site_use_id,
2684: p_party_site_id => l_party_site_id,