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 FND_GLOBAL

Line 670: LAST_UPDATED_BY = Fnd_Global.USER_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,
671: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
672: WHERE visit_id = p_visit_id;
673: CLOSE c_visit;
674: COMMIT WORK;

Line 671: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

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,
671: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
672: WHERE visit_id = p_visit_id;
673: CLOSE c_visit;
674: COMMIT WORK;
675:

Line 769: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);

765: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
766: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
767: fnd_file.put_line(fnd_file.log, 'p_caller -> '|| p_caller);
768: fnd_file.put_line(fnd_file.log, 'p_release_flag -> '||p_release_flag);
769: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
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:

Line 770: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);

766: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
767: fnd_file.put_line(fnd_file.log, 'p_caller -> '|| p_caller);
768: fnd_file.put_line(fnd_file.log, 'p_release_flag -> '||p_release_flag);
769: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
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;

Line 771: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);

767: fnd_file.put_line(fnd_file.log, 'p_caller -> '|| p_caller);
768: fnd_file.put_line(fnd_file.log, 'p_release_flag -> '||p_release_flag);
769: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
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:

Line 1313: LAST_UPDATED_BY = Fnd_Global.USER_ID,

1309: SET PROJECT_TASK_ID = l_task_id,
1310: OBJECT_VERSION_NUMBER = object_version_number + 1,
1311: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
1312: LAST_UPDATE_DATE = SYSDATE,
1313: LAST_UPDATED_BY = Fnd_Global.USER_ID,
1314: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
1315: WHERE VISIT_TASK_ID = p_visit_task_id;
1316: END IF;
1317:

Line 1314: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

1310: OBJECT_VERSION_NUMBER = object_version_number + 1,
1311: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
1312: LAST_UPDATE_DATE = SYSDATE,
1313: LAST_UPDATED_BY = Fnd_Global.USER_ID,
1314: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
1315: WHERE VISIT_TASK_ID = p_visit_task_id;
1316: END IF;
1317:
1318: ELSIF l_project_tsk_flag = 'N' AND l_proj_ref_flag = 'Y' THEN

Line 2208: LAST_UPDATED_BY = Fnd_Global.USER_ID,

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,
2208: LAST_UPDATED_BY = Fnd_Global.USER_ID,
2209: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
2210: WHERE VISIT_ID = p_visit_id;
2211: -- RROY
2212: -- Post 11.5.10

Line 2209: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_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,
2208: LAST_UPDATED_BY = Fnd_Global.USER_ID,
2209: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
2210: WHERE VISIT_ID = p_visit_id;
2211: -- RROY
2212: -- Post 11.5.10
2213: -- Call Create_Project_Parameter API

Line 2293: LAST_UPDATED_BY = Fnd_Global.USER_ID,

2289: SET PROJECT_TASK_ID = l_task_out(z).pa_task_id,
2290: OBJECT_VERSION_NUMBER = l_obj_version + 1,
2291: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
2292: LAST_UPDATE_DATE = SYSDATE,
2293: LAST_UPDATED_BY = Fnd_Global.USER_ID,
2294: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
2295: WHERE VISIT_ID = p_visit_id AND VISIT_TASK_NUMBER = l_task_in(z).PA_TASK_NUMBER;
2296: END IF;
2297: --PRAKKUM :: PIE :: 13-OCT-2010 ::END

Line 2294: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

2290: OBJECT_VERSION_NUMBER = l_obj_version + 1,
2291: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
2292: LAST_UPDATE_DATE = SYSDATE,
2293: LAST_UPDATED_BY = Fnd_Global.USER_ID,
2294: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
2295: WHERE VISIT_ID = p_visit_id AND VISIT_TASK_NUMBER = l_task_in(z).PA_TASK_NUMBER;
2296: END IF;
2297: --PRAKKUM :: PIE :: 13-OCT-2010 ::END
2298: EXIT WHEN z = l_task_out.LAST ;

