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 JAI_PA_TAX_PKG

Line 1: package body jai_pa_tax_pkg as

1: package body jai_pa_tax_pkg as
2: /* $Header: jai_pa_tax_pkg.plb 120.3.12020000.2 2013/03/22 05:26:46 vkaranam ship $ */
3:
4: /*----------------------------------------------------------------------------------------
5: Change History

Line 2: /* $Header: jai_pa_tax_pkg.plb 120.3.12020000.2 2013/03/22 05:26:46 vkaranam ship $ */

1: package body jai_pa_tax_pkg as
2: /* $Header: jai_pa_tax_pkg.plb 120.3.12020000.2 2013/03/22 05:26:46 vkaranam ship $ */
3:
4: /*----------------------------------------------------------------------------------------
5: Change History
6: S.No. DATE Description

Line 234: jai_pa_tax_pkg.calculate_taxes(

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,
237: pv_process_message => pv_process_message,
238: pv_process_flag => pv_process_flag

Line 255: jai_pa_tax_pkg.tax_defaultation_line(

251: pv_process_flag out nocopy varchar2
252: ) is
253: begin
254: if pv_action = jai_constants.default_taxes then
255: jai_pa_tax_pkg.tax_defaultation_line(
256: r_new => r_new ,
257: pv_action => pv_action,
258: pv_process_message => pv_process_message,
259: pv_process_flag => pv_process_flag

Line 262: jai_pa_tax_pkg.tax_recalculate_line(

258: pv_process_message => pv_process_message,
259: pv_process_flag => pv_process_flag
260: );
261: elsif pv_action = jai_constants.recalculate_taxes then
262: jai_pa_tax_pkg.tax_recalculate_line(
263: r_new => r_new,
264: pv_action => pv_action,
265: pv_process_message => pv_process_message,
266: pv_process_flag => pv_process_flag

Line 305: jai_pa_tax_pkg.get_tax_category(

301: -- step 1 - responsible for getting tax category for project id , invoice num , line num on basis of distribution rule
302:
303: -- for credit memo invoice generation , tax category is not required
304: if pkg_global_type.ln_draft_invoice_num_credited is null then
305: jai_pa_tax_pkg.get_tax_category(
306: r_new.project_id ,
307: r_new.draft_invoice_num ,
308: r_new.line_num ,
309: r_new.event_task_id ,

Line 319: jai_pa_tax_pkg.insert_line_info(

315: end if;
316: -- step 2 - responsible for populating project information in india localalization table
317: -- it will populate india localization table even if tax category id is null
318:
319: jai_pa_tax_pkg.insert_line_info(
320: r_new ,
321: ln_tax_category_id ,
322: pv_action ,
323: ln_draft_invoice_id ,

Line 333: jai_pa_tax_pkg.default_taxes(

329: -------------if tax category id is null then no defaultation happen
330: if ln_tax_category_id is not null or pkg_global_type.ln_draft_invoice_num_credited is not null then
331: /*Bug 13513070 - Replaced INV_AMOUNT with AMOUNT as AMOUNT stores in Functional Currency*/
332: ln_amount := r_new.amount ; -- invoice amount instead of amount
333: jai_pa_tax_pkg.default_taxes(
334: pn_tax_category_id => ln_tax_category_id,
335: pn_draft_invoice_id => ln_draft_invoice_id,
336: pn_draft_invoice_line_id => ln_draft_invoice_line_id,
337: pv_called_from => null,

Line 386: ln_process_status := jai_pa_tax_pkg.process_fail;

382: begin
383: ----initialization part -----------------------------------------------------
384: lv_distribution_rule := null ;
385: ln_tax_category_id := null ;
386: ln_process_status := jai_pa_tax_pkg.process_fail;
387: -----------------------------------------------------------------------------
388:
389: open cur_distribution_rule ;
390: fetch cur_distribution_rule into lv_distribution_rule ;

Line 405: jai_pa_tax_pkg.get_event_tax_category(

401: for rec_context_prefernece in cur_context_preference(lv_distribution_rule)
402: loop
403: if jai_constants.setup_event_type = rec_context_prefernece.context then
404: -- tax category for events
405: jai_pa_tax_pkg.get_event_tax_category(
406: pn_project_id ,
407: pn_draft_invoice_num ,
408: pn_line_num ,
409: pn_event_task_id ,

Line 418: exit when ln_process_status = jai_pa_tax_pkg.process_success ;

414: pv_process_flag
415: ) ;
416: -- exit when tax category is found for events
417: pn_tax_category_id := ln_tax_category_id ;
418: exit when ln_process_status = jai_pa_tax_pkg.process_success ;
419: end if ;
420: if jai_constants.setup_expenditure_type = rec_context_prefernece.context then
421: -- tax category for expenditure
422: jai_pa_tax_pkg.get_expn_tax_category(

Line 422: jai_pa_tax_pkg.get_expn_tax_category(

418: exit when ln_process_status = jai_pa_tax_pkg.process_success ;
419: end if ;
420: if jai_constants.setup_expenditure_type = rec_context_prefernece.context then
421: -- tax category for expenditure
422: jai_pa_tax_pkg.get_expn_tax_category(
423: pn_project_id ,
424: pn_draft_invoice_num ,
425: pn_line_num ,
426: ln_tax_category_id ,

Line 434: exit when ln_process_status = jai_pa_tax_pkg.process_success ;

430: ) ;
431:
432: -- exit when tax category is found for expenditure
433: pn_tax_category_id := ln_tax_category_id ;
434: exit when ln_process_status = jai_pa_tax_pkg.process_success ;
435: end if ;
436: if jai_constants.setup_project = rec_context_prefernece.context then
437: -- tax category for projects
438: jai_pa_tax_pkg.get_project_tax_category(

Line 438: jai_pa_tax_pkg.get_project_tax_category(

434: exit when ln_process_status = jai_pa_tax_pkg.process_success ;
435: end if ;
436: if jai_constants.setup_project = rec_context_prefernece.context then
437: -- tax category for projects
438: jai_pa_tax_pkg.get_project_tax_category(
439: pn_project_id ,
440: pn_draft_invoice_num ,
441: pn_line_num ,
442: ln_tax_category_id ,

Line 450: exit when ln_process_status = jai_pa_tax_pkg.process_success ;

446: ) ;
447:
448: -- exit when tax category is found for projects
449: pn_tax_category_id := ln_tax_category_id ;
450: exit when ln_process_status = jai_pa_tax_pkg.process_success ;
451: end if ;
452:
453: if jai_constants.setup_customer_site = rec_context_prefernece.context then
454: -- tax category for customer/site or customer null site

Line 455: jai_pa_tax_pkg.get_cust_tax_category(

451: end if ;
452:
453: if jai_constants.setup_customer_site = rec_context_prefernece.context then
454: -- tax category for customer/site or customer null site
455: jai_pa_tax_pkg.get_cust_tax_category(
456: pn_project_id ,
457: pn_draft_invoice_num ,
458: pn_line_num ,
459: ln_tax_category_id ,

Line 466: exit when ln_process_status = jai_pa_tax_pkg.process_success ;

462: pv_process_flag
463: ) ;
464: -- exit when tax category is found for customer/site or customer null site .
465: pn_tax_category_id := ln_tax_category_id ;
466: exit when ln_process_status = jai_pa_tax_pkg.process_success ;
467: end if ;
468: end loop ;
469: pv_process_message := '';
470: pv_process_flag := jai_constants.successful;

Line 523: pv_process_status := jai_pa_tax_pkg.process_fail; -- package global variable

519: org_id = ln_org_id; /*Bug 8348822 - Tax defaulted based on ORG_ID of the project*/
520:
521: begin
522: ----initialization part -----------------------------------------------------
523: pv_process_status := jai_pa_tax_pkg.process_fail; -- package global variable
524: pn_tax_category_id := null ;
525: ln_event_task_id := null ;
526: ln_event_num := null ;
527: ln_event_type := null ;

Line 542: pv_process_status := jai_pa_tax_pkg.process_fail;

538:
539: -- step1
540: -- if event_task_id and ln_evnet_num is found null then returns ........................
541: if ln_event_num is null then
542: pv_process_status := jai_pa_tax_pkg.process_fail;
543: pn_tax_category_id := null ;
544: return ;
545: end if ;
546:

Line 553: pv_process_status := jai_pa_tax_pkg.process_fail;

549: close cur_get_event_type ;
550:
551: -- if no event type it's found then returns
552: if ln_event_type is null then
553: pv_process_status := jai_pa_tax_pkg.process_fail;
554: pn_tax_category_id := null ;
555: return ;
556: end if ;
557:

Line 564: pv_process_status := jai_pa_tax_pkg.process_fail;

560: close cur_get_event_type_id ;
561:
562: -- if event_type_id is not presnet then returns
563: if ln_event_type_id is null then
564: pv_process_status := jai_pa_tax_pkg.process_fail;
565: pn_tax_category_id := null ;
566: return ;
567: end if ;
568:

Line 575: pv_process_status := jai_pa_tax_pkg.process_fail;

571: close cur_get_tax_category ;
572:
573: -- if tax_category_id is not presnet then returns
574: if ln_tax_category_id is null then
575: pv_process_status := jai_pa_tax_pkg.process_fail;
576: pn_tax_category_id := null ;
577: return ;
578: end if ;
579:

Line 581: pv_process_status := jai_pa_tax_pkg.process_success;

577: return ;
578: end if ;
579:
580: pn_tax_category_id := ln_tax_category_id ;
581: pv_process_status := jai_pa_tax_pkg.process_success;
582:
583: pv_process_message := '';
584: pv_process_flag := jai_constants.successful;
585:

Line 587: pv_process_status := jai_pa_tax_pkg.process_fail;

583: pv_process_message := '';
584: pv_process_flag := jai_constants.successful;
585:
586: exception when others then
587: pv_process_status := jai_pa_tax_pkg.process_fail;
588: pn_tax_category_id := null ;
589: pv_process_message := substr('get_event_tax_category='|| sqlerrm,1,1999);
590: pv_process_flag := jai_constants.unexpected_error;
591: end get_event_tax_category ;

Line 616: pv_process_status := jai_pa_tax_pkg.process_fail;

612: org_id = ln_org_id; /*Bug 8348822 - Tax defaulted based on ORG_ID of the project*/
613:
614: begin
615: ----initialization part -----------------------------------------------------
616: pv_process_status := jai_pa_tax_pkg.process_fail;
617: pn_tax_category_id := null ;
618: ln_tax_category_id := null ;
619: -----------------------------------------------------------------------------
620:

Line 631: pv_process_status := jai_pa_tax_pkg.process_fail;

627: fetch cur_get_project_all into ln_tax_category_id ;
628: close cur_get_project_all ;
629:
630: if ln_tax_category_id is null then
631: pv_process_status := jai_pa_tax_pkg.process_fail;
632: pn_tax_category_id := null ;
633: return ;
634: end if ;
635:

Line 637: pv_process_status := jai_pa_tax_pkg.process_success;

633: return ;
634: end if ;
635:
636: pn_tax_category_id := ln_tax_category_id ;
637: pv_process_status := jai_pa_tax_pkg.process_success;
638:
639: pv_process_message := '';
640: pv_process_flag := jai_constants.successful;
641:

Line 643: pv_process_status := jai_pa_tax_pkg.process_fail;

639: pv_process_message := '';
640: pv_process_flag := jai_constants.successful;
641:
642: exception when others then
643: pv_process_status := jai_pa_tax_pkg.process_fail;
644: pn_tax_category_id := null ;
645:
646: pv_process_message := substr('get_project_tax_category='|| sqlerrm,1,1999);
647: pv_process_flag := jai_constants.unexpected_error;

Line 684: pv_process_status := jai_pa_tax_pkg.process_fail;

680: attribute2 is null and
681: org_id = ln_org_id; /*Bug 8348822 - Tax defaulted based on ORG_ID of the project*/
682: begin
683: ----initialization part -----------------------------------------------------
684: pv_process_status := jai_pa_tax_pkg.process_fail;
685: pn_tax_category_id := null ;
686: ln_tax_category_id := null ;
687: -----------------------------------------------------------------------------
688: -- responsible for getting customer info

Line 716: pv_process_status := jai_pa_tax_pkg.process_fail;

712: close cur_cust_tax ;
713: end if ;
714:
715: if ln_tax_category_id is null then
716: pv_process_status := jai_pa_tax_pkg.process_fail;
717: pn_tax_category_id := null ;
718: return ;
719: end if ;
720:

Line 723: pv_process_status := jai_pa_tax_pkg.process_success;

719: end if ;
720:
721: -- when process sucess in getting tax category----------------------------------------
722: pn_tax_category_id := ln_tax_category_id ;
723: pv_process_status := jai_pa_tax_pkg.process_success;
724: pv_process_message := '';
725: pv_process_flag := jai_constants.successful;
726: ---------------------------------------------------------------------------------------
727: exception when others then

Line 728: pv_process_status := jai_pa_tax_pkg.process_fail;

724: pv_process_message := '';
725: pv_process_flag := jai_constants.successful;
726: ---------------------------------------------------------------------------------------
727: exception when others then
728: pv_process_status := jai_pa_tax_pkg.process_fail;
729: pn_tax_category_id := null ;
730: pv_process_message := substr('get_event_tax_category='|| sqlerrm,1,1999);
731: pv_process_flag := jai_constants.unexpected_error;
732: end get_cust_tax_category;

Line 785: pv_process_status := jai_pa_tax_pkg.process_fail;

781: jpsv.org_id = ln_org_id; /*Bug 8348822 - Tax defaulted based on
782: ORG_ID of the project*/ /* Bug 12534669 Added alias jpsv to org_id column*/
783: begin
784: ----initialization part -----------------------------------------------------
785: pv_process_status := jai_pa_tax_pkg.process_fail;
786: pn_tax_category_id := null ;
787: ln_tax_category_id := null ;
788: ln_count_expend_type := 0 ;
789: lv_expenditure_type := null ;

Line 803: pv_process_status := jai_pa_tax_pkg.process_fail;

799: close cur_count_expend_type ;
800:
801: -- if expenditure defined for draft invoice lines is greater than 1 then skip this one and continue with next preference
802: if nvl(ln_count_expend_type,0) = 0 or nvl(ln_count_expend_type,0) > 1 then
803: pv_process_status := jai_pa_tax_pkg.process_fail;
804: pn_tax_category_id := null ;
805: return ;
806: end if ;
807:

Line 818: pv_process_status := jai_pa_tax_pkg.process_fail;

814: close cur_expn_tax_category ;
815:
816: -- when process successful in getting tax category----------------------------------------
817: if ln_tax_category_id is null then
818: pv_process_status := jai_pa_tax_pkg.process_fail;
819: pn_tax_category_id := null ;
820: return ;
821: end if ;
822:

Line 824: pv_process_status := jai_pa_tax_pkg.process_success;

820: return ;
821: end if ;
822:
823: pn_tax_category_id := ln_tax_category_id ;
824: pv_process_status := jai_pa_tax_pkg.process_success;
825:
826: pv_process_message := '';
827: pv_process_flag := jai_constants.successful;
828: ---------------------------------------------------------------------------------------

Line 830: pv_process_status := jai_pa_tax_pkg.process_fail;

826: pv_process_message := '';
827: pv_process_flag := jai_constants.successful;
828: ---------------------------------------------------------------------------------------
829: exception when others then
830: pv_process_status := jai_pa_tax_pkg.process_fail;
831: pn_tax_category_id := null ;
832:
833: pv_process_message := substr('get_event_tax_category='|| sqlerrm,1,1999);
834: pv_process_flag := jai_constants.unexpected_error;

Line 1393: END jai_pa_tax_pkg ;

1389:
1390: end loop ;
1391: end tax_recalculate_line ;
1392:
1393: END jai_pa_tax_pkg ;