DBA Data[Home] [Help]

APPS.HRDPP_CREATE_ELEMENT_ENTRY dependencies on HR_PUMP_GET

Line 417: hr_pump_get.gl(l.pval002,'ENTRY_TYPE',d(l.pval001),l.pval091)) p2,

413: cursor cr is
414: select l.rowid myrowid,
415: decode(l.pval001,cn,dn,d(l.pval001)) p1,
416: decode(l.pval002,cn,vn,
417: hr_pump_get.gl(l.pval002,'ENTRY_TYPE',d(l.pval001),l.pval091)) p2,
418: decode(l.pval003,cn,vn,vn,'F',l.pval003) p3,
419: l.pval003 d3,
420: decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
421: l.pval004 d4,

Line 423: hr_pump_get.gl(l.pval005,'ELE_ENTRY_REASON',d(l.pval001),l.pval091)) p5,

419: l.pval003 d3,
420: decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
421: l.pval004 d4,
422: decode(l.pval005,cn,vn,vn,vn,
423: hr_pump_get.gl(l.pval005,'ELE_ENTRY_REASON',d(l.pval001),l.pval091)) p5,
424: l.pval005 d5,
425: decode(l.pval006,cn,nn,vn,nn,n(l.pval006)) p6,
426: l.pval006 d6,
427: decode(l.pval007,cn,dn,vn,dn,d(l.pval007)) p7,

Line 665: hr_pump_get.get_original_entry_id

661: if c.p81 is null then
662: L_ORIGINAL_ENTRY_ID:=nn;
663: else
664: L_ORIGINAL_ENTRY_ID :=
665: hr_pump_get.get_original_entry_id
666: (P_ORIGINAL_ENTRY_USER_KEY => c.p81);
667: end if;
668: --
669: if c.p82 is null then

Line 673: hr_pump_get.get_assignment_id

669: if c.p82 is null then
670: L_ASSIGNMENT_ID:=nn;
671: else
672: L_ASSIGNMENT_ID :=
673: hr_pump_get.get_assignment_id
674: (P_ASSIGNMENT_USER_KEY => c.p82);
675: end if;
676: --
677: if c.p83 is null then

Line 681: hr_pump_get.get_element_link_id

677: if c.p83 is null then
678: L_ELEMENT_LINK_ID:=nn;
679: else
680: L_ELEMENT_LINK_ID :=
681: hr_pump_get.get_element_link_id
682: (P_ELEMENT_LINK_USER_KEY => c.p83);
683: end if;
684: --
685: if c.p84 is null then

Line 689: hr_pump_get.get_cost_allocation_keyflex_id

685: if c.p84 is null then
686: L_COST_ALLOCATION_KEYFLEX_ID:=nn;
687: else
688: L_COST_ALLOCATION_KEYFLEX_ID :=
689: hr_pump_get.get_cost_allocation_keyflex_id
690: (P_COST_ALLOC_KEYFLEX_USER_KEY => c.p84);
691: end if;
692: --
693: if c.p85 is null then

Line 697: hr_pump_get.get_updating_action_id

693: if c.p85 is null then
694: L_UPDATING_ACTION_ID:=nn;
695: else
696: L_UPDATING_ACTION_ID :=
697: hr_pump_get.get_updating_action_id
698: (P_UPDATING_ACTION_USER_KEY => c.p85);
699: end if;
700: --
701: if c.p86 is null then

Line 705: hr_pump_get.get_comment_id

701: if c.p86 is null then
702: L_COMMENT_ID:=nn;
703: else
704: L_COMMENT_ID :=
705: hr_pump_get.get_comment_id
706: (P_COMMENT_USER_KEY => c.p86);
707: end if;
708: --
709: if c.p87 is null then

Line 713: hr_pump_get.get_target_entry_id

709: if c.p87 is null then
710: L_TARGET_ENTRY_ID:=nn;
711: else
712: L_TARGET_ENTRY_ID :=
713: hr_pump_get.get_target_entry_id
714: (P_TARGET_ENTRY_USER_KEY => c.p87);
715: end if;
716: --
717: if c.p88 is null then

Line 721: hr_pump_get.get_personal_payment_method_id

717: if c.p88 is null then
718: L_PERSONAL_PAYMENT_METHOD_ID:=nn;
719: else
720: L_PERSONAL_PAYMENT_METHOD_ID :=
721: hr_pump_get.get_personal_payment_method_id
722: (P_PERSONAL_PAY_METHOD_USER_KEY => c.p88);
723: end if;
724: --
725: if c.p89 is null or

Line 732: hr_pump_get.GET_INPUT_VALUE_ID1

728: c.p91 is null then
729: L_INPUT_VALUE_ID1:=nn;
730: else
731: L_INPUT_VALUE_ID1 :=
732: hr_pump_get.GET_INPUT_VALUE_ID1
733: (P_INPUT_VALUE_NAME1 => c.p89
734: ,P_ELEMENT_NAME => c.p90
735: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
736: ,P_EFFECTIVE_DATE => c.p1

Line 747: hr_pump_get.GET_INPUT_VALUE_ID2

743: c.p91 is null then
744: L_INPUT_VALUE_ID2:=nn;
745: else
746: L_INPUT_VALUE_ID2 :=
747: hr_pump_get.GET_INPUT_VALUE_ID2
748: (P_INPUT_VALUE_NAME2 => c.p92
749: ,P_ELEMENT_NAME => c.p90
750: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
751: ,P_EFFECTIVE_DATE => c.p1

Line 762: hr_pump_get.GET_INPUT_VALUE_ID3

758: c.p91 is null then
759: L_INPUT_VALUE_ID3:=nn;
760: else
761: L_INPUT_VALUE_ID3 :=
762: hr_pump_get.GET_INPUT_VALUE_ID3
763: (P_INPUT_VALUE_NAME3 => c.p93
764: ,P_ELEMENT_NAME => c.p90
765: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
766: ,P_EFFECTIVE_DATE => c.p1

Line 777: hr_pump_get.GET_INPUT_VALUE_ID4

773: c.p91 is null then
774: L_INPUT_VALUE_ID4:=nn;
775: else
776: L_INPUT_VALUE_ID4 :=
777: hr_pump_get.GET_INPUT_VALUE_ID4
778: (P_INPUT_VALUE_NAME4 => c.p94
779: ,P_ELEMENT_NAME => c.p90
780: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
781: ,P_EFFECTIVE_DATE => c.p1

Line 792: hr_pump_get.GET_INPUT_VALUE_ID5

788: c.p91 is null then
789: L_INPUT_VALUE_ID5:=nn;
790: else
791: L_INPUT_VALUE_ID5 :=
792: hr_pump_get.GET_INPUT_VALUE_ID5
793: (P_INPUT_VALUE_NAME5 => c.p95
794: ,P_ELEMENT_NAME => c.p90
795: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
796: ,P_EFFECTIVE_DATE => c.p1

Line 807: hr_pump_get.GET_INPUT_VALUE_ID6

803: c.p91 is null then
804: L_INPUT_VALUE_ID6:=nn;
805: else
806: L_INPUT_VALUE_ID6 :=
807: hr_pump_get.GET_INPUT_VALUE_ID6
808: (P_INPUT_VALUE_NAME6 => c.p96
809: ,P_ELEMENT_NAME => c.p90
810: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
811: ,P_EFFECTIVE_DATE => c.p1

Line 822: hr_pump_get.GET_INPUT_VALUE_ID7

818: c.p91 is null then
819: L_INPUT_VALUE_ID7:=nn;
820: else
821: L_INPUT_VALUE_ID7 :=
822: hr_pump_get.GET_INPUT_VALUE_ID7
823: (P_INPUT_VALUE_NAME7 => c.p97
824: ,P_ELEMENT_NAME => c.p90
825: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
826: ,P_EFFECTIVE_DATE => c.p1

Line 837: hr_pump_get.GET_INPUT_VALUE_ID8

833: c.p91 is null then
834: L_INPUT_VALUE_ID8:=nn;
835: else
836: L_INPUT_VALUE_ID8 :=
837: hr_pump_get.GET_INPUT_VALUE_ID8
838: (P_INPUT_VALUE_NAME8 => c.p98
839: ,P_ELEMENT_NAME => c.p90
840: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
841: ,P_EFFECTIVE_DATE => c.p1

Line 852: hr_pump_get.GET_INPUT_VALUE_ID9

848: c.p91 is null then
849: L_INPUT_VALUE_ID9:=nn;
850: else
851: L_INPUT_VALUE_ID9 :=
852: hr_pump_get.GET_INPUT_VALUE_ID9
853: (P_INPUT_VALUE_NAME9 => c.p99
854: ,P_ELEMENT_NAME => c.p90
855: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
856: ,P_EFFECTIVE_DATE => c.p1

Line 867: hr_pump_get.GET_INPUT_VALUE_ID10

863: c.p91 is null then
864: L_INPUT_VALUE_ID10:=nn;
865: else
866: L_INPUT_VALUE_ID10 :=
867: hr_pump_get.GET_INPUT_VALUE_ID10
868: (P_INPUT_VALUE_NAME10 => c.p100
869: ,P_ELEMENT_NAME => c.p90
870: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
871: ,P_EFFECTIVE_DATE => c.p1

Line 882: hr_pump_get.GET_INPUT_VALUE_ID11

878: c.p91 is null then
879: L_INPUT_VALUE_ID11:=nn;
880: else
881: L_INPUT_VALUE_ID11 :=
882: hr_pump_get.GET_INPUT_VALUE_ID11
883: (P_INPUT_VALUE_NAME11 => c.p101
884: ,P_ELEMENT_NAME => c.p90
885: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
886: ,P_EFFECTIVE_DATE => c.p1

Line 897: hr_pump_get.GET_INPUT_VALUE_ID12

893: c.p91 is null then
894: L_INPUT_VALUE_ID12:=nn;
895: else
896: L_INPUT_VALUE_ID12 :=
897: hr_pump_get.GET_INPUT_VALUE_ID12
898: (P_INPUT_VALUE_NAME12 => c.p102
899: ,P_ELEMENT_NAME => c.p90
900: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
901: ,P_EFFECTIVE_DATE => c.p1

Line 912: hr_pump_get.GET_INPUT_VALUE_ID13

908: c.p91 is null then
909: L_INPUT_VALUE_ID13:=nn;
910: else
911: L_INPUT_VALUE_ID13 :=
912: hr_pump_get.GET_INPUT_VALUE_ID13
913: (P_INPUT_VALUE_NAME13 => c.p103
914: ,P_ELEMENT_NAME => c.p90
915: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
916: ,P_EFFECTIVE_DATE => c.p1

Line 927: hr_pump_get.GET_INPUT_VALUE_ID14

923: c.p91 is null then
924: L_INPUT_VALUE_ID14:=nn;
925: else
926: L_INPUT_VALUE_ID14 :=
927: hr_pump_get.GET_INPUT_VALUE_ID14
928: (P_INPUT_VALUE_NAME14 => c.p104
929: ,P_ELEMENT_NAME => c.p90
930: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
931: ,P_EFFECTIVE_DATE => c.p1

Line 942: hr_pump_get.GET_INPUT_VALUE_ID15

938: c.p91 is null then
939: L_INPUT_VALUE_ID15:=nn;
940: else
941: L_INPUT_VALUE_ID15 :=
942: hr_pump_get.GET_INPUT_VALUE_ID15
943: (P_INPUT_VALUE_NAME15 => c.p105
944: ,P_ELEMENT_NAME => c.p90
945: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
946: ,P_EFFECTIVE_DATE => c.p1