1 Package cn_mass_adjust_util AUTHID CURRENT_USER AS
2 -- $Header: cnvmutls.pls 120.3 2005/08/10 03:48:38 hithanki noship $
3 -- +======================================================================+
4 -- | Copyright (c) 1994 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +======================================================================+
8
9 --
10 -- Package Name
11 -- CN_MASS_ADJUST_UTIL
12 -- Purpose
13 -- Package Body for Mass Adjustments Package (JSP Version)
14 -- History
15 -- 08/27/01 Rao.Chenna Created
16 /*
17 PROCEDURE my_debug(
18 i_value IN VARCHAR2); */
19 /*--------------------------------------------------------------------------
20 API name : find_functional_amount
21 Type : Private
22 Pre-reqs :
23 Usage :
24 Desc : This API converts foreign currency to functional currency
25 and vice versa.
26 Parameters
27 IN : p_from_currency - Source Currency Code.
28 : p_to_currency - Target Currency Code.
29 : p_conversion_date - Conversion Date
30 : p_conversion_type - Conversion Type
31 : p_from_amount - Source Transaction Amount
32 OUT NOCOPY : x_to_amount - Target Transaction Amount
33 Notes :
34 --------------------------------------------------------------------------*/
35 PROCEDURE find_functional_amount(
36 p_from_currency IN VARCHAR2,
37 p_to_currency IN VARCHAR2,
38 p_conversion_date IN DATE,
39 p_conversion_type IN VARCHAR2 := fnd_profile.value('CN_CONVERSION_TYPE'),
40 p_from_amount IN NUMBER,
41 x_to_amount OUT NOCOPY NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2);
43 /*--------------------------------------------------------------------------
44 API name : search_result
45 Type : Private
46 Pre-reqs :
47 Usage :
48 Desc : This API provides the list of transactions match with the
49 search criteria.
50 Parameters
51 IN : p_salesrep_id - From the transaction summary search page.
52 : p_pr_date_to - From the transaction summary search page.
53 : p_pr_date_from - From the transaction summary search page.
54 : p_calc_status - From the transaction summary search page.
55 : p_order_num - From the transaction summary search page.
56 : p_srch_attr_rec - This record type stores the attribute
57 columns from the advanced search option.
58 OUT NOCOPY : x_adj_tbl - This PL/SQL table holds the resultset based
59 on the search criteria given.
60 Notes :
61 --------------------------------------------------------------------------*/
62 PROCEDURE search_result (
63 p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
64 p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
65 p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
66 p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
67 p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
68 p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
69 p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
70 p_order_num IN NUMBER := FND_API.G_MISS_NUM,
71 p_org_id IN NUMBER := FND_API.G_MISS_NUM,
72 p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_adj_tbl OUT NOCOPY cn_get_tx_data_pub.adj_tbl_type,
75 x_source_counter OUT NOCOPY NUMBER);
76 /*--------------------------------------------------------------------------
77 API name : convert_rec_to_tbl
78 Type : Private
79 Pre-reqs :
80 Usage :
81 Desc : Currently attribute column values from the Advanced Search
82 JSP are stored in a PL/SQL record type. But it is very
83 difficult to add dynamically these attributes columns in the
84 search criteria. So this API converts the record type to
85 PL/SQL table type. Check the search_result body about how
86 this PL/SQL table is being used.
87 Parameters
88 IN : p_srch_attr_rec - A PL/SQL record which holds attribute column
89 values
90 OUT NOCOPY : x_attribute_tbl - A PL/SQL table which holds the same
91 attribute column values
92 Notes :
93 --------------------------------------------------------------------------*/
94 PROCEDURE convert_rec_to_tbl(
95 p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
96 x_attribute_tbl OUT NOCOPY cn_get_tx_data_pub.attribute_tbl);
97
98 PROCEDURE convert_rec_to_gmiss(
99 p_rec IN cn_get_tx_data_pub.adj_rec_type,
100 x_api_rec OUT NOCOPY cn_get_tx_data_pub.adj_rec_type);
101
102 --
103 END;