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 4162: l_class_category HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE;

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

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

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

Line 4168: FROM HZ_CODE_ASSIGNMENTS

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

Line 4173: FROM hz_class_categories cc, hz_code_assignments ca

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

Line 4193: UPDATE HZ_CODE_ASSIGNMENTS

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

Line 4215: FROM HZ_CODE_ASSIGNMENTS

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

Line 4229: UPDATE HZ_CODE_ASSIGNMENTS

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

Line 4275: l_class_category HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE;

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

Line 4280: FROM HZ_CODE_ASSIGNMENTS

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

Line 4285: FROM hz_class_categories cc, hz_code_assignments ca

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

Line 4304: UPDATE HZ_CODE_ASSIGNMENTS

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

Line 4324: FROM HZ_CODE_ASSIGNMENTS

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

Line 4339: UPDATE HZ_CODE_ASSIGNMENTS

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