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.0.12000000.1 2007/10/24 18:20:43 rallamse noship $ */
3:
4: /*----------------------------------------------------------------------------------------
5: Change History

Line 2: /* $Header: jai_pa_tax_pkg.plb 120.0.12000000.1 2007/10/24 18:20:43 rallamse noship $ */

1: package body jai_pa_tax_pkg as
2: /* $Header: jai_pa_tax_pkg.plb 120.0.12000000.1 2007/10/24 18:20:43 rallamse noship $ */
3:
4: /*----------------------------------------------------------------------------------------
5: Change History
6: S.No. DATE Description

Line 224: jai_pa_tax_pkg.calculate_taxes(

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,
227: pv_process_message => pv_process_message,
228: pv_process_flag => pv_process_flag

Line 245: jai_pa_tax_pkg.tax_defaultation_line(

241: pv_process_flag out nocopy varchar2
242: ) is
243: begin
244: if pv_action = jai_constants.default_taxes then
245: jai_pa_tax_pkg.tax_defaultation_line(
246: r_new => r_new ,
247: pv_action => pv_action,
248: pv_process_message => pv_process_message,
249: pv_process_flag => pv_process_flag

Line 252: jai_pa_tax_pkg.tax_recalculate_line(

248: pv_process_message => pv_process_message,
249: pv_process_flag => pv_process_flag
250: );
251: elsif pv_action = jai_constants.recalculate_taxes then
252: jai_pa_tax_pkg.tax_recalculate_line(
253: r_new => r_new,
254: pv_action => pv_action,
255: pv_process_message => pv_process_message,
256: pv_process_flag => pv_process_flag

Line 295: jai_pa_tax_pkg.get_tax_category(

291: -- step 1 - responsible for getting tax category for project id , invoice num , line num on basis of distribution rule
292:
293: -- for credit memo invoice generation , tax category is not required
294: if pkg_global_type.ln_draft_invoice_num_credited is null then
295: jai_pa_tax_pkg.get_tax_category(
296: r_new.project_id ,
297: r_new.draft_invoice_num ,
298: r_new.line_num ,
299: r_new.event_task_id ,

Line 309: jai_pa_tax_pkg.insert_line_info(

305: end if;
306: -- step 2 - responsible for populating project information in india localalization table
307: -- it will populate india localization table even if tax category id is null
308:
309: jai_pa_tax_pkg.insert_line_info(
310: r_new ,
311: ln_tax_category_id ,
312: pv_action ,
313: ln_draft_invoice_id ,

Line 322: jai_pa_tax_pkg.default_taxes(

318: -- step 3 - responsible for default taxes
319: -------------if tax category id is null then no defaultation happen
320: if ln_tax_category_id is not null or pkg_global_type.ln_draft_invoice_num_credited is not null then
321: ln_amount := r_new.inv_amount ; -- invoice amount instead of amount
322: jai_pa_tax_pkg.default_taxes(
323: pn_tax_category_id => ln_tax_category_id,
324: pn_draft_invoice_id => ln_draft_invoice_id,
325: pn_draft_invoice_line_id => ln_draft_invoice_line_id,
326: pv_called_from => null,

Line 375: ln_process_status := jai_pa_tax_pkg.process_fail;

371: begin
372: ----initialization part -----------------------------------------------------
373: lv_distribution_rule := null ;
374: ln_tax_category_id := null ;
375: ln_process_status := jai_pa_tax_pkg.process_fail;
376: -----------------------------------------------------------------------------
377:
378: open cur_distribution_rule ;
379: fetch cur_distribution_rule into lv_distribution_rule ;

Line 394: jai_pa_tax_pkg.get_event_tax_category(

390: for rec_context_prefernece in cur_context_preference(lv_distribution_rule)
391: loop
392: if jai_constants.setup_event_type = rec_context_prefernece.context then
393: -- tax category for events
394: jai_pa_tax_pkg.get_event_tax_category(
395: pn_project_id ,
396: pn_draft_invoice_num ,
397: pn_line_num ,
398: pn_event_task_id ,

Line 407: exit when ln_process_status = jai_pa_tax_pkg.process_success ;

403: pv_process_flag
404: ) ;
405: -- exit when tax category is found for events
406: pn_tax_category_id := ln_tax_category_id ;
407: exit when ln_process_status = jai_pa_tax_pkg.process_success ;
408: end if ;
409: if jai_constants.setup_expenditure_type = rec_context_prefernece.context then
410: -- tax category for expenditure
411: jai_pa_tax_pkg.get_expn_tax_category(

Line 411: jai_pa_tax_pkg.get_expn_tax_category(

407: exit when ln_process_status = jai_pa_tax_pkg.process_success ;
408: end if ;
409: if jai_constants.setup_expenditure_type = rec_context_prefernece.context then
410: -- tax category for expenditure
411: jai_pa_tax_pkg.get_expn_tax_category(
412: pn_project_id ,
413: pn_draft_invoice_num ,
414: pn_line_num ,
415: ln_tax_category_id ,

Line 423: exit when ln_process_status = jai_pa_tax_pkg.process_success ;

419: ) ;
420:
421: -- exit when tax category is found for expenditure
422: pn_tax_category_id := ln_tax_category_id ;
423: exit when ln_process_status = jai_pa_tax_pkg.process_success ;
424: end if ;
425: if jai_constants.setup_project = rec_context_prefernece.context then
426: -- tax category for projects
427: jai_pa_tax_pkg.get_project_tax_category(

Line 427: jai_pa_tax_pkg.get_project_tax_category(

423: exit when ln_process_status = jai_pa_tax_pkg.process_success ;
424: end if ;
425: if jai_constants.setup_project = rec_context_prefernece.context then
426: -- tax category for projects
427: jai_pa_tax_pkg.get_project_tax_category(
428: pn_project_id ,
429: pn_draft_invoice_num ,
430: pn_line_num ,
431: ln_tax_category_id ,

Line 439: exit when ln_process_status = jai_pa_tax_pkg.process_success ;

435: ) ;
436:
437: -- exit when tax category is found for projects
438: pn_tax_category_id := ln_tax_category_id ;
439: exit when ln_process_status = jai_pa_tax_pkg.process_success ;
440: end if ;
441:
442: if jai_constants.setup_customer_site = rec_context_prefernece.context then
443: -- tax category for customer/site or customer null site

Line 444: jai_pa_tax_pkg.get_cust_tax_category(

440: end if ;
441:
442: if jai_constants.setup_customer_site = rec_context_prefernece.context then
443: -- tax category for customer/site or customer null site
444: jai_pa_tax_pkg.get_cust_tax_category(
445: pn_project_id ,
446: pn_draft_invoice_num ,
447: pn_line_num ,
448: ln_tax_category_id ,

Line 455: exit when ln_process_status = jai_pa_tax_pkg.process_success ;

451: pv_process_flag
452: ) ;
453: -- exit when tax category is found for customer/site or customer null site .
454: pn_tax_category_id := ln_tax_category_id ;
455: exit when ln_process_status = jai_pa_tax_pkg.process_success ;
456: end if ;
457: end loop ;
458: pv_process_message := '';
459: pv_process_flag := jai_constants.successful;

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

506: attribute1 = ln_event_type_id ;
507:
508: begin
509: ----initialization part -----------------------------------------------------
510: pv_process_status := jai_pa_tax_pkg.process_fail; -- package global variable
511: pn_tax_category_id := null ;
512: ln_event_task_id := null ;
513: ln_event_num := null ;
514: ln_event_type := null ;

Line 524: pv_process_status := jai_pa_tax_pkg.process_fail;

520:
521: -- step1
522: -- if event_task_id and ln_evnet_num is found null then returns ........................
523: if ln_event_num is null then
524: pv_process_status := jai_pa_tax_pkg.process_fail;
525: pn_tax_category_id := null ;
526: return ;
527: end if ;
528:

Line 535: pv_process_status := jai_pa_tax_pkg.process_fail;

531: close cur_get_event_type ;
532:
533: -- if no event type it's found then returns
534: if ln_event_type is null then
535: pv_process_status := jai_pa_tax_pkg.process_fail;
536: pn_tax_category_id := null ;
537: return ;
538: end if ;
539:

Line 546: pv_process_status := jai_pa_tax_pkg.process_fail;

542: close cur_get_event_type_id ;
543:
544: -- if event_type_id is not presnet then returns
545: if ln_event_type_id is null then
546: pv_process_status := jai_pa_tax_pkg.process_fail;
547: pn_tax_category_id := null ;
548: return ;
549: end if ;
550:

Line 557: pv_process_status := jai_pa_tax_pkg.process_fail;

553: close cur_get_tax_category ;
554:
555: -- if tax_category_id is not presnet then returns
556: if ln_tax_category_id is null then
557: pv_process_status := jai_pa_tax_pkg.process_fail;
558: pn_tax_category_id := null ;
559: return ;
560: end if ;
561:

Line 563: pv_process_status := jai_pa_tax_pkg.process_success;

559: return ;
560: end if ;
561:
562: pn_tax_category_id := ln_tax_category_id ;
563: pv_process_status := jai_pa_tax_pkg.process_success;
564:
565: pv_process_message := '';
566: pv_process_flag := jai_constants.successful;
567:

Line 569: pv_process_status := jai_pa_tax_pkg.process_fail;

565: pv_process_message := '';
566: pv_process_flag := jai_constants.successful;
567:
568: exception when others then
569: pv_process_status := jai_pa_tax_pkg.process_fail;
570: pn_tax_category_id := null ;
571: pv_process_message := substr('get_event_tax_category='|| sqlerrm,1,1999);
572: pv_process_flag := jai_constants.unexpected_error;
573: end get_event_tax_category ;

Line 596: pv_process_status := jai_pa_tax_pkg.process_fail;

592: attribute1 = pn_project_id ;
593:
594: begin
595: ----initialization part -----------------------------------------------------
596: pv_process_status := jai_pa_tax_pkg.process_fail;
597: pn_tax_category_id := null ;
598: ln_tax_category_id := null ;
599: -----------------------------------------------------------------------------
600:

Line 606: pv_process_status := jai_pa_tax_pkg.process_fail;

602: fetch cur_get_project_all into ln_tax_category_id ;
603: close cur_get_project_all ;
604:
605: if ln_tax_category_id is null then
606: pv_process_status := jai_pa_tax_pkg.process_fail;
607: pn_tax_category_id := null ;
608: return ;
609: end if ;
610:

Line 612: pv_process_status := jai_pa_tax_pkg.process_success;

608: return ;
609: end if ;
610:
611: pn_tax_category_id := ln_tax_category_id ;
612: pv_process_status := jai_pa_tax_pkg.process_success;
613:
614: pv_process_message := '';
615: pv_process_flag := jai_constants.successful;
616:

Line 618: pv_process_status := jai_pa_tax_pkg.process_fail;

614: pv_process_message := '';
615: pv_process_flag := jai_constants.successful;
616:
617: exception when others then
618: pv_process_status := jai_pa_tax_pkg.process_fail;
619: pn_tax_category_id := null ;
620:
621: pv_process_message := substr('get_project_tax_category='|| sqlerrm,1,1999);
622: pv_process_flag := jai_constants.unexpected_error;

Line 656: pv_process_status := jai_pa_tax_pkg.process_fail;

652: context = jai_constants.setup_customer_site and
653: attribute2 is null ;
654: begin
655: ----initialization part -----------------------------------------------------
656: pv_process_status := jai_pa_tax_pkg.process_fail;
657: pn_tax_category_id := null ;
658: ln_tax_category_id := null ;
659: -----------------------------------------------------------------------------
660: -- responsible for getting customer info

Line 683: pv_process_status := jai_pa_tax_pkg.process_fail;

679: close cur_cust_tax ;
680: end if ;
681:
682: if ln_tax_category_id is null then
683: pv_process_status := jai_pa_tax_pkg.process_fail;
684: pn_tax_category_id := null ;
685: return ;
686: end if ;
687:

Line 690: pv_process_status := jai_pa_tax_pkg.process_success;

686: end if ;
687:
688: -- when process sucess in getting tax category----------------------------------------
689: pn_tax_category_id := ln_tax_category_id ;
690: pv_process_status := jai_pa_tax_pkg.process_success;
691: pv_process_message := '';
692: pv_process_flag := jai_constants.successful;
693: ---------------------------------------------------------------------------------------
694: exception when others then

Line 695: pv_process_status := jai_pa_tax_pkg.process_fail;

691: pv_process_message := '';
692: pv_process_flag := jai_constants.successful;
693: ---------------------------------------------------------------------------------------
694: exception when others then
695: pv_process_status := jai_pa_tax_pkg.process_fail;
696: pn_tax_category_id := null ;
697: pv_process_message := substr('get_event_tax_category='|| sqlerrm,1,1999);
698: pv_process_flag := jai_constants.unexpected_error;
699: end get_cust_tax_category;

Line 749: pv_process_status := jai_pa_tax_pkg.process_fail;

745: jpsv.attribute1 = pet.expenditure_type_id and
746: pet.expenditure_type =cv_expenditure_type ;
747: begin
748: ----initialization part -----------------------------------------------------
749: pv_process_status := jai_pa_tax_pkg.process_fail;
750: pn_tax_category_id := null ;
751: ln_tax_category_id := null ;
752: ln_count_expend_type := 0 ;
753: lv_expenditure_type := null ;

Line 762: pv_process_status := jai_pa_tax_pkg.process_fail;

758: close cur_count_expend_type ;
759:
760: -- if expenditure defined for draft invoice lines is greater than 1 then skip this one and continue with next preference
761: if nvl(ln_count_expend_type,0) = 0 or nvl(ln_count_expend_type,0) > 1 then
762: pv_process_status := jai_pa_tax_pkg.process_fail;
763: pn_tax_category_id := null ;
764: return ;
765: end if ;
766:

Line 777: pv_process_status := jai_pa_tax_pkg.process_fail;

773: close cur_expn_tax_category ;
774:
775: -- when process successful in getting tax category----------------------------------------
776: if ln_tax_category_id is null then
777: pv_process_status := jai_pa_tax_pkg.process_fail;
778: pn_tax_category_id := null ;
779: return ;
780: end if ;
781:

Line 783: pv_process_status := jai_pa_tax_pkg.process_success;

779: return ;
780: end if ;
781:
782: pn_tax_category_id := ln_tax_category_id ;
783: pv_process_status := jai_pa_tax_pkg.process_success;
784:
785: pv_process_message := '';
786: pv_process_flag := jai_constants.successful;
787: ---------------------------------------------------------------------------------------

Line 789: pv_process_status := jai_pa_tax_pkg.process_fail;

785: pv_process_message := '';
786: pv_process_flag := jai_constants.successful;
787: ---------------------------------------------------------------------------------------
788: exception when others then
789: pv_process_status := jai_pa_tax_pkg.process_fail;
790: pn_tax_category_id := null ;
791:
792: pv_process_message := substr('get_event_tax_category='|| sqlerrm,1,1999);
793: pv_process_flag := jai_constants.unexpected_error;

Line 1346: END jai_pa_tax_pkg ;

1342:
1343: end loop ;
1344: end tax_recalculate_line ;
1345:
1346: END jai_pa_tax_pkg ;