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_ORDER_TYPES_PKG dependencies on ENG_CHANGE_ORDER_TYPES

Line 1: package body ENG_CHANGE_ORDER_TYPES_PKG as

1: package body ENG_CHANGE_ORDER_TYPES_PKG as
2: /* $Header: ENGCTYPEB.pls 120.6 2011/08/09 23:13:15 chulhale noship $ */
3:
4: TYPE number_list IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5:

Line 699: SELECT eng_change_order_types_s.nextval

695: l_base_change_mgmt_type_code VARCHAR2(30);
696: c_start_date DATE;
697:
698: BEGIN
699: SELECT eng_change_order_types_s.nextval
700: INTO l_change_order_type_id
701: FROM dual;
702:
703: SELECT default_assignee_id,

Line 733: FROM ENG_CHANGE_ORDER_TYPES_VL

729: l_enable_item_in_local_org,
730: l_create_bom_in_local_org,
731: l_subject_updatable_flag,
732: l_base_change_mgmt_type_code --Added for Bug No:3497234, Issue: DEF-2071
733: FROM ENG_CHANGE_ORDER_TYPES_VL
734: WHERE
735: CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
736:
737: SELECT START_DATE INTO c_start_date

Line 738: FROM ENG_CHANGE_ORDER_TYPES_VL

734: WHERE
735: CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
736:
737: SELECT START_DATE INTO c_start_date
738: FROM ENG_CHANGE_ORDER_TYPES_VL
739: WHERE CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE
740: AND TYPE_CLASSIFICATION = 'CATEGORY';
741:
742: ENG_CHANGE_ORDER_TYPES_PKG.INSERT_ROW(

Line 742: ENG_CHANGE_ORDER_TYPES_PKG.INSERT_ROW(

738: FROM ENG_CHANGE_ORDER_TYPES_VL
739: WHERE CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE
740: AND TYPE_CLASSIFICATION = 'CATEGORY';
741:
742: ENG_CHANGE_ORDER_TYPES_PKG.INSERT_ROW(
743: X_ROWID => v_row_id
744: , X_CHANGE_ORDER_TYPE_ID => l_change_order_type_id
745: , X_CHANGE_MGMT_TYPE_CODE => X_CHANGE_MGMT_TYPE_CODE
746: , X_START_DATE => c_start_date -- Start date should be same as category's start date

Line 801: ENG_CHANGE_ORDER_TYPES C

797:
798: CURSOR get_applications IS
799: SELECT A.APPLICATION_ID
800: FROM ENG_CHANGE_TYPE_APPLICATIONS A,
801: ENG_CHANGE_ORDER_TYPES C
802: WHERE C.CHANGE_ORDER_TYPE_ID = A.CHANGE_TYPE_ID
803: AND C.TYPE_CLASSIFICATION = 'CATEGORY'
804: AND C.CHANGE_MGMT_TYPE_CODE = X_BASE_CHANGE_MGMT_TYPE_CODE;
805:

Line 808: FROM ENG_CHANGE_ORDER_TYPES

804: AND C.CHANGE_MGMT_TYPE_CODE = X_BASE_CHANGE_MGMT_TYPE_CODE;
805:
806: CURSOR get_types IS
807: SELECT CHANGE_ORDER_TYPE_ID
808: FROM ENG_CHANGE_ORDER_TYPES
809: WHERE
810: --(TYPE_CLASSIFICATION = 'REVISED_LINE' OR TYPE_CLASSIFICATION = 'LINE')
811: --AND SEEDED_FLAG = 'Y'
812: TYPE_CLASSIFICATION = 'REVISED_LINE'

Line 910: cursor C is select ROWID from ENG_CHANGE_ORDER_TYPES

906: X_SUBJECT_UPDATABLE_FLAG in VARCHAR2 DEFAULT NULL,
907: x_xml_data_source_code IN VARCHAR2 DEFAULT NULL,
908: X_TYPE_INTERNAL_NAME in VARCHAR2 DEFAULT NULL
909: ) is
910: cursor C is select ROWID from ENG_CHANGE_ORDER_TYPES
911: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID
912: ;
913: l_current_id NUMBER;
914: l_created_by NUMBER;

Line 968: insert into ENG_CHANGE_ORDER_TYPES (

964: END IF;
965:
966:
967:
968: insert into ENG_CHANGE_ORDER_TYPES (
969: CHANGE_MGMT_TYPE_CODE,
970: START_DATE,
971: DEFAULT_ASSIGNEE_ID,
972: SUBJECT_ID,

Line 1054: insert into ENG_CHANGE_ORDER_TYPES_TL (

1050: X_XML_DATA_SOURCE_CODE,
1051: X_TYPE_INTERNAL_NAME
1052: );
1053:
1054: insert into ENG_CHANGE_ORDER_TYPES_TL (
1055: CHANGE_ORDER_TYPE_ID,
1056: TYPE_NAME,
1057: DESCRIPTION,
1058: TAB_TEXT,

Line 1082: from ENG_CHANGE_ORDER_TYPES_TL T

1078: from FND_LANGUAGES L
1079: where L.INSTALLED_FLAG in ('I', 'B')
1080: and not exists
1081: (select NULL
1082: from ENG_CHANGE_ORDER_TYPES_TL T
1083: where T.CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID
1084: and T.LANGUAGE = L.LANGUAGE_CODE);
1085:
1086: open c;

Line 1101: FROM ENG_CHANGE_ORDER_TYPES_VL

1097: THEN
1098:
1099: SELECT CHANGE_MGMT_TYPE_CODE
1100: INTO l_base_change_mgmt_type_code
1101: FROM ENG_CHANGE_ORDER_TYPES_VL
1102: WHERE CHANGE_ORDER_TYPE_ID = l_parent_cat_id;
1103:
1104: DUPLICATE_CATEGORY_ENTRIES (
1105: X_CHANGE_ORDER_TYPE_ID => X_CHANGE_ORDER_TYPE_ID,

Line 1164: FROM ENG_CHANGE_ORDER_TYPES_VL

1160:
1161: ELSE
1162: SELECT BASE_CHANGE_MGMT_TYPE_CODE
1163: INTO l_base_change_mgmt_type_code
1164: FROM ENG_CHANGE_ORDER_TYPES_VL
1165: WHERE CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
1166:
1167: ADD_DEFAULT_LIFECYCLES (
1168: X_CHANGE_ORDER_TYPE_ID => X_CHANGE_ORDER_TYPE_ID,

Line 1269: from ENG_CHANGE_ORDER_TYPES

1265: CREATE_BOM_IN_LOCAL_ORG ,
1266: SUBJECT_UPDATABLE_FLAG,
1267: xml_data_source_code,
1268: X_TYPE_INTERNAL_NAME
1269: from ENG_CHANGE_ORDER_TYPES
1270: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID
1271: for update of CHANGE_ORDER_TYPE_ID nowait;
1272: recinfo c%rowtype;
1273:

Line 1279: from ENG_CHANGE_ORDER_TYPES_TL

1275: TYPE_NAME,
1276: DESCRIPTION,
1277: TAB_TEXT,
1278: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
1279: from ENG_CHANGE_ORDER_TYPES_TL
1280: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID
1281: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1282: for update of CHANGE_ORDER_TYPE_ID nowait;
1283: begin

Line 1431: FROM ENG_CHANGE_ORDER_TYPES

1427: ) is
1428:
1429: CURSOR c_get_change_order_type IS
1430: SELECT change_order_type
1431: FROM ENG_CHANGE_ORDER_TYPES
1432: WHERE change_order_type_id = X_CHANGE_ORDER_TYPE_ID;
1433:
1434: l_internal_type_name VARCHAR2(80);
1435: begin

Line 1451: update ENG_CHANGE_ORDER_TYPES set

1447: ELSE
1448: l_internal_type_name := X_TYPE_INTERNAL_NAME;
1449: END IF;
1450:
1451: update ENG_CHANGE_ORDER_TYPES set
1452: CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE,
1453: START_DATE = X_START_DATE,
1454: DEFAULT_ASSIGNEE_ID = X_DEFAULT_ASSIGNEE_ID,
1455: SUBJECT_ID = X_SUBJECT_ID,

Line 1496: update ENG_CHANGE_ORDER_TYPES_TL set

1492: if (sql%notfound) then
1493: raise no_data_found;
1494: end if;
1495:
1496: update ENG_CHANGE_ORDER_TYPES_TL set
1497: TYPE_NAME = X_TYPE_NAME,
1498: DESCRIPTION = X_DESCRIPTION,
1499: TAB_TEXT = X_TAB_TEXT,
1500: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 1516: delete from ENG_CHANGE_ORDER_TYPES_TL

1512: procedure DELETE_ROW (
1513: X_CHANGE_ORDER_TYPE_ID in NUMBER
1514: ) is
1515: begin
1516: delete from ENG_CHANGE_ORDER_TYPES_TL
1517: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
1518:
1519: if (sql%notfound) then
1520: raise no_data_found;

Line 1523: delete from ENG_CHANGE_ORDER_TYPES

1519: if (sql%notfound) then
1520: raise no_data_found;
1521: end if;
1522:
1523: delete from ENG_CHANGE_ORDER_TYPES
1524: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
1525:
1526: if (sql%notfound) then
1527: raise no_data_found;

Line 1534: delete from ENG_CHANGE_ORDER_TYPES_TL T

1530:
1531: procedure ADD_LANGUAGE
1532: is
1533: begin
1534: delete from ENG_CHANGE_ORDER_TYPES_TL T
1535: where not exists
1536: (select NULL
1537: from ENG_CHANGE_ORDER_TYPES B
1538: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID

Line 1537: from ENG_CHANGE_ORDER_TYPES B

1533: begin
1534: delete from ENG_CHANGE_ORDER_TYPES_TL T
1535: where not exists
1536: (select NULL
1537: from ENG_CHANGE_ORDER_TYPES B
1538: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID
1539: );
1540:
1541: update ENG_CHANGE_ORDER_TYPES_TL T set (

Line 1541: update ENG_CHANGE_ORDER_TYPES_TL T set (

1537: from ENG_CHANGE_ORDER_TYPES B
1538: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID
1539: );
1540:
1541: update ENG_CHANGE_ORDER_TYPES_TL T set (
1542: TYPE_NAME,
1543: DESCRIPTION,
1544: TAB_TEXT
1545: ) = (select

Line 1549: from ENG_CHANGE_ORDER_TYPES_TL B

1545: ) = (select
1546: B.TYPE_NAME,
1547: B.DESCRIPTION,
1548: B.TAB_TEXT
1549: from ENG_CHANGE_ORDER_TYPES_TL B
1550: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID
1551: and B.LANGUAGE = T.SOURCE_LANG)
1552: where (
1553: T.CHANGE_ORDER_TYPE_ID,

Line 1558: from ENG_CHANGE_ORDER_TYPES_TL SUBB, ENG_CHANGE_ORDER_TYPES_TL SUBT

1554: T.LANGUAGE
1555: ) in (select
1556: SUBT.CHANGE_ORDER_TYPE_ID,
1557: SUBT.LANGUAGE
1558: from ENG_CHANGE_ORDER_TYPES_TL SUBB, ENG_CHANGE_ORDER_TYPES_TL SUBT
1559: where SUBB.CHANGE_ORDER_TYPE_ID = SUBT.CHANGE_ORDER_TYPE_ID
1560: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1561: and (SUBB.TYPE_NAME <> SUBT.TYPE_NAME
1562: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 1570: insert into ENG_CHANGE_ORDER_TYPES_TL (

1566: or (SUBB.TAB_TEXT is null and SUBT.TAB_TEXT is not null)
1567: or (SUBB.TAB_TEXT is not null and SUBT.TAB_TEXT is null)
1568: ));
1569:
1570: insert into ENG_CHANGE_ORDER_TYPES_TL (
1571: CHANGE_ORDER_TYPE_ID,
1572: TYPE_NAME,
1573: DESCRIPTION,
1574: TAB_TEXT,

Line 1594: from ENG_CHANGE_ORDER_TYPES_TL B, FND_LANGUAGES L

1590: B.LAST_UPDATED_BY,
1591: B.LAST_UPDATE_LOGIN,
1592: L.LANGUAGE_CODE,
1593: B.SOURCE_LANG
1594: from ENG_CHANGE_ORDER_TYPES_TL B, FND_LANGUAGES L
1595: where L.INSTALLED_FLAG in ('I', 'B')
1596: and B.LANGUAGE = userenv('LANG')
1597: and not exists
1598: (select NULL

Line 1599: from ENG_CHANGE_ORDER_TYPES_TL T

1595: where L.INSTALLED_FLAG in ('I', 'B')
1596: and B.LANGUAGE = userenv('LANG')
1597: and not exists
1598: (select NULL
1599: from ENG_CHANGE_ORDER_TYPES_TL T
1600: where T.CHANGE_ORDER_TYPE_ID = B.CHANGE_ORDER_TYPE_ID
1601: and T.LANGUAGE = L.LANGUAGE_CODE);
1602: end ADD_LANGUAGE;
1603:

Line 1604: end ENG_CHANGE_ORDER_TYPES_PKG;

1600: where T.CHANGE_ORDER_TYPE_ID = B.CHANGE_ORDER_TYPE_ID
1601: and T.LANGUAGE = L.LANGUAGE_CODE);
1602: end ADD_LANGUAGE;
1603:
1604: end ENG_CHANGE_ORDER_TYPES_PKG;