DBA Data[Home] [Help]

APPS.PA_MU_BATCHES_V_PKG dependencies on PA_MASS_UPDATE_DETAILS

Line 375: DELETE FROM pa_mass_update_details

371: -- First, delete all the lines for this batch
372: --
373: BEGIN
374:
375: DELETE FROM pa_mass_update_details
376: WHERE batch_id = l_batch_id;
377:
378: EXCEPTION
379: WHEN NO_DATA_FOUND THEN

Line 523: FROM pa_mass_update_details

519: new_attribute_value,
520: update_flag,
521: recalculate_flag,
522: pa_security.allow_update(project_id) allow_update
523: FROM pa_mass_update_details
524: WHERE batch_id = X_Batch_ID
525: FOR UPDATE;
526:
527: --

Line 700: UPDATE pa_mass_update_details

696:
697: CLOSE l_batch_csr;
698:
699: -- Reset the rejection reason for all the lines
700: UPDATE pa_mass_update_details
701: SET rejection_reason = NULL,
702: last_updated_by = FND_GLOBAL.user_id,
703: last_update_date = sysdate,
704: last_update_login = FND_GLOBAL.login_id

Line 974: UPDATE pa_mass_update_details

970: --
971: ROLLBACK TO Process_Batch;
972:
973: FOR i IN l_Error_Tab.FIRST .. l_Error_Tab.LAST LOOP
974: UPDATE pa_mass_update_details
975: SET rejection_reason = l_Error_Tab(i).rejection_reason,
976: last_updated_by = FND_GLOBAL.user_id,
977: last_update_date = sysdate,
978: last_update_login = FND_GLOBAL.login_id