eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_DEDUCTIONS_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 6: Procedure Create_Deduction_Hdr( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2: -- /* $Header: PADCTNPB.pls 120.2.12010000.3 2010/04/15 07:25:23 vchilla noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_DEDUCTIONS_PUB';
5:
6: Procedure Create_Deduction_Hdr( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
8: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
9: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10: ,p_msg_count OUT NOCOPY NUMBER

Line 9: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

5:
6: Procedure Create_Deduction_Hdr( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
8: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
9: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10: ,p_msg_count OUT NOCOPY NUMBER
11: ,p_msg_data OUT NOCOPY VARCHAR2
12: ,p_return_status OUT NOCOPY VARCHAR2
13: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 13: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10: ,p_msg_count OUT NOCOPY NUMBER
11: ,p_msg_data OUT NOCOPY VARCHAR2
12: ,p_return_status OUT NOCOPY VARCHAR2
13: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14: ,p_vendor_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
15: ,p_vendor_site_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16: ,p_ci_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17: ,p_po_header_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 14: ,p_vendor_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

10: ,p_msg_count OUT NOCOPY NUMBER
11: ,p_msg_data OUT NOCOPY VARCHAR2
12: ,p_return_status OUT NOCOPY VARCHAR2
13: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14: ,p_vendor_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
15: ,p_vendor_site_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16: ,p_ci_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17: ,p_po_header_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18: ,p_deduction_req_num IN OUT NOCOPY VARCHAR2

Line 15: ,p_vendor_site_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

11: ,p_msg_data OUT NOCOPY VARCHAR2
12: ,p_return_status OUT NOCOPY VARCHAR2
13: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14: ,p_vendor_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
15: ,p_vendor_site_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16: ,p_ci_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17: ,p_po_header_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18: ,p_deduction_req_num IN OUT NOCOPY VARCHAR2
19: ,p_debit_memo_num IN OUT NOCOPY VARCHAR2

Line 16: ,p_ci_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

12: ,p_return_status OUT NOCOPY VARCHAR2
13: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14: ,p_vendor_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
15: ,p_vendor_site_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16: ,p_ci_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17: ,p_po_header_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18: ,p_deduction_req_num IN OUT NOCOPY VARCHAR2
19: ,p_debit_memo_num IN OUT NOCOPY VARCHAR2
20: ,p_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17: ,p_po_header_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

13: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14: ,p_vendor_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
15: ,p_vendor_site_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16: ,p_ci_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17: ,p_po_header_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18: ,p_deduction_req_num IN OUT NOCOPY VARCHAR2
19: ,p_debit_memo_num IN OUT NOCOPY VARCHAR2
20: ,p_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 20: ,p_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

16: ,p_ci_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17: ,p_po_header_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18: ,p_deduction_req_num IN OUT NOCOPY VARCHAR2
19: ,p_debit_memo_num IN OUT NOCOPY VARCHAR2
20: ,p_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
23: ,p_conversion_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,p_deduction_req_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 21: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17: ,p_po_header_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18: ,p_deduction_req_num IN OUT NOCOPY VARCHAR2
19: ,p_debit_memo_num IN OUT NOCOPY VARCHAR2
20: ,p_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
23: ,p_conversion_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,p_deduction_req_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
25: ,p_debit_memo_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 22: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

18: ,p_deduction_req_num IN OUT NOCOPY VARCHAR2
19: ,p_debit_memo_num IN OUT NOCOPY VARCHAR2
20: ,p_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
23: ,p_conversion_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,p_deduction_req_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
25: ,p_debit_memo_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
26: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 23: ,p_conversion_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

19: ,p_debit_memo_num IN OUT NOCOPY VARCHAR2
20: ,p_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
23: ,p_conversion_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,p_deduction_req_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
25: ,p_debit_memo_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
26: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: ,p_status IN OUT NOCOPY VARCHAR2

Line 24: ,p_deduction_req_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

20: ,p_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
23: ,p_conversion_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,p_deduction_req_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
25: ,p_debit_memo_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
26: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: ,p_status IN OUT NOCOPY VARCHAR2
28: ,p_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 25: ,p_debit_memo_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

21: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
23: ,p_conversion_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,p_deduction_req_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
25: ,p_debit_memo_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
26: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: ,p_status IN OUT NOCOPY VARCHAR2
28: ,p_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: ) IS

Line 26: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

22: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
23: ,p_conversion_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,p_deduction_req_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
25: ,p_debit_memo_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
26: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: ,p_status IN OUT NOCOPY VARCHAR2
28: ,p_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: ) IS
30: l_ded_req_id NUMBER;

Line 28: ,p_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

24: ,p_deduction_req_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
25: ,p_debit_memo_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
26: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: ,p_status IN OUT NOCOPY VARCHAR2
28: ,p_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: ) IS
30: l_ded_req_id NUMBER;
31: l_dctn_hdrtbl g_pub_dctn_hdr_tbl%TYPE;
32: l_msg_count NUMBER;

Line 100: pa_interface_utils_pub.map_new_amg_msg

96: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
97: RAISE FND_API.G_EXC_ERROR;
98: END IF;
99: IF l_function_allowed = 'N' THEN
100: pa_interface_utils_pub.map_new_amg_msg
101: ( p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
102: ,p_msg_attribute => 'CHANGE'
103: ,p_resize_flag => 'Y'
104: ,p_msg_context => 'GENERAL'

Line 285: Procedure Create_Deduction_Txn( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

281: ( p_count => p_msg_count ,
282: p_data => p_msg_data );
283: End;
284:
285: Procedure Create_Deduction_Txn( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
286: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
287: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
288: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
289: ,p_msg_count OUT NOCOPY NUMBER

Line 288: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

284:
285: Procedure Create_Deduction_Txn( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
286: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
287: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
288: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
289: ,p_msg_count OUT NOCOPY NUMBER
290: ,p_msg_data OUT NOCOPY VARCHAR2
291: ,p_return_status OUT NOCOPY VARCHAR2
292: ,p_deduction_req_num IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 292: ,p_deduction_req_num IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

288: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
289: ,p_msg_count OUT NOCOPY NUMBER
290: ,p_msg_data OUT NOCOPY VARCHAR2
291: ,p_return_status OUT NOCOPY VARCHAR2
292: ,p_deduction_req_num IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
293: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
294: ,p_expenditure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
295: ,p_expenditure_item_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
296: ,p_gl_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 293: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

289: ,p_msg_count OUT NOCOPY NUMBER
290: ,p_msg_data OUT NOCOPY VARCHAR2
291: ,p_return_status OUT NOCOPY VARCHAR2
292: ,p_deduction_req_num IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
293: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
294: ,p_expenditure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
295: ,p_expenditure_item_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
296: ,p_gl_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
297: ,p_expenditure_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 294: ,p_expenditure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

290: ,p_msg_data OUT NOCOPY VARCHAR2
291: ,p_return_status OUT NOCOPY VARCHAR2
292: ,p_deduction_req_num IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
293: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
294: ,p_expenditure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
295: ,p_expenditure_item_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
296: ,p_gl_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
297: ,p_expenditure_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
298: ,p_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 295: ,p_expenditure_item_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

291: ,p_return_status OUT NOCOPY VARCHAR2
292: ,p_deduction_req_num IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
293: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
294: ,p_expenditure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
295: ,p_expenditure_item_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
296: ,p_gl_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
297: ,p_expenditure_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
298: ,p_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
299: -- ,p_override_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223

Line 296: ,p_gl_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

292: ,p_deduction_req_num IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
293: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
294: ,p_expenditure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
295: ,p_expenditure_item_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
296: ,p_gl_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
297: ,p_expenditure_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
298: ,p_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
299: -- ,p_override_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
300: ,p_expenditure_item_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 297: ,p_expenditure_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

293: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
294: ,p_expenditure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
295: ,p_expenditure_item_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
296: ,p_gl_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
297: ,p_expenditure_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
298: ,p_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
299: -- ,p_override_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
300: ,p_expenditure_item_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: -- ,p_projfunc_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 298: ,p_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

294: ,p_expenditure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
295: ,p_expenditure_item_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
296: ,p_gl_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
297: ,p_expenditure_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
298: ,p_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
299: -- ,p_override_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
300: ,p_expenditure_item_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: -- ,p_projfunc_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
302: ,p_orig_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 299: -- ,p_override_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223

295: ,p_expenditure_item_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
296: ,p_gl_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
297: ,p_expenditure_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
298: ,p_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
299: -- ,p_override_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
300: ,p_expenditure_item_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: -- ,p_projfunc_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
302: ,p_orig_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: -- ,p_override_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223

Line 300: ,p_expenditure_item_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

296: ,p_gl_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
297: ,p_expenditure_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
298: ,p_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
299: -- ,p_override_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
300: ,p_expenditure_item_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: -- ,p_projfunc_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
302: ,p_orig_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: -- ,p_override_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
304: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 301: -- ,p_projfunc_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

297: ,p_expenditure_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
298: ,p_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
299: -- ,p_override_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
300: ,p_expenditure_item_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: -- ,p_projfunc_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
302: ,p_orig_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: -- ,p_override_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
304: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
305: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 302: ,p_orig_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

298: ,p_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
299: -- ,p_override_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
300: ,p_expenditure_item_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: -- ,p_projfunc_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
302: ,p_orig_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: -- ,p_override_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
304: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
305: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
306: ,p_conversion_rate IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 303: -- ,p_override_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223

299: -- ,p_override_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
300: ,p_expenditure_item_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: -- ,p_projfunc_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
302: ,p_orig_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: -- ,p_override_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
304: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
305: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
306: ,p_conversion_rate IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
307: -- ,p_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223

Line 304: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

300: ,p_expenditure_item_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: -- ,p_projfunc_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
302: ,p_orig_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: -- ,p_override_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
304: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
305: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
306: ,p_conversion_rate IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
307: -- ,p_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
308: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 305: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

301: -- ,p_projfunc_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
302: ,p_orig_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: -- ,p_override_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
304: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
305: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
306: ,p_conversion_rate IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
307: -- ,p_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
308: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
309: ) IS

Line 306: ,p_conversion_rate IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

302: ,p_orig_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: -- ,p_override_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
304: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
305: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
306: ,p_conversion_rate IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
307: -- ,p_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
308: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
309: ) IS
310:

Line 307: -- ,p_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223

303: -- ,p_override_projfunc_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
304: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
305: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
306: ,p_conversion_rate IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
307: -- ,p_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
308: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
309: ) IS
310:
311: l_dctn_txntbl g_pub_dctn_txn_tbl%TYPE;

Line 308: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

304: ,p_conversion_ratetype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
305: ,p_conversion_ratedate IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
306: ,p_conversion_rate IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
307: -- ,p_amount IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- bug9052223
308: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
309: ) IS
310:
311: l_dctn_txntbl g_pub_dctn_txn_tbl%TYPE;
312:

Line 377: pa_interface_utils_pub.map_new_amg_msg

373: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;
376: IF l_function_allowed = 'N' THEN
377: pa_interface_utils_pub.map_new_amg_msg
378: ( p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
379: ,p_msg_attribute => 'CHANGE'
380: ,p_resize_flag => 'Y'
381: ,p_msg_context => 'GENERAL'