eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PA_TAX_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 203: from pa_draft_invoice_items pdii

199: ) is
200:
201: cursor cur_get_invoice_lines is
202: select pdii.*
203: from pa_draft_invoice_items pdii
204: where pdii.project_id = r_new.project_id and
205: pdii.draft_invoice_num = r_new.draft_invoice_num ;
206: begin
207: ---- package level global variables -----------------------------------------------------

Line 222: for r_pa_draft_invoice_items in cur_get_invoice_lines

218: pkg_global_type.ln_draft_invoice_line_id := null;
219: pkg_global_type.ln_draft_invoice_id := null;
220: pkg_global_type.ln_line_amt := null;
221: -----------------------------------------------------------------------------
222: for r_pa_draft_invoice_items in cur_get_invoice_lines
223: loop
224: jai_pa_tax_pkg.calculate_taxes(
225: r_new => r_pa_draft_invoice_items,
226: pv_action => pv_action,

Line 225: r_new => r_pa_draft_invoice_items,

221: -----------------------------------------------------------------------------
222: for r_pa_draft_invoice_items in cur_get_invoice_lines
223: loop
224: jai_pa_tax_pkg.calculate_taxes(
225: r_new => r_pa_draft_invoice_items,
226: pv_action => pv_action,
227: pv_process_message => pv_process_message,
228: pv_process_flag => pv_process_flag
229: );

Line 238: r_new in pa_draft_invoice_items%rowtype,

234:
235: /*-------------------------------begin local method calculate_taxes -----------------------------*/
236: procedure calculate_taxes
237: (
238: r_new in pa_draft_invoice_items%rowtype,
239: pv_action in varchar2,
240: pv_process_message out nocopy varchar2,
241: pv_process_flag out nocopy varchar2
242: ) is

Line 264: r_new in pa_draft_invoice_items%rowtype,

260:
261: /*-------------------------------begin local method tax_defaultation_line -----------------------------*/
262: procedure tax_defaultation_line
263: (
264: r_new in pa_draft_invoice_items%rowtype,
265: pv_action in varchar2,
266: pv_process_message out nocopy varchar2,
267: pv_process_flag out nocopy varchar2
268: ) is

Line 340: pn_line_num in pa_draft_invoice_items.line_num%type ,

336:
337: procedure get_tax_category(
338: pn_project_id in pa_draft_invoices_all.project_id%type ,
339: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
340: pn_line_num in pa_draft_invoice_items.line_num%type ,
341: pn_event_task_id in pa_draft_invoice_items.event_task_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,

Line 341: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,

337: procedure get_tax_category(
338: pn_project_id in pa_draft_invoices_all.project_id%type ,
339: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
340: pn_line_num in pa_draft_invoice_items.line_num%type ,
341: pn_event_task_id in pa_draft_invoice_items.event_task_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,

Line 342: pn_event_num in pa_draft_invoice_items.event_num%type,

338: pn_project_id in pa_draft_invoices_all.project_id%type ,
339: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
340: pn_line_num in pa_draft_invoice_items.line_num%type ,
341: pn_event_task_id in pa_draft_invoice_items.event_task_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

Line 468: pn_line_num in pa_draft_invoice_items.line_num%type ,

464: /*-------------------------------BEGIN LOCAL METHOD GET_EVENT_TAX_CATEGORY -----------------------------*/
465: procedure get_event_tax_category(
466: pn_project_id in pa_draft_invoices_all.project_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 ,

Line 469: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,

465: procedure get_event_tax_category(
466: pn_project_id in pa_draft_invoices_all.project_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,

Line 470: pn_event_num in pa_draft_invoice_items.event_num%type,

466: pn_project_id in pa_draft_invoices_all.project_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

Line 478: ln_event_task_id pa_draft_invoice_items.event_task_id%type ;

474: pv_process_flag out nocopy varchar2
475: ) is
476:
477: ----------------VARIABLE DECLARATIONS---------------------------
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;

Line 479: ln_event_num pa_draft_invoice_items.event_num%type ;

475: ) is
476:
477: ----------------VARIABLE DECLARATIONS---------------------------
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:

Line 579: pn_line_num in pa_draft_invoice_items.line_num%type ,

575: /*-------------------------------begin local method get_project_tax_category -----------------------------*/
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

Line 628: pn_line_num in pa_draft_invoice_items.line_num%type ,

624: /*-------------------------------begin local method get_cust_tax_category -----------------------------*/
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

Line 705: pn_line_num in pa_draft_invoice_items.line_num%type ,

701: /*-------------------------------BEGIN LOCAL METHOD GET_EXPN_TAX_CATEGORY -----------------------------*/
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

Line 799: r_new in pa_draft_invoice_items%rowtype,

795:
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 ,

Line 1283: r_new in pa_draft_invoice_items%rowtype,

1279: /*-------------------------------begin local method tax_recalculate_line -----------------------------*/
1280:
1281: procedure tax_recalculate_line
1282: (
1283: r_new in pa_draft_invoice_items%rowtype,
1284: pv_action in varchar2,
1285: pv_process_message out nocopy varchar2,
1286: pv_process_flag out nocopy varchar2
1287: ) is