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_VISITS_STAGES_PVT dependencies on FND_GLOBAL

Line 743: X_CREATED_BY => Fnd_Global.USER_ID,

739: X_ATTRIBUTE14 => l_stages_tbl(i).ATTRIBUTE14 ,
740: X_ATTRIBUTE15 => l_stages_tbl(i).ATTRIBUTE15 ,
741:
742: X_CREATION_DATE => SYSDATE,
743: X_CREATED_BY => Fnd_Global.USER_ID,
744: X_LAST_UPDATE_DATE => SYSDATE,
745: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
746: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
747: X_STAGE_STATUS_CODE => l_stages_tbl(i).STAGE_STATUS_CODE,--PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063

Line 745: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

741:
742: X_CREATION_DATE => SYSDATE,
743: X_CREATED_BY => Fnd_Global.USER_ID,
744: X_LAST_UPDATE_DATE => SYSDATE,
745: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
746: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
747: X_STAGE_STATUS_CODE => l_stages_tbl(i).STAGE_STATUS_CODE,--PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063
748: X_PLANNED_START_DATE => l_stages_tbl(i).Stage_Planned_Start_Time, --PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063
749: X_PLANNED_END_DATE => l_stages_tbl(i).Stage_Planned_End_Time,--PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063

Line 746: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,

742: X_CREATION_DATE => SYSDATE,
743: X_CREATED_BY => Fnd_Global.USER_ID,
744: X_LAST_UPDATE_DATE => SYSDATE,
745: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
746: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
747: X_STAGE_STATUS_CODE => l_stages_tbl(i).STAGE_STATUS_CODE,--PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063
748: X_PLANNED_START_DATE => l_stages_tbl(i).Stage_Planned_Start_Time, --PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063
749: X_PLANNED_END_DATE => l_stages_tbl(i).Stage_Planned_End_Time,--PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063
750: X_PREV_STAGE_NUM => l_stages_tbl(i).PREV_STAGE_NUM,--PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063

Line 1131: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

1127: X_ATTRIBUTE13 => p_x_stages_tbl(i).ATTRIBUTE13,
1128: X_ATTRIBUTE14 => p_x_stages_tbl(i).ATTRIBUTE14,
1129: X_ATTRIBUTE15 => p_x_stages_tbl(i).ATTRIBUTE15,
1130: X_LAST_UPDATE_DATE => SYSDATE,
1131: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1132: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
1133: X_STAGE_STATUS_CODE => p_x_stages_tbl(i).STAGE_STATUS_CODE, -- PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063
1134: X_PLANNED_START_DATE => p_x_stages_tbl(i).Stage_Planned_Start_Time,-- PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063
1135: X_PLANNED_END_DATE => p_x_stages_tbl(i).Stage_Planned_End_Time,-- PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063

Line 1132: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,

1128: X_ATTRIBUTE14 => p_x_stages_tbl(i).ATTRIBUTE14,
1129: X_ATTRIBUTE15 => p_x_stages_tbl(i).ATTRIBUTE15,
1130: X_LAST_UPDATE_DATE => SYSDATE,
1131: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1132: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
1133: X_STAGE_STATUS_CODE => p_x_stages_tbl(i).STAGE_STATUS_CODE, -- PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063
1134: X_PLANNED_START_DATE => p_x_stages_tbl(i).Stage_Planned_Start_Time,-- PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063
1135: X_PLANNED_END_DATE => p_x_stages_tbl(i).Stage_Planned_End_Time,-- PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063
1136: X_PREV_STAGE_NUM => p_x_stages_tbl(i).PREV_STAGE_NUM,-- PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063

Line 1494: LAST_UPDATED_BY = Fnd_Global.USER_ID,

1490: END IF;
1491: update AHL_VWP_STAGES_B set OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1,
1492: DURATION = 0,
1493: LAST_UPDATE_DATE = SYSDATE,
1494: LAST_UPDATED_BY = Fnd_Global.USER_ID,
1495: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
1496: where STAGE_ID = p_x_stages_tbl(i).STAGE_ID;
1497:
1498: FOR l_stagelinks_rec IN c_stage_links(p_x_stages_tbl(i).STAGE_ID)

Line 1495: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

1491: update AHL_VWP_STAGES_B set OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1,
1492: DURATION = 0,
1493: LAST_UPDATE_DATE = SYSDATE,
1494: LAST_UPDATED_BY = Fnd_Global.USER_ID,
1495: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
1496: where STAGE_ID = p_x_stages_tbl(i).STAGE_ID;
1497:
1498: FOR l_stagelinks_rec IN c_stage_links(p_x_stages_tbl(i).STAGE_ID)
1499: LOOP

Line 1605: LAST_UPDATED_BY = Fnd_Global.USER_ID,

1601: END IF;
1602: update AHL_VISIT_TASKS_B set OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1,
1603: STAGE_ID = null,
1604: LAST_UPDATE_DATE = SYSDATE,
1605: LAST_UPDATED_BY = Fnd_Global.USER_ID,
1606: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
1607: where STAGE_ID = p_x_stages_tbl(i).STAGE_ID;
1608:
1609: -- Since stage deletion ios allowed only if no tasks associated to it

Line 1606: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

1602: update AHL_VISIT_TASKS_B set OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1,
1603: STAGE_ID = null,
1604: LAST_UPDATE_DATE = SYSDATE,
1605: LAST_UPDATED_BY = Fnd_Global.USER_ID,
1606: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
1607: where STAGE_ID = p_x_stages_tbl(i).STAGE_ID;
1608:
1609: -- Since stage deletion ios allowed only if no tasks associated to it
1610: END LOOP;

Line 2994: X_CREATED_BY => Fnd_Global.USER_ID,

2990: X_ATTRIBUTE13 => NULL ,
2991: X_ATTRIBUTE14 => NULL ,
2992: X_ATTRIBUTE15 => NULL ,
2993: X_CREATION_DATE => SYSDATE,
2994: X_CREATED_BY => Fnd_Global.USER_ID,
2995: X_LAST_UPDATE_DATE => SYSDATE,
2996: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2997: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
2998:

Line 2996: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

2992: X_ATTRIBUTE15 => NULL ,
2993: X_CREATION_DATE => SYSDATE,
2994: X_CREATED_BY => Fnd_Global.USER_ID,
2995: X_LAST_UPDATE_DATE => SYSDATE,
2996: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2997: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
2998:
2999: IF (l_log_statement >= l_log_current_level) THEN
3000: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling insert row. Created an association for stage - '||p_stage_type_assoc_tbl(i).STAGE_ID||' and stage type - '||p_stage_type_assoc_tbl(i).STAGE_TYPE_CODE);

Line 2997: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);

2993: X_CREATION_DATE => SYSDATE,
2994: X_CREATED_BY => Fnd_Global.USER_ID,
2995: X_LAST_UPDATE_DATE => SYSDATE,
2996: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2997: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
2998:
2999: IF (l_log_statement >= l_log_current_level) THEN
3000: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling insert row. Created an association for stage - '||p_stage_type_assoc_tbl(i).STAGE_ID||' and stage type - '||p_stage_type_assoc_tbl(i).STAGE_TYPE_CODE);
3001: END IF;

Line 3280: X_CREATED_BY => Fnd_Global.USER_ID,

3276: X_ATTRIBUTE13 => NULL ,
3277: X_ATTRIBUTE14 => NULL ,
3278: X_ATTRIBUTE15 => NULL ,
3279: X_CREATION_DATE => SYSDATE,
3280: X_CREATED_BY => Fnd_Global.USER_ID,
3281: X_LAST_UPDATE_DATE => SYSDATE,
3282: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3283: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
3284: X_STAGE_STATUS_CODE => 'PLANNING',

Line 3282: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

3278: X_ATTRIBUTE15 => NULL ,
3279: X_CREATION_DATE => SYSDATE,
3280: X_CREATED_BY => Fnd_Global.USER_ID,
3281: X_LAST_UPDATE_DATE => SYSDATE,
3282: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3283: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
3284: X_STAGE_STATUS_CODE => 'PLANNING',
3285: X_PLANNED_START_DATE => NULL,
3286: X_PLANNED_END_DATE => NULL,

Line 3283: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,

3279: X_CREATION_DATE => SYSDATE,
3280: X_CREATED_BY => Fnd_Global.USER_ID,
3281: X_LAST_UPDATE_DATE => SYSDATE,
3282: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3283: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
3284: X_STAGE_STATUS_CODE => 'PLANNING',
3285: X_PLANNED_START_DATE => NULL,
3286: X_PLANNED_END_DATE => NULL,
3287: X_PREV_STAGE_NUM => l_prev_stage_num,

Line 3352: Fnd_Global.USER_ID,

3348: l_stage_id,
3349: l_stagetypes_rec.stage_type_code,
3350: null,
3351: SYSDATE,
3352: Fnd_Global.USER_ID,
3353: SYSDATE,
3354: Fnd_Global.USER_ID,
3355: Fnd_Global.LOGIN_ID);
3356:

Line 3354: Fnd_Global.USER_ID,

3350: null,
3351: SYSDATE,
3352: Fnd_Global.USER_ID,
3353: SYSDATE,
3354: Fnd_Global.USER_ID,
3355: Fnd_Global.LOGIN_ID);
3356:
3357: --We need to update all the tasks (that are in PLANNING) of this visit which have stage type that matches with the passed stage type.
3358: -- Set the stage_id with the passed stage_id for all such tasks

Line 3355: Fnd_Global.LOGIN_ID);

3351: SYSDATE,
3352: Fnd_Global.USER_ID,
3353: SYSDATE,
3354: Fnd_Global.USER_ID,
3355: Fnd_Global.LOGIN_ID);
3356:
3357: --We need to update all the tasks (that are in PLANNING) of this visit which have stage type that matches with the passed stage type.
3358: -- Set the stage_id with the passed stage_id for all such tasks
3359: FOR l_tasks_rec IN c_visit_tasks(P_VISIT_ID, l_stagetypes_rec.stage_type_code) LOOP

Line 3441: Fnd_Global.USER_ID,

3437: l_stage_rules_rec.relation_type,
3438: 1,
3439: null,
3440: SYSDATE,
3441: Fnd_Global.USER_ID,
3442: SYSDATE,
3443: Fnd_Global.USER_ID,
3444: Fnd_Global.LOGIN_ID
3445: );

Line 3443: Fnd_Global.USER_ID,

3439: null,
3440: SYSDATE,
3441: Fnd_Global.USER_ID,
3442: SYSDATE,
3443: Fnd_Global.USER_ID,
3444: Fnd_Global.LOGIN_ID
3445: );
3446:
3447: IF (l_log_statement >= l_log_current_level) THEN

Line 3444: Fnd_Global.LOGIN_ID

3440: SYSDATE,
3441: Fnd_Global.USER_ID,
3442: SYSDATE,
3443: Fnd_Global.USER_ID,
3444: Fnd_Global.LOGIN_ID
3445: );
3446:
3447: IF (l_log_statement >= l_log_current_level) THEN
3448: fnd_log.string(l_log_statement,

Line 3902: LAST_UPDATED_BY = Fnd_Global.USER_ID,

3898: --Update prev_stage_num to null as current relation is going to be deleted.
3899: update AHL_VWP_STAGES_B set object_version_number=object_version_number+1,
3900: PREV_STAGE_NUM = NULL,
3901: LAST_UPDATE_DATE = SYSDATE,
3902: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3903: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3904: where STAGE_ID = p_object_id;
3905: IF (l_log_statement >= l_log_current_level) THEN
3906: fnd_log.string(l_log_statement,L_DEBUG,p_object_id||' stage id updated');

Line 3903: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

3899: update AHL_VWP_STAGES_B set object_version_number=object_version_number+1,
3900: PREV_STAGE_NUM = NULL,
3901: LAST_UPDATE_DATE = SYSDATE,
3902: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3903: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3904: where STAGE_ID = p_object_id;
3905: IF (l_log_statement >= l_log_current_level) THEN
3906: fnd_log.string(l_log_statement,L_DEBUG,p_object_id||' stage id updated');
3907: END IF;

Line 3961: LAST_UPDATED_BY = Fnd_Global.USER_ID,

3957: -- update stage start date to previous stage planned end date
3958: update AHL_VWP_STAGES_B set OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1,
3959: PLANNED_START_DATE=l_prev_stage_planned_end_date,
3960: LAST_UPDATE_DATE = SYSDATE,
3961: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3962: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3963: where STAGE_ID = l_update_stage_id;
3964: IF (l_log_statement >= l_log_current_level) THEN
3965: fnd_log.string(l_log_statement,L_DEBUG,l_update_stage_id||' stage id updated');

Line 3962: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

3958: update AHL_VWP_STAGES_B set OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1,
3959: PLANNED_START_DATE=l_prev_stage_planned_end_date,
3960: LAST_UPDATE_DATE = SYSDATE,
3961: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3962: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3963: where STAGE_ID = l_update_stage_id;
3964: IF (l_log_statement >= l_log_current_level) THEN
3965: fnd_log.string(l_log_statement,L_DEBUG,l_update_stage_id||' stage id updated');
3966: END IF;

Line 4206: LAST_UPDATED_BY = Fnd_Global.USER_ID,

4202: UPDATE AHL_VWP_STAGES_B SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
4203: PLANNED_START_DATE = l_stg_start_date_dets.MAX_START_DATE,
4204: PLANNED_END_DATE = l_planned_end_date,
4205: LAST_UPDATE_DATE = SYSDATE,
4206: LAST_UPDATED_BY = Fnd_Global.USER_ID,
4207: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
4208: WHERE STAGE_ID = p_stage_id;
4209: IF (l_log_statement >= l_log_current_level) THEN
4210: fnd_log.string(l_log_statement,L_DEBUG,p_stage_id||' stage id updated');

Line 4207: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

4203: PLANNED_START_DATE = l_stg_start_date_dets.MAX_START_DATE,
4204: PLANNED_END_DATE = l_planned_end_date,
4205: LAST_UPDATE_DATE = SYSDATE,
4206: LAST_UPDATED_BY = Fnd_Global.USER_ID,
4207: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
4208: WHERE STAGE_ID = p_stage_id;
4209: IF (l_log_statement >= l_log_current_level) THEN
4210: fnd_log.string(l_log_statement,L_DEBUG,p_stage_id||' stage id updated');
4211: END IF;

Line 4477: LAST_UPDATED_BY = Fnd_Global.USER_ID,

4473: /*update AHL_VWP_STAGES_B set object_version_number=object_version_number+1,
4474: PLANNED_START_DATE=l_prev_stage_planned_end_date,
4475: PREV_STAGE_NUM = l_stg_stage_number,
4476: LAST_UPDATE_DATE = SYSDATE,
4477: LAST_UPDATED_BY = Fnd_Global.USER_ID,
4478: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
4479: where STAGE_ID = l_update_stage_id;
4480: IF (l_log_statement >= l_log_current_level) THEN
4481: fnd_log.string(l_log_statement,L_DEBUG,l_update_stage_id||' stage id updated');

Line 4478: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

4474: PLANNED_START_DATE=l_prev_stage_planned_end_date,
4475: PREV_STAGE_NUM = l_stg_stage_number,
4476: LAST_UPDATE_DATE = SYSDATE,
4477: LAST_UPDATED_BY = Fnd_Global.USER_ID,
4478: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
4479: where STAGE_ID = l_update_stage_id;
4480: IF (l_log_statement >= l_log_current_level) THEN
4481: fnd_log.string(l_log_statement,L_DEBUG,l_update_stage_id||' stage id updated');
4482: END IF;*/

Line 4757: LAST_UPDATED_BY = Fnd_Global.USER_ID,

4753: UPDATE AHL_VWP_STAGES_B set object_version_number=object_version_number+1,
4754: PLANNED_START_DATE=null,
4755: PLANNED_END_DATE=null,
4756: LAST_UPDATE_DATE = SYSDATE,
4757: LAST_UPDATED_BY = Fnd_Global.USER_ID,
4758: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
4759: WHERE VISIT_ID =p_visit_id;
4760: RETURN;
4761:

Line 4758: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

4754: PLANNED_START_DATE=null,
4755: PLANNED_END_DATE=null,
4756: LAST_UPDATE_DATE = SYSDATE,
4757: LAST_UPDATED_BY = Fnd_Global.USER_ID,
4758: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
4759: WHERE VISIT_ID =p_visit_id;
4760: RETURN;
4761:
4762: ELSE

Line 4810: LAST_UPDATED_BY = Fnd_Global.USER_ID,

4806: PLANNED_END_DATE=Compute_Stage_End_Date(p_visit_id,
4807: l_visit_limited_dets.IS_OPERATIONAL_VISIT,
4808: l_visit_start_date, l_dept_id, DURATION ),-- PRAKKUM :: 23-FEB-2011 :: Bug 13711800 :: Fix for Operational Visits
4809: LAST_UPDATE_DATE = SYSDATE,
4810: LAST_UPDATED_BY = Fnd_Global.USER_ID,
4811: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
4812: WHERE VISIT_ID =p_visit_id;
4813: --PRAKKUM :: Bug 13817921 :: 07/03/2012 :: Commented since below condition not updating stage start dates even on department change
4814: --AND ( PLANNED_START_DATE IS NULL OR PLANNED_START_DATE<>l_visit_start_date );-- To update only stages whose start date is not equals to visit start date

Line 4811: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

4807: l_visit_limited_dets.IS_OPERATIONAL_VISIT,
4808: l_visit_start_date, l_dept_id, DURATION ),-- PRAKKUM :: 23-FEB-2011 :: Bug 13711800 :: Fix for Operational Visits
4809: LAST_UPDATE_DATE = SYSDATE,
4810: LAST_UPDATED_BY = Fnd_Global.USER_ID,
4811: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
4812: WHERE VISIT_ID =p_visit_id;
4813: --PRAKKUM :: Bug 13817921 :: 07/03/2012 :: Commented since below condition not updating stage start dates even on department change
4814: --AND ( PLANNED_START_DATE IS NULL OR PLANNED_START_DATE<>l_visit_start_date );-- To update only stages whose start date is not equals to visit start date
4815:

Line 5630: LAST_UPDATED_BY = Fnd_Global.USER_ID,

5626: UPDATE AHL_VWP_STAGES_B SET object_version_number=object_version_number+1,
5627: PLANNED_START_DATE = l_stage_start_date,
5628: PLANNED_END_DATE = l_stage_end_date,
5629: LAST_UPDATE_DATE = SYSDATE,
5630: LAST_UPDATED_BY = Fnd_Global.USER_ID,
5631: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
5632: WHERE STAGE_ID = l_stage_id;
5633: IF (l_log_statement >= l_log_current_level) THEN
5634: fnd_log.string(l_log_statement,L_DEBUG,l_stage_id||' stage id updated');

Line 5631: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

5627: PLANNED_START_DATE = l_stage_start_date,
5628: PLANNED_END_DATE = l_stage_end_date,
5629: LAST_UPDATE_DATE = SYSDATE,
5630: LAST_UPDATED_BY = Fnd_Global.USER_ID,
5631: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
5632: WHERE STAGE_ID = l_stage_id;
5633: IF (l_log_statement >= l_log_current_level) THEN
5634: fnd_log.string(l_log_statement,L_DEBUG,l_stage_id||' stage id updated');
5635: END IF;

Line 5883: ' LAST_UPDATED_BY = Fnd_Global.USER_ID, '||

5879:
5880: l_query_str :=' UPDATE AHL_VWP_STAGES_B set object_version_number=object_version_number+1, '||
5881: ' PLANNED_START_DATE = :p_planned_end_date, '||
5882: ' LAST_UPDATE_DATE = SYSDATE, '||
5883: ' LAST_UPDATED_BY = Fnd_Global.USER_ID, '||
5884: ' LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID '||
5885: ' WHERE STAGE_ID IN ('||parallelStagesInStr||') '||
5886: ' AND PLANNED_START_DATE = :p_max_planned_start_date';
5887: IF (l_log_statement >= l_log_current_level) THEN

Line 5884: ' LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID '||

5880: l_query_str :=' UPDATE AHL_VWP_STAGES_B set object_version_number=object_version_number+1, '||
5881: ' PLANNED_START_DATE = :p_planned_end_date, '||
5882: ' LAST_UPDATE_DATE = SYSDATE, '||
5883: ' LAST_UPDATED_BY = Fnd_Global.USER_ID, '||
5884: ' LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID '||
5885: ' WHERE STAGE_ID IN ('||parallelStagesInStr||') '||
5886: ' AND PLANNED_START_DATE = :p_max_planned_start_date';
5887: IF (l_log_statement >= l_log_current_level) THEN
5888: fnd_log.string(l_log_statement,L_DEBUG,parallelStagesInStr||' stage id updated');