APPS.AHL_PRD_DF_PVT dependencies on AHL_PRD_WORKORDER_PVT

Line 3024: AHL_PRD_WORKORDER_PVT.validate_dependencies

3020:
3021: -- Skip for UMP Deferral
3022: IF NOT(is_ump_deferral(p_df_header_rec.unit_deferral_id)) THEN
3023:
3024: AHL_PRD_WORKORDER_PVT.validate_dependencies
3025: (
3026: p_api_version => 1.0,
3027: p_init_msg_list => FND_API.G_TRUE,
3028: p_commit => FND_API.G_FALSE,

Line 3829: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

3825: p_object_version_number IN NUMBER,
3826: p_approval_result_code IN VARCHAR2,
3827: x_return_status OUT NOCOPY VARCHAR2) IS
3828:
3829: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3830: l_temp_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3831:
3832:
3833: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

Line 3830: l_temp_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

3826: p_approval_result_code IN VARCHAR2,
3827: x_return_status OUT NOCOPY VARCHAR2) IS
3828:
3829: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3830: l_temp_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3831:
3832:
3833: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
3834:

Line 3833: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

3829: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3830: l_temp_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3831:
3832:
3833: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
3834:
3835: --rroy
3836: --ACL Changes
3837: -- Added object_type to query

Line 4169: AHL_PRD_WORKORDER_PVT.update_job

4165: CLOSE chk_inst_in_job;
4166: END IF;
4167: IF(x_return_status = FND_API.G_RET_STS_SUCCESS)THEN
4168: -- call update job API
4169: AHL_PRD_WORKORDER_PVT.update_job
4170: (
4171: p_api_version => 1.0,
4172: p_init_msg_list => FND_API.G_FALSE,
4173: p_commit => FND_API.G_FALSE,

Line 4188: 'Status after AHL_PRD_WORKORDER_PVT.update_job API call : ' || x_return_status

4184: fnd_log.string
4185: (
4186: fnd_log.level_statement,
4187: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4188: 'Status after AHL_PRD_WORKORDER_PVT.update_job API call : ' || x_return_status
4189: );
4190: END IF;
4191: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4192: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_UPD_JB_FAIL');

Line 4199: 'AHL_PRD_WORKORDER_PVT.update_job API returned error '

4195: fnd_log.string
4196: (
4197: fnd_log.level_unexpected,
4198: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4199: 'AHL_PRD_WORKORDER_PVT.update_job API returned error '
4200: );
4201: END IF;
4202: EXIT;
4203: END IF;

Line 4228: AHL_PRD_WORKORDER_PVT.update_job

4224: --l_prd_workorder_rec.actual_start_date := NVL(l_prd_workorder_rec.actual_start_date,SYSDATE);
4225: --l_prd_workorder_rec.actual_end_date := NVL(l_prd_workorder_rec.actual_end_date,SYSDATE);
4226:
4227: -- call update job API
4228: AHL_PRD_WORKORDER_PVT.update_job
4229: (
4230: p_api_version => 1.0,
4231: p_init_msg_list => FND_API.G_FALSE,
4232: p_commit => FND_API.G_FALSE,

Line 4247: 'Status after AHL_PRD_WORKORDER_PVT.update_job API call : ' || x_return_status

4243: fnd_log.string
4244: (
4245: fnd_log.level_statement,
4246: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4247: 'Status after AHL_PRD_WORKORDER_PVT.update_job API call : ' || x_return_status
4248: );
4249: END IF;
4250: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4251: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_UPD_JB_FAIL');

Line 4258: 'AHL_PRD_WORKORDER_PVT.update_job API returned error '

4254: fnd_log.string
4255: (
4256: fnd_log.level_unexpected,
4257: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4258: 'AHL_PRD_WORKORDER_PVT.update_job API returned error '
4259: );
4260: END IF;
4261: EXIT;
4262: END IF; */

Line 4314: 'before ahl.plsql.AHL_PRD_WORKORDER_PVT.cancel_visit_jobs',

4310: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4311: fnd_log.string
4312: (
4313: fnd_log.level_statement,
4314: 'before ahl.plsql.AHL_PRD_WORKORDER_PVT.cancel_visit_jobs',
4315: 'Workorder Cancel Visits Jobs '
4316: );
4317: END IF;
4318:

Line 4328: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.cancel_visit_jobs',

4324: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4325: fnd_log.string
4326: (
4327: fnd_log.level_statement,
4328: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.cancel_visit_jobs',
4329: 'Workorder Cancel Visits Jobs '
4330: );
4331: END IF;
4332:

Line 4335: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

4331: END IF;
4332:
4333: -- if approval was approved, cancel all workorders
4334: IF (p_approval_result_code = G_DEFERRAL_APPROVED)THEN
4335: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
4336: (
4337: p_api_version => 1.0,
4338: p_init_msg_list => FND_API.G_TRUE,
4339: p_commit => FND_API.G_FALSE,