1 PACKAGE PA_DEDUCTIONS_PUB AUTHID CURRENT_USER AS
2 -- /* $Header: PADCTNPS.pls 120.6 2010/12/01 00:11:28 snizam noship $ */
3 /*#
4 * This package contains the public APIs for creation of deduction request header and details.
5 * The name of the package is PA_DEDUCTIONS_PUB. API's Create_Deduction_Hdr and Create_Deduction_Txn
6 * are to create the data into the tables PA_DEDUCTIONS_ALL and PA_DEDUCTION_TRANSACTIONS_ALL.
7 * @rep:scope public
8 * @rep:product PA
9 * @rep:lifecycle active
10 * @rep:displayname Deduction Request Creation
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY PA_PROJECT
13 * @rep:category BUSINESS_ENTITY PA_PAYABLE_INV_COST
14 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
15 */
16
17 g_pub_dctn_hdr_tbl PA_DEDUCTIONS.g_dctn_hdrtbl;
18 g_pub_dctn_txn_tbl PA_DEDUCTIONS.g_dctn_txntbl;
19
20 g_validate_txn VARCHAR2(1) := 'N';
21 g_user_id NUMBER(15) := FND_GLOBAL.USER_ID;
22 g_resp_id NUMBER := FND_GLOBAL.resp_id;
23 g_api_version_number NUMBER := 1.0;
24
25 /*#
26 * This API creates deduction request header information.
27 * @param p_api_version_number API standard version number
28 * @param p_commit API standard (default = F): indicates if transaction will be committed
29 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
30 * @param p_pm_product_code Identifier of the external system from which the project was imported
31 * @rep:paraminfo {@rep:precision 25}
32 * @param p_msg_count API standard: number of error messages
33 * @rep:paraminfo {@rep:required}
34 * @param p_msg_data API standard: error message
35 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
36 * @param p_return_status API standard: return of the API (success/failure/unexpected error)
37 * @rep:paraminfo {@rep:precision 1} {@rep:required}
38 * @param p_project_id Input project id
39 * @rep:paraminfo {@rep:required}
40 * @param p_vendor_id Input vendor id
41 * @rep:paraminfo {@rep:required}
42 * @param p_vendor_site_id Input vendor site id
43 * @rep:paraminfo {@rep:required}
44 * @param p_ci_id Input Control item id
45 * @param p_po_header_id Input PO Header Id
46 * @param p_deduction_req_num Input Deducion request number
47 * @rep:paraminfo {@rep:required}
48 * @param p_debit_memo_num Input debit memo number
49 * @param p_currency_code Input debit memo currency
50 * @rep:paraminfo {@rep:required}
51 * @param p_conversion_ratetype Input conversion rate type
52 * @param p_conversion_ratedate Input conversion rate date
53 * @param p_conversion_rate Input conversion rate
54 * @param p_deduction_req_date Input Deduction request date
55 * @rep:paraminfo {@rep:required}
56 * @param p_debit_memo_date Input debit memo date
57 * @param p_description Input description of the debit memo
58 * @param p_org_id Input org_id
59 * @rep:paraminfo {@rep:required}
60 * @rep:scope public
61 * @rep:lifecycle active
62 * @rep:displayname Create Deduction Request Header
63 * @rep:compatibility S
64 */
65 Procedure Create_Deduction_Hdr( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
66 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
67 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69 ,p_msg_count OUT NOCOPY NUMBER
70 ,p_msg_data OUT NOCOPY VARCHAR2
71 ,p_return_status OUT NOCOPY VARCHAR2
72 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
73 ,p_vendor_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
74 ,p_vendor_site_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
75 ,p_ci_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
76 ,p_po_header_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
77 ,p_deduction_req_num IN OUT NOCOPY VARCHAR2
78 ,p_debit_memo_num IN OUT NOCOPY VARCHAR2
79 ,p_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
80 ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
81 ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
82 ,p_conversion_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
83 ,p_deduction_req_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
84 ,p_debit_memo_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
85 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
86 ,p_status IN OUT NOCOPY VARCHAR2
87 ,p_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
88 );
89
90 /*#
91 * This API creates deduction request detail information.
92 * @param p_api_version_number API standard version number
93 * @param p_commit API standard (default = F): indicates if transaction will be committed
94 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
95 * @param p_pm_product_code Identifier of the external system from which the project was imported
96 * @rep:paraminfo {@rep:precision 25}
97 * @param p_msg_count API standard: number of error messages
98 * @rep:paraminfo {@rep:required}
99 * @param p_msg_data API standard: error message
100 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
101 * @param p_return_status API standard: return of the API (success/failure/unexpected error)
102 * @rep:paraminfo {@rep:precision 1} {@rep:required}
103 * @param p_deduction_req_num Input Deduction request number
104 * @rep:paraminfo {@rep:required}
105 * @param p_task_id Input task id
106 * @rep:paraminfo {@rep:required}
107 * @param p_expenditure_type Input expenditure type
108 * @rep:paraminfo {@rep:required}
109 * @param p_expenditure_item_date Input expenditure item date
110 * @rep:paraminfo {@rep:required}
111 * @param p_gl_date Input accounting date
112 * @rep:paraminfo {@rep:required}
113 * @param p_expenditure_org_id Input expenditure organization id
114 * @rep:paraminfo {@rep:required}
115 * @param p_quantity Input quantity
116 * @param p_expenditure_item_id Input expenditure item id
117 * @param p_orig_projfunc_amount Input Amount in project functional currency
118 * @rep:paraminfo {@rep:required}
119 * @param p_conversion_ratetype Input conversion rate type
120 * @param p_conversion_ratedate Input conversion rate date
121 * @param p_conversion_rate Input conversion rate
122 * @rep:paraminfo {@rep:required}
123 * @param p_description Input Detail transaction description.
124 * @rep:scope public
125 * @rep:lifecycle active
126 * @rep:displayname Create Deduction Transaction Details
127 * @rep:compatibility S
128 */
129 Procedure Create_Deduction_Txn( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
130 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
131 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
132 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
133 ,p_msg_count OUT NOCOPY NUMBER
134 ,p_msg_data OUT NOCOPY VARCHAR2
135 ,p_return_status OUT NOCOPY VARCHAR2
136 ,p_deduction_req_num IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
137 ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
138 ,p_expenditure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
139 ,p_expenditure_item_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
140 ,p_gl_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
141 ,p_expenditure_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
142 ,p_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
143 --,p_override_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
144 ,p_expenditure_item_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
145 -- ,p_projfunc_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- bug9052223
146 ,p_orig_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
147 --,p_override_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
148 ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
149 ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
150 ,p_conversion_rate IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
151 --,p_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
152 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
153 );
154
155 END PA_DEDUCTIONS_PUB;