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 440: SELECT * FROM AHL_VISITS_B

436: l_module_type VARCHAR2(3) := p_module_type;
437:
438: -- To find visit related information
439: CURSOR c_visit (c_id IN NUMBER) IS
440: SELECT * FROM AHL_VISITS_B
441: WHERE VISIT_ID = c_id
442: FOR UPDATE OF OBJECT_VERSION_NUMBER;
443: c_visit_rec c_visit%ROWTYPE;
444:

Line 450: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB

446: --salogan::Modified the cursor to handle both request id from P2P and Cost Estimation CP ER 9299910::01-JUN-2009::BEGIN
447: --Cursor to fetch phase
448: CURSOR c_conc_req_phase(c_id IN NUMBER) IS
449: SELECT 'X'
450: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB
451: WHERE FCR.REQUEST_ID IN ( AVB.CST_EST_REQUEST_ID, AVB.REQUEST_ID )
452: AND FCR.PHASE_CODE IN ('P', 'R')
453: AND AVB.VISIT_ID = c_id;
454: l_dummy_val c_conc_req_phase%ROWTYPE;

Line 461: FROM ahl_visits_b

457: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063
458: --Get visit status
459: CURSOR get_visit_status (c_visit_id IN NUMBER) IS
460: SELECT status_code
461: FROM ahl_visits_b
462: WHERE visit_id = c_visit_id;
463:
464: --CHANGES by jrotich bug #13028686 begin
465: CURSOR c_stages_without_types(c_visit_id IN NUMBER ) IS

Line 666: UPDATE ahl_visits_b

662: END IF;
663:
664: x_request_id := l_req_id;
665: --Update the table with l_req_id
666: UPDATE ahl_visits_b
667: SET REQUEST_ID = l_req_id,
668: OBJECT_VERSION_NUMBER = object_version_number + 1,-- PRAKKUM :: PIE :: 13-OCT-2010 ::
669: LAST_UPDATE_DATE = SYSDATE,
670: LAST_UPDATED_BY = Fnd_Global.USER_ID,

Line 774: SELECT visit_id INTO l_visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;

770: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
771: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
772: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
773:
774: SELECT visit_id INTO l_visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;
775:
776: IF l_visit_id IS NOT NULL THEN
777:
778: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Release_visit');

Line 2203: UPDATE AHL_VISITS_B

2199: END IF;
2200: END IF;
2201:
2202: IF x_return_status = 'S' THEN
2203: UPDATE AHL_VISITS_B
2204: SET PROJECT_ID = l_project_out.pa_project_id,
2205: OBJECT_VERSION_NUMBER = c_visit_rec.object_version_number + 1,
2206: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
2207: LAST_UPDATE_DATE = SYSDATE,

Line 2474: CURSOR get_vst_prj_top_task(c_project_id IN AHL_VISITS_B.PROJECT_ID%TYPE, c_visit_id IN AHL_VISITS_B.VISIT_ID%TYPE) IS

2470: AND PPEV.PROJ_ELEMENT_ID = CURR.TASK_ID
2471: AND PPEV.PROJECT_ID = c_project_id
2472: ORDER BY PPEV.DISPLAY_SEQUENCE;
2473:
2474: CURSOR get_vst_prj_top_task(c_project_id IN AHL_VISITS_B.PROJECT_ID%TYPE, c_visit_id IN AHL_VISITS_B.VISIT_ID%TYPE) IS
2475: SELECT distinct PTSKS.TOP_TASK_ID TOP_TASK_ID
2476: FROM AHL_VISIT_TASKS_VL VT, PA_PROJ_ELEMENT_VERSIONS PPEV, PA_TASKS PTSKS
2477: WHERE PPEV.PROJECT_ID = c_project_id
2478: AND PPEV.PROJ_ELEMENT_ID = VT.PROJECT_TASK_ID

Line 2550: FROM ahl_visits_b avb, pa_projects_all ppa

2546: /*sowsubra - starts*/
2547: -- To get the project status for visit updation
2548: CURSOR c_proj_status_code(x_id IN NUMBER) IS
2549: SELECT ppa.project_status_code
2550: FROM ahl_visits_b avb, pa_projects_all ppa
2551: WHERE avb.visit_id = x_id
2552: AND avb.project_id = ppa.project_id;
2553:
2554: l_prj_status_code_fdb pa_projects_all.project_status_code%TYPE;

Line 2637: AHL_VISITS_B vst

