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.HR_UPLOAD_PROPOSAL_API dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 12: per_pay_proposal_components.change_percentage%TYPE

8: --
9: -- define plsql table types
10: --
11: TYPE t_of_number2 is table of
12: per_pay_proposal_components.change_percentage%TYPE
13: index by binary_integer;
14: --
15: TYPE t_of_number is table of
16: per_pay_proposal_components.component_id%TYPE

Line 16: per_pay_proposal_components.component_id%TYPE

12: per_pay_proposal_components.change_percentage%TYPE
13: index by binary_integer;
14: --
15: TYPE t_of_number is table of
16: per_pay_proposal_components.component_id%TYPE
17: index by binary_integer;
18: --
19: TYPE t_of_char is table of
20: per_pay_proposal_components.component_reason%TYPE

Line 20: per_pay_proposal_components.component_reason%TYPE

16: per_pay_proposal_components.component_id%TYPE
17: index by binary_integer;
18: --
19: TYPE t_of_char is table of
20: per_pay_proposal_components.component_reason%TYPE
21: index by binary_integer;
22:
23: --------vkodedal 7-mar-07
24: -----------------------------------------------------------------------------

Line 704: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;

700: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;
701: l_pyp_object_version_number
702: per_pay_proposals.object_version_number%TYPE;
703: --
704: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;
705: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;
706: l_component_reason per_pay_proposal_components.component_reason%TYPE;
707: l_ppc_approved per_pay_proposal_components.approved%TYPE;
708: l_ppc_object_version_number

Line 705: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;

701: l_pyp_object_version_number
702: per_pay_proposals.object_version_number%TYPE;
703: --
704: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;
705: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;
706: l_component_reason per_pay_proposal_components.component_reason%TYPE;
707: l_ppc_approved per_pay_proposal_components.approved%TYPE;
708: l_ppc_object_version_number
709: per_pay_proposal_components.object_version_number%TYPE;

Line 706: l_component_reason per_pay_proposal_components.component_reason%TYPE;

702: per_pay_proposals.object_version_number%TYPE;
703: --
704: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;
705: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;
706: l_component_reason per_pay_proposal_components.component_reason%TYPE;
707: l_ppc_approved per_pay_proposal_components.approved%TYPE;
708: l_ppc_object_version_number
709: per_pay_proposal_components.object_version_number%TYPE;
710: --

Line 707: l_ppc_approved per_pay_proposal_components.approved%TYPE;

703: --
704: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;
705: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;
706: l_component_reason per_pay_proposal_components.component_reason%TYPE;
707: l_ppc_approved per_pay_proposal_components.approved%TYPE;
708: l_ppc_object_version_number
709: per_pay_proposal_components.object_version_number%TYPE;
710: --
711: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;

Line 709: per_pay_proposal_components.object_version_number%TYPE;

705: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;
706: l_component_reason per_pay_proposal_components.component_reason%TYPE;
707: l_ppc_approved per_pay_proposal_components.approved%TYPE;
708: l_ppc_object_version_number
709: per_pay_proposal_components.object_version_number%TYPE;
710: --
711: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;
712: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;
713: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;

Line 711: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;

707: l_ppc_approved per_pay_proposal_components.approved%TYPE;
708: l_ppc_object_version_number
709: per_pay_proposal_components.object_version_number%TYPE;
710: --
711: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;
712: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;
713: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;
714: l_approved_in per_pay_proposal_components.approved%TYPE;
715: l_object_version_number_in

Line 712: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;

708: l_ppc_object_version_number
709: per_pay_proposal_components.object_version_number%TYPE;
710: --
711: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;
712: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;
713: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;
714: l_approved_in per_pay_proposal_components.approved%TYPE;
715: l_object_version_number_in
716: per_pay_proposal_components.object_version_number%TYPE;

Line 713: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;

709: per_pay_proposal_components.object_version_number%TYPE;
710: --
711: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;
712: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;
713: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;
714: l_approved_in per_pay_proposal_components.approved%TYPE;
715: l_object_version_number_in
716: per_pay_proposal_components.object_version_number%TYPE;
717: l_component_id_in per_pay_proposal_components.component_id%TYPE;

Line 714: l_approved_in per_pay_proposal_components.approved%TYPE;

