DBA Data[Home] [Help]

APPS.AHL_VWP_TASKS_PVT dependencies on FND_GLOBAL

Line 2423: X_CREATED_BY => Fnd_Global.USER_ID,

2419: X_VISIT_TASK_NAME => l_task_rec.visit_task_name,
2420: X_DESCRIPTION => l_task_rec.description,
2421: X_QUANTITY => l_Task_rec.quantity, -- Added by rnahata for Issue 105
2422: X_CREATION_DATE => SYSDATE,
2423: X_CREATED_BY => Fnd_Global.USER_ID,
2424: X_LAST_UPDATE_DATE => SYSDATE,
2425: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2426: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
2427:

Line 2425: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

2421: X_QUANTITY => l_Task_rec.quantity, -- Added by rnahata for Issue 105
2422: X_CREATION_DATE => SYSDATE,
2423: X_CREATED_BY => Fnd_Global.USER_ID,
2424: X_LAST_UPDATE_DATE => SYSDATE,
2425: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2426: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
2427:
2428: ------------------------- finish -------------------------------
2429:

Line 2426: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );

2422: X_CREATION_DATE => SYSDATE,
2423: X_CREATED_BY => Fnd_Global.USER_ID,
2424: X_LAST_UPDATE_DATE => SYSDATE,
2425: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2426: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
2427:
2428: ------------------------- finish -------------------------------
2429:
2430: -- salogan added for supplier warranty starts

Line 3137: X_CREATED_BY => Fnd_Global.USER_ID,

3133: X_DESCRIPTION => l_task_rec.description,
3134: -- Added by rnahata for Issue 105 - Qty is zero for manully created summary tasks
3135: X_QUANTITY => 0,
3136: X_CREATION_DATE => SYSDATE,
3137: X_CREATED_BY => Fnd_Global.USER_ID,
3138: X_LAST_UPDATE_DATE => SYSDATE,
3139: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3140: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
3141: X_REPAIR_BATCH_NAME => l_task_rec.REPAIR_BATCH_NAME --PRAKKUM :: 13/06/2012 :: Bug 14068468

Line 3139: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

3135: X_QUANTITY => 0,
3136: X_CREATION_DATE => SYSDATE,
3137: X_CREATED_BY => Fnd_Global.USER_ID,
3138: X_LAST_UPDATE_DATE => SYSDATE,
3139: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3140: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
3141: X_REPAIR_BATCH_NAME => l_task_rec.REPAIR_BATCH_NAME --PRAKKUM :: 13/06/2012 :: Bug 14068468
3142: );
3143:

Line 3140: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,

3136: X_CREATION_DATE => SYSDATE,
3137: X_CREATED_BY => Fnd_Global.USER_ID,
3138: X_LAST_UPDATE_DATE => SYSDATE,
3139: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3140: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
3141: X_REPAIR_BATCH_NAME => l_task_rec.REPAIR_BATCH_NAME --PRAKKUM :: 13/06/2012 :: Bug 14068468
3142: );
3143:
3144: IF (l_log_statement >= l_log_current_level) THEN

Line 4495: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

4491: X_VISIT_TASK_NAME => l_task_rec.visit_task_name,
4492: X_DESCRIPTION => l_task_rec.description,
4493: X_QUANTITY => l_old_Task_rec.quantity, -- Added by rnahata for Issue 105
4494: X_LAST_UPDATE_DATE => SYSDATE,
4495: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4496: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
4497:
4498: IF (l_log_statement >= l_log_current_level) THEN
4499: fnd_log.string(l_log_statement,

Line 4496: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );

4492: X_DESCRIPTION => l_task_rec.description,
4493: X_QUANTITY => l_old_Task_rec.quantity, -- Added by rnahata for Issue 105
4494: X_LAST_UPDATE_DATE => SYSDATE,
4495: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4496: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
4497:
4498: IF (l_log_statement >= l_log_current_level) THEN
4499: fnd_log.string(l_log_statement,
4500: L_DEBUG_KEY,

Line 5065: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

5061: X_VISIT_TASK_NAME => l_task_rec.visit_task_name,
5062: X_DESCRIPTION => l_task_rec.description,
5063: X_QUANTITY => c_task_rec.quantity, -- Added by rnahata for Issue 105
5064: X_LAST_UPDATE_DATE => SYSDATE,
5065: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
5066: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
5067:
5068: IF (l_log_statement >= l_log_current_level) THEN
5069: fnd_log.string(l_log_statement,

Line 5066: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );

5062: X_DESCRIPTION => l_task_rec.description,
5063: X_QUANTITY => c_task_rec.quantity, -- Added by rnahata for Issue 105
5064: X_LAST_UPDATE_DATE => SYSDATE,
5065: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
5066: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
5067:
5068: IF (l_log_statement >= l_log_current_level) THEN
5069: fnd_log.string(l_log_statement,
5070: L_DEBUG_KEY,

Line 5712: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

5708: X_DESCRIPTION => l_task_rec.description,
5709: -- Added by rnahata for Issue 105 - qty is zero for manually created summary tasks
5710: X_QUANTITY => 0,
5711: X_LAST_UPDATE_DATE => SYSDATE,
5712: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
5713: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
5714:
5715: IF (l_log_statement >= l_log_current_level) THEN
5716: fnd_log.string(l_log_statement,

Line 5713: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );

5709: -- Added by rnahata for Issue 105 - qty is zero for manually created summary tasks
5710: X_QUANTITY => 0,
5711: X_LAST_UPDATE_DATE => SYSDATE,
5712: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
5713: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
5714:
5715: IF (l_log_statement >= l_log_current_level) THEN
5716: fnd_log.string(l_log_statement,
5717: L_DEBUG_KEY,

Line 6239: last_updated_by = Fnd_Global.USER_ID,

6235: UPDATE AHL_VISIT_TASKS_B
6236: SET status_code = 'RELEASED',
6237: object_version_number = object_version_number + 1,
6238: last_update_date = SYSDATE,
6239: last_updated_by = Fnd_Global.USER_ID,
6240: last_update_login = Fnd_Global.LOGIN_ID
6241: WHERE repair_batch_name = l_repair_batch_name;
6242:
6243: END IF;

Line 6240: last_update_login = Fnd_Global.LOGIN_ID

6236: SET status_code = 'RELEASED',
6237: object_version_number = object_version_number + 1,
6238: last_update_date = SYSDATE,
6239: last_updated_by = Fnd_Global.USER_ID,
6240: last_update_login = Fnd_Global.LOGIN_ID
6241: WHERE repair_batch_name = l_repair_batch_name;
6242:
6243: END IF;
6244: CLOSE chk_rpr_batch_has_planed_tasks;

Line 9392: last_updated_by = Fnd_Global.USER_ID,

9388: UPDATE AHL_VISIT_TASKS_B
9389: SET status_code = 'PARTIALLY RELEASED',
9390: object_version_number = object_version_number + 1,
9391: last_update_date = SYSDATE,
9392: last_updated_by = Fnd_Global.USER_ID,
9393: last_update_login = Fnd_Global.LOGIN_ID
9394: WHERE visit_task_id = l_repair_batch_task_id;
9395: END IF;
9396:

Line 9393: last_update_login = Fnd_Global.LOGIN_ID

9389: SET status_code = 'PARTIALLY RELEASED',
9390: object_version_number = object_version_number + 1,
9391: last_update_date = SYSDATE,
9392: last_updated_by = Fnd_Global.USER_ID,
9393: last_update_login = Fnd_Global.LOGIN_ID
9394: WHERE visit_task_id = l_repair_batch_task_id;
9395: END IF;
9396:
9397: END IF; -- IF l_is_cost_parent_setting_done

Line 10164: X_CREATED_BY => Fnd_Global.USER_ID,

10160: X_VISIT_TASK_NAME => 'Stage Task',
10161: X_DESCRIPTION => NULL,
10162: X_QUANTITY => 1,
10163: X_CREATION_DATE => SYSDATE,
10164: X_CREATED_BY => Fnd_Global.USER_ID,
10165: X_LAST_UPDATE_DATE => SYSDATE,
10166: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
10167: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
10168:

Line 10166: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

10162: X_QUANTITY => 1,
10163: X_CREATION_DATE => SYSDATE,
10164: X_CREATED_BY => Fnd_Global.USER_ID,
10165: X_LAST_UPDATE_DATE => SYSDATE,
10166: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
10167: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
10168:
10169:
10170:

Line 10167: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );

10163: X_CREATION_DATE => SYSDATE,
10164: X_CREATED_BY => Fnd_Global.USER_ID,
10165: X_LAST_UPDATE_DATE => SYSDATE,
10166: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
10167: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
10168:
10169:
10170:
10171: --------------------End of API Body-------------------------------------

Line 10182: LAST_UPDATED_BY = Fnd_Global.USER_ID,

10178: UPDATE AHL_VISITS_B
10179: SET STATUS_CODE = 'PARTIALLY RELEASED',
10180: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
10181: LAST_UPDATE_DATE = SYSDATE,
10182: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10183: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10184: WHERE VISIT_ID = p_visit_id
10185: AND STATUS_CODE = 'RELEASED';
10186:

Line 10183: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

10179: SET STATUS_CODE = 'PARTIALLY RELEASED',
10180: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
10181: LAST_UPDATE_DATE = SYSDATE,
10182: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10183: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10184: WHERE VISIT_ID = p_visit_id
10185: AND STATUS_CODE = 'RELEASED';
10186:
10187: AHL_VWP_PROJ_PROD_PVT.plan_visit(