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.

[Home] [Help]

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: --start of changes for bug 12795442
15: TYPE t_of_number3 is table of
16: per_pay_proposal_components.change_amount%TYPE

Line 16: per_pay_proposal_components.change_amount%TYPE

12: per_pay_proposal_components.change_percentage%TYPE
13: index by binary_integer;
14: --start of changes for bug 12795442
15: TYPE t_of_number3 is table of
16: per_pay_proposal_components.change_amount%TYPE
17: index by binary_integer;
18: -- end of cahnges for bug 12795442
19: --
20: TYPE t_of_number is table of

Line 21: per_pay_proposal_components.component_id%TYPE

17: index by binary_integer;
18: -- end of cahnges for bug 12795442
19: --
20: TYPE t_of_number is table of
21: per_pay_proposal_components.component_id%TYPE
22: index by binary_integer;
23: --
24: TYPE t_of_char is table of
25: per_pay_proposal_components.component_reason%TYPE

Line 25: per_pay_proposal_components.component_reason%TYPE

21: per_pay_proposal_components.component_id%TYPE
22: index by binary_integer;
23: --
24: TYPE t_of_char is table of
25: per_pay_proposal_components.component_reason%TYPE
26: index by binary_integer;
27:
28: --------vkodedal 7-mar-07
29: -----------------------------------------------------------------------------

Line 732: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;

728: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;
729: l_pyp_object_version_number
730: per_pay_proposals.object_version_number%TYPE;
731: --
732: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;
733: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;
734: l_component_reason per_pay_proposal_components.component_reason%TYPE;
735: l_ppc_approved per_pay_proposal_components.approved%TYPE;
736: l_ppc_object_version_number

Line 733: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;

729: l_pyp_object_version_number
730: per_pay_proposals.object_version_number%TYPE;
731: --
732: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;
733: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;
734: l_component_reason per_pay_proposal_components.component_reason%TYPE;
735: l_ppc_approved per_pay_proposal_components.approved%TYPE;
736: l_ppc_object_version_number
737: per_pay_proposal_components.object_version_number%TYPE;

Line 734: l_component_reason per_pay_proposal_components.component_reason%TYPE;

730: per_pay_proposals.object_version_number%TYPE;
731: --
732: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;
733: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;
734: l_component_reason per_pay_proposal_components.component_reason%TYPE;
735: l_ppc_approved per_pay_proposal_components.approved%TYPE;
736: l_ppc_object_version_number
737: per_pay_proposal_components.object_version_number%TYPE;
738: --

Line 735: l_ppc_approved per_pay_proposal_components.approved%TYPE;

731: --
732: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;
733: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;
734: l_component_reason per_pay_proposal_components.component_reason%TYPE;
735: l_ppc_approved per_pay_proposal_components.approved%TYPE;
736: l_ppc_object_version_number
737: per_pay_proposal_components.object_version_number%TYPE;
738: --
739: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;

Line 737: per_pay_proposal_components.object_version_number%TYPE;

733: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;
734: l_component_reason per_pay_proposal_components.component_reason%TYPE;
735: l_ppc_approved per_pay_proposal_components.approved%TYPE;
736: l_ppc_object_version_number
737: per_pay_proposal_components.object_version_number%TYPE;
738: --
739: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;
740: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;
741: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;

Line 739: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;

735: l_ppc_approved per_pay_proposal_components.approved%TYPE;
736: l_ppc_object_version_number
737: per_pay_proposal_components.object_version_number%TYPE;
738: --
739: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;
740: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;
741: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;
742: l_approved_in per_pay_proposal_components.approved%TYPE;
743: l_object_version_number_in

Line 740: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;

736: l_ppc_object_version_number
737: per_pay_proposal_components.object_version_number%TYPE;
738: --
739: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;
740: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;
741: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;
742: l_approved_in per_pay_proposal_components.approved%TYPE;
743: l_object_version_number_in
744: per_pay_proposal_components.object_version_number%TYPE;

Line 741: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;

737: per_pay_proposal_components.object_version_number%TYPE;
738: --
739: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;
740: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;
741: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;
742: l_approved_in per_pay_proposal_components.approved%TYPE;
743: l_object_version_number_in
744: per_pay_proposal_components.object_version_number%TYPE;
745: l_component_id_in per_pay_proposal_components.component_id%TYPE;

Line 742: l_approved_in per_pay_proposal_components.approved%TYPE;

738: --
739: l_change_amount_in per_pay_proposal_components.change_amount_n%TYPE;
740: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;
741: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;
742: l_approved_in per_pay_proposal_components.approved%TYPE;
743: l_object_version_number_in
744: per_pay_proposal_components.object_version_number%TYPE;
745: l_component_id_in per_pay_proposal_components.component_id%TYPE;
746: l_component_sum number(20,6):=0;

Line 744: per_pay_proposal_components.object_version_number%TYPE;

740: l_change_percentage_in per_pay_proposal_components.change_percentage%TYPE;
741: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;
742: l_approved_in per_pay_proposal_components.approved%TYPE;
743: l_object_version_number_in
744: per_pay_proposal_components.object_version_number%TYPE;
745: l_component_id_in per_pay_proposal_components.component_id%TYPE;
746: l_component_sum number(20,6):=0;
747: l_total_component_sum number (20,6):=0;
748: l_comp_update boolean := false;

Line 745: l_component_id_in per_pay_proposal_components.component_id%TYPE;

741: l_component_reason_in per_pay_proposal_components.component_reason%TYPE;
742: l_approved_in per_pay_proposal_components.approved%TYPE;
743: l_object_version_number_in
744: per_pay_proposal_components.object_version_number%TYPE;
745: l_component_id_in per_pay_proposal_components.component_id%TYPE;
746: l_component_sum number(20,6):=0;
747: l_total_component_sum number (20,6):=0;
748: l_comp_update boolean := false;
749: l_prop_update boolean := false;

Line 756: l_component_id_1 per_pay_proposal_components.component_id%TYPE:=

752: p_pay_proposal_id;
753: l_pyp_ovn per_pay_proposals.object_version_number%TYPE:=
754: p_object_version_number;
755: --
756: l_component_id_1 per_pay_proposal_components.component_id%TYPE:=
757: p_component_id_1;
758: l_ppc_ovn_1 per_pay_proposal_components.object_version_number%TYPE:=
759: p_ppc_object_version_number_1;
760: --

Line 758: l_ppc_ovn_1 per_pay_proposal_components.object_version_number%TYPE:=

754: p_object_version_number;
755: --
756: l_component_id_1 per_pay_proposal_components.component_id%TYPE:=
757: p_component_id_1;
758: l_ppc_ovn_1 per_pay_proposal_components.object_version_number%TYPE:=
759: p_ppc_object_version_number_1;
760: --
761: l_component_id_2 per_pay_proposal_components.component_id%TYPE:=
762: p_component_id_2;

Line 761: l_component_id_2 per_pay_proposal_components.component_id%TYPE:=

757: p_component_id_1;
758: l_ppc_ovn_1 per_pay_proposal_components.object_version_number%TYPE:=
759: p_ppc_object_version_number_1;
760: --
761: l_component_id_2 per_pay_proposal_components.component_id%TYPE:=
762: p_component_id_2;
763: l_ppc_ovn_2 per_pay_proposal_components.object_version_number%TYPE:=
764: p_ppc_object_version_number_2;
765: --

Line 763: l_ppc_ovn_2 per_pay_proposal_components.object_version_number%TYPE:=

759: p_ppc_object_version_number_1;
760: --
761: l_component_id_2 per_pay_proposal_components.component_id%TYPE:=
762: p_component_id_2;
763: l_ppc_ovn_2 per_pay_proposal_components.object_version_number%TYPE:=
764: p_ppc_object_version_number_2;
765: --
766: l_component_id_3 per_pay_proposal_components.component_id%TYPE:=
767: p_component_id_3;

Line 766: l_component_id_3 per_pay_proposal_components.component_id%TYPE:=

762: p_component_id_2;
763: l_ppc_ovn_2 per_pay_proposal_components.object_version_number%TYPE:=
764: p_ppc_object_version_number_2;
765: --
766: l_component_id_3 per_pay_proposal_components.component_id%TYPE:=
767: p_component_id_3;
768: l_ppc_ovn_3 per_pay_proposal_components.object_version_number%TYPE:=
769: p_ppc_object_version_number_3;
770: --

Line 768: l_ppc_ovn_3 per_pay_proposal_components.object_version_number%TYPE:=

764: p_ppc_object_version_number_2;
765: --
766: l_component_id_3 per_pay_proposal_components.component_id%TYPE:=
767: p_component_id_3;
768: l_ppc_ovn_3 per_pay_proposal_components.object_version_number%TYPE:=
769: p_ppc_object_version_number_3;
770: --
771: l_component_id_4 per_pay_proposal_components.component_id%TYPE:=
772: p_component_id_4;

Line 771: l_component_id_4 per_pay_proposal_components.component_id%TYPE:=

767: p_component_id_3;
768: l_ppc_ovn_3 per_pay_proposal_components.object_version_number%TYPE:=
769: p_ppc_object_version_number_3;
770: --
771: l_component_id_4 per_pay_proposal_components.component_id%TYPE:=
772: p_component_id_4;
773: l_ppc_ovn_4 per_pay_proposal_components.object_version_number%TYPE:=
774: p_ppc_object_version_number_4;
775: --

Line 773: l_ppc_ovn_4 per_pay_proposal_components.object_version_number%TYPE:=

769: p_ppc_object_version_number_3;
770: --
771: l_component_id_4 per_pay_proposal_components.component_id%TYPE:=
772: p_component_id_4;
773: l_ppc_ovn_4 per_pay_proposal_components.object_version_number%TYPE:=
774: p_ppc_object_version_number_4;
775: --
776: l_component_id_5 per_pay_proposal_components.component_id%TYPE:=
777: p_component_id_5;

Line 776: l_component_id_5 per_pay_proposal_components.component_id%TYPE:=

772: p_component_id_4;
773: l_ppc_ovn_4 per_pay_proposal_components.object_version_number%TYPE:=
774: p_ppc_object_version_number_4;
775: --
776: l_component_id_5 per_pay_proposal_components.component_id%TYPE:=
777: p_component_id_5;
778: l_ppc_ovn_5 per_pay_proposal_components.object_version_number%TYPE:=
779: p_ppc_object_version_number_5;
780: --

Line 778: l_ppc_ovn_5 per_pay_proposal_components.object_version_number%TYPE:=

774: p_ppc_object_version_number_4;
775: --
776: l_component_id_5 per_pay_proposal_components.component_id%TYPE:=
777: p_component_id_5;
778: l_ppc_ovn_5 per_pay_proposal_components.object_version_number%TYPE:=
779: p_ppc_object_version_number_5;
780: --
781: l_component_id_6 per_pay_proposal_components.component_id%TYPE:=
782: p_component_id_6;

Line 781: l_component_id_6 per_pay_proposal_components.component_id%TYPE:=

777: p_component_id_5;
778: l_ppc_ovn_5 per_pay_proposal_components.object_version_number%TYPE:=
779: p_ppc_object_version_number_5;
780: --
781: l_component_id_6 per_pay_proposal_components.component_id%TYPE:=
782: p_component_id_6;
783: l_ppc_ovn_6 per_pay_proposal_components.object_version_number%TYPE:=
784: p_ppc_object_version_number_6;
785: --

Line 783: l_ppc_ovn_6 per_pay_proposal_components.object_version_number%TYPE:=

779: p_ppc_object_version_number_5;
780: --
781: l_component_id_6 per_pay_proposal_components.component_id%TYPE:=
782: p_component_id_6;
783: l_ppc_ovn_6 per_pay_proposal_components.object_version_number%TYPE:=
784: p_ppc_object_version_number_6;
785: --
786: l_component_id_7 per_pay_proposal_components.component_id%TYPE:=
787: p_component_id_7;

Line 786: l_component_id_7 per_pay_proposal_components.component_id%TYPE:=

782: p_component_id_6;
783: l_ppc_ovn_6 per_pay_proposal_components.object_version_number%TYPE:=
784: p_ppc_object_version_number_6;
785: --
786: l_component_id_7 per_pay_proposal_components.component_id%TYPE:=
787: p_component_id_7;
788: l_ppc_ovn_7 per_pay_proposal_components.object_version_number%TYPE:=
789: p_ppc_object_version_number_7;
790: --

Line 788: l_ppc_ovn_7 per_pay_proposal_components.object_version_number%TYPE:=

784: p_ppc_object_version_number_6;
785: --
786: l_component_id_7 per_pay_proposal_components.component_id%TYPE:=
787: p_component_id_7;
788: l_ppc_ovn_7 per_pay_proposal_components.object_version_number%TYPE:=
789: p_ppc_object_version_number_7;
790: --
791: l_component_id_8 per_pay_proposal_components.component_id%TYPE:=
792: p_component_id_8;

Line 791: l_component_id_8 per_pay_proposal_components.component_id%TYPE:=

787: p_component_id_7;
788: l_ppc_ovn_7 per_pay_proposal_components.object_version_number%TYPE:=
789: p_ppc_object_version_number_7;
790: --
791: l_component_id_8 per_pay_proposal_components.component_id%TYPE:=
792: p_component_id_8;
793: l_ppc_ovn_8 per_pay_proposal_components.object_version_number%TYPE:=
794: p_ppc_object_version_number_8;
795: --

Line 793: l_ppc_ovn_8 per_pay_proposal_components.object_version_number%TYPE:=

789: p_ppc_object_version_number_7;
790: --
791: l_component_id_8 per_pay_proposal_components.component_id%TYPE:=
792: p_component_id_8;
793: l_ppc_ovn_8 per_pay_proposal_components.object_version_number%TYPE:=
794: p_ppc_object_version_number_8;
795: --
796: l_component_id_9 per_pay_proposal_components.component_id%TYPE:=
797: p_component_id_9;

Line 796: l_component_id_9 per_pay_proposal_components.component_id%TYPE:=

792: p_component_id_8;
793: l_ppc_ovn_8 per_pay_proposal_components.object_version_number%TYPE:=
794: p_ppc_object_version_number_8;
795: --
796: l_component_id_9 per_pay_proposal_components.component_id%TYPE:=
797: p_component_id_9;
798: l_ppc_ovn_9 per_pay_proposal_components.object_version_number%TYPE:=
799: p_ppc_object_version_number_9;
800: --

Line 798: l_ppc_ovn_9 per_pay_proposal_components.object_version_number%TYPE:=

794: p_ppc_object_version_number_8;
795: --
796: l_component_id_9 per_pay_proposal_components.component_id%TYPE:=
797: p_component_id_9;
798: l_ppc_ovn_9 per_pay_proposal_components.object_version_number%TYPE:=
799: p_ppc_object_version_number_9;
800: --
801: l_component_id_10 per_pay_proposal_components.component_id%TYPE:=
802: p_component_id_10;

Line 801: l_component_id_10 per_pay_proposal_components.component_id%TYPE:=

797: p_component_id_9;
798: l_ppc_ovn_9 per_pay_proposal_components.object_version_number%TYPE:=
799: p_ppc_object_version_number_9;
800: --
801: l_component_id_10 per_pay_proposal_components.component_id%TYPE:=
802: p_component_id_10;
803: l_ppc_ovn_10 per_pay_proposal_components.object_version_number%TYPE:=
804: p_ppc_object_version_number_10;
805:

Line 803: l_ppc_ovn_10 per_pay_proposal_components.object_version_number%TYPE:=

799: p_ppc_object_version_number_9;
800: --
801: l_component_id_10 per_pay_proposal_components.component_id%TYPE:=
802: p_component_id_10;
803: l_ppc_ovn_10 per_pay_proposal_components.object_version_number%TYPE:=
804: p_ppc_object_version_number_10;
805:
806:
807: lt_pay_proposal_id number := p_pay_proposal_id;

Line 863: from per_pay_proposal_components

859: --
860: cursor csr_sum_of_components
861: (c_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE) is
862: select sum(change_amount_n)
863: from per_pay_proposal_components
864: where pay_proposal_id = c_pay_proposal_id;
865:
866: --
867: --

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

914: --
915: -- cursor to get the component details
916: --
917: cursor csr_get_component_detail
918: (c_component_id per_pay_proposal_components.component_id%TYPE) is
919: select component_reason,
920: change_amount_n,
921: change_percentage,
922: approved,

Line 924: from per_pay_proposal_components

920: change_amount_n,
921: change_percentage,
922: approved,
923: object_version_number
924: from per_pay_proposal_components
925: where component_id = c_component_id
926: and business_group_id = p_business_group_id;
927: --
928: -- changed by schowdhu for bug #7693247 16-jan-2009