209: ) is
210:
211: cursor cur_get_invoice_lines is
212: select pdii.*
213: from pa_draft_invoice_items pdii
214: where pdii.project_id = r_new.project_id and
215: pdii.draft_invoice_num = r_new.draft_invoice_num ;
216: begin
217: ---- package level global variables -----------------------------------------------------
228: pkg_global_type.ln_draft_invoice_line_id := null;
229: pkg_global_type.ln_draft_invoice_id := null;
230: pkg_global_type.ln_line_amt := null;
231: -----------------------------------------------------------------------------
232: for r_pa_draft_invoice_items in cur_get_invoice_lines
233: loop
234: jai_pa_tax_pkg.calculate_taxes(
235: r_new => r_pa_draft_invoice_items,
236: pv_action => pv_action,
231: -----------------------------------------------------------------------------
232: for r_pa_draft_invoice_items in cur_get_invoice_lines
233: loop
234: jai_pa_tax_pkg.calculate_taxes(
235: r_new => r_pa_draft_invoice_items,
236: pv_action => pv_action,
237: pv_process_message => pv_process_message,
238: pv_process_flag => pv_process_flag
239: );
244:
245: /*-------------------------------begin local method calculate_taxes -----------------------------*/
246: procedure calculate_taxes
247: (
248: r_new in pa_draft_invoice_items%rowtype,
249: pv_action in varchar2,
250: pv_process_message out nocopy varchar2,
251: pv_process_flag out nocopy varchar2
252: ) is
270:
271: /*-------------------------------begin local method tax_defaultation_line -----------------------------*/
272: procedure tax_defaultation_line
273: (
274: r_new in pa_draft_invoice_items%rowtype,
275: pv_action in varchar2,
276: pv_process_message out nocopy varchar2,
277: pv_process_flag out nocopy varchar2
278: ) is
347:
348: procedure get_tax_category(
349: pn_project_id in pa_draft_invoices_all.project_id%type ,
350: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
351: pn_line_num in pa_draft_invoice_items.line_num%type ,
352: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,
353: pn_event_num in pa_draft_invoice_items.event_num%type,
354: pv_action in varchar2,
355: pv_process_message out nocopy varchar2,
348: procedure get_tax_category(
349: pn_project_id in pa_draft_invoices_all.project_id%type ,
350: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
351: pn_line_num in pa_draft_invoice_items.line_num%type ,
352: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,
353: pn_event_num in pa_draft_invoice_items.event_num%type,
354: pv_action in varchar2,
355: pv_process_message out nocopy varchar2,
356: pv_process_flag out nocopy varchar2,
349: pn_project_id in pa_draft_invoices_all.project_id%type ,
350: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
351: pn_line_num in pa_draft_invoice_items.line_num%type ,
352: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,
353: pn_event_num in pa_draft_invoice_items.event_num%type,
354: pv_action in varchar2,
355: pv_process_message out nocopy varchar2,
356: pv_process_flag out nocopy varchar2,
357: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type
475: /*-------------------------------BEGIN LOCAL METHOD GET_EVENT_TAX_CATEGORY -----------------------------*/
476: procedure get_event_tax_category(
477: pn_project_id in pa_draft_invoices_all.project_id%type ,
478: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
479: pn_line_num in pa_draft_invoice_items.line_num%type ,
480: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,
481: pn_event_num in pa_draft_invoice_items.event_num%type,
482: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
483: pv_process_status out nocopy varchar2 ,
476: procedure get_event_tax_category(
477: pn_project_id in pa_draft_invoices_all.project_id%type ,
478: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
479: pn_line_num in pa_draft_invoice_items.line_num%type ,
480: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,
481: pn_event_num in pa_draft_invoice_items.event_num%type,
482: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
483: pv_process_status out nocopy varchar2 ,
484: pv_process_message out nocopy varchar2,
477: pn_project_id in pa_draft_invoices_all.project_id%type ,
478: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
479: pn_line_num in pa_draft_invoice_items.line_num%type ,
480: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,
481: pn_event_num in pa_draft_invoice_items.event_num%type,
482: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
483: pv_process_status out nocopy varchar2 ,
484: pv_process_message out nocopy varchar2,
485: pv_process_flag out nocopy varchar2
485: pv_process_flag out nocopy varchar2
486: ) is
487:
488: ----------------VARIABLE DECLARATIONS---------------------------
489: ln_event_task_id pa_draft_invoice_items.event_task_id%type ;
490: ln_event_num pa_draft_invoice_items.event_num%type ;
491: ln_event_type pa_events.event_type%type ;
492: ln_event_type_id pa_event_types.event_type_id%type ;
493: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
486: ) is
487:
488: ----------------VARIABLE DECLARATIONS---------------------------
489: ln_event_task_id pa_draft_invoice_items.event_task_id%type ;
490: ln_event_num pa_draft_invoice_items.event_num%type ;
491: ln_event_type pa_events.event_type%type ;
492: ln_event_type_id pa_event_types.event_type_id%type ;
493: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
494: ln_org_id NUMBER; /*Bug 8348822*/
593: /*-------------------------------begin local method get_project_tax_category -----------------------------*/
594: procedure get_project_tax_category
595: ( pn_project_id in pa_draft_invoices_all.project_id%type ,
596: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
597: pn_line_num in pa_draft_invoice_items.line_num%type ,
598: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
599: pv_process_status out nocopy varchar2 ,
600: pv_process_message out nocopy varchar2,
601: pv_process_flag out nocopy varchar2
649: /*-------------------------------begin local method get_cust_tax_category -----------------------------*/
650: procedure get_cust_tax_category
651: ( pn_project_id in pa_draft_invoices_all.project_id%type ,
652: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
653: pn_line_num in pa_draft_invoice_items.line_num%type ,
654: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
655: pv_process_status out nocopy varchar2 ,
656: pv_process_message out nocopy varchar2,
657: pv_process_flag out nocopy varchar2
734: /*-------------------------------BEGIN LOCAL METHOD GET_EXPN_TAX_CATEGORY -----------------------------*/
735: procedure get_expn_tax_category
736: ( pn_project_id in pa_draft_invoices_all.project_id%type ,
737: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
738: pn_line_num in pa_draft_invoice_items.line_num%type ,
739: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
740: pv_process_status out nocopy varchar2 ,
741: pv_process_message out nocopy varchar2,
742: pv_process_flag out nocopy varchar2
836:
837: /*-------------------------------BEGIN LOCAL METHOD INSERT_LINE_INFO -----------------------------*/
838:
839: procedure insert_line_info (
840: r_new in pa_draft_invoice_items%rowtype,
841: pn_tax_category_id in JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
842: pv_action in varchar2,
843: pn_draft_invoice_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_id%type ,
844: pn_draft_invoice_line_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_line_id%type ,
1323: /*-------------------------------begin local method tax_recalculate_line -----------------------------*/
1324:
1325: procedure tax_recalculate_line
1326: (
1327: r_new in pa_draft_invoice_items%rowtype,
1328: pv_action in varchar2,
1329: pv_process_message out nocopy varchar2,
1330: pv_process_flag out nocopy varchar2
1331: ) is