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_MERGE_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 2075: 'HZ_CODE_ASSIGNMENTS','HZ_PARTIES',

2071:
2072: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2073: p_to_fk_id, p_par_entity_name,
2074: 'HZ_MERGE_PKG.code_assignment_merge',
2075: 'HZ_CODE_ASSIGNMENTS','HZ_PARTIES',
2076: 'CODE_ASSIGNMENT_ID', 'PARTY_ID',x_return_status);
2077:
2078: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2079: l_dup_exists := HZ_MERGE_DUP_CHECK.check_code_assignment_dup(

Line 2124: 'HZ_CODE_ASSIGNMENTS','HZ_PARTY_SITES',

2120:
2121: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2122: p_to_fk_id, p_par_entity_name,
2123: 'HZ_MERGE_PKG.code_assignment_merge',
2124: 'HZ_CODE_ASSIGNMENTS','HZ_PARTY_SITES',
2125: 'CODE_ASSIGNMENT_ID', 'PARTY_SITE_ID',x_return_status);
2126:
2127: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2128: l_dup_exists := HZ_MERGE_DUP_CHECK.check_code_assignment_dup(

Line 4160: l_class_category HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE;

4156: l_exists VARCHAR2(10);
4157: l_cont_src VARCHAR2(255);
4158: l_primary_flag VARCHAR2(1):='N';
4159: l_fp_primary_flag VARCHAR2(1);
4160: l_class_category HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE;
4161: l_code_exists VARCHAR2(1);
4162: l_class_code HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE; --bug 4582789
4163:
4164: CURSOR c_cont_source IS

Line 4162: l_class_code HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE; --bug 4582789

4158: l_primary_flag VARCHAR2(1):='N';
4159: l_fp_primary_flag VARCHAR2(1);
4160: l_class_category HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE;
4161: l_code_exists VARCHAR2(1);
4162: l_class_code HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE; --bug 4582789
4163:
4164: CURSOR c_cont_source IS
4165: SELECT CONTENT_SOURCE_TYPE,CLASS_CATEGORY,PRIMARY_FLAG,CLASS_CODE
4166: FROM HZ_CODE_ASSIGNMENTS

Line 4166: FROM HZ_CODE_ASSIGNMENTS

4162: l_class_code HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE; --bug 4582789
4163:
4164: CURSOR c_cont_source IS
4165: SELECT CONTENT_SOURCE_TYPE,CLASS_CATEGORY,PRIMARY_FLAG,CLASS_CODE
4166: FROM HZ_CODE_ASSIGNMENTS
4167: WHERE code_assignment_id = p_from_id;
4168:
4169: CURSOR check_multiple_assignments IS
4170: SELECT 'Y'

Line 4171: FROM hz_class_categories cc, hz_code_assignments ca

4167: WHERE code_assignment_id = p_from_id;
4168:
4169: CURSOR check_multiple_assignments IS
4170: SELECT 'Y'
4171: FROM hz_class_categories cc, hz_code_assignments ca
4172: WHERE ca.owner_table_id = p_to_fk_id
4173: AND cc.class_category = ca.class_category
4174: AND cc.allow_multi_assign_flag = 'N'
4175: AND ca.class_category = l_class_category;

Line 4191: UPDATE HZ_CODE_ASSIGNMENTS

4187:
4188:
4189: IF (x_to_id <> FND_API.G_MISS_NUM AND x_to_id <> p_from_id)
4190: OR (NVL(l_code_exists,'N') = 'Y') THEN
4191: UPDATE HZ_CODE_ASSIGNMENTS
4192: SET
4193: STATUS = 'M',
4194: last_update_date = hz_utility_pub.last_update_date,
4195: last_updated_by = hz_utility_pub.user_id,

Line 4213: FROM HZ_CODE_ASSIGNMENTS

4209: IF l_fp_primary_flag = 'Y' THEN
4210: BEGIN
4211: SELECT 'Exists'
4212: INTO l_exists
4213: FROM HZ_CODE_ASSIGNMENTS
4214: WHERE primary_flag = 'Y'
4215: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
4216: AND OWNER_TABLE_ID = p_to_fk_id
4217: AND CLASS_CATEGORY = l_class_category

Line 4227: UPDATE HZ_CODE_ASSIGNMENTS

4223: END;
4224: END IF;
4225:
4226: -- Update and set party_id = p_to_fk_id where pk = from_id
4227: UPDATE HZ_CODE_ASSIGNMENTS
4228: SET
4229: owner_table_id = p_to_fk_id,
4230: primary_flag = l_primary_flag,
4231: last_update_date = hz_utility_pub.last_update_date,

Line 4273: l_class_category HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE;

4269: l_exists VARCHAR2(10);
4270: l_primary_flag VARCHAR2(1):='N';
4271: l_fp_primary_flag VARCHAR2(1);
4272: l_cont_src VARCHAR2(255);
4273: l_class_category HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE;
4274: l_code_exists VARCHAR2(1);
4275:
4276: CURSOR c_cont_source IS
4277: SELECT CONTENT_SOURCE_TYPE,CLASS_CATEGORY,PRIMARY_FLAG

Line 4278: FROM HZ_CODE_ASSIGNMENTS

4274: l_code_exists VARCHAR2(1);
4275:
4276: CURSOR c_cont_source IS
4277: SELECT CONTENT_SOURCE_TYPE,CLASS_CATEGORY,PRIMARY_FLAG
4278: FROM HZ_CODE_ASSIGNMENTS
4279: WHERE code_assignment_id = p_from_id;
4280:
4281: CURSOR check_multiple_assignments IS
4282: SELECT 'Y'

Line 4283: FROM hz_class_categories cc, hz_code_assignments ca

4279: WHERE code_assignment_id = p_from_id;
4280:
4281: CURSOR check_multiple_assignments IS
4282: SELECT 'Y'
4283: FROM hz_class_categories cc, hz_code_assignments ca
4284: WHERE ca.owner_table_id = p_to_fk_id
4285: AND cc.class_category = ca.class_category
4286: AND cc.allow_multi_assign_flag = 'N'
4287: AND ca.class_category = l_class_category;

Line 4302: UPDATE HZ_CODE_ASSIGNMENTS

4298: CLOSE check_multiple_assignments;
4299:
4300: IF (x_to_id <> FND_API.G_MISS_NUM AND
4301: x_to_id <> p_from_id) OR (NVL(l_code_exists,'N') = 'Y') THEN
4302: UPDATE HZ_CODE_ASSIGNMENTS
4303: SET
4304: STATUS = 'M',
4305: last_update_date = hz_utility_pub.last_update_date,
4306: last_updated_by = hz_utility_pub.user_id,

Line 4322: FROM HZ_CODE_ASSIGNMENTS

4318: IF l_fp_primary_flag = 'Y' THEN
4319: BEGIN
4320: SELECT 'Exists'
4321: INTO l_exists
4322: FROM HZ_CODE_ASSIGNMENTS
4323: WHERE PRIMARY_FLAG = 'Y'
4324: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
4325: AND OWNER_TABLE_ID = p_to_fk_id
4326: AND CLASS_CATEGORY = l_class_category

Line 4337: UPDATE HZ_CODE_ASSIGNMENTS

4333: END;
4334: END IF;
4335:
4336: -- Update and set party_id = p_to_fk_id where pk = from_id
4337: UPDATE HZ_CODE_ASSIGNMENTS
4338: SET
4339: owner_table_id = p_to_fk_id,
4340: primary_flag = l_primary_flag,
4341: last_update_date = hz_utility_pub.last_update_date,