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.5.12010000.2 2009/01/28 12:18:27 gmarwah 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 592: UPDATE CN_COMM_LINES_API oldrec

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

Line 1287: FROM CN_COMM_LINES_API

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

Line 1308: UPDATE CN_COMM_LINES_API oldrec

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

Line 2001: DELETE FROM CN_COMM_LINES_API

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

Line 2031: FROM cn_comm_lines_api

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

Line 2101: SELECT cn_comm_lines_api_s.NEXTVAL

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

Line 2275: cn_comm_lines_api_pkg.insert_row(l_api_rec);

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

Line 2283: UPDATE cn_comm_lines_api

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

Line 2293: END CN_COMM_LINES_API_PKG;

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