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.IGW_REPORT_PROCESSING dependencies on IGW_REPORT_BUDGET

Line 26: from igw_report_budget_seed

22: x_category VARCHAR2(80);
23: Begin
24: select distinct proposal_budget_category
25: into x_category
26: from igw_report_budget_seed
27: where proposal_form_number = p_proposal_form_number
28: and proposal_budget_category_code = p_category_code;
29:
30: RETURN x_category;

Line 46: from igw_report_budget

42:
43:
44: select period_total_direct_cost
45: into l_period_total
46: from igw_report_budget
47: where proposal_budget_category_code = p_budget_category_code
48: and proposal_form_number = G_PROPOSAL_FORM_NUMBER
49: and proposal_id = G_PROPOSAL_ID
50: and version_id = l_version_id

Line 120: from igw_report_budget_seed

116: cursor c_budget_category is
117: select distinct proposal_budget_category
118: , budget_category_code
119: , details_required_flag
120: from igw_report_budget_seed
121: where proposal_form_number = p_proposal_form_number
122: and budget_category_code NOT IN ('84','SB');
123:
124: cursor c_itemized_budget is

Line 404: delete from igw_report_budget_base_rate

400: fnd_msg_pub.initialize;
401: l_version_id := get_final_version(p_proposal_id);
402:
403: --deleting previously precessed data
404: delete from igw_report_budget_base_rate
405: where p_proposal_form_number = p_proposal_form_number
406: and proposal_id = p_proposal_id
407: and version_id = l_version_id;
408:

