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

Line 2491: X_CREATED_BY => Fnd_Global.USER_ID,

2487: X_ANY_TASK_CHG_FLAG => 'N',
2488: X_VISIT_NAME => l_Visit_rec.VISIT_NAME,
2489: X_DESCRIPTION => l_Visit_rec.DESCRIPTION,
2490: X_CREATION_DATE => SYSDATE,
2491: X_CREATED_BY => Fnd_Global.USER_ID,
2492: X_LAST_UPDATE_DATE => SYSDATE,
2493: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2494: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
2495: X_PRIORITY_CODE => l_visit_rec.priority_code,

Line 2493: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

2489: X_DESCRIPTION => l_Visit_rec.DESCRIPTION,
2490: X_CREATION_DATE => SYSDATE,
2491: X_CREATED_BY => Fnd_Global.USER_ID,
2492: X_LAST_UPDATE_DATE => SYSDATE,
2493: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2494: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
2495: X_PRIORITY_CODE => l_visit_rec.priority_code,
2496: X_PROJECT_TEMPLATE_ID => l_visit_rec.proj_template_id,
2497: X_UNIT_SCHEDULE_ID => l_Visit_rec.unit_schedule_id,

Line 2494: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,

2490: X_CREATION_DATE => SYSDATE,
2491: X_CREATED_BY => Fnd_Global.USER_ID,
2492: X_LAST_UPDATE_DATE => SYSDATE,
2493: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2494: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
2495: X_PRIORITY_CODE => l_visit_rec.priority_code,
2496: X_PROJECT_TEMPLATE_ID => l_visit_rec.proj_template_id,
2497: X_UNIT_SCHEDULE_ID => l_Visit_rec.unit_schedule_id,
2498: --PRAKKUM ::FP PIE :: 13-OCT-2010

Line 2593: LAST_UPDATED_BY = Fnd_Global.USER_ID,

2589: UPDATE AHL_VISITS_B
2590: set PAST_DATED_VISIT_FLAG = 'N',
2591: OBJECT_VERSION_NUMBER = object_version_number + 1,
2592: LAST_UPDATE_DATE = SYSDATE,
2593: LAST_UPDATED_BY = Fnd_Global.USER_ID,
2594: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
2595: WHERE VISIT_ID = l_visit_rec.visit_id;
2596: END IF;
2597: -- TCHIMIRA :: Changes for Component Maintenance Planning :: 10-JAN-2012 :: END

Line 2594: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

2590: set PAST_DATED_VISIT_FLAG = 'N',
2591: OBJECT_VERSION_NUMBER = object_version_number + 1,
2592: LAST_UPDATE_DATE = SYSDATE,
2593: LAST_UPDATED_BY = Fnd_Global.USER_ID,
2594: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
2595: WHERE VISIT_ID = l_visit_rec.visit_id;
2596: END IF;
2597: -- TCHIMIRA :: Changes for Component Maintenance Planning :: 10-JAN-2012 :: END
2598: IF l_Visit_rec.visit_type_code IS NOT NULL

Line 3034: X_CREATED_BY => Fnd_Global.USER_ID,

3030: X_ANY_TASK_CHG_FLAG => 'N',
3031: X_VISIT_NAME => c_Visit_rec.VISIT_NAME,
3032: X_DESCRIPTION => c_Visit_rec.DESCRIPTION,
3033: X_CREATION_DATE => SYSDATE,
3034: X_CREATED_BY => Fnd_Global.USER_ID,
3035: X_LAST_UPDATE_DATE => SYSDATE,
3036: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3037: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
3038: X_PRIORITY_CODE => c_Visit_rec.PRIORITY_CODE,

Line 3036: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

3032: X_DESCRIPTION => c_Visit_rec.DESCRIPTION,
3033: X_CREATION_DATE => SYSDATE,
3034: X_CREATED_BY => Fnd_Global.USER_ID,
3035: X_LAST_UPDATE_DATE => SYSDATE,
3036: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3037: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
3038: X_PRIORITY_CODE => c_Visit_rec.PRIORITY_CODE,
3039: X_PROJECT_TEMPLATE_ID => c_Visit_rec.PROJECT_TEMPLATE_ID,
3040: X_UNIT_SCHEDULE_ID => c_Visit_rec.UNIT_SCHEDULE_ID,

Line 3037: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,

3033: X_CREATION_DATE => SYSDATE,
3034: X_CREATED_BY => Fnd_Global.USER_ID,
3035: X_LAST_UPDATE_DATE => SYSDATE,
3036: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3037: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
3038: X_PRIORITY_CODE => c_Visit_rec.PRIORITY_CODE,
3039: X_PROJECT_TEMPLATE_ID => c_Visit_rec.PROJECT_TEMPLATE_ID,
3040: X_UNIT_SCHEDULE_ID => c_Visit_rec.UNIT_SCHEDULE_ID,
3041: --PRAKKUM ::FP PIE :: 13-OCT-2010

Line 3144: X_CREATED_BY => Fnd_Global.USER_ID,

3140: X_VISIT_TASK_NAME => c_task_rec.visit_task_name,
3141: X_DESCRIPTION => c_task_rec.description,
3142: X_QUANTITY => c_task_rec.quantity, -- Added by rnahata for Issue 105
3143: X_CREATION_DATE => SYSDATE,
3144: X_CREATED_BY => Fnd_Global.USER_ID,
3145: X_LAST_UPDATE_DATE => SYSDATE,
3146: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3147: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
3148:

Line 3146: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

3142: X_QUANTITY => c_task_rec.quantity, -- Added by rnahata for Issue 105
3143: X_CREATION_DATE => SYSDATE,
3144: X_CREATED_BY => Fnd_Global.USER_ID,
3145: X_LAST_UPDATE_DATE => SYSDATE,
3146: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3147: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
3148:
3149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3150: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VISIT_TASKS_PKG.INSERT_ROW ');

Line 3147: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );

3143: X_CREATION_DATE => SYSDATE,
3144: X_CREATED_BY => Fnd_Global.USER_ID,
3145: X_LAST_UPDATE_DATE => SYSDATE,
3146: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3147: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
3148:
3149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3150: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VISIT_TASKS_PKG.INSERT_ROW ');
3151: END IF;

Line 3245: Fnd_Global.USER_ID,

3241: (
3242: ahl_task_links_s.nextval,
3243: 1,
3244: SYSDATE,
3245: Fnd_Global.USER_ID,
3246: SYSDATE,
3247: Fnd_Global.USER_ID,
3248: Fnd_Global.USER_ID,
3249: l_new_task_id ,

Line 3247: Fnd_Global.USER_ID,

3243: 1,
3244: SYSDATE,
3245: Fnd_Global.USER_ID,
3246: SYSDATE,
3247: Fnd_Global.USER_ID,
3248: Fnd_Global.USER_ID,
3249: l_new_task_id ,
3250: l_new_parent_task_id,
3251: --l_task_link_rec.SECURITY_GROUP_ID,

Line 3248: Fnd_Global.USER_ID,

3244: SYSDATE,
3245: Fnd_Global.USER_ID,
3246: SYSDATE,
3247: Fnd_Global.USER_ID,
3248: Fnd_Global.USER_ID,
3249: l_new_task_id ,
3250: l_new_parent_task_id,
3251: --l_task_link_rec.SECURITY_GROUP_ID,
3252: l_task_link_rec.ATTRIBUTE_CATEGORY,

Line 4541: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

4537: X_DESCRIPTION => l_Visit_rec.DESCRIPTION,
4538: X_PRIORITY_CODE => l_visit_rec.PRIORITY_CODE,
4539: X_PROJECT_TEMPLATE_ID => l_visit_rec.PROJ_TEMPLATE_ID,
4540: X_LAST_UPDATE_DATE => SYSDATE,
4541: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4542: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
4543: X_UNIT_SCHEDULE_ID => c_Visit_rec.unit_schedule_id,
4544: X_INV_LOCATOR_ID => l_visit_rec.INV_LOCATOR_ID, --Added by sowsubra
4545: -- SATHAPLI::Component Maintenance Planning Project, 02-Nov-2011

Line 4542: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,

4538: X_PRIORITY_CODE => l_visit_rec.PRIORITY_CODE,
4539: X_PROJECT_TEMPLATE_ID => l_visit_rec.PROJ_TEMPLATE_ID,
4540: X_LAST_UPDATE_DATE => SYSDATE,
4541: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4542: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
4543: X_UNIT_SCHEDULE_ID => c_Visit_rec.unit_schedule_id,
4544: X_INV_LOCATOR_ID => l_visit_rec.INV_LOCATOR_ID, --Added by sowsubra
4545: -- SATHAPLI::Component Maintenance Planning Project, 02-Nov-2011
4546: -- set the Planning and In-Repair locators

Line 5616: LAST_UPDATED_BY = Fnd_Global.USER_ID,

5612: SIMULATION_PLAN_ID = NULL,
5613: OBJECT_VERSION_NUMBER =OBJECT_VERSION_NUMBER + 1,
5614: --TCHIMIRA::FP BUG 12668460 for BUG 12607498 ::14-JUN-2011::UPDATE WHO COLUMNS
5615: LAST_UPDATE_DATE = SYSDATE,
5616: LAST_UPDATED_BY = Fnd_Global.USER_ID,
5617: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
5618: WHERE VISIT_ID = l_visit_rec.visit_id;
5619: END IF; -- soft delete flag
5620: --------------------------End of API Body---------------------------------------

Line 5617: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

5613: OBJECT_VERSION_NUMBER =OBJECT_VERSION_NUMBER + 1,
5614: --TCHIMIRA::FP BUG 12668460 for BUG 12607498 ::14-JUN-2011::UPDATE WHO COLUMNS
5615: LAST_UPDATE_DATE = SYSDATE,
5616: LAST_UPDATED_BY = Fnd_Global.USER_ID,
5617: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
5618: WHERE VISIT_ID = l_visit_rec.visit_id;
5619: END IF; -- soft delete flag
5620: --------------------------End of API Body---------------------------------------
5621: --Standard check to count messages

Line 6550: p_program_id => fnd_global.PROG_APPL_ID,

6546:
6547: AHL_VWP_COST_PVT.Get_WO_Cost(
6548: p_Session_Id => l_cost_price_rec.mr_session_id,
6549: p_Id => l_wip_entity_rec.wip_entity_id,
6550: p_program_id => fnd_global.PROG_APPL_ID,
6551: x_actual_cost => l_actual_cost,
6552: x_estimated_cost => l_estimated_cost,
6553: x_return_status => l_return_status);
6554:

Line 6591: p_program_id => fnd_global.PROG_APPL_ID,

6587:
6588: AHL_VWP_COST_PVT.Get_WO_Cost(
6589: p_Session_Id => l_cost_price_rec.mr_session_id,
6590: p_Id => l_summ_task_rec.visit_task_id,
6591: p_program_id => fnd_global.PROG_APPL_ID,
6592: x_actual_cost => l_actual_cost,
6593: x_estimated_cost => l_estimated_cost,
6594: x_return_status => l_return_status);
6595:

Line 6658: LAST_UPDATED_BY = Fnd_Global.USER_ID,

6654: SIMULATION_PLAN_ID = NULL,
6655: OBJECT_VERSION_NUMBER = c_visit_rec.object_version_number + 1,
6656: --TCHIMIRA::FP BUG 12668460 for BUG 12607498 ::14-JUN-2011::UPDATE WHO COLUMNS
6657: LAST_UPDATE_DATE = SYSDATE,
6658: LAST_UPDATED_BY = Fnd_Global.USER_ID,
6659: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
6660: WHERE VISIT_ID = p_visit_id;
6661:
6662: -- To update all tasks to CLOSED status

Line 6659: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

6655: OBJECT_VERSION_NUMBER = c_visit_rec.object_version_number + 1,
6656: --TCHIMIRA::FP BUG 12668460 for BUG 12607498 ::14-JUN-2011::UPDATE WHO COLUMNS
6657: LAST_UPDATE_DATE = SYSDATE,
6658: LAST_UPDATED_BY = Fnd_Global.USER_ID,
6659: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
6660: WHERE VISIT_ID = p_visit_id;
6661:
6662: -- To update all tasks to CLOSED status
6663: OPEN c_task(p_visit_id);

Line 6673: LAST_UPDATED_BY = Fnd_Global.USER_ID,

6669: SET STATUS_CODE = 'CLOSED',
6670: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1,
6671: --TCHIMIRA::FP BUG 12668460 for BUG 12607498 ::14-JUN-2011::UPDATE WHO COLUMNS
6672: LAST_UPDATE_DATE = SYSDATE,
6673: LAST_UPDATED_BY = Fnd_Global.USER_ID,
6674: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
6675: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id;
6676: END LOOP;
6677: CLOSE c_task;

Line 6674: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

6670: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1,
6671: --TCHIMIRA::FP BUG 12668460 for BUG 12607498 ::14-JUN-2011::UPDATE WHO COLUMNS
6672: LAST_UPDATE_DATE = SYSDATE,
6673: LAST_UPDATED_BY = Fnd_Global.USER_ID,
6674: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
6675: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id;
6676: END LOOP;
6677: CLOSE c_task;
6678:

Line 7024: LAST_UPDATED_BY = Fnd_Global.USER_ID,

7020: UPDATE AHL_VISIT_TASKS_B
7021: SET UNIT_EFFECTIVITY_ID = NULL,
7022: OBJECT_VERSION_NUMBER = object_version_number + 1,
7023: LAST_UPDATE_DATE = SYSDATE,
7024: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7025: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7026: WHERE VISIT_ID = p_visit_id
7027: AND NVL(UNIT_EFFECTIVITY_ID, -1) = l_ue_id_inst_tbl(i);
7028: END LOOP;

Line 7025: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

7021: SET UNIT_EFFECTIVITY_ID = NULL,
7022: OBJECT_VERSION_NUMBER = object_version_number + 1,
7023: LAST_UPDATE_DATE = SYSDATE,
7024: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7025: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7026: WHERE VISIT_ID = p_visit_id
7027: AND NVL(UNIT_EFFECTIVITY_ID, -1) = l_ue_id_inst_tbl(i);
7028: END LOOP;
7029: END IF;

Line 7080: LAST_UPDATED_BY = Fnd_Global.USER_ID,

7076: SET STATUS_CODE = 'CANCELLED',
7077: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1,
7078: --TCHIMIRA::FP BUG 12668460 for BUG 12607498 ::14-JUN-2011::UPDATE WHO COLUMNS
7079: LAST_UPDATE_DATE = SYSDATE,
7080: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7081: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7082: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id;
7083: END LOOP;
7084: CLOSE c_task;

Line 7081: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

7077: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1,
7078: --TCHIMIRA::FP BUG 12668460 for BUG 12607498 ::14-JUN-2011::UPDATE WHO COLUMNS
7079: LAST_UPDATE_DATE = SYSDATE,
7080: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7081: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7082: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id;
7083: END LOOP;
7084: CLOSE c_task;
7085:

Line 7095: LAST_UPDATED_BY = Fnd_Global.USER_ID,

7091: SET STATUS_CODE = 'CANCELLED',
7092: OBJECT_VERSION_NUMBER = c_visit_rec.object_version_number + 1,
7093: --TCHIMIRA::FP BUG 12668460 for BUG 12607498 ::14-JUN-2011::UPDATE WHO COLUMNS
7094: LAST_UPDATE_DATE = SYSDATE,
7095: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7096: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7097: WHERE VISIT_ID = p_visit_id;
7098:
7099: -- ****** cancelled check has to be added to production api

Line 7096: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

7092: OBJECT_VERSION_NUMBER = c_visit_rec.object_version_number + 1,
7093: --TCHIMIRA::FP BUG 12668460 for BUG 12607498 ::14-JUN-2011::UPDATE WHO COLUMNS
7094: LAST_UPDATE_DATE = SYSDATE,
7095: LAST_UPDATED_BY = Fnd_Global.USER_ID,
7096: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7097: WHERE VISIT_ID = p_visit_id;
7098:
7099: -- ****** cancelled check has to be added to production api
7100: -- Check if visit project id is null