APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on AHL_PRD_WORKORDER_PVT

Line 1077: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;

1073: wipj.wip_entity_id = c_wip_entity_id;
1074:
1075: l_visit_sch_end_date DATE;
1076: l_mwo_details_rec c_get_mwo_details%ROWTYPE;
1077: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
1078: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
1079: l_api_name CONSTANT VARCHAR2(30) := 'EXPAND_MASTER_WO_DATES';
1080: l_return_status VARCHAR2(1);
1081: l_msg_count NUMBER;

Line 1078: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;

1074:
1075: l_visit_sch_end_date DATE;
1076: l_mwo_details_rec c_get_mwo_details%ROWTYPE;
1077: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
1078: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
1079: l_api_name CONSTANT VARCHAR2(30) := 'EXPAND_MASTER_WO_DATES';
1080: l_return_status VARCHAR2(1);
1081: l_msg_count NUMBER;
1082: l_msg_data VARCHAR2(2000);

Line 1129: 'Before calling AHL_PRD_WORKORDER_PVT.update_job'

1125: THEN
1126: fnd_log.string(
1127: FND_LOG.LEVEL_STATEMENT,
1128: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1129: 'Before calling AHL_PRD_WORKORDER_PVT.update_job'
1130: );
1131: fnd_log.string(
1132: FND_LOG.LEVEL_STATEMENT,
1133: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 1150: AHL_PRD_WORKORDER_PVT.update_job

1146: END IF;
1147:
1148: -- The work order is expanded such that the end date of the work order
1149: -- is same as that of visit master work orders end date.
1150: AHL_PRD_WORKORDER_PVT.update_job
1151: (
1152: p_api_version => 1.0 ,
1153: p_init_msg_list => FND_API.G_FALSE ,
1154: p_commit => FND_API.G_FALSE ,

Line 1175: 'After calling AHL_PRD_WORKORDER_PVT.update_job'

1171: THEN
1172: fnd_log.string(
1173: FND_LOG.LEVEL_STATEMENT,
1174: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1175: 'After calling AHL_PRD_WORKORDER_PVT.update_job'
1176: );
1177: END IF;
1178:
1179: END Expand_Master_Wo_Dates;

Line 4037: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;

4033: l_msg_count NUMBER;
4034: l_return_status VARCHAR2(1);
4035: l_msg_data VARCHAR2(2000);
4036: l_resrc_Require_rec AHL_PP_RESRC_Require_PVT.Resrc_Require_Rec_Type;
4037: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
4038: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
4039: l_plan_flag NUMBER;
4040:
4041: CURSOR c_check_planned_wo(c_workorder_id IN NUMBER)

Line 4038: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;

4034: l_return_status VARCHAR2(1);
4035: l_msg_data VARCHAR2(2000);
4036: l_resrc_Require_rec AHL_PP_RESRC_Require_PVT.Resrc_Require_Rec_Type;
4037: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
4038: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
4039: l_plan_flag NUMBER;
4040:
4041: CURSOR c_check_planned_wo(c_workorder_id IN NUMBER)
4042: IS

Line 4178: AHL_PRD_WORKORDER_PVT.Update_Master_Wo_Dates(p_x_resrc_Require_tbl(l_res_count).workorder_id);

4174: CLOSE c_check_planned_wo;
4175:
4176: IF l_plan_flag = 2 THEN
4177:
4178: AHL_PRD_WORKORDER_PVT.Update_Master_Wo_Dates(p_x_resrc_Require_tbl(l_res_count).workorder_id);
4179:
4180: END IF;
4181:
4182: END LOOP;

Line 4202: AHL_PRD_WORKORDER_PVT.update_job

4198: IF l_plan_flag = 2 THEN
4199:
4200: l_up_workorder_rec.WORKORDER_ID := p_x_resrc_Require_tbl(i).workorder_id;
4201:
4202: AHL_PRD_WORKORDER_PVT.update_job
4203: (
4204: p_api_version => 1.0 ,
4205: p_init_msg_list => FND_API.G_FALSE ,
4206: p_commit => FND_API.G_FALSE ,