APPS.PA_MU_DETAILS_V_PKG dependencies on PA_MASS_UPDATE_DETAILS

Line 23: SELECT PA_MASS_UPDATE_DETAILS_S.NextVal

19: IS
20: l_line_id NUMBER;
21: BEGIN
22:
23: SELECT PA_MASS_UPDATE_DETAILS_S.NextVal
24: INTO l_line_id
25: FROM dual;
26:
27: INSERT INTO PA_MASS_UPDATE_DETAILS

Line 27: INSERT INTO PA_MASS_UPDATE_DETAILS

23: SELECT PA_MASS_UPDATE_DETAILS_S.NextVal
24: INTO l_line_id
25: FROM dual;
26:
27: INSERT INTO PA_MASS_UPDATE_DETAILS
28: ( Batch_ID,
29: Line_ID,
30: Project_ID,
31: Task_ID,

Line 60: FROM PA_MASS_UPDATE_DETAILS

56:
57: X_Line_ID := l_line_id;
58:
59: SELECT rowid INTO X_Rowid
60: FROM PA_MASS_UPDATE_DETAILS
61: WHERE batch_id = X_batch_id
62: AND line_id = l_line_id;
63:
64: END Insert_Row;

Line 82: UPDATE pa_mass_update_details

78: IS
79:
80: BEGIN
81:
82: UPDATE pa_mass_update_details
83: SET
84: Project_ID = X_Project_ID,
85: Task_ID = X_Task_ID,
86: Old_Attribute_Value = X_Old_Attribute_Value,

Line 123: FROM pa_mass_update_details

119: New_Attribute_Value,
120: Update_Flag,
121: Recalculate_Flag,
122: Rejection_Reason
123: FROM pa_mass_update_details
124: WHERE rowid = X_rowid
125: FOR UPDATE NOWAIT;
126:
127: l_line_rec l_line_csr%ROWTYPE;

Line 175: DELETE FROM pa_mass_update_details

171: PROCEDURE Delete_Row( X_Rowid VARCHAR2 )
172: IS
173: BEGIN
174:
175: DELETE FROM pa_mass_update_details
176: WHERE rowid = X_Rowid;
177:
178: IF (SQL%NOTFOUND) THEN
179: Raise NO_DATA_FOUND;

Line 265: FROM pa_mass_update_details

261: l_dummy VARCHAR2(1);
262:
263: CURSOR l_line_csr IS
264: SELECT 'x'
265: FROM pa_mass_update_details
266: WHERE batch_id = X_Batch_ID
267: AND project_id = X_Project_ID
268: AND ( ( task_id IS NULL
269: AND X_Task_ID IS NULL)

Line 298: FROM pa_mass_update_details

294: to_char(X_New_Organization_ID);
295:
296: --Bug 4629597. Delete the cached Lines. Please see the bug for more details
297: DELETE
298: FROM pa_mass_update_details
299: WHERE batch_id=X_Batch_ID;
300:
301: IF (X_Project_Selection = 'NAME') THEN
302: --