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.2 2008/11/04 07:41:52 sseshaiy 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 1016: cn_adjustments_pkg.api_negate_record(

1012: (x_adj_data(i).adjust_status NOT IN('FROZEN','REVERSAL','SCA_PENDING') OR
1013: x_adj_data(i).adjust_status IS null) AND
1014: x_adj_data(i).load_status NOT IN ('FILTERED') THEN
1015:
1016: cn_adjustments_pkg.api_negate_record(
1017: x_adj_data(i).comm_lines_api_id,
1018: x_adj_rec.adjusted_by,
1019: x_adj_rec.adjust_comments,
1020: x_adj_data(i).direct_salesrep_number);

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

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

Line 1255: cn_adjustments_pkg.api_negate_record(

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

Line 1265: cn_adjustments_pkg.api_negate_record(

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

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

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

Line 1284: cn_adjustments_pkg.api_negate_record(

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

Line 1573: cn_adjustments_pkg.api_negate_record(

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

Line 1595: END cn_adjustments_pkg;

1591: --
1592: END update_credit_credentials;
1593:
1594: --
1595: END cn_adjustments_pkg;
1596:
1597:
1598: