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.PAY_JP_BALANCE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 88: p_element_name IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

84: END get_legislation_code;
85: --
86: --===============================================================================
87: PROCEDURE get_element_input_id(
88: p_element_name IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
89: p_input_value_name IN PAY_INPUT_VALUES_F.NAME%TYPE,
90: p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE,
91: p_element_type_id IN OUT NOCOPY NUMBER,
92: p_input_value_id IN OUT NOCOPY NUMBER)

Line 413: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

409: -----------------------------------------------------------
410: -- GET_RESULT_VALUE_PAY_VALUE --
411: -----------------------------------------------------------
412: FUNCTION GET_RESULT_VALUE_PAY_VALUE(
413: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
414: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
415: RETURN NUMBER
416: IS
417: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

Line 418: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

414: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
415: RETURN NUMBER
416: IS
417: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
418: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
419: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
420: l_result_value NUMBER;
421: BEGIN
422: l_result_value := NULL;

Line 499: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

495: -----------------------------------------------------------
496: -- GET_RESULT_VALUE_CHAR --
497: -----------------------------------------------------------
498: FUNCTION GET_RESULT_VALUE_CHAR(
499: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
500: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
501: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
502: RETURN VARCHAR2
503: IS

Line 505: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

501: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
502: RETURN VARCHAR2
503: IS
504: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
505: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
506: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
507: l_result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;
508: BEGIN
509: l_result_value := NULL;

Line 580: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

576: -----------------------------------------------------------
577: -- GET_RESULT_VALUE_NUMBER --
578: -----------------------------------------------------------
579: FUNCTION GET_RESULT_VALUE_NUMBER(
580: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
581: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
582: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
583: RETURN NUMBER
584: IS

Line 586: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

582: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
583: RETURN NUMBER
584: IS
585: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
586: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
587: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
588: l_result_value NUMBER;
589: BEGIN
590: l_result_value := NULL;

Line 662: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

658: -----------------------------------------------------------
659: -- GET_RESULT_VALUE_DATE --
660: -----------------------------------------------------------
661: FUNCTION GET_RESULT_VALUE_DATE(
662: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
663: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
664: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
665: RETURN DATE
666: IS

Line 668: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

664: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
665: RETURN DATE
666: IS
667: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
668: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
669: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
670: l_result_value DATE;
671: BEGIN
672: l_result_value := NULL;

Line 746: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

742: -----------------------------------------------------
743: -- GET_ENTRY_VALUE_CHAR --
744: -----------------------------------------------------
745: FUNCTION GET_ENTRY_VALUE_CHAR(
746: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
747: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
748: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
749: P_EFFECTIVE_DATE IN DATE)
750: RETURN VARCHAR2

Line 753: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

749: P_EFFECTIVE_DATE IN DATE)
750: RETURN VARCHAR2
751: IS
752: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
753: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
754: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
755: l_entry_value PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE%TYPE;
756: BEGIN
757: l_entry_value := NULL;

Line 835: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

831: -------------------------------------------------------
832: -- GET_ENTRY_VALUE_NUMBER --
833: -------------------------------------------------------
834: FUNCTION GET_ENTRY_VALUE_NUMBER(
835: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
836: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
837: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
838: P_EFFECTIVE_DATE IN DATE)
839: RETURN NUMBER

Line 842: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

838: P_EFFECTIVE_DATE IN DATE)
839: RETURN NUMBER
840: IS
841: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
842: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
843: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
844: -- Modified by keyazawa at 2003/09/03 for bug#3088039
845: l_entry_value number;
846: BEGIN

Line 927: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

923: -----------------------------------------------------
924: -- GET_ENTRY_VALUE_DATE --
925: -----------------------------------------------------
926: FUNCTION GET_ENTRY_VALUE_DATE(
927: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
928: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
929: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
930: P_EFFECTIVE_DATE IN DATE)
931: RETURN DATE

Line 934: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

930: P_EFFECTIVE_DATE IN DATE)
931: RETURN DATE
932: IS
933: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
934: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
935: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
936: -- Modified by keyazawa at 2003/09/03 for bug#3088039
937: l_entry_value date;
938: BEGIN

Line 1023: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

1019: -----------------------------------------------------
1020: -- GET_ELEMENT_TYPE_ID --
1021: -----------------------------------------------------
1022: FUNCTION GET_ELEMENT_TYPE_ID(
1023: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
1024: P_BUSINESS_GROUP_ID IN NUMBER,
1025: P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
1026: RETURN NUMBER
1027: IS

Line 1031: select /+ INDEX(PAY_ELEMENT_TYPES_F_UK2 PET) /

1027: IS
1028: l_element_type_id NUMBER;
1029:
1030: CURSOR get_element_type_id IS
1031: select /*+ INDEX(PAY_ELEMENT_TYPES_F_UK2 PET) */
1032: min(pet.element_type_id)
1033: from pay_element_types_f pet
1034: where pet.element_name = p_element_name
1035: and nvl(pet.business_group_id,p_business_group_id) = p_business_group_id

Line 1033: from pay_element_types_f pet

1029:
1030: CURSOR get_element_type_id IS
1031: select /*+ INDEX(PAY_ELEMENT_TYPES_F_UK2 PET) */
1032: min(pet.element_type_id)
1033: from pay_element_types_f pet
1034: where pet.element_name = p_element_name
1035: and nvl(pet.business_group_id,p_business_group_id) = p_business_group_id
1036: and nvl(pet.legislation_code,p_legislation_code) = p_legislation_code;
1037: BEGIN

Line 1079: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

1075: -----------------------------------------------------
1076: -- GET_INPUT_VALUE_ID --
1077: -----------------------------------------------------
1078: FUNCTION GET_INPUT_VALUE_ID(
1079: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
1080: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
1081: P_BUSINESS_GROUP_ID IN NUMBER,
1082: P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
1083: RETURN NUMBER

Line 1113: p_element_name in pay_element_types_f.element_name%type,

1109: -- seed data. When the other argument is specified,
1110: -- null value would be returned.
1111: -------------------------------------------------- */
1112: FUNCTION get_loc_uni_seq_input_value_id(
1113: p_element_name in pay_element_types_f.element_name%type,
1114: p_input_value_disp_seq in pay_input_values_f.display_sequence%type,
1115: p_business_group_id in number,
1116: p_legislation_code in per_business_groups.legislation_code%type)
1117: return number