DBA Data[Home] [Help]

APPS.PA_BILL_WORKBENCH_INVOICE dependencies on PA_DRAFT_INVOICES_V

Line 424: l_customer_id pa_draft_invoices_v.customer_id%TYPE;

420: P_Draft_Invoice_Num in number,
421: P_Validation_Level in varchar2,
422: X_Error_Message_Code out NOCOPY varchar2 ) is --File.Sql.39 bug 4440895
423:
424: l_customer_id pa_draft_invoices_v.customer_id%TYPE;
425: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;
426: l_approved_date pa_draft_invoices_v.approved_date%TYPE;
427: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;
428: l_dummy number;

Line 425: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;

421: P_Validation_Level in varchar2,
422: X_Error_Message_Code out NOCOPY varchar2 ) is --File.Sql.39 bug 4440895
423:
424: l_customer_id pa_draft_invoices_v.customer_id%TYPE;
425: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;
426: l_approved_date pa_draft_invoices_v.approved_date%TYPE;
427: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;
428: l_dummy number;
429: l_err_msg_code varchar2(30);

Line 426: l_approved_date pa_draft_invoices_v.approved_date%TYPE;

422: X_Error_Message_Code out NOCOPY varchar2 ) is --File.Sql.39 bug 4440895
423:
424: l_customer_id pa_draft_invoices_v.customer_id%TYPE;
425: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;
426: l_approved_date pa_draft_invoices_v.approved_date%TYPE;
427: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;
428: l_dummy number;
429: l_err_msg_code varchar2(30);
430:

Line 427: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;

423:
424: l_customer_id pa_draft_invoices_v.customer_id%TYPE;
425: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;
426: l_approved_date pa_draft_invoices_v.approved_date%TYPE;
427: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;
428: l_dummy number;
429: l_err_msg_code varchar2(30);
430:
431: Cursor Inv_Cur is