APPS.PA_MU_BATCHES_V_PKG dependencies on PA_MASS_UPDATE_BATCHES

Line 43: SELECT PA_MASS_UPDATE_BATCHES_S.NextVal

39: l_batch_id NUMBER;
40: l_org_Id NUMBER := nvl(X_Org_Id, pa_moac_utils.get_current_org_id); -- R12 MOAC changes
41: BEGIN
42:
43: SELECT PA_MASS_UPDATE_BATCHES_S.NextVal
44: INTO l_batch_id
45: FROM dual;
46:
47: INSERT INTO PA_MASS_UPDATE_BATCHES

Line 47: INSERT INTO PA_MASS_UPDATE_BATCHES

43: SELECT PA_MASS_UPDATE_BATCHES_S.NextVal
44: INTO l_batch_id
45: FROM dual;
46:
47: INSERT INTO PA_MASS_UPDATE_BATCHES
48: ( Batch_ID,
49: Batch_Name,
50: Description,
51: Batch_Status_Code,

Line 110: FROM PA_MASS_UPDATE_BATCHES

106:
107: X_Batch_ID := l_batch_id;
108:
109: SELECT rowid INTO X_Rowid
110: FROM PA_MASS_UPDATE_BATCHES
111: WHERE batch_id = l_batch_id;
112:
113: EXCEPTION -- 4537865
114: WHEN OTHERS THEN

Line 162: UPDATE pa_mass_update_batches

158: IS
159:
160: BEGIN
161:
162: UPDATE pa_mass_update_batches
163: SET
164: Batch_Name = X_Batch_Name,
165: Description = X_Description,
166: Batch_Status_Code = X_Batch_Status_Code,

Line 258: FROM pa_mass_update_batches

254: Attribute12,
255: Attribute13,
256: Attribute14,
257: Attribute15
258: FROM pa_mass_update_batches
259: WHERE rowid = X_rowid
260: FOR UPDATE NOWAIT;
261:
262: l_batch_rec l_batch_csr%ROWTYPE;

Line 367: FROM pa_mass_update_batches

363:
364: BEGIN
365:
366: SELECT batch_id INTO l_batch_id
367: FROM pa_mass_update_batches
368: WHERE rowid = X_Rowid;
369:
370: --
371: -- First, delete all the lines for this batch

Line 384: DELETE FROM pa_mass_update_batches

380: -- This is okay
381: null;
382: END;
383:
384: DELETE FROM pa_mass_update_batches
385: WHERE rowid = X_Rowid;
386:
387: IF (SQL%NOTFOUND) THEN
388: Raise NO_DATA_FOUND;

Line 411: FROM pa_mass_update_batches

407: l_NO_EMP_RECORD EXCEPTION;
408:
409: CURSOR l_batch_csr IS
410: SELECT batch_id
411: FROM pa_mass_update_batches
412: WHERE batch_status_code = 'S'
413: AND trunc(sysdate) >= trunc(nvl(effective_date, sysdate));
414:
415: BEGIN

Line 510: FROM pa_mass_update_batches b

506: -- Cursor declarations
507: -- -----------------------
508: CURSOR l_batch_csr IS
509: SELECT batch_status_code, project_attribute, effective_date
510: FROM pa_mass_update_batches b
511: WHERE b.batch_id = X_Batch_ID
512: FOR UPDATE;
513:
514: CURSOR l_BatchLines_csr IS

Line 676: UPDATE pa_mass_update_batches

672: END IF;
673: --
674: -- Change the status to 'Running'
675: --
676: UPDATE pa_mass_update_batches
677: SET batch_status_code = 'P',
678: rejection_code = NULL,
679: process_run_date = sysdate,
680: process_run_by = FND_GLOBAL.user_id,

Line 994: UPDATE pa_mass_update_batches

990: IF (X_Concurrent = 'Y') THEN
991: --
992: -- Update the batch status
993: --
994: UPDATE pa_mass_update_batches
995: SET batch_status_code = l_proc_status,
996: rejection_code = ERRBUF,
997: process_run_by = FND_GLOBAL.user_id,
998: process_run_date = sysdate,

Line 1018: UPDATE pa_mass_update_batches

1014: --
1015: IF (X_All_Batches = 'N') THEN
1016: RETCODE := '1';
1017: ERRBUF := 'INVALID_STATUS';
1018: UPDATE pa_mass_update_batches
1019: SET batch_status_code = 'R',
1020: rejection_code = 'INVALID_STATUS',
1021: process_run_by = FND_GLOBAL.user_id,
1022: process_run_date = sysdate,

Line 1039: UPDATE pa_mass_update_batches

1035: --
1036: IF (X_All_Batches = 'N') THEN
1037: RETCODE := '1';
1038: ERRBUF := 'EFFECTIVE_DATE';
1039: UPDATE pa_mass_update_batches
1040: SET batch_status_code = 'R',
1041: rejection_code = 'EFFECTIVE_DATE',
1042: process_run_by = FND_GLOBAL.user_id,
1043: process_run_date = sysdate,

Line 1060: UPDATE pa_mass_update_batches

1056:
1057: RETCODE := '1';
1058: ERRBUF := 'SQL_ERROR';
1059: IF (X_Concurrent = 'Y') THEN
1060: UPDATE pa_mass_update_batches
1061: SET batch_status_code = 'R',
1062: rejection_code = 'SQL_ERROR',
1063: process_run_by = FND_GLOBAL.user_id,
1064: process_run_date = sysdate,