APPS.CN_COMM_LINES_API_PKG dependencies on CN_COMM_LINES_API

Line 1: PACKAGE BODY CN_COMM_LINES_API_PKG AS

1: PACKAGE BODY CN_COMM_LINES_API_PKG AS
2: /* $Header: cncmapib.pls 120.4.12000000.2 2007/08/07 14:48:57 apink ship $*/
3: -- +======================================================================+
4: -- | Copyright (c) 1998 Oracle Corporation |
5: -- | Redwood Shores, California, USA |

Line 13: -- Package Body -- Table Handler for Table CN_COMM_LINES_API

9: -- FILENAME
10: -- cncmapib.pls
11: --
12: -- PURPOSE
13: -- Package Body -- Table Handler for Table CN_COMM_LINES_API
14: --
15: -- NOTES
16: -- This file is generated by tblHandlerGen.pl *** DO NOT MODIFY ***
17: --

Line 41: INSERT into CN_COMM_LINES_API_ALL

37: l_err VARCHAR2(500);
38:
39: BEGIN
40:
41: INSERT into CN_COMM_LINES_API_ALL
42: ( SALESREP_ID,
43: PROCESSED_DATE,
44: PROCESSED_PERIOD_ID,
45: TRANSACTION_AMOUNT,

Line 593: UPDATE CN_COMM_LINES_API oldrec

589: ( p_comm_lines_api_rec IN COMM_LINES_API_REC_TYPE) IS
590:
591: BEGIN
592:
593: UPDATE CN_COMM_LINES_API oldrec
594: SET
595: SALESREP_ID = DECODE(p_comm_lines_api_rec.SALESREP_ID,
596: FND_API.G_MISS_NUM,
597: oldrec.SALESREP_ID,

Line 1288: FROM CN_COMM_LINES_API

1284: ( p_comm_lines_api_rec IN COMM_LINES_API_REC_TYPE) IS
1285:
1286: CURSOR c IS
1287: SELECT object_version_number
1288: FROM CN_COMM_LINES_API
1289: WHERE comm_lines_api_id = p_comm_lines_api_rec.comm_lines_api_id;
1290:
1291: tlinfo c%ROWTYPE ;
1292: BEGIN

Line 1309: UPDATE CN_COMM_LINES_API oldrec

1305: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1306: fnd_msg_pub.add;
1307: raise fnd_api.g_exc_unexpected_error;
1308: end if;
1309: UPDATE CN_COMM_LINES_API oldrec
1310: SET
1311: SALESREP_ID = DECODE(p_comm_lines_api_rec.SALESREP_ID,
1312: FND_API.G_MISS_NUM,
1313: oldrec.SALESREP_ID,

Line 2002: DELETE FROM CN_COMM_LINES_API

1998: ) IS
1999:
2000: BEGIN
2001:
2002: DELETE FROM CN_COMM_LINES_API
2003: WHERE comm_lines_api_id = p_comm_lines_api_id;
2004:
2005: IF (SQL%ROWCOUNT=0) THEN
2006: RAISE NO_DATA_FOUND;

Line 2032: FROM cn_comm_lines_api

2028: CURSOR api_lines (hid NUMBER,
2029: lid NUMBER,
2030: sd_type VARCHAR2) IS
2031: SELECT *
2032: FROM cn_comm_lines_api
2033: WHERE source_trx_line_id = lid
2034: AND NVL(source_trx_id,-99) = NVL(hid,-99)
2035: AND NVL(source_doc_type,'DUMMY') = NVL(sd_type,'DUMMY')
2036: AND negated_flag IS NULL

Line 2102: SELECT cn_comm_lines_api_s.NEXTVAL

2098:
2099: FOR api_curs_rec IN header_cur(l_reversal_header_id)
2100: LOOP
2101: --
2102: SELECT cn_comm_lines_api_s.NEXTVAL
2103: INTO l_comm_lines_api_id
2104: FROM dual;
2105: --
2106: l_api_rec.salesrep_id := api_curs_rec.direct_salesrep_id;

Line 2276: cn_comm_lines_api_pkg.insert_row(l_api_rec);

2272: l_api_rec.split_pct := api_curs_rec.split_pct;
2273: l_api_rec.split_status := api_curs_rec.split_status;
2274: l_api_rec.org_id := x_org_id;
2275: --
2276: cn_comm_lines_api_pkg.insert_row(l_api_rec);
2277: --
2278: END LOOP;
2279: EXCEPTION
2280: WHEN OTHERS THEN

Line 2284: UPDATE cn_comm_lines_api

2280: WHEN OTHERS THEN
2281: NULL;
2282: END;
2283: ELSE
2284: UPDATE cn_comm_lines_api
2285: SET load_status = 'OBSOLETE',
2286: adjust_status = 'FROZEN'
2287: WHERE comm_lines_api_id = api_line_rec.comm_lines_api_id
2288: AND org_id = x_org_id;

Line 2294: END CN_COMM_LINES_API_PKG;

2290:
2291: END LOOP;
2292: END negate_record;
2293: --
2294: END CN_COMM_LINES_API_PKG;
2295:
2296: