[Home] [Help]
91:
92: X_Model NUMBER := 1;
93: X_OptionClass NUMBER := 2;
94: X_Planning NUMBER := 3;
95: X_Standard NUMBER := 4;
96:
97: BEGIN
98: -- Standard Start of API savepoint
99: SAVEPOINT Implement_ECO_PUB;
94: X_Planning NUMBER := 3;
95: X_Standard NUMBER := 4;
96:
97: BEGIN
98: -- Standard Start of API savepoint
99: SAVEPOINT Implement_ECO_PUB;
100:
101: -- Standard call to check for call compatibility
102: IF NOT FND_API.Compatible_API_Call ( l_api_version
97: BEGIN
98: -- Standard Start of API savepoint
99: SAVEPOINT Implement_ECO_PUB;
100:
101: -- Standard call to check for call compatibility
102: IF NOT FND_API.Compatible_API_Call ( l_api_version
103: ,p_api_version
104: ,l_api_name
105: ,G_PKG_NAME )
304:
305: END IF ;
306:
307:
308: -- Standard ending code ------------------------------------------------
309: -- IF FND_API.To_Boolean ( p_commit ) THEN
310: --Always commit to save request id.
311: COMMIT ;
312: -- END IF;
394:
395: X_Model NUMBER := 1;
396: X_OptionClass NUMBER := 2;
397: X_Planning NUMBER := 3;
398: X_Standard NUMBER := 4;
399:
400: BEGIN
401:
402: -- Standard Start of API savepoint
398: X_Standard NUMBER := 4;
399:
400: BEGIN
401:
402: -- Standard Start of API savepoint
403: SAVEPOINT Implement_ECO_PUB;
404:
405: -- Standard call to check for call compatibility
406: IF NOT FND_API.Compatible_API_Call ( l_api_version
401:
402: -- Standard Start of API savepoint
403: SAVEPOINT Implement_ECO_PUB;
404:
405: -- Standard call to check for call compatibility
406: IF NOT FND_API.Compatible_API_Call ( l_api_version
407: ,p_api_version
408: ,l_api_name
409: ,G_PKG_NAME )
462: Select null
463: From mtl_system_items msi
464: Where msi.inventory_item_id = eri.revised_item_id
465: And msi.organization_id = eri.organization_Id
466: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
467: And rownum = 1
468: )
469: And rownum = 1;
470: */
615:
616: END IF ;
617:
618:
619: -- Standard ending code ------------------------------------------------
620: IF FND_API.To_Boolean ( p_commit ) THEN
621: COMMIT WORK;
622: END IF;
623:
701: l_api_version CONSTANT NUMBER := 1.0;
702: l_return_status VARCHAR2(1);
703: BEGIN
704:
705: -- Standard Start of API savepoint
706: SAVEPOINT Propagate_ECO_PUB;
707:
708: -- Standard call to check for call compatibility
709: IF NOT FND_API.Compatible_API_Call ( l_api_version
704:
705: -- Standard Start of API savepoint
706: SAVEPOINT Propagate_ECO_PUB;
707:
708: -- Standard call to check for call compatibility
709: IF NOT FND_API.Compatible_API_Call ( l_api_version
710: ,p_api_version
711: ,l_api_name
712: ,G_PKG_NAME )
884: , x_msg_count => x_msg_count
885: , x_msg_data => x_msg_data
886: ) ;
887:
888: -- Standard ending code ------------------------------------------------
889: IF FND_API.To_Boolean ( p_commit ) THEN
890: COMMIT WORK;
891: END IF;
892:
968: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
969: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
970: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
971: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
972: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
973: X_Model NUMBER := 1;
974: X_OptionClass NUMBER := 2;
975: X_Planning NUMBER := 3;
976: X_Standard NUMBER := 4;
972: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
973: X_Model NUMBER := 1;
974: X_OptionClass NUMBER := 2;
975: X_Planning NUMBER := 3;
976: X_Standard NUMBER := 4;
977: x_change_notice VARCHAR2(10);
978: x_organization_id NUMBER;
979:
980: -- Status Lookups
999: AND bcb.IMPLEMENTATION_DATE IS NULL;
1000:
1001: BEGIN
1002:
1003: -- Standard Start of API savepoint
1004: SAVEPOINT Reschedule_ECO_PUB;
1005:
1006: -- begin of vamohan changes
1007: is_Reschedule_ECO_Allowed(p_change_id, x_is_Chg_Sch_Date_Allowed);
1014: END IF;
1015: -- end of vamohan changes
1016:
1017:
1018: -- Standard call to check for call compatibility
1019: IF NOT FND_API.Compatible_API_Call ( l_api_version
1020: ,p_api_version
1021: ,l_api_name
1022: ,G_PKG_NAME )
1062: X_Model := null;
1063: X_OptionClass := null;
1064: END IF;
1065:
1066: IF x_standard_item_access = 2 THEN
1067: X_Standard := null;
1068: END IF;
1069:
1070: SELECT change_notice, organization_id
1063: X_OptionClass := null;
1064: END IF;
1065:
1066: IF x_standard_item_access = 2 THEN
1067: X_Standard := null;
1068: END IF;
1069:
1070: SELECT change_notice, organization_id
1071: INTO x_change_notice, x_organization_id
1087: Select null
1088: From mtl_system_items msi
1089: Where msi.inventory_item_id = eri.revised_item_id
1090: And msi.organization_id = eri.organization_Id
1091: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1092: );
1093:
1094: IF FND_API.to_Boolean( p_debug ) THEN
1095: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1141: 9, -- IMPLEMENTATION_IN_PROGRESS
1142: 2 -- HOLD
1143: )
1144: And msi.bom_item_type in
1145: (X_Model, X_OptionClass, X_Planning, X_Standard);
1146:
1147: IF FND_API.to_Boolean( p_debug ) THEN
1148: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Current_Scheduled_Dates inserted ... ' );
1149: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1248: FROM mtl_system_items msi
1249: WHERE msi.inventory_item_id = eri.revised_item_id
1250: AND msi.organization_id = eri.organization_Id
1251: AND msi.bom_item_type in (X_Model, X_OptionClass,
1252: X_Planning, X_Standard)));
1253:
1254:
1255: -------not required to insert to MTL_ITEM_REVISIONS_TL as description is not there.
1256:
1283: FROM mtl_system_items msi
1284: WHERE msi.inventory_item_id = eri.revised_item_id
1285: AND msi.organization_id = eri.organization_Id
1286: AND msi.bom_item_type in (X_Model, X_OptionClass,
1287: X_Planning, X_Standard)));
1288:
1289: IF FND_API.to_Boolean( p_debug ) THEN
1290: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
1291: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1300:
1301: END IF;
1302:
1303:
1304: -- Standard ending code ------------------------------------------------
1305: IF FND_API.To_Boolean ( p_commit ) THEN
1306: COMMIT WORK;
1307: END IF;
1308:
1381: x_user_id NUMBER := to_number(Fnd_Profile.Value('USER_ID'));
1382: x_login_id NUMBER := to_number(Fnd_Profile.Value('LOGIN_ID'));
1383: x_planning_item_access NUMBER := Fnd_Profile.Value('BOM:PLANNING_ITEM_ACCESS');
1384: x_model_item_access NUMBER := Fnd_Profile.Value('BOM:ITEM_ACCESS');
1385: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1386: X_Model NUMBER := 1;
1387: X_OptionClass NUMBER := 2;
1388: X_Planning NUMBER := 3;
1389: X_Standard NUMBER := 4;
1385: x_standard_item_access NUMBER := Fnd_Profile.Value('BOM:STANDARD_ITEM_ACCESS');
1386: X_Model NUMBER := 1;
1387: X_OptionClass NUMBER := 2;
1388: X_Planning NUMBER := 3;
1389: X_Standard NUMBER := 4;
1390: x_change_notice VARCHAR2(10);
1391: x_organization_id NUMBER;
1392:
1393: -- Status Lookups
1409: OR bcb.common_component_sequence_id = bcb.component_sequence_id)
1410: AND bcb.IMPLEMENTATION_DATE IS NULL;
1411: BEGIN
1412:
1413: -- Standard Start of API savepoint
1414: SAVEPOINT Change_Effectivity_Date_PUB;
1415:
1416: -- Standard call to check for call compatibility
1417: IF NOT FND_API.Compatible_API_Call ( l_api_version
1412:
1413: -- Standard Start of API savepoint
1414: SAVEPOINT Change_Effectivity_Date_PUB;
1415:
1416: -- Standard call to check for call compatibility
1417: IF NOT FND_API.Compatible_API_Call ( l_api_version
1418: ,p_api_version
1419: ,l_api_name
1420: ,G_PKG_NAME )
1459: X_Model := null;
1460: X_OptionClass := null;
1461: END IF;
1462:
1463: IF x_standard_item_access = 2 THEN
1464: X_Standard := null;
1465: END IF;
1466:
1467: SELECT change_notice, organization_id
1460: X_OptionClass := null;
1461: END IF;
1462:
1463: IF x_standard_item_access = 2 THEN
1464: X_Standard := null;
1465: END IF;
1466:
1467: SELECT change_notice, organization_id
1468: INTO x_change_notice, x_organization_id
1484: Select null
1485: From mtl_system_items msi
1486: Where msi.inventory_item_id = eri.revised_item_id
1487: And msi.organization_id = eri.organization_Id
1488: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1489: );
1490:
1491: IF FND_API.to_Boolean( p_debug ) THEN
1492: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1598: FROM mtl_system_items msi
1599: WHERE msi.inventory_item_id = eri.revised_item_id
1600: AND msi.organization_id = eri.organization_Id
1601: AND msi.bom_item_type in (X_Model, X_OptionClass,
1602: X_Planning, X_Standard)));
1603: --no updation of mtl_item_revisions_tl
1604:
1605:
1606: IF FND_API.to_Boolean( p_debug ) THEN
1629: FROM mtl_system_items msi
1630: WHERE msi.inventory_item_id = eri.revised_item_id
1631: AND msi.organization_id = eri.organization_Id
1632: AND msi.bom_item_type in (X_Model, X_OptionClass,
1633: X_Planning, X_Standard)));
1634:
1635: IF FND_API.to_Boolean( p_debug ) THEN
1636: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
1637: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1646:
1647: END IF;
1648:
1649:
1650: -- Standard ending code ------------------------------------------------
1651: IF FND_API.To_Boolean ( p_commit ) THEN
1652: COMMIT WORK;
1653: END IF;
1654:
1760: , last_updated_by
1761: , creation_date
1762: , created_by
1763: , last_update_login
1764: , standard_operation_id
1765: , department_id
1766: , operation_lead_time_percent
1767: , minimum_transfer_quantity
1768: , count_point_type
1825: , p_user_id -- Last Updated By
1826: , SYSDATE -- Creation Date
1827: , p_user_id -- Created By
1828: , p_login_id -- Last Update Login
1829: , bos.STANDARD_OPERATION_ID
1830: , bos.DEPARTMENT_ID
1831: , bos.OPERATION_LEAD_TIME_PERCENT
1832: , bos.MINIMUM_TRANSFER_QUANTITY
1833: , bos.COUNT_POINT_TYPE
2463: THEN
2464: --
2465: -- Get respective profile values
2466: --
2467: IF fnd_profile.value('BOM:STANDARD_ITEM_ACCESS') = '1'
2468: THEN
2469: Eng_Globals.Set_STD_Item_Access
2470: ( p_std_item_access => 4);
2471: ELSE
4287:
4288:
4289: l_pls_block VARCHAR2(5000);
4290: BEGIN
4291: -- Standard Start of API savepoint
4292: -- Standard Start of API savepoint
4293: SAVEPOINT Init_Lifecycle;
4294: -- Standard call to check for call compatibility
4295: IF NOT FND_API.Compatible_API_Call ( l_api_version
4288:
4289: l_pls_block VARCHAR2(5000);
4290: BEGIN
4291: -- Standard Start of API savepoint
4292: -- Standard Start of API savepoint
4293: SAVEPOINT Init_Lifecycle;
4294: -- Standard call to check for call compatibility
4295: IF NOT FND_API.Compatible_API_Call ( l_api_version
4296: ,p_api_version
4290: BEGIN
4291: -- Standard Start of API savepoint
4292: -- Standard Start of API savepoint
4293: SAVEPOINT Init_Lifecycle;
4294: -- Standard call to check for call compatibility
4295: IF NOT FND_API.Compatible_API_Call ( l_api_version
4296: ,p_api_version
4297: ,l_api_name
4298: ,G_PKG_NAME )