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
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
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
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
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
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
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
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
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
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
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
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
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: );
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:
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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:
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;
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;