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.

[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PVT dependencies on FND_GLOBAL

Line 173: last_updated_by = Fnd_Global.user_id,

169: SET requested_quantity = 0,
170: status = 'DELETED',
171: object_version_number = l_sch_mtls_Rec.object_version_number + 1,
172: last_update_date = SYSDATE,
173: last_updated_by = Fnd_Global.user_id,
174: last_update_login = Fnd_Global.login_id
175: WHERE scheduled_material_id = l_sch_mtls_Rec.scheduled_material_id;
176: --
177: END IF; --Scheduled date

Line 174: last_update_login = Fnd_Global.login_id

170: status = 'DELETED',
171: object_version_number = l_sch_mtls_Rec.object_version_number + 1,
172: last_update_date = SYSDATE,
173: last_updated_by = Fnd_Global.user_id,
174: last_update_login = Fnd_Global.login_id
175: WHERE scheduled_material_id = l_sch_mtls_Rec.scheduled_material_id;
176: --
177: END IF; --Scheduled date
178: CLOSE c_visit_task_matrl_cur;

Line 636: fnd_global.user_id,

632: VALUES
633: (l_schedule_material_id,
634: 1,
635: SYSDATE,
636: fnd_global.user_id,
637: SYSDATE,
638: fnd_global.user_id,
639: fnd_global.login_id,
640: l_inventory_item_id,

Line 638: fnd_global.user_id,

634: 1,
635: SYSDATE,
636: fnd_global.user_id,
637: SYSDATE,
638: fnd_global.user_id,
639: fnd_global.login_id,
640: l_inventory_item_id,
641: NULL,
642: p_visit_id,

Line 639: fnd_global.login_id,

635: SYSDATE,
636: fnd_global.user_id,
637: SYSDATE,
638: fnd_global.user_id,
639: fnd_global.login_id,
640: l_inventory_item_id,
641: NULL,
642: p_visit_id,
643: NULL,

Line 1866: last_updated_by = Fnd_Global.USER_ID,

1862: UPDATE ahl_schedule_materials
1863: SET STATUS = 'DELETED',
1864: object_version_number = l_Planned_Items_Rec.object_version_number + 1,
1865: last_update_date = sysdate,
1866: last_updated_by = Fnd_Global.USER_ID,
1867: last_update_login = Fnd_Global.LOGIN_ID
1868: WHERE scheduled_material_id = l_Planned_Items_Rec.scheduled_material_id;
1869: ELSE
1870: -- Begin Changes by surrkuma on 27-Jun-2011 for SB

Line 1867: last_update_login = Fnd_Global.LOGIN_ID

1863: SET STATUS = 'DELETED',
1864: object_version_number = l_Planned_Items_Rec.object_version_number + 1,
1865: last_update_date = sysdate,
1866: last_updated_by = Fnd_Global.USER_ID,
1867: last_update_login = Fnd_Global.LOGIN_ID
1868: WHERE scheduled_material_id = l_Planned_Items_Rec.scheduled_material_id;
1869: ELSE
1870: -- Begin Changes by surrkuma on 27-Jun-2011 for SB
1871: OPEN Item_exists_in_wip_cur(l_Planned_Items_Rec.scheduled_material_id);

Line 1890: last_updated_by = Fnd_Global.USER_ID,

1886: organization_id = l_visit_org_id,
1887: requested_date = trunc(l_Visit_Task_Route_Tbl(i).task_start_date),
1888: object_version_number = l_Planned_Items_Rec.object_version_number + 1,
1889: last_update_date = sysdate,
1890: last_updated_by = Fnd_Global.USER_ID,
1891: last_update_login = Fnd_Global.LOGIN_ID
1892: WHERE scheduled_material_id = l_Planned_Items_Rec.scheduled_material_id ;
1893: END IF;
1894: CLOSE Item_exists_in_wip_cur;

Line 1891: last_update_login = Fnd_Global.LOGIN_ID

1887: requested_date = trunc(l_Visit_Task_Route_Tbl(i).task_start_date),
1888: object_version_number = l_Planned_Items_Rec.object_version_number + 1,
1889: last_update_date = sysdate,
1890: last_updated_by = Fnd_Global.USER_ID,
1891: last_update_login = Fnd_Global.LOGIN_ID
1892: WHERE scheduled_material_id = l_Planned_Items_Rec.scheduled_material_id ;
1893: END IF;
1894: CLOSE Item_exists_in_wip_cur;
1895: -- End of changes by surrkuma for SB

Line 3341: LAST_UPDATED_BY = Fnd_Global.USER_ID,

3337: UPDATE ahl_Schedule_materials
3338: SET STATUS = 'HISTORY',
3339: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
3340: LAST_UPDATE_DATE = sysdate,
3341: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3342: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3343: WHERE visit_task_id = p_visit_task_id
3344: AND STATUS = 'ACTIVE';
3345:

Line 3342: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

3338: SET STATUS = 'HISTORY',
3339: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
3340: LAST_UPDATE_DATE = sysdate,
3341: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3342: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3343: WHERE visit_task_id = p_visit_task_id
3344: AND STATUS = 'ACTIVE';
3345:
3346: -- Standard check of p_commit

Line 3755: last_updated_by = Fnd_Global.USER_ID,

3751: SET requested_quantity = requested_quantity + l_prim_quantity,
3752: scheduled_quantity = scheduled_quantity + l_prim_quantity,
3753: object_version_number = object_version_number + 1,
3754: last_update_date = SYSDATE,
3755: last_updated_by = Fnd_Global.USER_ID,
3756: last_update_login = Fnd_Global.LOGIN_ID
3757: WHERE scheduled_material_id = l_scheduled_material_id;
3758: END IF;
3759: CLOSE get_workorder_detls;

Line 3756: last_update_login = Fnd_Global.LOGIN_ID

3752: scheduled_quantity = scheduled_quantity + l_prim_quantity,
3753: object_version_number = object_version_number + 1,
3754: last_update_date = SYSDATE,
3755: last_updated_by = Fnd_Global.USER_ID,
3756: last_update_login = Fnd_Global.LOGIN_ID
3757: WHERE scheduled_material_id = l_scheduled_material_id;
3758: END IF;
3759: CLOSE get_workorder_detls;
3760: CLOSE get_scheduled_mat_detls;

Line 4215: last_updated_by = Fnd_Global.USER_ID,

4211: SET requested_quantity = l_prim_req_quantity,
4212: scheduled_quantity = l_prim_sch_quantity,
4213: object_version_number = object_version_number + 1,
4214: last_update_date = SYSDATE,
4215: last_updated_by = Fnd_Global.USER_ID,
4216: last_update_login = Fnd_Global.LOGIN_ID
4217: WHERE scheduled_material_id = l_scheduled_material_id;
4218: END IF;
4219: CLOSE get_workorder_detls;

Line 4216: last_update_login = Fnd_Global.LOGIN_ID

4212: scheduled_quantity = l_prim_sch_quantity,
4213: object_version_number = object_version_number + 1,
4214: last_update_date = SYSDATE,
4215: last_updated_by = Fnd_Global.USER_ID,
4216: last_update_login = Fnd_Global.LOGIN_ID
4217: WHERE scheduled_material_id = l_scheduled_material_id;
4218: END IF;
4219: CLOSE get_workorder_detls;
4220: