APPS.CSI_UTILITY_GRP dependencies on CSI_MASS_EDIT_ENTRIES_B

Line 857: csi_mass_edit_entries_b cmee

853: SELECT cil.active_end_date active_end_date
854: ,cil.installation_date installation_date
855: ,cil.txn_line_detail_id txn_line_detail_id
856: FROM csi_t_txn_line_details cil,
857: csi_mass_edit_entries_b cmee
858: WHERE cmee.entry_id = pc_batch_id
859: AND cmee.txn_line_id = cil.transaction_line_id
860: AND cil.instance_id IS NULL;
861:

Line 1004: csi_mass_edit_entries_b cmee

1000: -- FTS on this cursor
1001: CURSOR inst_csr(pc_batch_id IN NUMBER) IS
1002: SELECT cil.instance_id instance_id
1003: FROM csi_t_txn_line_details cil,
1004: csi_mass_edit_entries_b cmee
1005: WHERE cmee.entry_id = pc_batch_id
1006: AND cmee.txn_line_id = cil.transaction_line_id
1007: AND cil.instance_id IS NOT NULL;
1008:

Line 1016: csi_mass_edit_entries_b cmee

1012: SELECT cil.active_end_date active_end_date
1013: ,cil.installation_date installation_date
1014: ,cil.txn_line_detail_id txn_line_detail_id
1015: FROM csi_t_txn_line_details cil,
1016: csi_mass_edit_entries_b cmee
1017: WHERE cmee.entry_id = pc_batch_id
1018: AND cmee.txn_line_id = cil.transaction_line_id
1019: AND cil.instance_id IS NULL;
1020:

Line 1597: FROM csi_mass_edit_entries_b

1593: purge_error EXCEPTION;
1594:
1595: CURSOR c_mu (p_status IN VARCHAR2) IS
1596: SELECT txn_line_id
1597: FROM csi_mass_edit_entries_b
1598: WHERE status_code = p_status;
1599:
1600: CURSOR c_processed_recs (p_status IN VARCHAR2) IS
1601: SELECT transaction_line_id

Line 1781: debug_con_log(' No Records exist so remove the Mass Update data from csi_mass_edit_entries_b: '||r_mu.txn_line_id);

1777: WHERE transaction_line_id = r_mu.txn_line_id;
1778:
1779: EXCEPTION
1780: WHEN no_data_found THEN
1781: debug_con_log(' No Records exist so remove the Mass Update data from csi_mass_edit_entries_b: '||r_mu.txn_line_id);
1782:
1783: DELETE from csi_mass_edit_entries_b
1784: WHERE txn_line_id = r_mu.txn_line_id;
1785:

Line 1783: DELETE from csi_mass_edit_entries_b

1779: EXCEPTION
1780: WHEN no_data_found THEN
1781: debug_con_log(' No Records exist so remove the Mass Update data from csi_mass_edit_entries_b: '||r_mu.txn_line_id);
1782:
1783: DELETE from csi_mass_edit_entries_b
1784: WHERE txn_line_id = r_mu.txn_line_id;
1785:
1786: END;
1787: END LOOP; -- c_mu