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.3 2006/01/30 02:24:11 pdutta noship $ */
3:
4: TYPE number_list IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5:

Line 662: SELECT eng_change_order_types_s.nextval

658: l_base_change_mgmt_type_code VARCHAR2(30);
659: c_start_date DATE;
660:
661: BEGIN
662: SELECT eng_change_order_types_s.nextval
663: INTO l_change_order_type_id
664: FROM dual;
665:
666: SELECT default_assignee_id,

Line 696: FROM ENG_CHANGE_ORDER_TYPES_VL

692: l_enable_item_in_local_org,
693: l_create_bom_in_local_org,
694: l_subject_updatable_flag,
695: l_base_change_mgmt_type_code --Added for Bug No:3497234, Issue: DEF-2071
696: FROM ENG_CHANGE_ORDER_TYPES_VL
697: WHERE
698: CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
699:
700: SELECT START_DATE INTO c_start_date

Line 701: FROM ENG_CHANGE_ORDER_TYPES_VL

697: WHERE
698: CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
699:
700: SELECT START_DATE INTO c_start_date
701: FROM ENG_CHANGE_ORDER_TYPES_VL
702: WHERE CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE
703: AND TYPE_CLASSIFICATION = 'CATEGORY';
704:
705: ENG_CHANGE_ORDER_TYPES_PKG.INSERT_ROW(

Line 705: ENG_CHANGE_ORDER_TYPES_PKG.INSERT_ROW(

701: FROM ENG_CHANGE_ORDER_TYPES_VL
702: WHERE CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE
703: AND TYPE_CLASSIFICATION = 'CATEGORY';
704:
705: ENG_CHANGE_ORDER_TYPES_PKG.INSERT_ROW(
706: X_ROWID => v_row_id
707: , X_CHANGE_ORDER_TYPE_ID => l_change_order_type_id
708: , X_CHANGE_MGMT_TYPE_CODE => X_CHANGE_MGMT_TYPE_CODE
709: , X_START_DATE => c_start_date -- Start date should be same as category's start date

Line 764: ENG_CHANGE_ORDER_TYPES C

760:
761: CURSOR get_applications IS
762: SELECT A.APPLICATION_ID
763: FROM ENG_CHANGE_TYPE_APPLICATIONS A,
764: ENG_CHANGE_ORDER_TYPES C
765: WHERE C.CHANGE_ORDER_TYPE_ID = A.CHANGE_TYPE_ID
766: AND C.TYPE_CLASSIFICATION = 'CATEGORY'
767: AND C.CHANGE_MGMT_TYPE_CODE = X_BASE_CHANGE_MGMT_TYPE_CODE;
768:

Line 771: FROM ENG_CHANGE_ORDER_TYPES

767: AND C.CHANGE_MGMT_TYPE_CODE = X_BASE_CHANGE_MGMT_TYPE_CODE;
768:
769: CURSOR get_types IS
770: SELECT CHANGE_ORDER_TYPE_ID
771: FROM ENG_CHANGE_ORDER_TYPES
772: WHERE
773: --(TYPE_CLASSIFICATION = 'REVISED_LINE' OR TYPE_CLASSIFICATION = 'LINE')
774: --AND SEEDED_FLAG = 'Y'
775: TYPE_CLASSIFICATION = 'REVISED_LINE'

Line 873: cursor C is select ROWID from ENG_CHANGE_ORDER_TYPES

869: X_SUBJECT_UPDATABLE_FLAG in VARCHAR2 DEFAULT NULL,
870: x_xml_data_source_code IN VARCHAR2 DEFAULT NULL,
871: X_TYPE_INTERNAL_NAME in VARCHAR2 DEFAULT NULL
872: ) is
873: cursor C is select ROWID from ENG_CHANGE_ORDER_TYPES
874: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID
875: ;
876: l_current_id NUMBER;
877: l_created_by NUMBER;

Line 931: insert into ENG_CHANGE_ORDER_TYPES (

927: END IF;
928:
929:
930:
931: insert into ENG_CHANGE_ORDER_TYPES (
932: CHANGE_MGMT_TYPE_CODE,
933: START_DATE,
934: DEFAULT_ASSIGNEE_ID,
935: SUBJECT_ID,

Line 1017: insert into ENG_CHANGE_ORDER_TYPES_TL (

1013: X_XML_DATA_SOURCE_CODE,
1014: X_TYPE_INTERNAL_NAME
1015: );
1016:
1017: insert into ENG_CHANGE_ORDER_TYPES_TL (
1018: CHANGE_ORDER_TYPE_ID,
1019: TYPE_NAME,
1020: DESCRIPTION,
1021: TAB_TEXT,

Line 1045: from ENG_CHANGE_ORDER_TYPES_TL T

1041: from FND_LANGUAGES L
1042: where L.INSTALLED_FLAG in ('I', 'B')
1043: and not exists
1044: (select NULL
1045: from ENG_CHANGE_ORDER_TYPES_TL T
1046: where T.CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID
1047: and T.LANGUAGE = L.LANGUAGE_CODE);
1048:
1049: open c;

Line 1064: FROM ENG_CHANGE_ORDER_TYPES_VL

1060: THEN
1061:
1062: SELECT CHANGE_MGMT_TYPE_CODE
1063: INTO l_base_change_mgmt_type_code
1064: FROM ENG_CHANGE_ORDER_TYPES_VL
1065: WHERE CHANGE_ORDER_TYPE_ID = l_parent_cat_id;
1066:
1067: DUPLICATE_CATEGORY_ENTRIES (
1068: X_CHANGE_ORDER_TYPE_ID => X_CHANGE_ORDER_TYPE_ID,

Line 1127: FROM ENG_CHANGE_ORDER_TYPES_VL

1123:
1124: ELSE
1125: SELECT BASE_CHANGE_MGMT_TYPE_CODE
1126: INTO l_base_change_mgmt_type_code
1127: FROM ENG_CHANGE_ORDER_TYPES_VL
1128: WHERE CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
1129:
1130: ADD_DEFAULT_LIFECYCLES (
1131: X_CHANGE_ORDER_TYPE_ID => X_CHANGE_ORDER_TYPE_ID,

Line 1232: from ENG_CHANGE_ORDER_TYPES

1228: CREATE_BOM_IN_LOCAL_ORG ,
1229: SUBJECT_UPDATABLE_FLAG,
1230: xml_data_source_code,
1231: X_TYPE_INTERNAL_NAME
1232: from ENG_CHANGE_ORDER_TYPES
1233: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID
1234: for update of CHANGE_ORDER_TYPE_ID nowait;
1235: recinfo c%rowtype;
1236:

Line 1242: from ENG_CHANGE_ORDER_TYPES_TL

1238: TYPE_NAME,
1239: DESCRIPTION,
1240: TAB_TEXT,
1241: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
1242: from ENG_CHANGE_ORDER_TYPES_TL
1243: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID
1244: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1245: for update of CHANGE_ORDER_TYPE_ID nowait;
1246: begin

Line 1394: FROM ENG_CHANGE_ORDER_TYPES

1390: ) is
1391:
1392: CURSOR c_get_change_order_type IS
1393: SELECT change_order_type
1394: FROM ENG_CHANGE_ORDER_TYPES
1395: WHERE change_order_type_id = X_CHANGE_ORDER_TYPE_ID;
1396:
1397: l_internal_type_name VARCHAR2(80);
1398: begin

Line 1414: update ENG_CHANGE_ORDER_TYPES set

1410: ELSE
1411: l_internal_type_name := X_TYPE_INTERNAL_NAME;
1412: END IF;
1413:
1414: update ENG_CHANGE_ORDER_TYPES set
1415: CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE,
1416: START_DATE = X_START_DATE,
1417: DEFAULT_ASSIGNEE_ID = X_DEFAULT_ASSIGNEE_ID,
1418: SUBJECT_ID = X_SUBJECT_ID,

Line 1459: update ENG_CHANGE_ORDER_TYPES_TL set

1455: if (sql%notfound) then
1456: raise no_data_found;
1457: end if;
1458:
1459: update ENG_CHANGE_ORDER_TYPES_TL set
1460: TYPE_NAME = X_TYPE_NAME,
1461: DESCRIPTION = X_DESCRIPTION,
1462: TAB_TEXT = X_TAB_TEXT,
1463: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 1479: delete from ENG_CHANGE_ORDER_TYPES_TL

1475: procedure DELETE_ROW (
1476: X_CHANGE_ORDER_TYPE_ID in NUMBER
1477: ) is
1478: begin
1479: delete from ENG_CHANGE_ORDER_TYPES_TL
1480: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
1481:
1482: if (sql%notfound) then
1483: raise no_data_found;

Line 1486: delete from ENG_CHANGE_ORDER_TYPES

1482: if (sql%notfound) then
1483: raise no_data_found;
1484: end if;
1485:
1486: delete from ENG_CHANGE_ORDER_TYPES
1487: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
1488:
1489: if (sql%notfound) then
1490: raise no_data_found;

Line 1497: delete from ENG_CHANGE_ORDER_TYPES_TL T

1493:
1494: procedure ADD_LANGUAGE
1495: is
1496: begin
1497: delete from ENG_CHANGE_ORDER_TYPES_TL T
1498: where not exists
1499: (select NULL
1500: from ENG_CHANGE_ORDER_TYPES B
1501: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID

Line 1500: from ENG_CHANGE_ORDER_TYPES B

1496: begin
1497: delete from ENG_CHANGE_ORDER_TYPES_TL T
1498: where not exists
1499: (select NULL
1500: from ENG_CHANGE_ORDER_TYPES B
1501: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID
1502: );
1503:
1504: update ENG_CHANGE_ORDER_TYPES_TL T set (

Line 1504: update ENG_CHANGE_ORDER_TYPES_TL T set (

1500: from ENG_CHANGE_ORDER_TYPES B
1501: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID
1502: );
1503:
1504: update ENG_CHANGE_ORDER_TYPES_TL T set (
1505: TYPE_NAME,
1506: DESCRIPTION,
1507: TAB_TEXT
1508: ) = (select

Line 1512: from ENG_CHANGE_ORDER_TYPES_TL B

1508: ) = (select
1509: B.TYPE_NAME,
1510: B.DESCRIPTION,
1511: B.TAB_TEXT
1512: from ENG_CHANGE_ORDER_TYPES_TL B
1513: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID
1514: and B.LANGUAGE = T.SOURCE_LANG)
1515: where (
1516: T.CHANGE_ORDER_TYPE_ID,

Line 1521: from ENG_CHANGE_ORDER_TYPES_TL SUBB, ENG_CHANGE_ORDER_TYPES_TL SUBT

1517: T.LANGUAGE
1518: ) in (select
1519: SUBT.CHANGE_ORDER_TYPE_ID,
1520: SUBT.LANGUAGE
1521: from ENG_CHANGE_ORDER_TYPES_TL SUBB, ENG_CHANGE_ORDER_TYPES_TL SUBT
1522: where SUBB.CHANGE_ORDER_TYPE_ID = SUBT.CHANGE_ORDER_TYPE_ID
1523: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1524: and (SUBB.TYPE_NAME <> SUBT.TYPE_NAME
1525: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 1533: insert into ENG_CHANGE_ORDER_TYPES_TL (

1529: or (SUBB.TAB_TEXT is null and SUBT.TAB_TEXT is not null)
1530: or (SUBB.TAB_TEXT is not null and SUBT.TAB_TEXT is null)
1531: ));
1532:
1533: insert into ENG_CHANGE_ORDER_TYPES_TL (
1534: CHANGE_ORDER_TYPE_ID,
1535: TYPE_NAME,
1536: DESCRIPTION,
1537: TAB_TEXT,

Line 1557: from ENG_CHANGE_ORDER_TYPES_TL B, FND_LANGUAGES L

1553: B.LAST_UPDATED_BY,
1554: B.LAST_UPDATE_LOGIN,
1555: L.LANGUAGE_CODE,
1556: B.SOURCE_LANG
1557: from ENG_CHANGE_ORDER_TYPES_TL B, FND_LANGUAGES L
1558: where L.INSTALLED_FLAG in ('I', 'B')
1559: and B.LANGUAGE = userenv('LANG')
1560: and not exists
1561: (select NULL

Line 1562: from ENG_CHANGE_ORDER_TYPES_TL T

1558: where L.INSTALLED_FLAG in ('I', 'B')
1559: and B.LANGUAGE = userenv('LANG')
1560: and not exists
1561: (select NULL
1562: from ENG_CHANGE_ORDER_TYPES_TL T
1563: where T.CHANGE_ORDER_TYPE_ID = B.CHANGE_ORDER_TYPE_ID
1564: and T.LANGUAGE = L.LANGUAGE_CODE);
1565: end ADD_LANGUAGE;
1566:

Line 1567: end ENG_CHANGE_ORDER_TYPES_PKG;

1563: where T.CHANGE_ORDER_TYPE_ID = B.CHANGE_ORDER_TYPE_ID
1564: and T.LANGUAGE = L.LANGUAGE_CODE);
1565: end ADD_LANGUAGE;
1566:
1567: end ENG_CHANGE_ORDER_TYPES_PKG;