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.ENG_CHANGE_LINE_UTIL dependencies on ENG_CHANGE_SUBJECTS

Line 906: Insert into eng_change_subjects

902: -- End Changes
903:
904: IF p_change_line_rec.transaction_type = Eng_Globals.G_OPR_CREATE
905: THEN
906: Insert into eng_change_subjects
907: (CHANGE_SUBJECT_ID,
908: CHANGE_ID,
909: CHANGE_LINE_ID,
910: ENTITY_NAME,

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 950: Insert into eng_change_subjects

946: l_prog_id,sysdate);
947:
948: IF l_parent_entity_name = 'EGO_ITEM'
949: THEN
950: Insert into eng_change_subjects
951: (CHANGE_SUBJECT_ID,
952: CHANGE_ID,
953: CHANGE_LINE_ID,
954: ENTITY_NAME,

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 997: Insert into eng_change_subjects

993: THEN
994: OPEN getcataloggroupid(l_change_subject_unexp_rec.pk1_value,
995: l_change_subject_unexp_rec.pk2_value);
996: FETCH getcataloggroupid into l_item_catalog_group_id;
997: Insert into eng_change_subjects
998: (CHANGE_SUBJECT_ID,
999: CHANGE_ID,
1000: CHANGE_LINE_ID,
1001: ENTITY_NAME,

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 1070: DELETE FROM eng_change_subjects

1066: AND subject_level = 2
1067: AND change_line_id = l_change_subject_unexp_rec.change_line_id;
1068: END IF;
1069: ELSE
1070: DELETE FROM eng_change_subjects
1071: WHERE change_line_id = l_change_subject_unexp_rec.change_line_id
1072: AND change_id = l_change_subject_unexp_rec.change_id;
1073: END IF; -- if CREATE
1074: END IF; -- if return status is 'S'

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: