DBA Data[Home] [Help]

APPS.PA_DEDUCTIONS_PUB dependencies on PA_INTERFACE_UTILS_PUB

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

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

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

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

Line 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

Line 73: ,p_vendor_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

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

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

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

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

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

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

Line 79: ,p_currency_code 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

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

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

Line 81: ,p_conversion_ratedate 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

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

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

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

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

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

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

Line 85: ,p_description 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:

Line 87: ,p_org_id 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.

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

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

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

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

Line 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

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

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

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

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

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

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

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

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

Line 141: ,p_expenditure_org_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

Line 142: ,p_quantity 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

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

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

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

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

Line 145: -- ,p_projfunc_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- bug9052223

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

Line 146: ,p_orig_projfunc_amount 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

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

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

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

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

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

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

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

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:

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

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;

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

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;