DBA Data[Home] [Help]

APPS.JAI_PA_TAX_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 213: from pa_draft_invoice_items pdii

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 -----------------------------------------------------

Line 232: for r_pa_draft_invoice_items in cur_get_invoice_lines

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,

Line 235: r_new => r_pa_draft_invoice_items,

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: );

Line 248: r_new in pa_draft_invoice_items%rowtype,

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

Line 274: r_new in pa_draft_invoice_items%rowtype,

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

Line 351: pn_line_num in pa_draft_invoice_items.line_num%type ,

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,

Line 352: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,

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,

Line 353: pn_event_num in pa_draft_invoice_items.event_num%type,

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

Line 479: pn_line_num in pa_draft_invoice_items.line_num%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 ,

Line 480: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,

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,

Line 481: pn_event_num in pa_draft_invoice_items.event_num%type,

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

Line 489: ln_event_task_id pa_draft_invoice_items.event_task_id%type ;

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;

Line 490: ln_event_num pa_draft_invoice_items.event_num%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*/

Line 597: pn_line_num in pa_draft_invoice_items.line_num%type ,

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

Line 653: pn_line_num in pa_draft_invoice_items.line_num%type ,

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

Line 738: pn_line_num in pa_draft_invoice_items.line_num%type ,

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

Line 840: r_new in pa_draft_invoice_items%rowtype,

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 ,

Line 1327: r_new in pa_draft_invoice_items%rowtype,

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