[Home] [Help]
517: SET priority_code = nvl(l_wo_priority, priority_code)
518: WHERE asset_activity_id = p_target_activity_id AND maintenance_object_id = l_cur_maintenance_object_id
519: AND maintenance_object_type = l_cur_maintenance_object_type;
520:
521: UPDATE eam_org_maint_defaults
522: SET accounting_class_code = nvl(l_wo_wac, accounting_class_code),
523: owning_department_id = nvl(l_wo_dept_id, owning_department_id),
524: tagging_required_flag = nvl(l_wo_tagout, tagging_required_flag)
525: WHERE object_id in (SELECT activity_association_id
1416: ELSE
1417: l_object_type := 60;
1418: END IF;
1419:
1420: eam_org_maint_defaults_pvt.insert_row
1421: (
1422: p_api_version => 1.0
1423: ,p_object_type => l_object_type
1424: ,p_object_id => l_act_assoc_tbl(l_act_assoc_tbl_index).activity_association_id
1588: eomd.Activity_Cause_Code, eomd.Activity_Type_Code, eomd.Activity_Source_Code,
1589: eomd.Tagging_Required_Flag, eomd.Shutdown_Type_Code
1590: , eomd.Work_Order_Type, eomd.Planner_Maintenance AS planner, eomd.Plan_Maintenance AS planned -- added for 16525236
1591: , eomd.Firm_Planned_Flag as firm, eomd.Notification_Required -- ended for 16525236
1592: FROM mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
1593: WHERE maintenance_object_id = p_maintenance_object_id AND maintenance_object_type = 2
1594: AND tmpl_flag = 'Y' AND meaa.Activity_Association_Id = eomd.object_id(+) AND eomd.object_type(+) = 40
1595: AND eomd.organization_id(+) = p_organization_id;
1596: -- 2735563: Simply pick up ALL templates and copy the start and end dates to the association records
1801: END;
1802:
1803: IF l_asset_activity_row.organization_id IS NOT NULL THEN
1804:
1805: eam_org_maint_defaults_pvt.insert_row
1806: (
1807: p_api_version => 1.0
1808: ,p_object_type => 60
1809: ,p_object_id => l_next_association_id