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:
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:
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
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
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:
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
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,
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,
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,
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,
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,
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,
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;
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;
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:
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
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:
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:
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-------------------------------------
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:
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(