DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PVT dependencies on CSI_MASS_EDIT_ENTRIES_B

Line 164: CSI_MASS_EDIT_ENTRIES_B_PKG.Insert_Row(

160: csi_t_gen_utility_pvt.dump_mass_edit_rec(px_mass_edit_rec);
161:
162: -- Insert row in CSI_MASS_EDIT_ENTRIES table and CSI_T_TRANSACITON_LINES AND CSI_T_TRANSACTION_LINE_DETAILS
163:
164: CSI_MASS_EDIT_ENTRIES_B_PKG.Insert_Row(
165: px_ENTRY_ID => px_mass_edit_rec.ENTRY_ID,
166: px_TXN_LINE_ID => px_mass_edit_rec.TXN_LINE_ID,
167: px_TXN_LINE_DETAIL_ID => px_mass_edit_rec.TXN_LINE_DETAIL_ID,
168: p_STATUS_CODE => px_mass_edit_rec.STATUS_CODE,

Line 684: l_status csi_mass_edit_entries_b.status_code%type := null;

680: p_batch_id IN NUMBER,
681: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl)
682: IS
683:
684: l_status csi_mass_edit_entries_b.status_code%type := null;
685:
686: BEGIN
687: debug('Validating batch status');
688:

Line 693: FROM csi_mass_edit_entries_b cmee,

689: BEGIN
690:
691: SELECT status_code
692: INTO l_status
693: FROM csi_mass_edit_entries_b cmee,
694: csi_lookups cl
695: WHERE cmee.entry_id = p_batch_id
696: AND cmee.status_code = cl.lookup_code
697: AND cl.lookup_type = 'CSI_MU_BATCH_STATUSES';

Line 1215: CSI_MASS_EDIT_ENTRIES_B_PKG.update_Row(

1211: END IF; -- Check return of Validate Batch
1212: END IF; -- IF mass edit inst tbl.count OR line_detail_rec exists
1213:
1214: -- calling table handler at the end to handle cases where only mu rec is updated in a batch
1215: CSI_MASS_EDIT_ENTRIES_B_PKG.update_Row(
1216: p_ENTRY_ID => px_mass_edit_rec.ENTRY_ID,
1217: p_TXN_LINE_ID => px_mass_edit_rec.TXN_LINE_ID,
1218: p_STATUS_CODE => l_mass_edit_rec.STATUS_CODE,
1219: p_SCHEDULE_DATE => l_mass_edit_rec.SCHEDULE_DATE,

Line 1361: csi_mass_edit_entries_b_pkg.delete_row(

1357: END IF;
1358:
1359: -- call table handler to delete mass edit entry
1360:
1361: csi_mass_edit_entries_b_pkg.delete_row(
1362: p_entry_id => l_mass_edit_rec.entry_id);
1363:
1364: -- call Service contracts API to delete the contracts rules, if any.
1365: