DBA Data[Home] [Help]

APPS.PA_CI_SUPPLIER_UTILS dependencies on PA_NUM_TBL_TYPE

Line 205: p_ci_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,

201: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_ci_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
206: p_ci_id IN NUMBER,
207: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
208: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
209: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

Line 207: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_ci_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
206: p_ci_id IN NUMBER,
207: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
208: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
209: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
210: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
211: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 209: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

205: p_ci_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
206: p_ci_id IN NUMBER,
207: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
208: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
209: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
210: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
211: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
212: );
213:

Line 211: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

207: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
208: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
209: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
210: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
211: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
212: );
213:
214: procedure save_supplier_costs(
215: p_api_version IN NUMBER

Line 221: ,p_ci_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

217: ,x_return_status IN OUT NOCOPY VARCHAR2
218: ,x_msg_data IN OUT NOCOPY VARCHAR2
219: ,x_msg_count IN OUT NOCOPY NUMBER
220: ,p_rowid_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
221: ,p_ci_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
222: ,p_ci_id IN NUMBER
223: ,p_ci_type_id IN NUMBER
224: ,p_ci_impact_id IN NUMBER DEFAULT NULL
225: ,p_calling_mode IN VARCHAR2

Line 230: ,p_vendor_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

226: ,p_org_id IN NUMBER
227: ,p_version_type IN VARCHAR2 DEFAULT 'ALL'
228: ,p_record_status_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
229: ,p_vendor_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
230: ,p_vendor_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
231: ,p_po_number_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
232: ,p_po_header_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
233: ,p_po_line_num_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
234: ,p_po_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 232: ,p_po_header_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

228: ,p_record_status_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
229: ,p_vendor_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
230: ,p_vendor_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
231: ,p_po_number_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
232: ,p_po_header_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
233: ,p_po_line_num_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
234: ,p_po_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
235: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
236: ,p_change_amount_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 234: ,p_po_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

230: ,p_vendor_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
231: ,p_po_number_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
232: ,p_po_header_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
233: ,p_po_line_num_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
234: ,p_po_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
235: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
236: ,p_change_amount_tbl IN SYSTEM.PA_NUM_TBL_TYPE
237: ,p_change_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
238: ,p_change_description_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE

Line 236: ,p_change_amount_tbl IN SYSTEM.PA_NUM_TBL_TYPE

232: ,p_po_header_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
233: ,p_po_line_num_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
234: ,p_po_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
235: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
236: ,p_change_amount_tbl IN SYSTEM.PA_NUM_TBL_TYPE
237: ,p_change_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
238: ,p_change_description_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
239: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
240: ,p_resource_list_mem_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 239: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

235: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
236: ,p_change_amount_tbl IN SYSTEM.PA_NUM_TBL_TYPE
237: ,p_change_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
238: ,p_change_description_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
239: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
240: ,p_resource_list_mem_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
241: ,p_adjusted_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
242: ,p_from_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
243: ,p_to_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 240: ,p_resource_list_mem_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

236: ,p_change_amount_tbl IN SYSTEM.PA_NUM_TBL_TYPE
237: ,p_change_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
238: ,p_change_description_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
239: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
240: ,p_resource_list_mem_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
241: ,p_adjusted_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
242: ,p_from_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
243: ,p_to_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
244: ,p_need_by_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 241: ,p_adjusted_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

237: ,p_change_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
238: ,p_change_description_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
239: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
240: ,p_resource_list_mem_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
241: ,p_adjusted_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
242: ,p_from_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
243: ,p_to_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
244: ,p_need_by_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
245: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 245: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

241: ,p_adjusted_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
242: ,p_from_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
243: ,p_to_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
244: ,p_need_by_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
245: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
246: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
247: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
248: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
249: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

Line 246: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

242: ,p_from_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
243: ,p_to_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
244: ,p_need_by_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
245: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
246: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
247: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
248: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
249: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
250: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 247: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

243: ,p_to_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
244: ,p_need_by_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
245: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
246: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
247: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
248: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
249: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
250: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
251: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 248: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

244: ,p_need_by_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
245: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
246: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
247: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
248: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
249: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
250: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
251: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
252: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 249: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

245: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
246: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
247: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
248: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
249: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
250: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
251: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
252: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
253: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 250: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE

246: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
247: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
248: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
249: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
250: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
251: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
252: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
253: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
254: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 251: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

247: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
248: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
249: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
250: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
251: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
252: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
253: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
254: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
255: ,p_sup_ref_no_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

Line 253: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

249: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
250: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
251: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
252: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
253: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
254: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
255: ,p_sup_ref_no_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
256: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
257: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 254: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

250: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
251: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
252: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
253: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
254: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
255: ,p_sup_ref_no_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
256: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
257: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
258: ,p_change_reason_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 255: ,p_sup_ref_no_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

251: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
252: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
253: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
254: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
255: ,p_sup_ref_no_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
256: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
257: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
258: ,p_change_reason_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
259: ,p_quote_negotiation_ref_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE

Line 257: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

253: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
254: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
255: ,p_sup_ref_no_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
256: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
257: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
258: ,p_change_reason_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
259: ,p_quote_negotiation_ref_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
260: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
261: );

Line 260: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

256: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
257: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
258: ,p_change_reason_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
259: ,p_quote_negotiation_ref_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
260: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
261: );
262: -- gboomina added for 12.1.3 supplier cost requirement - end
263:
264: