eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_VISITS_B

Line 1408: UPDATE AHL_VISITS_B

1404: END IF;
1405: END IF;
1406:
1407: IF x_return_status = 'S' THEN
1408: UPDATE AHL_VISITS_B
1409: SET PROJECT_ID = l_project_out.pa_project_id,
1410: OBJECT_VERSION_NUMBER = c_visit_rec.object_version_number + 1
1411: WHERE VISIT_ID = p_visit_id;
1412: -- RROY

Line 1620: FROM ahl_visits_b avb, pa_projects_all ppa

1616: /*sowsubra - starts*/
1617: -- To get the project status for visit updation
1618: CURSOR c_proj_status_code(x_id IN NUMBER) IS
1619: SELECT ppa.project_status_code
1620: FROM ahl_visits_b avb, pa_projects_all ppa
1621: WHERE avb.visit_id = x_id
1622: AND avb.project_id = ppa.project_id;
1623:
1624: l_prj_status_code_fdb pa_projects_all.project_status_code%TYPE;

Line 4089: ahl_visits_b v

4085: -- Yan added the condition to filter out summary tasks on 08/31/2005
4086: CURSOR get_independent_tasks(c_visit_id IN NUMBER) IS
4087: select t.visit_task_id
4088: from ahl_visit_tasks_b t,
4089: ahl_visits_b v
4090: where v.visit_id = c_visit_id
4091: and v.visit_id = t.visit_id
4092: and v.status_code = 'PARTIALLY RELEASED'
4093: and t.start_date_time < SYSDATE

Line 4117: FROM ahl_visits_b

4113:
4114: /* Added by rnahata for Bug 6447196 */
4115: CURSOR c_get_vst_status_and_date (c_visit_id IN NUMBER) IS
4116: SELECT status_code, close_date_time
4117: FROM ahl_visits_b
4118: WHERE visit_id = c_visit_id;
4119: get_vst_status_and_date_rec c_get_vst_status_and_date%ROWTYPE;
4120:
4121: /* Added by rnahata for Bug 5758813

Line 4926: UPDATE AHL_VISITS_B

4922: RAISE Fnd_Api.g_exc_error;
4923: END IF;
4924: --------------------------------- R12 changes For Serial Number Reservations End----------------------------------
4925:
4926: UPDATE AHL_VISITS_B
4927: SET STATUS_CODE = 'RELEASED',
4928: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
4929: WHERE VISIT_ID = p_visit_id;
4930:

Line 4932: UPDATE AHL_VISITS_B

4928: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
4929: WHERE VISIT_ID = p_visit_id;
4930:
4931: ELSE
4932: UPDATE AHL_VISITS_B
4933: SET STATUS_CODE = c_orig_visit_rec.STATUS_CODE,
4934: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
4935: WHERE VISIT_ID = p_visit_id;
4936: END IF;

Line 5365: SELECT 1 FROM AHL_VISITS_B

5361: l_temp_msg_count NUMBER:=0; --rnahata
5362:
5363: -- chk if the visit is valid
5364: CURSOR c_validate_visit (x_id IN NUMBER) IS
5365: SELECT 1 FROM AHL_VISITS_B
5366: WHERE VISIT_ID = x_id;
5367:
5368: -- chk if the visit is in partially released or planning status
5369: CURSOR c_visit_info (x_id IN NUMBER) IS

Line 5370: SELECT start_date_time,status_code FROM AHL_VISITS_B

5366: WHERE VISIT_ID = x_id;
5367:
5368: -- chk if the visit is in partially released or planning status
5369: CURSOR c_visit_info (x_id IN NUMBER) IS
5370: SELECT start_date_time,status_code FROM AHL_VISITS_B
5371: WHERE VISIT_ID = x_id
5372: AND NVL(STATUS_CODE,'X') IN ('PARTIALLY RELEASED', 'PLANNING');
5373:
5374: c_visit_info_rec c_visit_info%ROWTYPE;

Line 5833: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip

5829:
5830: --cursor to fetch master work order for the visit
5831: CURSOR c_fet_master_wo (x_visit_id IN NUMBER) IS
5832: SELECT wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date
5833: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip
5834: WHERE v.visit_id = x_visit_id
5835: AND NVL(v.status_code,'X') = 'PARTIALLY RELEASED'
5836: AND v.visit_id = wo.visit_id
5837: AND wo.visit_task_id IS NULL

Line 6222: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip

6218:
6219: --fetch master work order for the visit
6220: CURSOR c_visit_master_wo (x_visit_id IN NUMBER) IS
6221: SELECT wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date,wo.object_version_number
6222: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip
6223: WHERE v.visit_id = x_visit_id
6224: AND v.visit_id = wo.visit_id
6225: AND wo.visit_task_id IS NULL
6226: AND wo.master_workorder_flag = 'Y'

Line 6355: FROM ahl_visits_b vst, ahl_workorders wo, wip_discrete_jobs wdj

6351: AND status_code = 'PLANNING';
6352:
6353: CURSOR c_visit_time_matches_MWO_time(p_visit_id IN NUMBER) IS
6354: SELECT 1
6355: FROM ahl_visits_b vst, ahl_workorders wo, wip_discrete_jobs wdj
6356: WHERE vst.visit_id = p_visit_id
6357: AND wo.visit_id = vst.visit_id
6358: AND wo.MASTER_WORKORDER_FLAG = 'Y'
6359: AND wo.visit_task_id IS NULL

Line 6903: UPDATE ahl_visits_b

6899: 'Visit times and Master Work order times do not match. Setting Visit status to PARTIALLY RELEASED.');
6900: END IF;
6901: END IF;
6902:
6903: UPDATE ahl_visits_b
6904: SET status_code = 'PARTIALLY RELEASED'
6905: WHERE visit_id = p_visit_id;
6906: ELSE
6907: IF (l_log_statement >= l_log_current_level) THEN

Line 6913: UPDATE ahl_visits_b

6909: L_DEBUG_KEY,
6910: 'Setting Visit status to RELEASED.');
6911: END IF;
6912:
6913: UPDATE ahl_visits_b
6914: SET status_code = 'RELEASED',
6915: any_task_chg_flag ='N'
6916: WHERE visit_id = p_visit_id;
6917: END IF;

Line 7138: ahl_visits_b v

7134: -- Get all the parent tasks for a given UE that start in a past date
7135: CURSOR get_independent_tasks(x_visit_id IN NUMBER, x_unit_effectivity_id IN NUMBER) IS
7136: select distinct t.visit_task_id
7137: from ahl_visit_tasks_b t,
7138: ahl_visits_b v
7139: where v.visit_id = x_visit_id
7140: and v.visit_id = t.visit_id
7141: and v.status_code = 'PARTIALLY RELEASED'
7142: and t.start_date_time < SYSDATE

Line 8095: UPDATE ahl_visits_b

8091: FETCH c_get_wo_details into c_get_wo_details_rec;
8092: IF (c_visit_task_exists%NOTFOUND and
8093: c_visit_rec.start_date_time = c_get_wo_details_rec.scheduled_start_date and
8094: c_visit_rec.close_date_time = c_get_wo_details_rec.scheduled_completion_date) THEN
8095: UPDATE ahl_visits_b
8096: SET status_code = 'RELEASED',
8097: object_version_number = object_version_number + 1
8098: WHERE visit_id = c_visit_rec.visit_id;
8099:

Line 8883: FROM ahl_workorders wo, ahl_visits_b av

8879:
8880: --fetch the project id, visit start date and visit end date
8881: CURSOR get_visit_details_cur (p_wo_id IN NUMBER) IS
8882: SELECT wo.workorder_id, av.visit_id, av.project_id, av.start_date_time, av.close_date_time
8883: FROM ahl_workorders wo, ahl_visits_b av
8884: WHERE WO.WORKORDER_ID = p_wo_id
8885: AND wo.visit_id = av.visit_id
8886: AND wo.visit_task_id IS NULL
8887: AND wo.master_workorder_flag = 'Y';

Line 9269: -- UPDATE AHL_VISITS_B SET STATUS_CODE = 'PARTIALLY RELEASED',

9265: -- status with end date exceeding visit planned end date, then non-routine cannot be created
9266: IF TRUNC(l_visit_end_time) > TRUNC(c_visit_rec.close_date_time) THEN
9267: --yazhou Jul-20-2005 start
9268: -- Set visit status to partially released
9269: -- UPDATE AHL_VISITS_B SET STATUS_CODE = 'PARTIALLY RELEASED',
9270: -- OBJECT_VERSION_NUMBER = c_visit_rec.object_version_number + 1
9271: -- WHERE VISIT_ID = c_visit_rec.visit_id;
9272: --yazhou Jul-20-2005 end
9273:

Line 9485: UPDATE ahl_visits_b

9481: FETCH c_get_wo_details into c_get_wo_details_rec;
9482: IF (c_visit_task_exists%NOTFOUND and
9483: c_visit_rec.start_date_time = c_get_wo_details_rec.scheduled_start_date and
9484: c_visit_rec.close_date_time = c_get_wo_details_rec.scheduled_completion_date) THEN
9485: UPDATE ahl_visits_b
9486: SET status_code = 'RELEASED',
9487: object_version_number = object_version_number + 1
9488: WHERE visit_id = c_visit_rec.visit_id;
9489: