DBA Data[Home] [Help]

APPS.JAI_PA_TAX_PKG dependencies on JAI_CMN_TAX_CTGS_ALL

Line 280: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;

276: pv_process_message out nocopy varchar2,
277: pv_process_flag out nocopy varchar2
278: ) is
279: ----------------variable declarations---------------------------
280: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;
281: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;
282: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;
283: ln_amount number ;
284: ln_tax_amount number ;

Line 357: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_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
358: ) is
359:
360: ----------------VARIABLE DECLARATIONS---------------------------
361: lv_distribution_rule pa_projects_all.distribution_rule%type ;

Line 362: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;

358: ) is
359:
360: ----------------VARIABLE DECLARATIONS---------------------------
361: lv_distribution_rule pa_projects_all.distribution_rule%type ;
362: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;
363: ln_process_status varchar2(20) ;
364: -----------------------------------------------------------------
365: ----------------cursor declarations------------------------------
366: -- responsible for getting distribution rule of project id

Line 482: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_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
486: ) is

Line 493: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;

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*/
495:
496: ----------------cursor declarations------------------------------
497: -- responsible for getting event type from pa_events

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

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
602: ) is

Line 604: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;

600: pv_process_message out nocopy varchar2,
601: pv_process_flag out nocopy varchar2
602: ) is
603: ----------------VARIABLE DECLARATIONS---------------------------
604: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
605: ln_org_id NUMBER; /*Bug 8348822*/
606: ----------------CURSOR DECLARATIONS------------------------------
607: cursor cur_get_project_all is
608: select setup_value1 tax_category

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

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
658: ) is

Line 660: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;

656: pv_process_message out nocopy varchar2,
657: pv_process_flag out nocopy varchar2
658: ) is
659: ----------------variable declarations---------------------------
660: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
661: ln_tax_customer_id pa_draft_invoices_all.ship_to_customer_id%type ;
662: ln_tax_address_id pa_draft_invoices_all.ship_to_address_id%type ;
663: ln_org_id NUMBER; /*Bug 8348822*/
664: ----------------cursor declarations------------------------------

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

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
743: ) is

Line 745: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;

741: pv_process_message out nocopy varchar2,
742: pv_process_flag out nocopy varchar2
743: ) is
744: ----------------variable declarations---------------------------
745: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
746: ln_count_expend_type number ;
747: lv_expenditure_type pa_expenditure_types.expenditure_type%type ;
748: ln_org_id NUMBER; /*Bug 8348822*/
749: ----------------cursor declarations------------------------------

Line 841: pn_tax_category_id in JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,

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 ,
845: pv_process_message out nocopy varchar2,

Line 1037: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;

1033: ) is
1034:
1035: ----------------variable declarations---------------------------
1036: ln_tax_amount number ;
1037: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;
1038: lv_inv_currency_code pa_draft_invoices_all.inv_currency_code%type;
1039: ln_inv_exchange_rate pa_draft_invoices_all.inv_exchange_rate%type;
1040: ----------------------------------------------------------------
1041: -- responsible to check for tax category id whether it is already exists .