APPS.PA_INVOICE_ACTIONS dependencies on PA_DRAFT_INVOICES_V

Line 270: l_customer_id pa_draft_invoices_v.customer_id%TYPE;

266: P_Draft_Invoice_Num in number,
267: P_Validation_Level in varchar2,
268: X_Error_Message_Code out NOCOPY varchar2 ) is --File.Sql.39 bug 4440895
269:
270: l_customer_id pa_draft_invoices_v.customer_id%TYPE;
271: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;
272: l_approved_date pa_draft_invoices_v.approved_date%TYPE;
273: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;
274: l_dummy number;

Line 271: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;

267: P_Validation_Level in varchar2,
268: X_Error_Message_Code out NOCOPY varchar2 ) is --File.Sql.39 bug 4440895
269:
270: l_customer_id pa_draft_invoices_v.customer_id%TYPE;
271: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;
272: l_approved_date pa_draft_invoices_v.approved_date%TYPE;
273: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;
274: l_dummy number;
275: l_err_msg_code varchar2(30);

Line 272: l_approved_date pa_draft_invoices_v.approved_date%TYPE;

268: X_Error_Message_Code out NOCOPY varchar2 ) is --File.Sql.39 bug 4440895
269:
270: l_customer_id pa_draft_invoices_v.customer_id%TYPE;
271: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;
272: l_approved_date pa_draft_invoices_v.approved_date%TYPE;
273: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;
274: l_dummy number;
275: l_err_msg_code varchar2(30);
276:

Line 273: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;

269:
270: l_customer_id pa_draft_invoices_v.customer_id%TYPE;
271: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;
272: l_approved_date pa_draft_invoices_v.approved_date%TYPE;
273: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;
274: l_dummy number;
275: l_err_msg_code varchar2(30);
276:
277:

Line 278: /* Bug#4940211 - Performance Issue for calling the pa_draft_invoices_v

274: l_dummy number;
275: l_err_msg_code varchar2(30);
276:
277:
278: /* Bug#4940211 - Performance Issue for calling the pa_draft_invoices_v
279: Fix : commented the old code and Geting
280: the value from pa_project_all and pa_draft_invoices table
281:
282: Cursor Inv_Cur is

Line 285: FROM pa_draft_invoices_v i

281:
282: Cursor Inv_Cur is
283: SELECT i.customer_id, i.generation_error_flag,
284: i.approved_date , i.project_status_code
285: FROM pa_draft_invoices_v i
286: WHERE i.project_id = P_Project_ID
287: AND i.draft_invoice_num = P_Draft_Invoice_Num;
288: */
289:

Line 401: l_RA_Invoice_Num pa_draft_invoices_v.RA_Invoice_Number%TYPE;

397:
398: l_dummy number;
399: l_customer_id number;
400: l_err_msg_code varchar2(30);
401: l_RA_Invoice_Num pa_draft_invoices_v.RA_Invoice_Number%TYPE;
402: l_status number;
403: l_bill_to number;
404: l_ship_to number;
405: l_Error_Message_Code VARCHAR2(80):=NULL;

Line 407: l_invoice_category pa_draft_invoices_v.invoice_category%TYPE;

403: l_bill_to number;
404: l_ship_to number;
405: l_Error_Message_Code VARCHAR2(80):=NULL;
406:
407: l_invoice_category pa_draft_invoices_v.invoice_category%TYPE;
408: l_bill_ship_to_customer_id number; /*Added for customer account relation enhancement*/
409: Cursor Imp_Cur is
410: SELECT user_defined_invoice_num_code, manual_invoice_num_type
411: FROM pa_implementations;