APPS.ENG_CHANGE_LINE_UTIL dependencies on ENG_CHANGE_SUBJECTS_S

Line 928: (eng_change_subjects_s.nextval,

924: PROGRAM_ID,
925: PROGRAM_APPLICATION_ID,
926: PROGRAM_UPDATE_DATE)
927: values
928: (eng_change_subjects_s.nextval,
929: l_change_subject_unexp_rec.change_id,
930: l_change_subject_unexp_rec.change_line_id,
931: l_change_subject_unexp_rec.entity_name,
932: l_change_subject_unexp_rec.pk1_value,

Line 972: (eng_change_subjects_s.nextval,

968: PROGRAM_ID,
969: PROGRAM_APPLICATION_ID,
970: PROGRAM_UPDATE_DATE)
971: values
972: (eng_change_subjects_s.nextval,
973: l_change_subject_unexp_rec.change_id,
974: l_change_subject_unexp_rec.change_line_id,
975: l_parent_entity_name, --l_change_subject_unexp_rec.entity_name,
976: l_change_subject_unexp_rec.pk1_value,

Line 1019: (eng_change_subjects_s.nextval,

1015: PROGRAM_ID,
1016: PROGRAM_APPLICATION_ID,
1017: PROGRAM_UPDATE_DATE)
1018: values
1019: (eng_change_subjects_s.nextval,
1020: l_change_subject_unexp_rec.change_id,
1021: l_change_subject_unexp_rec.change_line_id,
1022: l_parent_entity_name, --l_change_subject_unexp_rec.entity_name,
1023: l_item_catalog_group_id,

Line 1042: UPDATE eng_change_subjects SET

1038: sysdate);
1039: END IF;
1040: ELSIF p_change_line_rec.transaction_type = Eng_Globals.G_OPR_UPDATE
1041: THEN
1042: UPDATE eng_change_subjects SET
1043: pk1_value = l_change_subject_unexp_rec.pk1_value,
1044: pk2_value = l_change_subject_unexp_rec.pk2_value,
1045: pk3_value = l_change_subject_unexp_rec.pk3_value
1046: WHERE change_id = l_change_subject_unexp_rec.change_id

Line 1052: UPDATE eng_change_subjects SET

1048: AND subject_level = 1;
1049:
1050: IF l_parent_entity_name = 'EGO_ITEM'
1051: THEN
1052: UPDATE eng_change_subjects SET
1053: pk1_value = l_change_subject_unexp_rec.pk1_value,
1054: pk2_value = l_change_subject_unexp_rec.pk2_value
1055: WHERE change_id = l_change_subject_unexp_rec.change_id
1056: AND subject_level = 2

Line 1063: UPDATE eng_change_subjects SET

1059: THEN
1060: OPEN getcataloggroupid(l_change_subject_unexp_rec.pk1_value,
1061: l_change_subject_unexp_rec.pk2_value);
1062: FETCH getcataloggroupid into l_item_catalog_group_id;
1063: UPDATE eng_change_subjects SET
1064: pk1_value = l_item_catalog_group_id
1065: WHERE change_id = l_change_subject_unexp_rec.change_id
1066: AND subject_level = 2
1067: AND change_line_id = l_change_subject_unexp_rec.change_line_id;

Line 1112: FROM eng_subject_entities_v esev, eng_change_subjects subs

1108: , esev.query_column1_name, esev.query_column2_name, esev.query_column3_name
1109: , esev.query_column4_name, esev.query_column5_name
1110: , subs.entity_name, subs.subject_level, subs.pk1_value
1111: , subs.pk2_value, subs.pk3_value, subs.pk4_value, subs.pk5_value
1112: FROM eng_subject_entities_v esev, eng_change_subjects subs
1113: WHERE esev.subject_id = p_subject_id
1114: AND esev.subject_level = subs.subject_level
1115: AND esev.entity_name = subs.entity_name
1116: AND subs.change_id = p_change_id

Line 1227: FROM ENG_CHANGE_OBJECTS eco, eng_change_subjects subs

1223: ,'pk2Value', subs.pk2_value)
1224: ,'pk3Value', subs.pk3_value)
1225: ,'pk4Value', subs.pk4_value)
1226: ,'pk1Value', subs.pk5_value) subject_url
1227: FROM ENG_CHANGE_OBJECTS eco, eng_change_subjects subs
1228: WHERE eco.entity_name = subs.entity_name
1229: AND subs.pk1_value IS NOT NULL
1230: AND subs.entity_name <> 'EGO_COMPONENT'
1231: AND subs.change_id = p_change_id

Line 1243: FROM eng_change_subjects subs

1239: ,'pk2Value', subs.pk2_value)
1240: ,'pk3Value', subs.pk3_value)
1241: ,'pk4Value', subs.pk4_value)
1242: ,'pk1Value', subs.pk5_value) subject_url
1243: FROM eng_change_subjects subs
1244: WHERE subs.subject_level = 3 and subs.entity_name = 'EGO_ITEM_REVISION'
1245: AND subs.change_id = p_change_id
1246: AND subs.change_line_id = p_change_line_id;
1247: