DBA Data[Home] [Help]

APPS.JAI_PA_TAX_PKG dependencies on JAI_CMN_TAX_CTGS_ALL

Line 270: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;

266: pv_process_message out nocopy varchar2,
267: pv_process_flag out nocopy varchar2
268: ) is
269: ----------------variable declarations---------------------------
270: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;
271: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;
272: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;
273: ln_amount number ;
274: ln_tax_amount number ;

Line 346: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type

342: pn_event_num in pa_draft_invoice_items.event_num%type,
343: pv_action in varchar2,
344: pv_process_message out nocopy varchar2,
345: pv_process_flag out nocopy varchar2,
346: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type
347: ) is
348:
349: ----------------VARIABLE DECLARATIONS---------------------------
350: lv_distribution_rule pa_projects_all.distribution_rule%type ;

Line 351: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;

347: ) is
348:
349: ----------------VARIABLE DECLARATIONS---------------------------
350: lv_distribution_rule pa_projects_all.distribution_rule%type ;
351: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;
352: ln_process_status varchar2(20) ;
353: -----------------------------------------------------------------
354: ----------------cursor declarations------------------------------
355: -- responsible for getting distribution rule of project id

Line 471: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,

467: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
468: pn_line_num in pa_draft_invoice_items.line_num%type ,
469: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,
470: pn_event_num in pa_draft_invoice_items.event_num%type,
471: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
472: pv_process_status out nocopy varchar2 ,
473: pv_process_message out nocopy varchar2,
474: pv_process_flag out nocopy varchar2
475: ) is

Line 482: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;

478: ln_event_task_id pa_draft_invoice_items.event_task_id%type ;
479: ln_event_num pa_draft_invoice_items.event_num%type ;
480: ln_event_type pa_events.event_type%type ;
481: ln_event_type_id pa_event_types.event_type_id%type ;
482: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
483:
484: ----------------cursor declarations------------------------------
485: -- responsible for getting event type from pa_events
486:

Line 580: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,

576: procedure get_project_tax_category
577: ( pn_project_id in pa_draft_invoices_all.project_id%type ,
578: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
579: pn_line_num in pa_draft_invoice_items.line_num%type ,
580: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
581: pv_process_status out nocopy varchar2 ,
582: pv_process_message out nocopy varchar2,
583: pv_process_flag out nocopy varchar2
584: ) is

Line 586: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;

582: pv_process_message out nocopy varchar2,
583: pv_process_flag out nocopy varchar2
584: ) is
585: ----------------VARIABLE DECLARATIONS---------------------------
586: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
587: ----------------CURSOR DECLARATIONS------------------------------
588: cursor cur_get_project_all is
589: select setup_value1 tax_category
590: from jai_pa_setup_values

Line 629: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,

625: procedure get_cust_tax_category
626: ( pn_project_id in pa_draft_invoices_all.project_id%type ,
627: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
628: pn_line_num in pa_draft_invoice_items.line_num%type ,
629: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
630: pv_process_status out nocopy varchar2 ,
631: pv_process_message out nocopy varchar2,
632: pv_process_flag out nocopy varchar2
633: ) is

Line 635: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;

631: pv_process_message out nocopy varchar2,
632: pv_process_flag out nocopy varchar2
633: ) is
634: ----------------variable declarations---------------------------
635: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
636: ln_tax_customer_id pa_draft_invoices_all.ship_to_customer_id%type ;
637: ln_tax_address_id pa_draft_invoices_all.ship_to_address_id%type ;
638: ----------------cursor declarations------------------------------
639: -- responsible for getting tax category attached with customer / site combination or customer / null site combination

Line 706: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,

702: procedure get_expn_tax_category
703: ( pn_project_id in pa_draft_invoices_all.project_id%type ,
704: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
705: pn_line_num in pa_draft_invoice_items.line_num%type ,
706: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
707: pv_process_status out nocopy varchar2 ,
708: pv_process_message out nocopy varchar2,
709: pv_process_flag out nocopy varchar2
710: ) is

Line 712: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;

708: pv_process_message out nocopy varchar2,
709: pv_process_flag out nocopy varchar2
710: ) is
711: ----------------variable declarations---------------------------
712: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
713: ln_count_expend_type number ;
714: lv_expenditure_type pa_expenditure_types.expenditure_type%type ;
715: ----------------cursor declarations------------------------------
716: -- count different types of expenditure defined in invoices lines

Line 800: pn_tax_category_id in JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,

796: /*-------------------------------BEGIN LOCAL METHOD INSERT_LINE_INFO -----------------------------*/
797:
798: procedure insert_line_info (
799: r_new in pa_draft_invoice_items%rowtype,
800: pn_tax_category_id in JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
801: pv_action in varchar2,
802: pn_draft_invoice_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_id%type ,
803: pn_draft_invoice_line_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_line_id%type ,
804: pv_process_message out nocopy varchar2,

Line 996: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;

992: ) is
993:
994: ----------------variable declarations---------------------------
995: ln_tax_amount number ;
996: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;
997: lv_inv_currency_code pa_draft_invoices_all.inv_currency_code%type;
998: ln_inv_exchange_rate pa_draft_invoices_all.inv_exchange_rate%type;
999: ----------------------------------------------------------------
1000: -- responsible to check for tax category id whether it is already exists .