APPS.AHL_PRD_DF_PVT dependencies on AHL_PRD_WORKORDER_PVT

Line 2914: AHL_PRD_WORKORDER_PVT.validate_dependencies

2910:
2911: -- Skip for UMP Deferral
2912: IF NOT(is_ump_deferral(p_df_header_rec.unit_deferral_id)) THEN
2913:
2914: AHL_PRD_WORKORDER_PVT.validate_dependencies
2915: (
2916: p_api_version => 1.0,
2917: p_init_msg_list => FND_API.G_TRUE,
2918: p_commit => FND_API.G_FALSE,

Line 3673: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

3669: p_object_version_number IN NUMBER,
3670: p_approval_result_code IN VARCHAR2,
3671: x_return_status OUT NOCOPY VARCHAR2) IS
3672:
3673: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3674: l_temp_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3675:
3676:
3677: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

Line 3674: l_temp_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

3670: p_approval_result_code IN VARCHAR2,
3671: x_return_status OUT NOCOPY VARCHAR2) IS
3672:
3673: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3674: l_temp_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3675:
3676:
3677: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
3678:

Line 3677: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

3673: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3674: l_temp_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3675:
3676:
3677: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
3678:
3679: --rroy
3680: --ACL Changes
3681: -- Added object_type to query

Line 4013: AHL_PRD_WORKORDER_PVT.update_job

4009: CLOSE chk_inst_in_job;
4010: END IF;
4011: IF(x_return_status = FND_API.G_RET_STS_SUCCESS)THEN
4012: -- call update job API
4013: AHL_PRD_WORKORDER_PVT.update_job
4014: (
4015: p_api_version => 1.0,
4016: p_init_msg_list => FND_API.G_FALSE,
4017: p_commit => FND_API.G_FALSE,

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

4028: fnd_log.string
4029: (
4030: fnd_log.level_statement,
4031: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4032: 'Status after AHL_PRD_WORKORDER_PVT.update_job API call : ' || x_return_status
4033: );
4034: END IF;
4035: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4036: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_UPD_JB_FAIL');

Line 4043: 'AHL_PRD_WORKORDER_PVT.update_job API returned error '

4039: fnd_log.string
4040: (
4041: fnd_log.level_unexpected,
4042: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4043: 'AHL_PRD_WORKORDER_PVT.update_job API returned error '
4044: );
4045: END IF;
4046: EXIT;
4047: END IF;

Line 4072: AHL_PRD_WORKORDER_PVT.update_job

4068: --l_prd_workorder_rec.actual_start_date := NVL(l_prd_workorder_rec.actual_start_date,SYSDATE);
4069: --l_prd_workorder_rec.actual_end_date := NVL(l_prd_workorder_rec.actual_end_date,SYSDATE);
4070:
4071: -- call update job API
4072: AHL_PRD_WORKORDER_PVT.update_job
4073: (
4074: p_api_version => 1.0,
4075: p_init_msg_list => FND_API.G_FALSE,
4076: p_commit => FND_API.G_FALSE,

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

4087: fnd_log.string
4088: (
4089: fnd_log.level_statement,
4090: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4091: 'Status after AHL_PRD_WORKORDER_PVT.update_job API call : ' || x_return_status
4092: );
4093: END IF;
4094: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4095: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_UPD_JB_FAIL');

Line 4102: 'AHL_PRD_WORKORDER_PVT.update_job API returned error '

4098: fnd_log.string
4099: (
4100: fnd_log.level_unexpected,
4101: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4102: 'AHL_PRD_WORKORDER_PVT.update_job API returned error '
4103: );
4104: END IF;
4105: EXIT;
4106: END IF; */

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

4154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4155: fnd_log.string
4156: (
4157: fnd_log.level_statement,
4158: 'before ahl.plsql.AHL_PRD_WORKORDER_PVT.cancel_visit_jobs',
4159: 'Workorder Cancel Visits Jobs '
4160: );
4161: END IF;
4162:

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

4168: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4169: fnd_log.string
4170: (
4171: fnd_log.level_statement,
4172: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.cancel_visit_jobs',
4173: 'Workorder Cancel Visits Jobs '
4174: );
4175: END IF;
4176:

Line 4179: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

4175: END IF;
4176:
4177: -- if approval was approved, cancel all workorders
4178: IF (p_approval_result_code = G_DEFERRAL_APPROVED)THEN
4179: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
4180: (
4181: p_api_version => 1.0,
4182: p_init_msg_list => FND_API.G_TRUE,
4183: p_commit => FND_API.G_FALSE,