Line 448: insert into igw_report_budget_base_rate(proposal_id

444: if l_fiscal_end_date < rec_no_of_periods.end_date then
445: l_fiscal_year := null;
446: end if;
447:
448: insert into igw_report_budget_base_rate(proposal_id
449: ,version_id
450: ,budget_period_id
451: ,base_amount
452: ,rate_applied

Line 483: from igw_report_budget_base_rate

479: , avg(base_amount)
480: into l_version_id
481: , l_rate_applied
482: , l_base_amount
483: from igw_report_budget_base_rate
484: where proposal_id = p_proposal_id
485: and proposal_form_number = p_proposal_form_number
486: group by proposal_id, version_id;
487:

Line 488: insert into igw_report_budget_base_rate(proposal_id

484: where proposal_id = p_proposal_id
485: and proposal_form_number = p_proposal_form_number
486: group by proposal_id, version_id;
487:
488: insert into igw_report_budget_base_rate(proposal_id
489: ,version_id
490: ,budget_period_id
491: ,base_amount
492: ,rate_applied

Line 534: /* Logic: First of all put all the lowest categories in igw_report_budget fetching

530:
531:
532: --------------------------------------------------------------------------------------------------
533:
534: /* Logic: First of all put all the lowest categories in igw_report_budget fetching
535: their corresponding data from the database by the setting the recently updated flag to 'Y'.
536: Then find their parent categories in the seed table and insert them into the above table
537: ( if parent category alrady exists then update it instead of inserting). Repeat the
538: process till the loop */

Line 554: from igw_report_budget_seed irs

550:
551:
552: cursor c_lowest_category is
553: select irs.budget_category_code
554: from igw_report_budget_seed irs
555: where irs.proposal_form_number = p_proposal_form_number
556: and irs.budget_category_code not in
557: (select distinct IR.proposal_budget_category_code
558: from igw_report_budget_seed IR

Line 558: from igw_report_budget_seed IR

554: from igw_report_budget_seed irs
555: where irs.proposal_form_number = p_proposal_form_number
556: and irs.budget_category_code not in
557: (select distinct IR.proposal_budget_category_code
558: from igw_report_budget_seed IR
559: where IR.proposal_form_number = p_proposal_form_number);
560:
561: cursor c_parent_category is
562: select distinct proposal_budget_category_code

Line 563: from igw_report_budget_seed

559: where IR.proposal_form_number = p_proposal_form_number);
560:
561: cursor c_parent_category is
562: select distinct proposal_budget_category_code
563: from igw_report_budget_seed
564: where proposal_form_number = p_proposal_form_number
565: and budget_category_code IN (
566: select proposal_budget_category_code
567: from igw_report_budget

Line 567: from igw_report_budget

563: from igw_report_budget_seed
564: where proposal_form_number = p_proposal_form_number
565: and budget_category_code IN (
566: select proposal_budget_category_code
567: from igw_report_budget
568: where proposal_form_number = p_proposal_form_number
569: and proposal_id = p_proposal_id
570: and recently_updated_flag = 'Y');
571:

Line 610: delete from igw_report_budget

606:
607: --dbms_output.put_line('before role selection'||l_post_award_exists);
608:
609: --deleting previously precessed data
610: delete from igw_report_budget
611: where p_proposal_form_number = p_proposal_form_number
612: and proposal_id = p_proposal_id
613: and version_id = l_version_id;
614:

Line 643: from igw_report_budget_seed

639: begin
640: l_budget_category := null;
641: select proposal_budget_category
642: into l_budget_category
643: from igw_report_budget_seed
644: where proposal_form_number = p_proposal_form_number
645: and budget_category_code = rec_lowest_category.budget_category_code;
646: exception
647: when no_data_found then

Line 659: insert into igw_report_budget(

655: when no_data_found then null;
656: end;
657: end;
658:
659: insert into igw_report_budget(
660: proposal_id
661: ,version_id
662: ,budget_period_id
663: ,proposal_budget_category

Line 680: --,igw_report_budget_seed_s.nextval

676: ,rec_lowest_category.budget_category_code
677: ,l_period_direct_cost_amt
678: ,l_period_eb_amt
679: ,p_proposal_form_number
680: --,igw_report_budget_seed_s.nextval
681: ,'Y');
682:
683: <>
684: l_period_direct_cost_amt := null;

Line 700: from igw_report_budget_seed

696: l_parent_exists := null;
697: begin
698: select '1'
699: into l_parent_exists
700: from igw_report_budget_seed
701: where budget_category_code = rec_parent_category.proposal_budget_category_code
702: and rownum < 2;
703: exception
704: when no_data_found then null;

Line 730: from igw_report_budget

726: select sum(nvl(period_total_direct_cost,0))
727: , sum(nvl(eb_total,0))
728: into l_period_direct_cost_amt1
729: , l_period_eb_amt1
730: from igw_report_budget
731: where proposal_id = p_proposal_id
732: and version_id = l_version_id
733: and budget_period_id = rec_budget_period.budget_period_id
734: and proposal_form_number = p_proposal_form_number

Line 737: from igw_report_budget_seed

733: and budget_period_id = rec_budget_period.budget_period_id
734: and proposal_form_number = p_proposal_form_number
735: and proposal_budget_category_code IN (
736: select budget_category_code
737: from igw_report_budget_seed
738: where proposal_form_number = p_proposal_form_number
739: and proposal_budget_category_code = rec_parent_category.proposal_budget_category_code)
740: group by proposal_id, version_id, budget_period_id;
741:

Line 758: from igw_report_budget_seed

754: begin
755: l_budget_category := null;
756: select proposal_budget_category
757: into l_budget_category
758: from igw_report_budget_seed
759: where proposal_form_number = p_proposal_form_number
760: and budget_category_code = rec_parent_category.proposal_budget_category_code;
761: exception
762: when no_data_found then

Line 776: update igw_report_budget

772: end;
773:
774: begin
775: l_found := null;
776: update igw_report_budget
777: set period_total_direct_cost = l_period_direct_cost_amt
778: , eb_total = l_period_eb_amt
779: where proposal_form_number = p_proposal_form_number
780: and proposal_id = p_proposal_id

Line 792: insert into igw_report_budget(

788: end if;
789: end;
790:
791: if l_found is null then
792: insert into igw_report_budget(
793: proposal_id
794: ,version_id
795: ,budget_period_id
796: ,proposal_budget_category

Line 815: update igw_report_budget

811: ,p_proposal_form_number
812: ,'Y');
813: end if;
814:
815: update igw_report_budget
816: set recently_updated_flag = 'N'
817: where proposal_form_number = p_proposal_form_number
818: and proposal_id = p_proposal_id
819: and proposal_budget_category_code IN (

Line 821: from igw_report_budget_seed

817: where proposal_form_number = p_proposal_form_number
818: and proposal_id = p_proposal_id
819: and proposal_budget_category_code IN (
820: select budget_category_code
821: from igw_report_budget_seed
822: where proposal_form_number = p_proposal_form_number
823: and proposal_budget_category_code = rec_parent_category.proposal_budget_category_code);
824:
825: if l_found = 1 then

Line 826: update igw_report_budget

822: where proposal_form_number = p_proposal_form_number
823: and proposal_budget_category_code = rec_parent_category.proposal_budget_category_code);
824:
825: if l_found = 1 then
826: update igw_report_budget
827: set recently_updated_flag = 'Y'
828: where proposal_form_number = p_proposal_form_number
829: and proposal_id = p_proposal_id
830: and proposal_budget_category_code = rec_parent_category.proposal_budget_category_code;

Line 864: from igw_report_budget_seed

860: from igw_budget_category_v
861: where budget_category_code NOT IN
862: (
863: select budget_category_code
864: from igw_report_budget_seed
865: where proposal_form_number = p_proposal_form_number)
866: and proposal_id = p_proposal_id
867: and version_id = l_version_id
868: and budget_period_id = rec_budget_period.budget_period_id

Line 877: update igw_report_budget

873:
874: end;
875:
876:
877: update igw_report_budget
878: set period_total_direct_cost = l_period_direct_cost_amt
879: , eb_total = l_period_eb_amt
880: where proposal_form_number = p_proposal_form_number
881: and proposal_id = p_proposal_id

Line 923: from igw_report_budget_seed

919: cursor c_budget_category is
920: select proposal_budget_category
921: , budget_category_code
922: , details_required_flag
923: from igw_report_budget_seed
924: where proposal_form_number = p_proposal_form_number
925: and details_required_flag = 'Y';
926:
927: cursor c_itemized_budget is