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.PA_IND_RATE_SCH_REVISIONS_PKG dependencies on PA_IND_RATE_SCH_REVISIONS

Line 1: package body PA_IND_RATE_SCH_REVISIONS_PKG as

1: package body PA_IND_RATE_SCH_REVISIONS_PKG as
2: -- $Header: PAXCIRRB.pls 120.2.12000000.12 2007/08/31 07:37:01 prabsing ship $
3: -----------------------------------------------------------------------------
4: procedure start_to_gl(x_return_status IN OUT NOCOPY number,
5: x_stage IN OUT NOCOPY number,

Line 81: x_max_start_date_active pa_ind_rate_sch_revisions.start_date_active%TYPE;

77: x_max_revision_id IN OUT NOCOPY number,
78: x_max_end_date_active IN OUT NOCOPY date)
79: is
80:
81: x_max_start_date_active pa_ind_rate_sch_revisions.start_date_active%TYPE;
82: x_dummy number;
83:
84: begin
85: x_return_status := 0;

Line 96: from pa_ind_rate_sch_revisions

92: end_date_active
93: into x_max_revision_id,
94: x_max_start_date_active,
95: x_max_end_date_active
96: from pa_ind_rate_sch_revisions
97: where ind_rate_sch_id = x_ind_rate_sch_id
98: and start_date_active in
99: (select max(start_date_active)
100: from pa_ind_rate_sch_revisions

Line 100: from pa_ind_rate_sch_revisions

96: from pa_ind_rate_sch_revisions
97: where ind_rate_sch_id = x_ind_rate_sch_id
98: and start_date_active in
99: (select max(start_date_active)
100: from pa_ind_rate_sch_revisions
101: where ind_rate_sch_id = x_ind_rate_sch_id);
102:
103: x_return_status := 0;
104:

Line 604: from pa_ind_rate_sch_revisions

600:
601: begin
602: select end_date_active
603: into x_end_date_active
604: from pa_ind_rate_sch_revisions
605: where ind_rate_sch_revision_id = x_ind_rate_sch_revision_id;
606:
607: if (x_end_date_active is null) then
608: begin

Line 615: from pa_ind_rate_sch_revisions

611: ind_rate_sch_revision_id
612: into x_prev_end_date_active,
613: x_prev_start_date_active,
614: x_prev_revision_id
615: from pa_ind_rate_sch_revisions
616: where ind_rate_sch_id = x_ind_rate_sch_id
617: and end_date_active in
618: (select max(end_date_active)
619: from pa_ind_rate_sch_revisions

Line 619: from pa_ind_rate_sch_revisions

615: from pa_ind_rate_sch_revisions
616: where ind_rate_sch_id = x_ind_rate_sch_id
617: and end_date_active in
618: (select max(end_date_active)
619: from pa_ind_rate_sch_revisions
620: where ind_rate_sch_id = x_ind_rate_sch_id);
621: end;
622: else
623: begin

Line 630: from pa_ind_rate_sch_revisions

626: ind_rate_sch_revision_id
627: into x_prev_end_date_active,
628: x_prev_start_date_active,
629: x_prev_revision_id
630: from pa_ind_rate_sch_revisions
631: where ind_rate_sch_id = x_ind_rate_sch_id
632: and end_date_active < x_end_date_active
633: and end_date_active in
634: (select max(end_date_active)

Line 635: from pa_ind_rate_sch_revisions

631: where ind_rate_sch_id = x_ind_rate_sch_id
632: and end_date_active < x_end_date_active
633: and end_date_active in
634: (select max(end_date_active)
635: from pa_ind_rate_sch_revisions
636: where ind_rate_sch_id = x_ind_rate_sch_id
637: and end_date_active < x_end_date_active);
638: end;
639: end if;

Line 661: pa_ind_rate_sch_revisions_pkg.check_references(x_return_status,

657: begin
658: -- Check that the previous revision that is to be changed is
659: -- not referenced in expenditure items. If it is , then the
660: -- change is not allowed.
661: pa_ind_rate_sch_revisions_pkg.check_references(x_return_status,
662: x_stage,
663: x_prev_revision_id);
664: if (x_return_status > 0) then
665: begin

Line 702: from pa_ind_rate_sch_revisions

698:
699: begin
700: select start_date_active
701: into x_start_date_active
702: from pa_ind_rate_sch_revisions
703: where ind_rate_sch_revision_id = x_ind_rate_sch_revision_id;
704:
705: select start_date_active,
706: end_date_active,

Line 711: from pa_ind_rate_sch_revisions

707: ind_rate_sch_revision_id
708: into x_next_start_date_active,
709: x_next_end_date_active,
710: x_next_revision_id
711: from pa_ind_rate_sch_revisions
712: where ind_rate_sch_id = x_ind_rate_sch_id
713: and start_date_active > x_start_date_active
714: and start_date_active in
715: (select min(start_date_active)

Line 716: from pa_ind_rate_sch_revisions

712: where ind_rate_sch_id = x_ind_rate_sch_id
713: and start_date_active > x_start_date_active
714: and start_date_active in
715: (select min(start_date_active)
716: from pa_ind_rate_sch_revisions
717: where ind_rate_sch_id = x_ind_rate_sch_id
718: and start_date_active > x_start_date_active);
719:
720: x_return_status := 0;

Line 740: pa_ind_rate_sch_revisions_pkg.check_references(x_return_status,

736: begin
737: -- Check that the next revision that is to be changed is
738: -- not referenced in expenditure items. If it is , then the
739: -- change is not allowed.
740: pa_ind_rate_sch_revisions_pkg.check_references(x_return_status,
741: x_stage,
742: x_next_revision_id);
743: if (x_return_status > 0) then
744: begin

Line 815: FROM pa_ind_rate_sch_revisions

811: x_return_status := 0;
812:
813: SELECT ready_to_compile_flag, compiled_flag
814: INTO x_ready_compile_flag, x_compiled_flag
815: FROM pa_ind_rate_sch_revisions
816: WHERE ind_rate_sch_revision_id = x_ind_rate_sch_revision_id;
817:
818: /***2933915 :This is to check if ready to compile multipliers are existing i.e if multipliers have changed*/
819: Begin

Line 839: end PA_IND_RATE_SCH_REVISIONS_PKG;

835:
836: end check_ready_compile;
837: -----------------------------------------------------------------------------
838:
839: end PA_IND_RATE_SCH_REVISIONS_PKG;