APPS.ENG_ECO_UTIL dependencies on ENG_CHANGE_SUBJECTS_S

Line 4086: SELECT eng_change_subjects_s.nextval INTO l_change_subject_unexp_rec.change_subject_id

4082: END IF;
4083: -- End Changes
4084:
4085: IF p_eco_rec.transaction_type = Eng_Globals.G_OPR_CREATE THEN
4086: SELECT eng_change_subjects_s.nextval INTO l_change_subject_unexp_rec.change_subject_id
4087: FROM SYS.DUAL;
4088:
4089:
4090:

Line 4159: (eng_change_subjects_s.nextval,

4155: PROGRAM_ID,
4156: PROGRAM_APPLICATION_ID,
4157: PROGRAM_UPDATE_DATE)
4158: values
4159: (eng_change_subjects_s.nextval,
4160: l_change_subject_unexp_rec.change_id,
4161: null,
4162: l_parent_entity_name, -- bug 3572698
4163: l_change_subject_unexp_rec.pk1_value,

Line 4204: (eng_change_subjects_s.nextval,

4200: PROGRAM_ID,
4201: PROGRAM_APPLICATION_ID,
4202: PROGRAM_UPDATE_DATE)
4203: values
4204: (eng_change_subjects_s.nextval,
4205: l_change_subject_unexp_rec.change_id,
4206: null,
4207: l_parent_entity_name, -- bug 3572698
4208: l_item_catalog_group_id,

Line 4225: UPDATE eng_change_subjects SET

4221: l_prog_appid,
4222: l_prog_id,sysdate);
4223: END IF;
4224: ELSIF p_eco_rec.transaction_type = Eng_Globals.G_OPR_UPDATE THEN
4225: UPDATE eng_change_subjects SET
4226: pk1_value = l_change_subject_unexp_rec.pk1_value,
4227: pk2_value = l_change_subject_unexp_rec.pk2_value,
4228: pk3_value = l_change_subject_unexp_rec.pk3_value
4229: WHERE change_id = l_change_subject_unexp_rec.change_id

Line 4234: UPDATE eng_change_subjects SET

4230: AND subject_level = 1
4231: AND change_line_id is null;
4232:
4233: IF l_parent_entity_name = 'EGO_ITEM' THEN
4234: UPDATE eng_change_subjects SET
4235: pk1_value = l_change_subject_unexp_rec.pk1_value,
4236: pk2_value = l_change_subject_unexp_rec.pk2_value
4237: WHERE change_id = l_change_subject_unexp_rec.change_id
4238: AND subject_level = 2

Line 4245: UPDATE eng_change_subjects SET

4241: l_parent_entity_name = 'EGO_CATALOG_GROUP' THEN
4242: OPEN getcataloggroupid(l_change_subject_unexp_rec.pk1_value,
4243: l_change_subject_unexp_rec.pk2_value);
4244: FETCH getcataloggroupid into l_item_catalog_group_id;
4245: UPDATE eng_change_subjects SET
4246: pk1_value = l_item_catalog_group_id
4247: WHERE change_id = l_change_subject_unexp_rec.change_id
4248: AND subject_level = 2
4249: AND change_line_id is null;