APPS.CN_INVOICE_CHANGES_PKG dependencies on CN_INVOICE_CHANGES_ALL

Line 20: INSERT into CN_INVOICE_CHANGES_ALL

16: ( p_invoice_changes_all_rec IN INVOICE_CHANGES_ALL_REC_TYPE) IS
17:
18: BEGIN
19:
20: INSERT into CN_INVOICE_CHANGES_ALL
21: ( INVOICE_CHANGE_ID,
22: SALESREP_ID,
23: INVOICE_NUMBER,
24: LINE_NUMBER,

Line 124: UPDATE CN_INVOICE_CHANGES_ALL oldrec

120: ( p_invoice_changes_all_rec IN INVOICE_CHANGES_ALL_REC_TYPE) IS
121:
122: BEGIN
123:
124: UPDATE CN_INVOICE_CHANGES_ALL oldrec
125: SET
126: SALESREP_ID = DECODE(p_invoice_changes_all_rec.SALESREP_ID,
127: FND_API.G_MISS_NUM,
128: oldrec.SALESREP_ID,

Line 243: FROM CN_INVOICE_CHANGES_ALL

239: ( p_invoice_changes_all_rec IN INVOICE_CHANGES_ALL_REC_TYPE) IS
240:
241: CURSOR c IS
242: SELECT object_version_number
243: FROM CN_INVOICE_CHANGES_ALL
244: WHERE invoice_change_id = p_invoice_changes_all_rec.invoice_change_id;
245:
246: tlinfo c%ROWTYPE ;
247: BEGIN

Line 264: UPDATE CN_INVOICE_CHANGES_ALL oldrec

260: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
261: fnd_msg_pub.add;
262: raise fnd_api.g_exc_unexpected_error;
263: end if;
264: UPDATE CN_INVOICE_CHANGES_ALL oldrec
265: SET
266: SALESREP_ID = DECODE(p_invoice_changes_all_rec.SALESREP_ID,
267: FND_API.G_MISS_NUM,
268: oldrec.SALESREP_ID,

Line 383: DELETE FROM CN_INVOICE_CHANGES_ALL

379: ) IS
380:
381: BEGIN
382:
383: DELETE FROM CN_INVOICE_CHANGES_ALL
384: WHERE invoice_change_id = p_invoice_change_id;
385:
386: IF (SQL%ROWCOUNT=0) THEN
387: RAISE NO_DATA_FOUND;