APPS.CN_MASS_ADJUST_UTIL dependencies on CN_GET_TX_DATA_PUB

Line 120: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,

116: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
118: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
119: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_adj_tbl OUT NOCOPY cn_get_tx_data_pub.adj_tbl_type,
123: x_source_counter OUT NOCOPY NUMBER) IS
124: --

Line 122: x_adj_tbl OUT NOCOPY cn_get_tx_data_pub.adj_tbl_type,

118: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
119: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_adj_tbl OUT NOCOPY cn_get_tx_data_pub.adj_tbl_type,
123: x_source_counter OUT NOCOPY NUMBER) IS
124: --
125: TYPE api_rec IS RECORD(
126: salesrep_id cn_comm_lines_api.salesrep_id%TYPE,

Line 515: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;

511: l_terr_id NUMBER;
512: l_keep_flag VARCHAR2(1);
513:
514: -- Tables/Records definitions
515: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
516: adj cn_get_tx_data_pub.adj_rec_type;
517: l_attribute_tbl cn_get_tx_data_pub.attribute_tbl;
518: -- Defining REF CURSOR
519: TYPE rc IS REF CURSOR;

Line 516: adj cn_get_tx_data_pub.adj_rec_type;

512: l_keep_flag VARCHAR2(1);
513:
514: -- Tables/Records definitions
515: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
516: adj cn_get_tx_data_pub.adj_rec_type;
517: l_attribute_tbl cn_get_tx_data_pub.attribute_tbl;
518: -- Defining REF CURSOR
519: TYPE rc IS REF CURSOR;
520: query_cur rc;

Line 517: l_attribute_tbl cn_get_tx_data_pub.attribute_tbl;

513:
514: -- Tables/Records definitions
515: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
516: adj cn_get_tx_data_pub.adj_rec_type;
517: l_attribute_tbl cn_get_tx_data_pub.attribute_tbl;
518: -- Defining REF CURSOR
519: TYPE rc IS REF CURSOR;
520: query_cur rc;
521:

Line 1291: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,

1287: x_source_counter := l_source_counter;
1288: END;
1289: --
1290: PROCEDURE convert_rec_to_tbl(
1291: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
1292: x_attribute_tbl OUT NOCOPY cn_get_tx_data_pub.attribute_tbl) IS
1293: --
1294: l_counter NUMBER := 1;
1295: --

Line 1292: x_attribute_tbl OUT NOCOPY cn_get_tx_data_pub.attribute_tbl) IS

1288: END;
1289: --
1290: PROCEDURE convert_rec_to_tbl(
1291: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
1292: x_attribute_tbl OUT NOCOPY cn_get_tx_data_pub.attribute_tbl) IS
1293: --
1294: l_counter NUMBER := 1;
1295: --
1296: BEGIN

Line 1803: p_rec IN cn_get_tx_data_pub.adj_rec_type,

1799: END IF;
1800: END;
1801:
1802: PROCEDURE convert_rec_to_gmiss(
1803: p_rec IN cn_get_tx_data_pub.adj_rec_type,
1804: x_api_rec OUT NOCOPY cn_get_tx_data_pub.adj_rec_type) IS
1805:
1806: BEGIN
1807:

Line 1804: x_api_rec OUT NOCOPY cn_get_tx_data_pub.adj_rec_type) IS

1800: END;
1801:
1802: PROCEDURE convert_rec_to_gmiss(
1803: p_rec IN cn_get_tx_data_pub.adj_rec_type,
1804: x_api_rec OUT NOCOPY cn_get_tx_data_pub.adj_rec_type) IS
1805:
1806: BEGIN
1807:
1808: SELECT DECODE(p_rec.direct_salesrep_id, null, fnd_api.g_miss_num, p_rec.direct_salesrep_id),