APPS.AHL_COMPLETIONS_PVT dependencies on AHL_PRD_WORKORDER_PVT

Line 2552: fnd_log.string(l_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations.begin',

2548: BEGIN
2549:
2550:
2551: IF ( l_DEBUG_PROC >= l_DEBUG_LEVEL) THEN
2552: fnd_log.string(l_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations.begin',
2553: 'At the start of procedure for workorder_id:' || p_workorder_id);
2554: END IF;
2555:
2556: -- Initialize return status.

Line 2575: fnd_log.string(l_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations',

2571: p_scheduled_material_id => get_scheduled_mater_rec.scheduled_material_id );
2572:
2573: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2574: IF (l_DEBUG_STMT >= l_DEBUG_LEVEL) THEN
2575: fnd_log.string(l_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations',
2576: 'AHL_RSV_RESERVATIONS_PVT.Delete_Reservation failed for schedule material ID: '
2577: || get_scheduled_mater_rec.scheduled_material_id);
2578: END IF; -- x_return_status
2579:

Line 3067: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;

3063: l_mr_rec mr_rec_type;
3064: l_counter_tbl counter_tbl_type;
3065:
3066: l_child_wos_complete BOOLEAN := TRUE;
3067: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
3068: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
3069:
3070: l_mr_status VARCHAR2(30);
3071:

Line 3068: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;

3064: l_counter_tbl counter_tbl_type;
3065:
3066: l_child_wos_complete BOOLEAN := TRUE;
3067: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
3068: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
3069:
3070: l_mr_status VARCHAR2(30);
3071:
3072: CURSOR get_parent_master_wos( c_child_wip_entity_id NUMBER )

Line 3163: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;

3159:
3160: l_employee_id NUMBER;
3161: l_operation_seq_num NUMBER;
3162: l_resource_seq_num NUMBER;
3163: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
3164: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
3165: l_object_version_number NUMBER := NULL;
3166:
3167:

Line 3164: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;

3160: l_employee_id NUMBER;
3161: l_operation_seq_num NUMBER;
3162: l_resource_seq_num NUMBER;
3163: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
3164: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
3165: l_object_version_number NUMBER := NULL;
3166:
3167:
3168: BEGIN

Line 3243: AHL_PRD_WORKORDER_PVT.update_job

3239: l_up_workorder_rec.ACTUAL_END_HR := TO_NUMBER(TO_CHAR(l_up_workorder_rec.ACTUAL_END_DATE, 'HH24'));
3240: l_up_workorder_rec.ACTUAL_END_MI := TO_NUMBER(TO_CHAR(l_up_workorder_rec.ACTUAL_END_DATE, 'MI'));
3241: END IF;
3242:
3243: AHL_PRD_WORKORDER_PVT.update_job
3244: (
3245: p_api_version => 1.0 ,
3246: p_init_msg_list => FND_API.G_TRUE ,
3247: p_commit => FND_API.G_FALSE ,

Line 10194: l_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

10190: l_return_status VARCHAR2(1);
10191: l_msg_count NUMBER;
10192: l_msg_data VARCHAR2(2000);
10193:
10194: l_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
10195: l_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
10196: l_wo_count NUMBER;
10197:
10198: -- cursor to retrieve the visit master workorder

Line 10195: l_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;

10191: l_msg_count NUMBER;
10192: l_msg_data VARCHAR2(2000);
10193:
10194: l_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
10195: l_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
10196: l_wo_count NUMBER;
10197:
10198: -- cursor to retrieve the visit master workorder
10199: CURSOR get_visit_master_wo(c_visit_id NUMBER )

Line 10308: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

10304: CLOSE chk_cmplt_wo_exists;
10305: -- all jobs cancelled.
10306: -- cancel master workorder.
10307: IF (p_visit_id IS NOT NULL) THEN
10308: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
10309: (
10310: p_api_version => 1.0,
10311: p_init_msg_list => FND_API.G_TRUE,
10312: p_commit => FND_API.G_FALSE,

Line 10324: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

10320: p_unit_effectivity_id => NULL,
10321: p_workorder_id => NULL
10322: );
10323: ELSIF (p_ue_id IS NOT NULL) THEN
10324: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
10325: (
10326: p_api_version => 1.0,
10327: p_init_msg_list => FND_API.G_TRUE,
10328: p_commit => FND_API.G_FALSE,

Line 10340: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

10336: p_unit_effectivity_id => p_ue_id,
10337: p_workorder_id => NULL
10338: );
10339: ELSIF (p_workorder_id IS NOT NULL) THEN
10340: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
10341: (
10342: p_api_version => 1.0,
10343: p_init_msg_list => FND_API.G_TRUE,
10344: p_commit => FND_API.G_FALSE,