APPS.CSI_MASS_EDIT_PUB dependencies on CSI_MASS_EDIT_ENTRIES_B

Line 138: UPDATE csi_mass_edit_entries_b

134: PRAGMA AUTONOMOUS_TRANSACTION;
135: Begin
136:
137: -- Updating Batch status
138: UPDATE csi_mass_edit_entries_b
139: SET status_code = 'FAILED'
140: WHERE entry_id = p_entry_id;
141:
142: -- Updating status for each failed transaction_line_detail_id with instance

Line 210: UPDATE csi_mass_edit_entries_b

206: PRAGMA AUTONOMOUS_TRANSACTION;
207: BEGIN
208:
209: -- Updating Batch status
210: UPDATE csi_mass_edit_entries_b
211: SET status_code = 'FAILED'
212: WHERE entry_id = p_entry_id;
213:
214: COMMIT;

Line 373: UPDATE csi_mass_edit_entries_b

369: END IF;
370: --End of code for re-uploaded batch
371:
372: BEGIN
373: UPDATE csi_mass_edit_entries_b
374: SET status_code = 'SCHEDULED',
375: SCHEDULE_DATE = SYSDATE
376: WHERE BATCH_TYPE = 'WBADI'
377: AND status_code = 'CREATED';

Line 759: UPDATE csi_mass_edit_entries_b

755: IF l_status = 'Y'
756: THEN
757:
758: -- Setting the Batch Status to 'Processing'
759: UPDATE csi_mass_edit_entries_b
760: SET status_code = 'PROCESSING',
761: request_id = FND_GLOBAL.CONC_REQUEST_ID
762: WHERE entry_id = p_entry_id;
763: COMMIT;

Line 1393: UPDATE csi_mass_edit_entries_b

1389: WHERE transaction_line_id = l_txn_line_id
1390: AND instance_id is not null;
1391:
1392: -- Updating batch status
1393: UPDATE csi_mass_edit_entries_b
1394: SET status_code = 'SUCCESSFUL'
1395: WHERE entry_id = p_entry_id;
1396:
1397: IF l_errbuf='W'

Line 1536: UPDATE csi_mass_edit_entries_b

1532: WHERE transaction_line_id = l_txn_line_id
1533: AND instance_id is not null;
1534:
1535: -- Updating batch status
1536: UPDATE csi_mass_edit_entries_b
1537: SET status_code = 'SUCCESSFUL'
1538: WHERE entry_id = p_entry_id;
1539:
1540: IF l_errbuf='W'

Line 3006: --Updated the csi_mass_edit_entries_b table with status_code to SCHEDULED from status CREATED

3002: END VALIDATE_SYSTEM_BATCH; -- VALIDATE_SYSTEM_BATCH
3003:
3004:
3005:
3006: --Updated the csi_mass_edit_entries_b table with status_code to SCHEDULED from status CREATED
3007: --This program is called from CSI_MASS_EDIT_PUB.Process_mass_edit_batch
3008: PROCEDURE Process_webadi_batch
3009: ( errbuf OUT NOCOPY VARCHAR2
3010: ,retcode OUT NOCOPY NUMBER

Line 3036: UPDATE csi_mass_edit_entries_b

3032: UPDATE CSI_WEBADI_STAGING
3033: SET PROCESSING_STATUS = 'P'
3034: WHERE BATCH_ID = p_entry_id;
3035:
3036: UPDATE csi_mass_edit_entries_b
3037: SET status_code = 'PROCESSING',
3038: request_id = FND_GLOBAL.CONC_REQUEST_ID
3039: WHERE entry_id = p_entry_id;
3040: COMMIT;

Line 3128: UPDATE csi_mass_edit_entries_b

3124: Process_webadi_update(errbuf, retcode, p_Entry_id, px_csi_txn_rec);
3125: END IF;
3126:
3127: IF(errbuf = 'E') THEN
3128: UPDATE csi_mass_edit_entries_b
3129: SET status_code = 'FAILED'
3130: WHERE entry_id = p_entry_id;
3131: COMMIT;
3132: ELSE

Line 3133: UPDATE csi_mass_edit_entries_b

3129: SET status_code = 'FAILED'
3130: WHERE entry_id = p_entry_id;
3131: COMMIT;
3132: ELSE
3133: UPDATE csi_mass_edit_entries_b
3134: SET status_code = 'SUCCESSFUL'
3135: WHERE entry_id = p_entry_id;
3136: COMMIT;
3137: END IF;