[Home] [Help]
492: SET priority_code = nvl(l_wo_priority, priority_code)
493: WHERE asset_activity_id = p_target_activity_id AND maintenance_object_id = l_cur_maintenance_object_id
494: AND maintenance_object_type = l_cur_maintenance_object_type;
495:
496: UPDATE eam_org_maint_defaults
497: SET accounting_class_code = nvl(l_wo_wac, accounting_class_code),
498: owning_department_id = nvl(l_wo_dept_id, owning_department_id),
499: tagging_required_flag = nvl(l_wo_tagout, tagging_required_flag)
500: WHERE object_id in (SELECT activity_association_id
1335: ELSE
1336: l_object_type := 60;
1337: END IF;
1338:
1339: eam_org_maint_defaults_pvt.insert_row
1340: (
1341: p_api_version => 1.0
1342: ,p_object_type => l_object_type
1343: ,p_object_id => l_act_assoc_tbl(l_act_assoc_tbl_index).activity_association_id
1500: meaa.Prev_Scheduled_Start_Date, meaa.Prev_Scheduled_End_Date,
1501: meaa.Activity_Association_Id, eomd.organization_id, eomd.accounting_class_code, eomd.owning_department_id,
1502: eomd.Activity_Cause_Code, eomd.Activity_Type_Code, eomd.Activity_Source_Code,
1503: eomd.Tagging_Required_Flag, eomd.Shutdown_Type_Code
1504: FROM mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
1505: WHERE maintenance_object_id = p_maintenance_object_id AND maintenance_object_type = 2
1506: AND tmpl_flag = 'Y' AND meaa.Activity_Association_Id = eomd.object_id(+) AND eomd.object_type(+) = 40
1507: AND eomd.organization_id(+) = p_organization_id;
1508: -- 2735563: Simply pick up ALL templates and copy the start and end dates to the association records
1713: END;
1714:
1715: IF l_asset_activity_row.organization_id IS NOT NULL THEN
1716:
1717: eam_org_maint_defaults_pvt.insert_row
1718: (
1719: p_api_version => 1.0
1720: ,p_object_type => 60
1721: ,p_object_id => l_next_association_id