DBA Data[Home] [Help]

APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on FND_GLOBAL

Line 844: X_LAST_UPDATED_BY => fnd_global.user_id,

840: X_ANY_TASK_CHG_FLAG => visit_rec.ANY_TASK_CHG_FLAG,
841: X_VISIT_NAME => visit_rec.VISIT_NAME,
842: X_DESCRIPTION => visit_rec.DESCRIPTION,
843: X_LAST_UPDATE_DATE => SYSDATE,
844: X_LAST_UPDATED_BY => fnd_global.user_id,
845: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
846: X_PRIORITY_CODE => visit_rec.PRIORITY_CODE,
847: X_PROJECT_TEMPLATE_ID => visit_rec.PROJECT_TEMPLATE_ID,
848: X_UNIT_SCHEDULE_ID => visit_rec.unit_schedule_id,

Line 845: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

841: X_VISIT_NAME => visit_rec.VISIT_NAME,
842: X_DESCRIPTION => visit_rec.DESCRIPTION,
843: X_LAST_UPDATE_DATE => SYSDATE,
844: X_LAST_UPDATED_BY => fnd_global.user_id,
845: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
846: X_PRIORITY_CODE => visit_rec.PRIORITY_CODE,
847: X_PROJECT_TEMPLATE_ID => visit_rec.PROJECT_TEMPLATE_ID,
848: X_UNIT_SCHEDULE_ID => visit_rec.unit_schedule_id,
849: X_INV_LOCATOR_ID => visit_rec.INV_LOCATOR_ID, --Added by sowsubra

Line 2097: X_LAST_UPDATED_BY => fnd_global.user_id,

2093: X_DESCRIPTION => visit_rec.DESCRIPTION,
2094:
2095: X_LAST_UPDATE_DATE => SYSDATE,
2096:
2097: X_LAST_UPDATED_BY => fnd_global.user_id,
2098:
2099: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2100:
2101: X_PRIORITY_CODE => visit_rec.PRIORITY_CODE,

Line 2099: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

2095: X_LAST_UPDATE_DATE => SYSDATE,
2096:
2097: X_LAST_UPDATED_BY => fnd_global.user_id,
2098:
2099: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2100:
2101: X_PRIORITY_CODE => visit_rec.PRIORITY_CODE,
2102: X_PROJECT_TEMPLATE_ID => visit_rec.PROJECT_TEMPLATE_ID,
2103: X_UNIT_SCHEDULE_ID => visit_rec.unit_schedule_id,

Line 2341: X_LAST_UPDATED_BY => fnd_global.user_id,

2337: X_SNAPSHOT_NUMBER => l_snapshot_number,
2338:
2339: X_LAST_UPDATE_DATE => SYSDATE,
2340:
2341: X_LAST_UPDATED_BY => fnd_global.user_id,
2342:
2343: X_CREATION_DATE => SYSDATE,
2344:
2345: X_CREATED_BY => fnd_global.user_id,

Line 2345: X_CREATED_BY => fnd_global.user_id,

2341: X_LAST_UPDATED_BY => fnd_global.user_id,
2342:
2343: X_CREATION_DATE => SYSDATE,
2344:
2345: X_CREATED_BY => fnd_global.user_id,
2346:
2347: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2348:
2349: X_VISIT_ID => p_visit_id,

Line 2347: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

2343: X_CREATION_DATE => SYSDATE,
2344:
2345: X_CREATED_BY => fnd_global.user_id,
2346:
2347: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2348:
2349: X_VISIT_ID => p_visit_id,
2350:
2351: X_VISIT_TASK_ID => other_tasks_rec.visit_task_id,

Line 2645: X_LAST_UPDATED_BY => fnd_global.user_id,

2641: X_SNAPSHOT_ID => l_snapshot_id,
2642: X_OBJECT_VERSION_NUMBER => 1,
2643: X_SNAPSHOT_NUMBER => l_snapshot_number,
2644: X_LAST_UPDATE_DATE => SYSDATE,
2645: X_LAST_UPDATED_BY => fnd_global.user_id,
2646: X_CREATION_DATE => SYSDATE,
2647: X_CREATED_BY => fnd_global.user_id,
2648: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2649: X_VISIT_ID => p_x_cost_price_rec.visit_id,

Line 2647: X_CREATED_BY => fnd_global.user_id,

2643: X_SNAPSHOT_NUMBER => l_snapshot_number,
2644: X_LAST_UPDATE_DATE => SYSDATE,
2645: X_LAST_UPDATED_BY => fnd_global.user_id,
2646: X_CREATION_DATE => SYSDATE,
2647: X_CREATED_BY => fnd_global.user_id,
2648: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2649: X_VISIT_ID => p_x_cost_price_rec.visit_id,
2650: X_VISIT_TASK_ID => summary_tasks_rec.visit_task_id,
2651: X_MR_ID => summary_tasks_rec.mr_id,

Line 2648: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

2644: X_LAST_UPDATE_DATE => SYSDATE,
2645: X_LAST_UPDATED_BY => fnd_global.user_id,
2646: X_CREATION_DATE => SYSDATE,
2647: X_CREATED_BY => fnd_global.user_id,
2648: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2649: X_VISIT_ID => p_x_cost_price_rec.visit_id,
2650: X_VISIT_TASK_ID => summary_tasks_rec.visit_task_id,
2651: X_MR_ID => summary_tasks_rec.mr_id,
2652: X_ESTIMATED_PRICE => null,

Line 2712: X_LAST_UPDATED_BY => fnd_global.user_id,

2708: X_SNAPSHOT_ID => l_snapshot_id,
2709: X_OBJECT_VERSION_NUMBER => 1,
2710: X_SNAPSHOT_NUMBER => l_snapshot_number,
2711: X_LAST_UPDATE_DATE => SYSDATE,
2712: X_LAST_UPDATED_BY => fnd_global.user_id,
2713: X_CREATION_DATE => SYSDATE,
2714: X_CREATED_BY => fnd_global.user_id,
2715: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2716: X_VISIT_ID => p_x_cost_price_rec.visit_id,

Line 2714: X_CREATED_BY => fnd_global.user_id,

2710: X_SNAPSHOT_NUMBER => l_snapshot_number,
2711: X_LAST_UPDATE_DATE => SYSDATE,
2712: X_LAST_UPDATED_BY => fnd_global.user_id,
2713: X_CREATION_DATE => SYSDATE,
2714: X_CREATED_BY => fnd_global.user_id,
2715: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2716: X_VISIT_ID => p_x_cost_price_rec.visit_id,
2717: X_VISIT_TASK_ID => other_tasks_rec.visit_task_id,
2718: X_MR_ID => other_tasks_rec.mr_id,

Line 2715: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

2711: X_LAST_UPDATE_DATE => SYSDATE,
2712: X_LAST_UPDATED_BY => fnd_global.user_id,
2713: X_CREATION_DATE => SYSDATE,
2714: X_CREATED_BY => fnd_global.user_id,
2715: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2716: X_VISIT_ID => p_x_cost_price_rec.visit_id,
2717: X_VISIT_TASK_ID => other_tasks_rec.visit_task_id,
2718: X_MR_ID => other_tasks_rec.mr_id,
2719: X_ESTIMATED_PRICE => null,

Line 3749: LAST_UPDATED_BY = Fnd_Global.USER_ID,

3745: UPDATE ahl_visits_b
3746: SET CST_EST_REQUEST_ID = l_req_id,
3747: OBJECT_VERSION_NUMBER = object_version_number + 1,
3748: LAST_UPDATE_DATE = SYSDATE,
3749: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3750: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3751: WHERE visit_id = p_x_cost_price_rec.Visit_id;
3752: CLOSE c_visit;
3753: COMMIT WORK;

Line 3750: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

3746: SET CST_EST_REQUEST_ID = l_req_id,
3747: OBJECT_VERSION_NUMBER = object_version_number + 1,
3748: LAST_UPDATE_DATE = SYSDATE,
3749: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3750: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3751: WHERE visit_id = p_x_cost_price_rec.Visit_id;
3752: CLOSE c_visit;
3753: COMMIT WORK;
3754: END IF;

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

3841:
3842: -- 2. Dump all input parameters
3843: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
3844: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
3845: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
3846: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
3847: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
3848: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
3849:

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

3842: -- 2. Dump all input parameters
3843: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
3844: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
3845: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
3846: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
3847: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
3848: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
3849:
3850: SELECT visit_id INTO l_cost_price_rec.visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;

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

3843: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
3844: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
3845: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
3846: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
3847: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
3848: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
3849:
3850: SELECT visit_id INTO l_cost_price_rec.visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;
3851: