APPS.CN_ADJUSTMENTS_PKG dependencies on CN_ADJUSTMENTS_PKG

Line 1: PACKAGE BODY CN_ADJUSTMENTS_PKG AS

1: PACKAGE BODY CN_ADJUSTMENTS_PKG AS
2: -- $Header: cntradjb.pls 120.10.12010000.5 2009/06/30 07:02:08 gmarwah ship $
3: -- +======================================================================+
4: -- | Copyright (c) 1994 Oracle Corporation |
5: -- | Redwood Shores, California, USA |

Line 10: -- cn_adjustments_pkg

6: -- | All rights reserved. |
7: -- +======================================================================+
8: --
9: -- Package Name
10: -- cn_adjustments_pkg
11: -- Purpose
12: -- Package spec for notifying orders
13: -- History
14: -- 11/17/98 JPENDYAL Created

Line 22: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_ADJUSTMENTS_PKG';

18: -- Jun 26, 2006 vensrini Bug fix 5349170
19: --
20:
21:
22: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_ADJUSTMENTS_PKG';
23: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cntradjb.pls';
24: --
25: FUNCTION g_track_invoice
26: RETURN VARCHAR2 IS

Line 1018: cn_adjustments_pkg.api_negate_record(

1014: --x_adj_data(i).adjust_status IS null)
1015: AND
1016: x_adj_data(i).load_status NOT IN ('FILTERED') THEN
1017:
1018: cn_adjustments_pkg.api_negate_record(
1019: x_adj_data(i).comm_lines_api_id,
1020: x_adj_rec.adjusted_by,
1021: x_adj_rec.adjust_comments,
1022: x_adj_data(i).direct_salesrep_number);

Line 1132: --cn_adjustments_pkg.get_api_data(l_comm_lines_api_id,l_adj_tbl);

1128: LOOP
1129: IF (dbms_sql.fetch_rows(deal_select_cursor) > 0) THEN
1130: DBMS_SQL.column_value (deal_select_cursor,1,l_comm_lines_api_id);
1131: --
1132: --cn_adjustments_pkg.get_api_data(l_comm_lines_api_id,l_adj_tbl);
1133: cn_get_tx_data_pub.get_api_data(l_comm_lines_api_id,l_adj_tbl);
1134: --
1135: IF (l_adj_tbl.COUNT > 0) THEN
1136: l_transaction_amount := ((NVL(l_adj_tbl(1).transaction_amount,0) *

Line 1257: cn_adjustments_pkg.api_negate_record(

1253: IF (l_load_status = 'LOADED') THEN
1254: FOR rec IN header_cur(l_comm_lines_api_id)
1255: LOOP
1256: IF(nvl(rec.adjust_status,'X') <> 'FROZEN') THEN
1257: cn_adjustments_pkg.api_negate_record(
1258: rec.comm_lines_api_id,
1259: x_adjusted_by,
1260: x_adjust_comments);
1261: END IF;

Line 1267: cn_adjustments_pkg.api_negate_record(

1263: ELSIF (l_load_status = 'UNLOADED') THEN
1264: FOR rec IN api_cur(l_comm_lines_api_id)
1265: LOOP
1266: IF(nvl(rec.adjust_status,'X') <> 'FROZEN') THEN
1267: cn_adjustments_pkg.api_negate_record(
1268: rec.comm_lines_api_id,
1269: x_adjusted_by,
1270: x_adjust_comments);
1271: END IF;

Line 1275: --cn_adjustments_pkg.get_api_data(l_comm_lines_api_id,l_adj_tbl);

1271: END IF;
1272: END LOOP;
1273: END IF;
1274: --
1275: --cn_adjustments_pkg.get_api_data(l_comm_lines_api_id,l_adj_tbl);
1276: cn_get_tx_data_pub.get_api_data(l_comm_lines_api_id,l_adj_tbl);
1277: --
1278: IF (l_adj_tbl.COUNT > 0) THEN
1279: /* codeCheck: I need to revisit this code */

Line 1286: cn_adjustments_pkg.api_negate_record(

1282: := NVL(l_adj_tbl(1).transaction_amount,0);
1283: --
1284: /*
1285: IF(nvl(l_adj_tbl(1).adjust_status,'X') <> 'FROZEN') THEN
1286: cn_adjustments_pkg.api_negate_record(
1287: l_adj_tbl(1).comm_lines_api_id,
1288: l_adjusted_by,
1289: l_adjust_comments);
1290: END IF; */

Line 1575: cn_adjustments_pkg.api_negate_record(

1571: THEN
1572: FOR each_trx IN l_csr_credited_trx(p_comm_lines_api_id, p_org_id)
1573: LOOP
1574:
1575: cn_adjustments_pkg.api_negate_record(
1576: x_comm_lines_api_id => each_trx.comm_lines_api_id,
1577: x_adjusted_by => p_adjusted_by,
1578: x_adjust_comments => 'Parent transaction modified');
1579: END LOOP;

Line 1597: END cn_adjustments_pkg;

1593: --
1594: END update_credit_credentials;
1595:
1596: --
1597: END cn_adjustments_pkg;
1598:
1599:
1600: