APPS.JAI_PA_TAX_PKG dependencies on JAI_PA_DRAFT_INVOICES

Line 813: ln_organization_id jai_pa_draft_invoices.organization_id%type;

809: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;
810: ln_count number ;
811: -- credit memo changes
812: ----------------------------------------------------------------------------------------
813: ln_organization_id jai_pa_draft_invoices.organization_id%type;
814: ln_location_id jai_pa_draft_invoices.location_id%type;
815: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;
816: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;
817: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;

Line 814: ln_location_id jai_pa_draft_invoices.location_id%type;

810: ln_count number ;
811: -- credit memo changes
812: ----------------------------------------------------------------------------------------
813: ln_organization_id jai_pa_draft_invoices.organization_id%type;
814: ln_location_id jai_pa_draft_invoices.location_id%type;
815: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;
816: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;
817: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
818: ln_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;

Line 824: from jai_pa_draft_invoices

820: -- get draft invoice id for existing draft invoice lines
821:
822: cursor cur_draft_invoice_id is
823: select draft_invoice_id
824: from jai_pa_draft_invoices
825: where project_id = r_new.project_id and
826: draft_invoice_num = r_new.draft_invoice_num ;
827:
828: -- generate sequence for header id

Line 830: select jai_pa_draft_invoices_s.nextval

826: draft_invoice_num = r_new.draft_invoice_num ;
827:
828: -- generate sequence for header id
829: cursor cur_draft_inv_seq is
830: select jai_pa_draft_invoices_s.nextval
831: from dual ;
832:
833: -- generate sequence for line id
834: cursor cur_draft_inv_line_seq is

Line 845: from jai_pa_draft_invoices

841: --credit memo invoice changes ----------------------------------------
842:
843: cursor cur_get_header_var is
844: select organization_id , location_id , draft_invoice_id
845: from jai_pa_draft_invoices
846: where project_id = r_new.project_id and
847: draft_invoice_num = pkg_global_type.ln_draft_invoice_num_credited;
848:
849: cursor cur_get_detail_var is

Line 900: insert into jai_pa_draft_invoices (

896: open cur_draft_inv_seq ;
897: fetch cur_draft_inv_seq into ln_draft_invoice_id ;
898: close cur_draft_inv_seq;
899:
900: insert into jai_pa_draft_invoices (
901: draft_invoice_id ,
902: project_id ,
903: draft_invoice_num ,
904: organization_id ,

Line 1225: delete from jai_pa_draft_invoices

1221: delete from jai_pa_draft_invoice_lines
1222: where project_id = pn_project_id and
1223: draft_invoice_num = pn_draft_invoice_num ;
1224:
1225: delete from jai_pa_draft_invoices
1226: where project_id =pn_project_id and
1227: draft_invoice_num = pn_draft_invoice_num ;
1228:
1229: pv_process_message := '';