2633: further transactions will be done only over repair batch task itself */
2634: CURSOR is_rep_batch_have_trans(c_visit_id IN NUMBER)
2635: IS
2636: SELECT 'Y' FROM
2637: AHL_VISITS_B vst
2638: WHERE
2639: visit_id = c_visit_id AND
2640: EXISTS (
2641: SELECT 1

Line 3779: -- Update AHL_VISITS_B.TOP_PROJECT_TASK_ID with the top task id just created

3775: IF (l_log_statement >= l_log_current_level) THEN
3776: fnd_log.string(l_log_statement,L_DEBUG_KEY,'l_top_task_id = ' || l_top_task_id);
3777: END IF;
3778:
3779: -- Update AHL_VISITS_B.TOP_PROJECT_TASK_ID with the top task id just created
3780: IF l_top_task_id IS NOT NULL THEN
3781: UPDATE AHL_VISITS_B
3782: SET TOP_PROJECT_TASK_ID = l_top_task_id
3783: WHERE VISIT_ID = p_visit_id;

Line 3781: UPDATE AHL_VISITS_B

3777: END IF;
3778:
3779: -- Update AHL_VISITS_B.TOP_PROJECT_TASK_ID with the top task id just created
3780: IF l_top_task_id IS NOT NULL THEN
3781: UPDATE AHL_VISITS_B
3782: SET TOP_PROJECT_TASK_ID = l_top_task_id
3783: WHERE VISIT_ID = p_visit_id;
3784: END IF;
3785: END IF; -- c_visit_rec.PROJECT_ID IS NOT NULL

Line 6227: ahl_visits_b v

6223: -- Yan added the condition to filter out summary tasks on 08/31/2005
6224: CURSOR get_independent_tasks(c_visit_id IN NUMBER) IS
6225: select t.visit_task_id
6226: from ahl_visit_tasks_b t,
6227: ahl_visits_b v
6228: where v.visit_id = c_visit_id
6229: and v.visit_id = t.visit_id
6230: --and v.status_code = 'PARTIALLY RELEASED'
6231: and v.status_code IN ('PLANNING', 'PARTIALLY RELEASED') -- PRAKKUM :: BUG Internal :: 19/01/2012 :: Task Time Adjustments

Line 6258: FROM ahl_visits_b

6254:
6255: /* Added by rnahata for Bug 6447196 */
6256: CURSOR c_get_vst_status_and_date (c_visit_id IN NUMBER) IS
6257: SELECT status_code, close_date_time
6258: FROM ahl_visits_b
6259: WHERE visit_id = c_visit_id;
6260: get_vst_status_and_date_rec c_get_vst_status_and_date%ROWTYPE;
6261:
6262: /* Added by rnahata for Bug 5758813

Line 7476: UPDATE AHL_VISITS_B

7472: END IF;
7473: END IF;
7474: END LOOP;
7475:
7476: UPDATE AHL_VISITS_B
7477: SET STATUS_CODE = 'RELEASED',
7478: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7479: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
7480: LAST_UPDATE_DATE = SYSDATE,

Line 7486: UPDATE AHL_VISITS_B

7482: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7483: WHERE VISIT_ID = p_visit_id;
7484:
7485: ELSE
7486: UPDATE AHL_VISITS_B
7487: SET STATUS_CODE = c_orig_visit_rec.STATUS_CODE,
7488: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7489: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
7490: LAST_UPDATE_DATE = SYSDATE,

Line 7759: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB

7755: --salogan::Modified the cursor to handle both request id from P2P and Cost Estimation CP ER 9299910::01-JUN-2009::BEGIN
7756: --Cursor to fetch phase
7757: CURSOR c_conc_req_phase(c_id IN NUMBER) IS
7758: SELECT 'X'
7759: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB
7760: WHERE FCR.REQUEST_ID IN ( AVB.CST_EST_REQUEST_ID, AVB.REQUEST_ID )
7761: AND FCR.PHASE_CODE IN ('P', 'R')
7762: AND AVB.VISIT_ID = c_id;
7763: l_dummy_val c_conc_req_phase%ROWTYPE;

Line 8197: SELECT 1 FROM AHL_VISITS_B

8193: l_val_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type;
8194:
8195: -- chk if the visit is valid
8196: CURSOR c_validate_visit (x_id IN NUMBER) IS
8197: SELECT 1 FROM AHL_VISITS_B
8198: WHERE VISIT_ID = x_id;
8199:
8200: -- chk if the visit is in partially released or planning status
8201: CURSOR c_visit_info (x_id IN NUMBER) IS

Line 8202: SELECT start_date_time,status_code FROM AHL_VISITS_B

8198: WHERE VISIT_ID = x_id;
8199:
8200: -- chk if the visit is in partially released or planning status
8201: CURSOR c_visit_info (x_id IN NUMBER) IS
8202: SELECT start_date_time,status_code FROM AHL_VISITS_B
8203: WHERE VISIT_ID = x_id
8204: AND NVL(STATUS_CODE,'X') IN ('PARTIALLY RELEASED', 'PLANNING');
8205:
8206: c_visit_info_rec c_visit_info%ROWTYPE;

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

8747:
8748: --cursor to fetch master work order for the visit
8749: CURSOR c_fet_master_wo (x_visit_id IN NUMBER) IS
8750: SELECT wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date
8751: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip
8752: WHERE v.visit_id = x_visit_id
8753: AND NVL(v.status_code,'X') = 'PARTIALLY RELEASED'
8754: AND v.visit_id = wo.visit_id
8755: AND wo.visit_task_id IS NULL

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

9245:
9246: --fetch master work order for the visit
9247: CURSOR c_visit_master_wo (x_visit_id IN NUMBER) IS
9248: SELECT wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date,wo.object_version_number
9249: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip
9250: WHERE v.visit_id = x_visit_id
9251: AND v.visit_id = wo.visit_id
9252: AND wo.visit_task_id IS NULL
9253: AND wo.master_workorder_flag = 'Y'

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

9383: OR (STAGE_ID IS NOT NULL AND TASK_TYPE_CODE = 'STAGE'));
9384:
9385: CURSOR c_visit_time_matches_MWO_time(p_visit_id IN NUMBER) IS
9386: SELECT 1
9387: FROM ahl_visits_b vst, ahl_workorders wo, wip_discrete_jobs wdj
9388: WHERE vst.visit_id = p_visit_id
9389: AND wo.visit_id = vst.visit_id
9390: AND wo.MASTER_WORKORDER_FLAG = 'Y'
9391: AND wo.visit_task_id IS NULL

Line 10205: UPDATE ahl_visits_b

10201: 'Visit times and Master Work order times do not match. Setting Visit status to PARTIALLY RELEASED.');
10202: END IF;
10203: END IF;
10204:
10205: UPDATE ahl_visits_b
10206: SET status_code = 'PARTIALLY RELEASED',
10207: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE OVN AND WHO COLUMNS
10208: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
10209: LAST_UPDATE_DATE = SYSDATE,

Line 10220: UPDATE ahl_visits_b

10216: L_DEBUG_KEY,
10217: 'Setting Visit status to RELEASED.');
10218: END IF;
10219:
10220: UPDATE ahl_visits_b
10221: SET status_code = 'RELEASED',
10222: any_task_chg_flag ='N',
10223: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE OVN AND WHO COLUMNS
10224: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,

Line 10459: ahl_visits_b v

10455: -- Get all the parent tasks for a given UE that start in a past date
10456: CURSOR get_independent_tasks(x_visit_id IN NUMBER, x_unit_effectivity_id IN NUMBER) IS
10457: select distinct t.visit_task_id
10458: from ahl_visit_tasks_b t,
10459: ahl_visits_b v
10460: where v.visit_id = x_visit_id
10461: and v.visit_id = t.visit_id
10462: --and v.status_code = 'PARTIALLY RELEASED'
10463: and v.status_code IN ('PLANNING', 'PARTIALLY RELEASED') -- PRAKKUM :: BUG Internal :: 19/01/2012 :: Task Time Adjustments

Line 11663: UPDATE ahl_visits_b

11659: FETCH c_get_wo_details into c_get_wo_details_rec;
11660: IF (c_visit_task_exists%NOTFOUND and
11661: c_visit_rec.start_date_time = c_get_wo_details_rec.scheduled_start_date and
11662: c_visit_rec.close_date_time = c_get_wo_details_rec.scheduled_completion_date) THEN
11663: UPDATE ahl_visits_b
11664: SET status_code = 'RELEASED',
11665: object_version_number = object_version_number + 1,
11666: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
11667: LAST_UPDATE_DATE = SYSDATE,

Line 12712: FROM ahl_workorders wo, ahl_visits_b av

12708: CURSOR get_visit_details_cur (p_wo_id IN NUMBER) IS
12709: --TCHIMIRA::BUG:9117467::23-NOV-2009
12710: --Removed the column wo.workorder_id from the select clause
12711: SELECT av.visit_id, av.project_id, av.start_date_time, av.close_date_time, av.top_project_task_id
12712: FROM ahl_workorders wo, ahl_visits_b av
12713: WHERE WO.WORKORDER_ID = p_wo_id
12714: AND wo.visit_id = av.visit_id;
12715: -- Changed by jaramana on 11-NOV-2009 for bug 9109020
12716: --AND wo.visit_task_id IS NULL

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

13236: -- status with end date exceeding visit planned end date, then non-routine cannot be created
13237: IF TRUNC(l_visit_end_time) > TRUNC(c_visit_rec.close_date_time) THEN
13238: --yazhou Jul-20-2005 start
13239: -- Set visit status to partially released
13240: -- UPDATE AHL_VISITS_B SET STATUS_CODE = 'PARTIALLY RELEASED',
13241: -- OBJECT_VERSION_NUMBER = c_visit_rec.object_version_number + 1
13242: -- WHERE VISIT_ID = c_visit_rec.visit_id;
13243: --yazhou Jul-20-2005 end
13244:

Line 13459: UPDATE ahl_visits_b

13455: FETCH c_get_wo_details into c_get_wo_details_rec;
13456: IF (c_visit_task_exists%NOTFOUND and
13457: c_visit_rec.start_date_time = c_get_wo_details_rec.scheduled_start_date and
13458: c_visit_rec.close_date_time = c_get_wo_details_rec.scheduled_completion_date) THEN
13459: UPDATE ahl_visits_b
13460: SET status_code = 'RELEASED',
13461: object_version_number = object_version_number + 1
13462: WHERE visit_id = c_visit_rec.visit_id;
13463:

Line 13928: FROM ahl_visits_b

13924:
13925: --To find the visit details
13926: CURSOR get_vst_prj_details_csr (c_visit_id IN NUMBER) IS
13927: SELECT project_id, project_template_id
13928: FROM ahl_visits_b
13929: WHERE visit_id = c_visit_id ;
13930: get_vst_prj_details_csr_rec get_vst_prj_details_csr%ROWTYPE;
13931:
13932: -- PRAKKUM :: FPBug 16481709 for BaseBug 14828418 :: 07/11/2012 :: START

Line 14245: FROM ahl_visits_b

14241:
14242: Cursor get_visit_status (x_visit_id IN NUMBER)
14243: IS
14244: SELECT status_code, visit_number
14245: FROM ahl_visits_b
14246: WHERE visit_id = x_visit_id;
14247:
14248: BEGIN
14249:

Line 14378: UPDATE AHL_VISITS_B

14374: RAISE Fnd_Api.g_exc_unexpected_error;
14375: END IF;
14376: ELSE
14377: IF l_status_code = 'DRAFT' THEN
14378: UPDATE AHL_VISITS_B
14379: SET STATUS_CODE = 'PLANNING',
14380: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
14381: LAST_UPDATE_DATE = SYSDATE,
14382: LAST_UPDATED_BY = Fnd_Global.USER_ID,

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

14503:
14504: --fetch master work order for the visit
14505: CURSOR c_visit_master_wo (c_visit_id IN NUMBER) IS
14506: SELECT wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date,wo.object_version_number
14507: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip
14508: WHERE v.visit_id = c_visit_id
14509: AND v.visit_id = wo.visit_id
14510: AND wo.visit_task_id IS NULL
14511: AND wo.master_workorder_flag = 'Y'

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

14588: OR (STAGE_ID IS NOT NULL AND TASK_TYPE_CODE = 'STAGE'));
14589:
14590: CURSOR c_visit_time_matches_MWO_time(p_visit_id IN NUMBER) IS
14591: SELECT 1
14592: FROM ahl_visits_b vst, ahl_workorders wo, wip_discrete_jobs wdj
14593: WHERE vst.visit_id = p_visit_id
14594: AND wo.visit_id = vst.visit_id
14595: AND wo.MASTER_WORKORDER_FLAG = 'Y'
14596: AND wo.visit_task_id IS NULL

Line 15318: UPDATE ahl_visits_b

15314: 'Visit times and Master Work order times do not match. Setting Visit status to PARTIALLY RELEASED.');
15315: END IF;
15316: END IF;
15317:
15318: UPDATE ahl_visits_b
15319: SET status_code = 'PARTIALLY RELEASED',
15320: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15321: LAST_UPDATE_DATE = SYSDATE,
15322: LAST_UPDATED_BY = Fnd_Global.USER_ID,

Line 15332: UPDATE ahl_visits_b

15328: L_DEBUG_KEY,
15329: 'Setting Visit status to RELEASED.');
15330: END IF;
15331:
15332: UPDATE ahl_visits_b
15333: SET status_code = 'RELEASED',
15334: any_task_chg_flag ='N',
15335: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15336: LAST_UPDATE_DATE = SYSDATE,