APPS.CN_CALC_SUB_ENTRIES_PKG dependencies on CN_CALC_SUBMISSION_ENTRIES_ALL

Line 59: INSERT INTO cn_calc_submission_entries_all

55: INTO l_calc_sub_entry_id
56: FROM dual;
57: END IF;
58:
59: INSERT INTO cn_calc_submission_entries_all
60: ( calc_sub_entry_id,
61: calc_sub_batch_id,
62: salesrep_id,
63: hierarchy_flag,

Line 147: UPDATE cn_calc_submission_entries_all SET

143: ) IS
144:
145: BEGIN
146:
147: UPDATE cn_calc_submission_entries_all SET
148: calc_sub_entry_id = p_calc_sub_entry_id,
149: calc_sub_batch_id = p_calc_sub_batch_id,
150: salesrep_id = p_salesrep_id,
151: hierarchy_flag = nvl(p_hierarchy_flag, 'N')

Line 180: DELETE cn_calc_submission_entries_all

176:
177: Procedure delete_row ( p_calc_sub_entry_id NUMBER ) IS
178:
179: BEGIN
180: DELETE cn_calc_submission_entries_all
181: WHERE calc_sub_entry_id = p_calc_sub_entry_id;
182:
183: IF (sql%notfound) THEN
184: raise no_data_found;

Line 215: SELECT * FROM cn_calc_submission_entries_all

211: P_LAST_UPDATE_DATE DATE ,
212: P_LAST_UPDATED_BY NUMBER
213: ) IS
214: CURSOR C IS
215: SELECT * FROM cn_calc_submission_entries_all
216: WHERE calc_sub_entry_id = p_calc_sub_entry_id
217: FOR UPDATE OF calc_sub_entry_id NOWAIT;
218:
219: Recinfo C%ROWTYPE;