710: --
711: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;
712: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;
713: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;
714: l_approved_in per_pay_proposal_components.approved%TYPE;
715: l_object_version_number_in
716: per_pay_proposal_components.object_version_number%TYPE;
717: l_component_id_in per_pay_proposal_components.component_id%TYPE;
718: l_component_sum number(20,6):=0;

Line 716: per_pay_proposal_components.object_version_number%TYPE;

712: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;
713: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;
714: l_approved_in per_pay_proposal_components.approved%TYPE;
715: l_object_version_number_in
716: per_pay_proposal_components.object_version_number%TYPE;
717: l_component_id_in per_pay_proposal_components.component_id%TYPE;
718: l_component_sum number(20,6):=0;
719: l_total_component_sum number (20,6):=0;
720: l_comp_update boolean := false;

Line 717: l_component_id_in per_pay_proposal_components.component_id%TYPE;

713: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;
714: l_approved_in per_pay_proposal_components.approved%TYPE;
715: l_object_version_number_in
716: per_pay_proposal_components.object_version_number%TYPE;
717: l_component_id_in per_pay_proposal_components.component_id%TYPE;
718: l_component_sum number(20,6):=0;
719: l_total_component_sum number (20,6):=0;
720: l_comp_update boolean := false;
721: l_prop_update boolean := false;

Line 728: l_component_id_1 per_pay_proposal_components.component_id%TYPE:=

724: p_pay_proposal_id;
725: l_pyp_ovn per_pay_proposals.object_version_number%TYPE:=
726: p_object_version_number;
727: --
728: l_component_id_1 per_pay_proposal_components.component_id%TYPE:=
729: p_component_id_1;
730: l_ppc_ovn_1 per_pay_proposal_components.object_version_number%TYPE:=
731: p_ppc_object_version_number_1;
732: --

Line 730: l_ppc_ovn_1 per_pay_proposal_components.object_version_number%TYPE:=

726: p_object_version_number;
727: --
728: l_component_id_1 per_pay_proposal_components.component_id%TYPE:=
729: p_component_id_1;
730: l_ppc_ovn_1 per_pay_proposal_components.object_version_number%TYPE:=
731: p_ppc_object_version_number_1;
732: --
733: l_component_id_2 per_pay_proposal_components.component_id%TYPE:=
734: p_component_id_2;

Line 733: l_component_id_2 per_pay_proposal_components.component_id%TYPE:=

729: p_component_id_1;
730: l_ppc_ovn_1 per_pay_proposal_components.object_version_number%TYPE:=
731: p_ppc_object_version_number_1;
732: --
733: l_component_id_2 per_pay_proposal_components.component_id%TYPE:=
734: p_component_id_2;
735: l_ppc_ovn_2 per_pay_proposal_components.object_version_number%TYPE:=
736: p_ppc_object_version_number_2;
737: --

Line 735: l_ppc_ovn_2 per_pay_proposal_components.object_version_number%TYPE:=

731: p_ppc_object_version_number_1;
732: --
733: l_component_id_2 per_pay_proposal_components.component_id%TYPE:=
734: p_component_id_2;
735: l_ppc_ovn_2 per_pay_proposal_components.object_version_number%TYPE:=
736: p_ppc_object_version_number_2;
737: --
738: l_component_id_3 per_pay_proposal_components.component_id%TYPE:=
739: p_component_id_3;

Line 738: l_component_id_3 per_pay_proposal_components.component_id%TYPE:=

734: p_component_id_2;
735: l_ppc_ovn_2 per_pay_proposal_components.object_version_number%TYPE:=
736: p_ppc_object_version_number_2;
737: --
738: l_component_id_3 per_pay_proposal_components.component_id%TYPE:=
739: p_component_id_3;
740: l_ppc_ovn_3 per_pay_proposal_components.object_version_number%TYPE:=
741: p_ppc_object_version_number_3;
742: --

Line 740: l_ppc_ovn_3 per_pay_proposal_components.object_version_number%TYPE:=

736: p_ppc_object_version_number_2;
737: --
738: l_component_id_3 per_pay_proposal_components.component_id%TYPE:=
739: p_component_id_3;
740: l_ppc_ovn_3 per_pay_proposal_components.object_version_number%TYPE:=
741: p_ppc_object_version_number_3;
742: --
743: l_component_id_4 per_pay_proposal_components.component_id%TYPE:=
744: p_component_id_4;

Line 743: l_component_id_4 per_pay_proposal_components.component_id%TYPE:=

739: p_component_id_3;
740: l_ppc_ovn_3 per_pay_proposal_components.object_version_number%TYPE:=
741: p_ppc_object_version_number_3;
742: --
743: l_component_id_4 per_pay_proposal_components.component_id%TYPE:=
744: p_component_id_4;
745: l_ppc_ovn_4 per_pay_proposal_components.object_version_number%TYPE:=
746: p_ppc_object_version_number_4;
747: --

Line 745: l_ppc_ovn_4 per_pay_proposal_components.object_version_number%TYPE:=

741: p_ppc_object_version_number_3;
742: --
743: l_component_id_4 per_pay_proposal_components.component_id%TYPE:=
744: p_component_id_4;
745: l_ppc_ovn_4 per_pay_proposal_components.object_version_number%TYPE:=
746: p_ppc_object_version_number_4;
747: --
748: l_component_id_5 per_pay_proposal_components.component_id%TYPE:=
749: p_component_id_5;

Line 748: l_component_id_5 per_pay_proposal_components.component_id%TYPE:=

744: p_component_id_4;
745: l_ppc_ovn_4 per_pay_proposal_components.object_version_number%TYPE:=
746: p_ppc_object_version_number_4;
747: --
748: l_component_id_5 per_pay_proposal_components.component_id%TYPE:=
749: p_component_id_5;
750: l_ppc_ovn_5 per_pay_proposal_components.object_version_number%TYPE:=
751: p_ppc_object_version_number_5;
752: --

Line 750: l_ppc_ovn_5 per_pay_proposal_components.object_version_number%TYPE:=

746: p_ppc_object_version_number_4;
747: --
748: l_component_id_5 per_pay_proposal_components.component_id%TYPE:=
749: p_component_id_5;
750: l_ppc_ovn_5 per_pay_proposal_components.object_version_number%TYPE:=
751: p_ppc_object_version_number_5;
752: --
753: l_component_id_6 per_pay_proposal_components.component_id%TYPE:=
754: p_component_id_6;

Line 753: l_component_id_6 per_pay_proposal_components.component_id%TYPE:=

749: p_component_id_5;
750: l_ppc_ovn_5 per_pay_proposal_components.object_version_number%TYPE:=
751: p_ppc_object_version_number_5;
752: --
753: l_component_id_6 per_pay_proposal_components.component_id%TYPE:=
754: p_component_id_6;
755: l_ppc_ovn_6 per_pay_proposal_components.object_version_number%TYPE:=
756: p_ppc_object_version_number_6;
757: --

Line 755: l_ppc_ovn_6 per_pay_proposal_components.object_version_number%TYPE:=

751: p_ppc_object_version_number_5;
752: --
753: l_component_id_6 per_pay_proposal_components.component_id%TYPE:=
754: p_component_id_6;
755: l_ppc_ovn_6 per_pay_proposal_components.object_version_number%TYPE:=
756: p_ppc_object_version_number_6;
757: --
758: l_component_id_7 per_pay_proposal_components.component_id%TYPE:=
759: p_component_id_7;

Line 758: l_component_id_7 per_pay_proposal_components.component_id%TYPE:=

754: p_component_id_6;
755: l_ppc_ovn_6 per_pay_proposal_components.object_version_number%TYPE:=
756: p_ppc_object_version_number_6;
757: --
758: l_component_id_7 per_pay_proposal_components.component_id%TYPE:=
759: p_component_id_7;
760: l_ppc_ovn_7 per_pay_proposal_components.object_version_number%TYPE:=
761: p_ppc_object_version_number_7;
762: --

Line 760: l_ppc_ovn_7 per_pay_proposal_components.object_version_number%TYPE:=

756: p_ppc_object_version_number_6;
757: --
758: l_component_id_7 per_pay_proposal_components.component_id%TYPE:=
759: p_component_id_7;
760: l_ppc_ovn_7 per_pay_proposal_components.object_version_number%TYPE:=
761: p_ppc_object_version_number_7;
762: --
763: l_component_id_8 per_pay_proposal_components.component_id%TYPE:=
764: p_component_id_8;

Line 763: l_component_id_8 per_pay_proposal_components.component_id%TYPE:=

759: p_component_id_7;
760: l_ppc_ovn_7 per_pay_proposal_components.object_version_number%TYPE:=
761: p_ppc_object_version_number_7;
762: --
763: l_component_id_8 per_pay_proposal_components.component_id%TYPE:=
764: p_component_id_8;
765: l_ppc_ovn_8 per_pay_proposal_components.object_version_number%TYPE:=
766: p_ppc_object_version_number_8;
767: --

Line 765: l_ppc_ovn_8 per_pay_proposal_components.object_version_number%TYPE:=

761: p_ppc_object_version_number_7;
762: --
763: l_component_id_8 per_pay_proposal_components.component_id%TYPE:=
764: p_component_id_8;
765: l_ppc_ovn_8 per_pay_proposal_components.object_version_number%TYPE:=
766: p_ppc_object_version_number_8;
767: --
768: l_component_id_9 per_pay_proposal_components.component_id%TYPE:=
769: p_component_id_9;

Line 768: l_component_id_9 per_pay_proposal_components.component_id%TYPE:=

764: p_component_id_8;
765: l_ppc_ovn_8 per_pay_proposal_components.object_version_number%TYPE:=
766: p_ppc_object_version_number_8;
767: --
768: l_component_id_9 per_pay_proposal_components.component_id%TYPE:=
769: p_component_id_9;
770: l_ppc_ovn_9 per_pay_proposal_components.object_version_number%TYPE:=
771: p_ppc_object_version_number_9;
772: --

Line 770: l_ppc_ovn_9 per_pay_proposal_components.object_version_number%TYPE:=

766: p_ppc_object_version_number_8;
767: --
768: l_component_id_9 per_pay_proposal_components.component_id%TYPE:=
769: p_component_id_9;
770: l_ppc_ovn_9 per_pay_proposal_components.object_version_number%TYPE:=
771: p_ppc_object_version_number_9;
772: --
773: l_component_id_10 per_pay_proposal_components.component_id%TYPE:=
774: p_component_id_10;

Line 773: l_component_id_10 per_pay_proposal_components.component_id%TYPE:=

769: p_component_id_9;
770: l_ppc_ovn_9 per_pay_proposal_components.object_version_number%TYPE:=
771: p_ppc_object_version_number_9;
772: --
773: l_component_id_10 per_pay_proposal_components.component_id%TYPE:=
774: p_component_id_10;
775: l_ppc_ovn_10 per_pay_proposal_components.object_version_number%TYPE:=
776: p_ppc_object_version_number_10;
777:

Line 775: l_ppc_ovn_10 per_pay_proposal_components.object_version_number%TYPE:=

771: p_ppc_object_version_number_9;
772: --
773: l_component_id_10 per_pay_proposal_components.component_id%TYPE:=
774: p_component_id_10;
775: l_ppc_ovn_10 per_pay_proposal_components.object_version_number%TYPE:=
776: p_ppc_object_version_number_10;
777:
778:
779: lt_pay_proposal_id number := p_pay_proposal_id;

Line 833: from per_pay_proposal_components

829: --
830: cursor csr_sum_of_components
831: (c_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE) is
832: select sum(change_amount_n)
833: from per_pay_proposal_components
834: where pay_proposal_id = c_pay_proposal_id;
835:
836: --
837: --

Line 888: (c_component_id per_pay_proposal_components.component_id%TYPE) is

884: --
885: -- cursor to get the component details
886: --
887: cursor csr_get_component_detail
888: (c_component_id per_pay_proposal_components.component_id%TYPE) is
889: select component_reason,
890: change_amount_n,
891: change_percentage,
892: approved,

Line 894: from per_pay_proposal_components

890: change_amount_n,
891: change_percentage,
892: approved,
893: object_version_number
894: from per_pay_proposal_components
895: where component_id = c_component_id
896: and business_group_id = p_business_group_id;
897: --
898: -- changed by schowdhu for bug #7693247 16-jan-2009