APPS.JAI_PA_TAX_PKG dependencies on JAI_PA_DRAFT_INVOICES

Line 854: ln_organization_id jai_pa_draft_invoices.organization_id%type;

850: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;
851: ln_count number ;
852: -- credit memo changes
853: ----------------------------------------------------------------------------------------
854: ln_organization_id jai_pa_draft_invoices.organization_id%type;
855: ln_location_id jai_pa_draft_invoices.location_id%type;
856: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;
857: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;
858: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;

Line 855: ln_location_id jai_pa_draft_invoices.location_id%type;

851: ln_count number ;
852: -- credit memo changes
853: ----------------------------------------------------------------------------------------
854: ln_organization_id jai_pa_draft_invoices.organization_id%type;
855: ln_location_id jai_pa_draft_invoices.location_id%type;
856: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;
857: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;
858: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
859: ln_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;

Line 865: from jai_pa_draft_invoices

861: -- get draft invoice id for existing draft invoice lines
862:
863: cursor cur_draft_invoice_id is
864: select draft_invoice_id
865: from jai_pa_draft_invoices
866: where project_id = r_new.project_id and
867: draft_invoice_num = r_new.draft_invoice_num ;
868:
869: -- generate sequence for header id

Line 871: select jai_pa_draft_invoices_s.nextval

867: draft_invoice_num = r_new.draft_invoice_num ;
868:
869: -- generate sequence for header id
870: cursor cur_draft_inv_seq is
871: select jai_pa_draft_invoices_s.nextval
872: from dual ;
873:
874: -- generate sequence for line id
875: cursor cur_draft_inv_line_seq is

Line 886: from jai_pa_draft_invoices

882: --credit memo invoice changes ----------------------------------------
883:
884: cursor cur_get_header_var is
885: select organization_id , location_id , draft_invoice_id
886: from jai_pa_draft_invoices
887: where project_id = r_new.project_id and
888: draft_invoice_num = pkg_global_type.ln_draft_invoice_num_credited;
889:
890: cursor cur_get_detail_var is

Line 941: insert into jai_pa_draft_invoices (

937: open cur_draft_inv_seq ;
938: fetch cur_draft_inv_seq into ln_draft_invoice_id ;
939: close cur_draft_inv_seq;
940:
941: insert into jai_pa_draft_invoices (
942: draft_invoice_id ,
943: project_id ,
944: draft_invoice_num ,
945: organization_id ,

Line 1269: delete from jai_pa_draft_invoices

1265: delete from jai_pa_draft_invoice_lines
1266: where project_id = pn_project_id and
1267: draft_invoice_num = pn_draft_invoice_num ;
1268:
1269: delete from jai_pa_draft_invoices
1270: where project_id =pn_project_id and
1271: draft_invoice_num = pn_draft_invoice_num ;
1272:
1273: pv_process_message := '';