Line 3728: LAST_UPDATED_BY = Fnd_Global.USER_ID,

3724: PROJECT_TASK_ID = c_task_proj_rec.task_id,
3725: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
3726: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
3727: LAST_UPDATE_DATE = SYSDATE,
3728: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3729: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3730: /*B6436358 - sowsubra - Visit task number is of type number and task number in projects
3731: is of type char. Hence the invalid number error. And so added a to_char function to convert
3732: the visit task number to character*/

Line 3729: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

3725: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
3726: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
3727: LAST_UPDATE_DATE = SYSDATE,
3728: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3729: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3730: /*B6436358 - sowsubra - Visit task number is of type number and task number in projects
3731: is of type char. Hence the invalid number error. And so added a to_char function to convert
3732: the visit task number to character*/
3733: WHERE VISIT_ID = p_visit_id AND TO_CHAR(VISIT_TASK_NUMBER) = c_task_proj_rec.task_number

Line 3743: LAST_UPDATED_BY = Fnd_Global.USER_ID,

3739: PROJECT_TASK_ID = c_task_proj_rec.task_id,
3740: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
3741: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
3742: LAST_UPDATE_DATE = SYSDATE,
3743: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3744: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3745: /*B6436358 - sowsubra - Visit task number is of type number and task number in projects
3746: is of type char. Hence the invalid number error. And so added a to_char function to convert
3747: the visit task number to character*/

Line 3744: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

3740: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
3741: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
3742: LAST_UPDATE_DATE = SYSDATE,
3743: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3744: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3745: /*B6436358 - sowsubra - Visit task number is of type number and task number in projects
3746: is of type char. Hence the invalid number error. And so added a to_char function to convert
3747: the visit task number to character*/
3748: WHERE VISIT_ID = p_visit_id

Line 7438: LAST_UPDATED_BY = Fnd_Global.USER_ID,

7434: UPDATE AHL_VWP_STAGES_B
7435: SET STAGE_STATUS_CODE = 'RELEASED',
7436: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7437: LAST_UPDATE_DATE = SYSDATE,
7438: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7439: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7440: WHERE STAGE_ID = l_task_to_cancel_rec.stage_id;
7441: END IF;
7442: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 7439: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

7435: SET STAGE_STATUS_CODE = 'RELEASED',
7436: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7437: LAST_UPDATE_DATE = SYSDATE,
7438: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7439: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7440: WHERE STAGE_ID = l_task_to_cancel_rec.stage_id;
7441: END IF;
7442: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7443: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs l_workorder_id= '||l_workorder_id);

Line 7481: LAST_UPDATED_BY = Fnd_Global.USER_ID,

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,
7481: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7482: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7483: WHERE VISIT_ID = p_visit_id;
7484:
7485: ELSE

Line 7482: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

7478: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7479: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
7480: LAST_UPDATE_DATE = SYSDATE,
7481: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7482: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7483: WHERE VISIT_ID = p_visit_id;
7484:
7485: ELSE
7486: UPDATE AHL_VISITS_B

Line 7491: LAST_UPDATED_BY = Fnd_Global.USER_ID,

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,
7491: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7492: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7493: WHERE VISIT_ID = p_visit_id;
7494: END IF;
7495:

Line 7492: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

7488: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7489: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
7490: LAST_UPDATE_DATE = SYSDATE,
7491: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7492: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7493: WHERE VISIT_ID = p_visit_id;
7494: END IF;
7495:
7496: END IF;

Line 7506: LAST_UPDATED_BY = Fnd_Global.USER_ID,

7502: SET STATUS_CODE = 'RELEASED',
7503: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7504: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
7505: LAST_UPDATE_DATE = SYSDATE,
7506: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7507: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7508: WHERE VISIT_ID = p_visit_id
7509: AND STATUS_CODE IN ('PLANNING', 'PARTIALLY RELEASED')
7510: --SKPATHAK :: VWPE ER-12424063 :: 09-JUN-2011 :: Update the status of stage and duplicate tasks to CANCELLED

