DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_ELEMENT_ENTRY dependencies on HR_PUMP_GET

Line 415: hr_pump_get.gl(l.pval005,'ELE_ENTRY_REASON',d(l.pval002),l.pval087)) p5,

411: l.pval003 d3,
412: decode(l.pval004,cn,vn,vn,vh,l.pval004) p4,
413: l.pval004 d4,
414: decode(l.pval005,cn,vn,vn,vh,
415: hr_pump_get.gl(l.pval005,'ELE_ENTRY_REASON',d(l.pval002),l.pval087)) p5,
416: l.pval005 d5,
417: decode(l.pval006,cn,nn,vn,nh,n(l.pval006)) p6,
418: l.pval006 d6,
419: decode(l.pval007,cn,dn,vn,dh,d(l.pval007)) p7,

Line 651: hr_pump_get.get_element_entry_id

647: if c.p79 is null then
648: L_ELEMENT_ENTRY_ID:=nn;
649: else
650: L_ELEMENT_ENTRY_ID :=
651: hr_pump_get.get_element_entry_id
652: (P_ELEMENT_ENTRY_USER_KEY => c.p79);
653: end if;
654: --
655: if c.p79 is null or

Line 660: hr_pump_get.GET_ELEMENT_ENTRY_OVN

656: c.p2 is null then
657: L_OBJECT_VERSION_NUMBER:=nn;
658: else
659: L_OBJECT_VERSION_NUMBER :=
660: hr_pump_get.GET_ELEMENT_ENTRY_OVN
661: (P_ELEMENT_ENTRY_USER_KEY => c.p79
662: ,P_EFFECTIVE_DATE => c.p2);
663: end if;
664: --

Line 671: hr_pump_get.get_cost_allocation_keyflex_id

667: elsif c.d80 is null then
668: L_COST_ALLOCATION_KEYFLEX_ID:=nh;
669: else
670: L_COST_ALLOCATION_KEYFLEX_ID :=
671: hr_pump_get.get_cost_allocation_keyflex_id
672: (P_COST_ALLOC_KEYFLEX_USER_KEY => c.p80);
673: end if;
674: --
675: if c.d81=cn then

Line 681: hr_pump_get.get_updating_action_id

677: elsif c.d81 is null then
678: L_UPDATING_ACTION_ID:=nh;
679: else
680: L_UPDATING_ACTION_ID :=
681: hr_pump_get.get_updating_action_id
682: (P_UPDATING_ACTION_USER_KEY => c.p81);
683: end if;
684: --
685: if c.d82=cn then

Line 691: hr_pump_get.get_original_entry_id

687: elsif c.d82 is null then
688: L_ORIGINAL_ENTRY_ID:=nh;
689: else
690: L_ORIGINAL_ENTRY_ID :=
691: hr_pump_get.get_original_entry_id
692: (P_ORIGINAL_ENTRY_USER_KEY => c.p82);
693: end if;
694: --
695: if c.d83=cn then

Line 701: hr_pump_get.get_comment_id

697: elsif c.d83 is null then
698: L_COMMENT_ID:=nh;
699: else
700: L_COMMENT_ID :=
701: hr_pump_get.get_comment_id
702: (P_COMMENT_USER_KEY => c.p83);
703: end if;
704: --
705: L_CREATOR_ID :=

Line 706: hr_pump_get.get_creator_id;

702: (P_COMMENT_USER_KEY => c.p83);
703: end if;
704: --
705: L_CREATOR_ID :=
706: hr_pump_get.get_creator_id;
707: --
708: if c.d84=cn then
709: L_PERSONAL_PAYMENT_METHOD_ID:=nn;
710: elsif c.d84 is null then

Line 714: hr_pump_get.get_personal_payment_method_id

710: elsif c.d84 is null then
711: L_PERSONAL_PAYMENT_METHOD_ID:=nh;
712: else
713: L_PERSONAL_PAYMENT_METHOD_ID :=
714: hr_pump_get.get_personal_payment_method_id
715: (P_PERSONAL_PAY_METHOD_USER_KEY => c.p84);
716: end if;
717: --
718: if c.d85 is null or

Line 728: hr_pump_get.GET_INPUT_VALUE_ID1

724: c.d87=cn then
725: L_INPUT_VALUE_ID1:=nn;
726: else
727: L_INPUT_VALUE_ID1 :=
728: hr_pump_get.GET_INPUT_VALUE_ID1
729: (P_INPUT_VALUE_NAME1 => c.p85
730: ,P_ELEMENT_NAME => c.p86
731: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
732: ,P_EFFECTIVE_DATE => c.p2

Line 746: hr_pump_get.GET_INPUT_VALUE_ID2

742: c.d87=cn then
743: L_INPUT_VALUE_ID2:=nn;
744: else
745: L_INPUT_VALUE_ID2 :=
746: hr_pump_get.GET_INPUT_VALUE_ID2
747: (P_INPUT_VALUE_NAME2 => c.p88
748: ,P_ELEMENT_NAME => c.p86
749: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
750: ,P_EFFECTIVE_DATE => c.p2

Line 764: hr_pump_get.GET_INPUT_VALUE_ID3

760: c.d87=cn then
761: L_INPUT_VALUE_ID3:=nn;
762: else
763: L_INPUT_VALUE_ID3 :=
764: hr_pump_get.GET_INPUT_VALUE_ID3
765: (P_INPUT_VALUE_NAME3 => c.p89
766: ,P_ELEMENT_NAME => c.p86
767: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
768: ,P_EFFECTIVE_DATE => c.p2

Line 782: hr_pump_get.GET_INPUT_VALUE_ID4

778: c.d87=cn then
779: L_INPUT_VALUE_ID4:=nn;
780: else
781: L_INPUT_VALUE_ID4 :=
782: hr_pump_get.GET_INPUT_VALUE_ID4
783: (P_INPUT_VALUE_NAME4 => c.p90
784: ,P_ELEMENT_NAME => c.p86
785: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
786: ,P_EFFECTIVE_DATE => c.p2

Line 800: hr_pump_get.GET_INPUT_VALUE_ID5

796: c.d87=cn then
797: L_INPUT_VALUE_ID5:=nn;
798: else
799: L_INPUT_VALUE_ID5 :=
800: hr_pump_get.GET_INPUT_VALUE_ID5
801: (P_INPUT_VALUE_NAME5 => c.p91
802: ,P_ELEMENT_NAME => c.p86
803: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
804: ,P_EFFECTIVE_DATE => c.p2

Line 818: hr_pump_get.GET_INPUT_VALUE_ID6

814: c.d87=cn then
815: L_INPUT_VALUE_ID6:=nn;
816: else
817: L_INPUT_VALUE_ID6 :=
818: hr_pump_get.GET_INPUT_VALUE_ID6
819: (P_INPUT_VALUE_NAME6 => c.p92
820: ,P_ELEMENT_NAME => c.p86
821: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
822: ,P_EFFECTIVE_DATE => c.p2

Line 836: hr_pump_get.GET_INPUT_VALUE_ID7

832: c.d87=cn then
833: L_INPUT_VALUE_ID7:=nn;
834: else
835: L_INPUT_VALUE_ID7 :=
836: hr_pump_get.GET_INPUT_VALUE_ID7
837: (P_INPUT_VALUE_NAME7 => c.p93
838: ,P_ELEMENT_NAME => c.p86
839: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
840: ,P_EFFECTIVE_DATE => c.p2

Line 854: hr_pump_get.GET_INPUT_VALUE_ID8

850: c.d87=cn then
851: L_INPUT_VALUE_ID8:=nn;
852: else
853: L_INPUT_VALUE_ID8 :=
854: hr_pump_get.GET_INPUT_VALUE_ID8
855: (P_INPUT_VALUE_NAME8 => c.p94
856: ,P_ELEMENT_NAME => c.p86
857: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
858: ,P_EFFECTIVE_DATE => c.p2

Line 872: hr_pump_get.GET_INPUT_VALUE_ID9

868: c.d87=cn then
869: L_INPUT_VALUE_ID9:=nn;
870: else
871: L_INPUT_VALUE_ID9 :=
872: hr_pump_get.GET_INPUT_VALUE_ID9
873: (P_INPUT_VALUE_NAME9 => c.p95
874: ,P_ELEMENT_NAME => c.p86
875: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
876: ,P_EFFECTIVE_DATE => c.p2

Line 890: hr_pump_get.GET_INPUT_VALUE_ID10

886: c.d87=cn then
887: L_INPUT_VALUE_ID10:=nn;
888: else
889: L_INPUT_VALUE_ID10 :=
890: hr_pump_get.GET_INPUT_VALUE_ID10
891: (P_INPUT_VALUE_NAME10 => c.p96
892: ,P_ELEMENT_NAME => c.p86
893: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
894: ,P_EFFECTIVE_DATE => c.p2

Line 908: hr_pump_get.GET_INPUT_VALUE_ID11

904: c.d87=cn then
905: L_INPUT_VALUE_ID11:=nn;
906: else
907: L_INPUT_VALUE_ID11 :=
908: hr_pump_get.GET_INPUT_VALUE_ID11
909: (P_INPUT_VALUE_NAME11 => c.p97
910: ,P_ELEMENT_NAME => c.p86
911: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
912: ,P_EFFECTIVE_DATE => c.p2

Line 926: hr_pump_get.GET_INPUT_VALUE_ID12

922: c.d87=cn then
923: L_INPUT_VALUE_ID12:=nn;
924: else
925: L_INPUT_VALUE_ID12 :=
926: hr_pump_get.GET_INPUT_VALUE_ID12
927: (P_INPUT_VALUE_NAME12 => c.p98
928: ,P_ELEMENT_NAME => c.p86
929: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
930: ,P_EFFECTIVE_DATE => c.p2

Line 944: hr_pump_get.GET_INPUT_VALUE_ID13

940: c.d87=cn then
941: L_INPUT_VALUE_ID13:=nn;
942: else
943: L_INPUT_VALUE_ID13 :=
944: hr_pump_get.GET_INPUT_VALUE_ID13
945: (P_INPUT_VALUE_NAME13 => c.p99
946: ,P_ELEMENT_NAME => c.p86
947: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
948: ,P_EFFECTIVE_DATE => c.p2

Line 962: hr_pump_get.GET_INPUT_VALUE_ID14

958: c.d87=cn then
959: L_INPUT_VALUE_ID14:=nn;
960: else
961: L_INPUT_VALUE_ID14 :=
962: hr_pump_get.GET_INPUT_VALUE_ID14
963: (P_INPUT_VALUE_NAME14 => c.p100
964: ,P_ELEMENT_NAME => c.p86
965: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
966: ,P_EFFECTIVE_DATE => c.p2

Line 980: hr_pump_get.GET_INPUT_VALUE_ID15

976: c.d87=cn then
977: L_INPUT_VALUE_ID15:=nn;
978: else
979: L_INPUT_VALUE_ID15 :=
980: hr_pump_get.GET_INPUT_VALUE_ID15
981: (P_INPUT_VALUE_NAME15 => c.p101
982: ,P_ELEMENT_NAME => c.p86
983: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
984: ,P_EFFECTIVE_DATE => c.p2