DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PUB dependencies on CSI_MASS_EDIT_ENTRIES_B

Line 136: UPDATE csi_mass_edit_entries_b

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

Line 206: UPDATE csi_mass_edit_entries_b

202: PRAGMA AUTONOMOUS_TRANSACTION;
203: BEGIN
204:
205: -- Updating Batch status
206: UPDATE csi_mass_edit_entries_b
207: SET status_code = 'FAILED'
208: WHERE entry_id = p_entry_id;
209:
210: COMMIT;

Line 659: UPDATE csi_mass_edit_entries_b

655: IF l_status = 'Y'
656: THEN
657:
658: -- Setting the Batch Status to 'Processing'
659: UPDATE csi_mass_edit_entries_b
660: SET status_code = 'PROCESSING',
661: request_id = FND_GLOBAL.CONC_REQUEST_ID
662: WHERE entry_id = p_entry_id;
663: COMMIT;

Line 1279: UPDATE csi_mass_edit_entries_b

1275: WHERE transaction_line_id = l_txn_line_id
1276: AND instance_id is not null;
1277:
1278: -- Updating batch status
1279: UPDATE csi_mass_edit_entries_b
1280: SET status_code = 'SUCCESSFUL'
1281: WHERE entry_id = p_entry_id;
1282:
1283: IF l_errbuf='W'

Line 1421: UPDATE csi_mass_edit_entries_b

1417: WHERE transaction_line_id = l_txn_line_id
1418: AND instance_id is not null;
1419:
1420: -- Updating batch status
1421: UPDATE csi_mass_edit_entries_b
1422: SET status_code = 'SUCCESSFUL'
1423: WHERE entry_id = p_entry_id;
1424:
1425: IF l_errbuf='W'