Line 7507: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

7503: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7504: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
7505: LAST_UPDATE_DATE = SYSDATE,
7506: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7507: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7508: WHERE VISIT_ID = p_visit_id
7509: AND STATUS_CODE IN ('PLANNING', 'PARTIALLY RELEASED')
7510: --SKPATHAK :: VWPE ER-12424063 :: 09-JUN-2011 :: Update the status of stage and duplicate tasks to CANCELLED
7511: AND TASK_TYPE_CODE NOT IN ('STAGE','DUPLICATE');

Line 7518: LAST_UPDATED_BY = Fnd_Global.USER_ID,

7514: SET STATUS_CODE = 'CANCELLED',
7515: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7516: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
7517: LAST_UPDATE_DATE = SYSDATE,
7518: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7519: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7520: WHERE VISIT_ID = p_visit_id
7521: AND STATUS_CODE = 'PLANNING'
7522: AND ((TASK_TYPE_CODE = 'STAGE' AND STAGE_ID IS NOT NULL)

Line 7519: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

7515: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7516: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
7517: LAST_UPDATE_DATE = SYSDATE,
7518: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7519: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7520: WHERE VISIT_ID = p_visit_id
7521: AND STATUS_CODE = 'PLANNING'
7522: AND ((TASK_TYPE_CODE = 'STAGE' AND STAGE_ID IS NOT NULL)
7523: OR TASK_TYPE_CODE = 'DUPLICATE');

Line 7531: LAST_UPDATED_BY = Fnd_Global.USER_ID,

7527: SET STATUS_CODE = 'RELEASED',
7528: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7529: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
7530: LAST_UPDATE_DATE = SYSDATE,
7531: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7532: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7533: WHERE VISIT_ID = p_visit_id
7534: AND STATUS_CODE IN ('PLANNING', 'PARTIALLY RELEASED')
7535: --SKPATHAK :: VWPE ER-12424063 :: 09-JUN-2011 :: Need not s update the status of stage and duplicate tasks to RELEASED

Line 7532: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

7528: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7529: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
7530: LAST_UPDATE_DATE = SYSDATE,
7531: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7532: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7533: WHERE VISIT_ID = p_visit_id
7534: AND STATUS_CODE IN ('PLANNING', 'PARTIALLY RELEASED')
7535: --SKPATHAK :: VWPE ER-12424063 :: 09-JUN-2011 :: Need not s update the status of stage and duplicate tasks to RELEASED
7536: AND TASK_TYPE_CODE NOT IN ('STAGE','DUPLICATE')

Line 7548: LAST_UPDATED_BY = Fnd_Global.USER_ID,

7544: SET STATUS_CODE = 'CANCELLED',
7545: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7546: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
7547: LAST_UPDATE_DATE = SYSDATE,
7548: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7549: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7550: WHERE VISIT_ID = p_visit_id
7551: AND STATUS_CODE = 'PLANNING'
7552: AND TASK_TYPE_CODE IN ('STAGE','DUPLICATE')

Line 7549: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

7545: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7546: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
7547: LAST_UPDATE_DATE = SYSDATE,
7548: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7549: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7550: WHERE VISIT_ID = p_visit_id
7551: AND STATUS_CODE = 'PLANNING'
7552: AND TASK_TYPE_CODE IN ('STAGE','DUPLICATE')
7553: AND VISIT_TASK_NUMBER in (Select VISIT_TASK_NUMBER

Line 9015: LAST_UPDATED_BY = Fnd_Global.USER_ID,

9011: UPDATE ahl_visit_tasks_b
9012: SET status_code = 'RELEASED',
9013: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9014: LAST_UPDATE_DATE = SYSDATE,
9015: LAST_UPDATED_BY = Fnd_Global.USER_ID,
9016: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
9017: WHERE visit_task_id = lp_originating_task_id;
9018:
9019: FOR child_planning_tasks_rec IN get_child_planning_tasks (c_par_rel_sum_tsk_rec.visit_task_id) LOOP

Line 9016: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

9012: SET status_code = 'RELEASED',
9013: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9014: LAST_UPDATE_DATE = SYSDATE,
9015: LAST_UPDATED_BY = Fnd_Global.USER_ID,
9016: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
9017: WHERE visit_task_id = lp_originating_task_id;
9018:
9019: FOR child_planning_tasks_rec IN get_child_planning_tasks (c_par_rel_sum_tsk_rec.visit_task_id) LOOP
9020: IF (l_log_statement >= l_log_current_level) THEN

Line 9665: LAST_UPDATED_BY = Fnd_Global.USER_ID,

9661: SET status_code = 'RELEASED',
9662: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE OVN AND WHO COLUMNS
9663: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9664: LAST_UPDATE_DATE = SYSDATE,
9665: LAST_UPDATED_BY = Fnd_Global.USER_ID,
9666: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
9667: WHERE visit_task_id = p_tasks_tbl(i).visit_task_id;
9668:
9669: ELSE

Line 9666: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

9662: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE OVN AND WHO COLUMNS
9663: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9664: LAST_UPDATE_DATE = SYSDATE,
9665: LAST_UPDATED_BY = Fnd_Global.USER_ID,
9666: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
9667: WHERE visit_task_id = p_tasks_tbl(i).visit_task_id;
9668:
9669: ELSE
9670: --check if the wo exists for the task

Line 10083: LAST_UPDATED_BY = Fnd_Global.USER_ID,

10079: UPDATE ahl_visit_tasks_b
10080: SET status_code = 'CANCELLED',
10081: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
10082: LAST_UPDATE_DATE = SYSDATE,
10083: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10084: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10085: WHERE visit_task_id = p_tasks_tbl(i).visit_task_id;
10086: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
10087: (p_api_version => 1.0,

Line 10084: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

10080: SET status_code = 'CANCELLED',
10081: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
10082: LAST_UPDATE_DATE = SYSDATE,
10083: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10084: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10085: WHERE visit_task_id = p_tasks_tbl(i).visit_task_id;
10086: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
10087: (p_api_version => 1.0,
10088: p_init_msg_list => FND_API.G_TRUE,

Line 10104: LAST_UPDATED_BY = Fnd_Global.USER_ID,

10100: UPDATE ahl_visit_tasks_b
10101: SET status_code = 'RELEASED',
10102: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
10103: LAST_UPDATE_DATE = SYSDATE,
10104: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10105: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10106: WHERE visit_task_id = p_tasks_tbl(i).visit_task_id;
10107: END IF;
10108: END LOOP;

Line 10105: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

10101: SET status_code = 'RELEASED',
10102: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
10103: LAST_UPDATE_DATE = SYSDATE,
10104: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10105: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10106: WHERE visit_task_id = p_tasks_tbl(i).visit_task_id;
10107: END IF;
10108: END LOOP;
10109:

Line 10121: LAST_UPDATED_BY = Fnd_Global.USER_ID,

10117: UPDATE ahl_vwp_stages_b
10118: SET stage_status_code = 'PARTIALLY RELEASED',
10119: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
10120: LAST_UPDATE_DATE = SYSDATE,
10121: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10122: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10123: WHERE stage_id = l_stage_rec.stage_id;
10124: END LOOP;
10125: END IF;

Line 10122: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

10118: SET stage_status_code = 'PARTIALLY RELEASED',
10119: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
10120: LAST_UPDATE_DATE = SYSDATE,
10121: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10122: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10123: WHERE stage_id = l_stage_rec.stage_id;
10124: END LOOP;
10125: END IF;
10126: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: ENDS

Line 10155: last_updated_by = Fnd_Global.USER_ID,

10151: UPDATE AHL_VISIT_TASKS_B
10152: SET status_code = 'PARTIALLY RELEASED',
10153: object_version_number = object_version_number + 1,
10154: last_update_date = SYSDATE,
10155: last_updated_by = Fnd_Global.USER_ID,
10156: last_update_login = Fnd_Global.LOGIN_ID
10157: WHERE repair_batch_name = l_repair_batch_name;
10158:
10159: -- if Repair Batch has no planned tasks

Line 10156: last_update_login = Fnd_Global.LOGIN_ID

10152: SET status_code = 'PARTIALLY RELEASED',
10153: object_version_number = object_version_number + 1,
10154: last_update_date = SYSDATE,
10155: last_updated_by = Fnd_Global.USER_ID,
10156: last_update_login = Fnd_Global.LOGIN_ID
10157: WHERE repair_batch_name = l_repair_batch_name;
10158:
10159: -- if Repair Batch has no planned tasks
10160: ELSE

Line 10169: last_updated_by = Fnd_Global.USER_ID,

10165: UPDATE AHL_VISIT_TASKS_B
10166: SET status_code = 'RELEASED',
10167: object_version_number = object_version_number + 1,
10168: last_update_date = SYSDATE,
10169: last_updated_by = Fnd_Global.USER_ID,
10170: last_update_login = Fnd_Global.LOGIN_ID
10171: WHERE repair_batch_name = l_repair_batch_name;
10172: END IF;
10173: CLOSE chk_rpr_batch_has_planed_tasks;

Line 10170: last_update_login = Fnd_Global.LOGIN_ID

10166: SET status_code = 'RELEASED',
10167: object_version_number = object_version_number + 1,
10168: last_update_date = SYSDATE,
10169: last_updated_by = Fnd_Global.USER_ID,
10170: last_update_login = Fnd_Global.LOGIN_ID
10171: WHERE repair_batch_name = l_repair_batch_name;
10172: END IF;
10173: CLOSE chk_rpr_batch_has_planed_tasks;
10174:

Line 10210: LAST_UPDATED_BY = Fnd_Global.USER_ID,

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,
10210: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10211: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10212: WHERE visit_id = p_visit_id;
10213: ELSE
10214: IF (l_log_statement >= l_log_current_level) THEN

Line 10211: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

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,
10210: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10211: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10212: WHERE visit_id = p_visit_id;
10213: ELSE
10214: IF (l_log_statement >= l_log_current_level) THEN
10215: fnd_log.string(l_log_statement,

Line 10226: LAST_UPDATED_BY = Fnd_Global.USER_ID,

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,
10225: LAST_UPDATE_DATE = SYSDATE,
10226: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10227: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10228: WHERE visit_id = p_visit_id;
10229: END IF;
10230:

Line 10227: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

10223: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE OVN AND WHO COLUMNS
10224: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
10225: LAST_UPDATE_DATE = SYSDATE,
10226: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10227: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10228: WHERE visit_id = p_visit_id;
10229: END IF;
10230:
10231:

Line 11641: LAST_UPDATED_BY = Fnd_Global.USER_ID,

11637: SET STATUS_CODE = 'RELEASED',
11638: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
11639: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
11640: LAST_UPDATE_DATE = SYSDATE,
11641: LAST_UPDATED_BY = Fnd_Global.USER_ID,
11642: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
11643: WHERE VISIT_ID = p_visit_id
11644: AND VISIT_TASK_ID = c_task_rec.visit_task_id
11645: AND STATUS_CODE = 'PLANNING';

Line 11642: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

11638: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
11639: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
11640: LAST_UPDATE_DATE = SYSDATE,
11641: LAST_UPDATED_BY = Fnd_Global.USER_ID,
11642: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
11643: WHERE VISIT_ID = p_visit_id
11644: AND VISIT_TASK_ID = c_task_rec.visit_task_id
11645: AND STATUS_CODE = 'PLANNING';
11646:

Line 11668: LAST_UPDATED_BY = Fnd_Global.USER_ID,

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,
11668: LAST_UPDATED_BY = Fnd_Global.USER_ID,
11669: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
11670: WHERE visit_id = c_visit_rec.visit_id;
11671:
11672: IF (l_log_statement >= l_log_current_level) THEN

Line 11669: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

11665: object_version_number = object_version_number + 1,
11666: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
11667: LAST_UPDATE_DATE = SYSDATE,
11668: LAST_UPDATED_BY = Fnd_Global.USER_ID,
11669: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
11670: WHERE visit_id = c_visit_rec.visit_id;
11671:
11672: IF (l_log_statement >= l_log_current_level) THEN
11673: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before AHL_VWP_RULES_PVT.Update_Visit_Task_Flag Call');

Line 11713: last_updated_by = Fnd_Global.USER_ID,

11709: UPDATE AHL_VISIT_TASKS_B
11710: SET status_code = 'RELEASED',
11711: object_version_number = object_version_number + 1,
11712: last_update_date = SYSDATE,
11713: last_updated_by = Fnd_Global.USER_ID,
11714: last_update_login = Fnd_Global.LOGIN_ID
11715: WHERE repair_batch_name = l_repair_batch_name;
11716:
11717: END IF;

Line 11714: last_update_login = Fnd_Global.LOGIN_ID

11710: SET status_code = 'RELEASED',
11711: object_version_number = object_version_number + 1,
11712: last_update_date = SYSDATE,
11713: last_updated_by = Fnd_Global.USER_ID,
11714: last_update_login = Fnd_Global.LOGIN_ID
11715: WHERE repair_batch_name = l_repair_batch_name;
11716:
11717: END IF;
11718: CLOSE chk_rpr_batch_has_planed_tasks;

Line 12135: LAST_UPDATED_BY = Fnd_Global.USER_ID,

12131: UPDATE AHL_VISIT_TASKS_B SET PROJECT_TASK_ID = l_task_id,
12132: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1,
12133: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
12134: LAST_UPDATE_DATE = SYSDATE,
12135: LAST_UPDATED_BY = Fnd_Global.USER_ID,
12136: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
12137: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id;
12138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
12139: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Updated AHL_VISIT_TASKS_B: c_task_rec.visit_task_number = ' || c_task_rec.visit_task_number ||

Line 12136: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

12132: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1,
12133: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
12134: LAST_UPDATE_DATE = SYSDATE,
12135: LAST_UPDATED_BY = Fnd_Global.USER_ID,
12136: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
12137: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id;
12138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
12139: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Updated AHL_VISIT_TASKS_B: c_task_rec.visit_task_number = ' || c_task_rec.visit_task_number ||
12140: ', c_task_rec.visit_task_id = ' || c_task_rec.visit_task_id ||

Line 14382: LAST_UPDATED_BY = Fnd_Global.USER_ID,

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,
14383: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
14384: WHERE VISIT_ID = p_visit_id;
14385: END IF;
14386:

Line 14383: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

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,
14383: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
14384: WHERE VISIT_ID = p_visit_id;
14385: END IF;
14386:
14387: END IF;

Line 15177: LAST_UPDATED_BY = Fnd_Global.USER_ID,

15173: UPDATE ahl_vwp_stages_b
15174: SET STAGE_STATUS_CODE = 'RELEASED',
15175: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15176: LAST_UPDATE_DATE = SYSDATE,
15177: LAST_UPDATED_BY = Fnd_Global.USER_ID,
15178: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
15179: WHERE STAGE_ID = p_stages_tbl(i).stage_id;
15180:
15181: END LOOP;

Line 15178: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

15174: SET STAGE_STATUS_CODE = 'RELEASED',
15175: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15176: LAST_UPDATE_DATE = SYSDATE,
15177: LAST_UPDATED_BY = Fnd_Global.USER_ID,
15178: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
15179: WHERE STAGE_ID = p_stages_tbl(i).stage_id;
15180:
15181: END LOOP;
15182:

Line 15258: LAST_UPDATED_BY = Fnd_Global.USER_ID,

15254: UPDATE ahl_visit_tasks_b
15255: SET status_code = 'CANCELLED',
15256: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15257: LAST_UPDATE_DATE = SYSDATE,
15258: LAST_UPDATED_BY = Fnd_Global.USER_ID,
15259: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
15260: WHERE visit_task_id = l_non_summ_task_rec.visit_task_id;
15261: ELSIF l_non_summ_task_rec.task_type_code <> 'SUMMARY' THEN
15262: UPDATE ahl_visit_tasks_b

Line 15259: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

15255: SET status_code = 'CANCELLED',
15256: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15257: LAST_UPDATE_DATE = SYSDATE,
15258: LAST_UPDATED_BY = Fnd_Global.USER_ID,
15259: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
15260: WHERE visit_task_id = l_non_summ_task_rec.visit_task_id;
15261: ELSIF l_non_summ_task_rec.task_type_code <> 'SUMMARY' THEN
15262: UPDATE ahl_visit_tasks_b
15263: SET status_code = 'RELEASED',

Line 15266: LAST_UPDATED_BY = Fnd_Global.USER_ID,

15262: UPDATE ahl_visit_tasks_b
15263: SET status_code = 'RELEASED',
15264: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15265: LAST_UPDATE_DATE = SYSDATE,
15266: LAST_UPDATED_BY = Fnd_Global.USER_ID,
15267: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
15268: WHERE visit_task_id = l_non_summ_task_rec.visit_task_id;
15269: END IF;
15270: END LOOP;

Line 15267: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

15263: SET status_code = 'RELEASED',
15264: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15265: LAST_UPDATE_DATE = SYSDATE,
15266: LAST_UPDATED_BY = Fnd_Global.USER_ID,
15267: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
15268: WHERE visit_task_id = l_non_summ_task_rec.visit_task_id;
15269: END IF;
15270: END LOOP;
15271: END LOOP;

Line 15288: LAST_UPDATED_BY = Fnd_Global.USER_ID,

15284: UPDATE ahl_visit_tasks_b
15285: SET status_code = l_chk_status_code,
15286: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15287: LAST_UPDATE_DATE = SYSDATE,
15288: LAST_UPDATED_BY = Fnd_Global.USER_ID,
15289: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
15290: WHERE visit_task_id = l_summary_task_rec.visit_task_id;
15291: END LOOP;
15292: END LOOP;

Line 15289: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

15285: SET status_code = l_chk_status_code,
15286: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15287: LAST_UPDATE_DATE = SYSDATE,
15288: LAST_UPDATED_BY = Fnd_Global.USER_ID,
15289: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
15290: WHERE visit_task_id = l_summary_task_rec.visit_task_id;
15291: END LOOP;
15292: END LOOP;
15293:

Line 15322: LAST_UPDATED_BY = Fnd_Global.USER_ID,

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,
15323: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
15324: WHERE visit_id = p_visit_id;
15325: ELSE
15326: IF (l_log_statement >= l_log_current_level) THEN

Line 15323: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

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,
15323: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
15324: WHERE visit_id = p_visit_id;
15325: ELSE
15326: IF (l_log_statement >= l_log_current_level) THEN
15327: fnd_log.string(l_log_statement,

Line 15337: LAST_UPDATED_BY = Fnd_Global.USER_ID,

15333: SET status_code = 'RELEASED',
15334: any_task_chg_flag ='N',
15335: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15336: LAST_UPDATE_DATE = SYSDATE,
15337: LAST_UPDATED_BY = Fnd_Global.USER_ID,
15338: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
15339: WHERE visit_id = p_visit_id;
15340: END IF;
15341:

Line 15338: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

15334: any_task_chg_flag ='N',
15335: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15336: LAST_UPDATE_DATE = SYSDATE,
15337: LAST_UPDATED_BY = Fnd_Global.USER_ID,
15338: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
15339: WHERE visit_id = p_visit_id;
15340: END IF;
15341:
15342: -- SKPATHAK :: ER:12730539 :: 01-AUG-2011