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_INPUT_VALUES_F

Line 89: p_input_value_name IN PAY_INPUT_VALUES_F.NAME%TYPE,

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)
93: --===============================================================================

Line 419: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_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;
423:

Line 500: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,

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
504: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

Line 506: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_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;
510:

Line 581: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,

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
585: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

Line 587: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_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;
591:

Line 663: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,

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
667: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

Line 669: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_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;
673:

Line 747: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,

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
751: IS

Line 754: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;

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;
758:

Line 793: INDEX(PAY_INPUT_VALUES_F_PK PIV)

789:
790: CURSOR get_entry_value IS
791: select /*+ ORDERED
792: USE_NL(PIV, PLIV, PEE, PEEV)
793: INDEX(PAY_INPUT_VALUES_F_PK PIV)
794: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV)
795: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
796: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV) */
797: min( decode(piv.hot_default_flag, 'Y',nvl(peev.screen_entry_value,nvl(pliv.default_value,piv.default_value)),

Line 799: from pay_input_values_f piv,

795: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
796: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV) */
797: min( decode(piv.hot_default_flag, 'Y',nvl(peev.screen_entry_value,nvl(pliv.default_value,piv.default_value)),
798: 'N',peev.screen_entry_value))
799: from pay_input_values_f piv,
800: pay_link_input_values_f pliv,
801: pay_element_entries_f pee,
802: pay_element_entry_values_f peev
803: WHERE piv.input_value_id = p_input_value_id

Line 836: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,

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
840: IS

Line 843: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;

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
847: l_entry_value := NULL;

Line 884: INDEX(PAY_INPUT_VALUES_F_PK PIV)

880:
881: CURSOR get_entry_value IS
882: select /*+ ORDERED
883: USE_NL(PIV, PLIV, PEE, PEEV)
884: INDEX(PAY_INPUT_VALUES_F_PK PIV)
885: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV)
886: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
887: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV) */
888: min(fnd_number.canonical_to_number(decode(decode(substr(piv.uom,1,1),'M','N','N','N','I','N','H','N',null),'N',

Line 891: from pay_input_values_f piv,

887: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV) */
888: min(fnd_number.canonical_to_number(decode(decode(substr(piv.uom,1,1),'M','N','N','N','I','N','H','N',null),'N',
889: decode(piv.hot_default_flag, 'Y',nvl(peev.screen_entry_value,nvl(pliv.default_value,piv.default_value)),
890: 'N',peev.screen_entry_value),null)))
891: from pay_input_values_f piv,
892: pay_link_input_values_f pliv,
893: pay_element_entries_f pee,
894: pay_element_entry_values_f peev
895: WHERE piv.input_value_id = p_input_value_id

Line 928: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,

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
932: IS

Line 935: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;

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
939: l_entry_value := NULL;

Line 980: INDEX(PAY_INPUT_VALUES_F_PK PIV)

976: -- decode(piv.hot_default_flag, 'Y',nvl(peev.screen_entry_value,nvl(pliv.default_value,piv.default_value)),
977: -- 'N',peev.screen_entry_value),null),'DD-MON-YYYY'))
978: select /*+ ORDERED
979: USE_NL(PIV, PLIV, PEE, PEEV)
980: INDEX(PAY_INPUT_VALUES_F_PK PIV)
981: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV)
982: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
983: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV) */
984: min (fnd_date.canonical_to_date(decode(substr(piv.uom,1,1),'D',

Line 987: from pay_input_values_f piv,

983: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV) */
984: min (fnd_date.canonical_to_date(decode(substr(piv.uom,1,1),'D',
985: decode(piv.hot_default_flag, 'Y',nvl(peev.screen_entry_value,nvl(pliv.default_value,piv.default_value)),
986: 'N',peev.screen_entry_value),null)))
987: from pay_input_values_f piv,
988: pay_link_input_values_f pliv,
989: pay_element_entries_f pee,
990: pay_element_entry_values_f peev
991: WHERE piv.input_value_id = p_input_value_id

Line 1053: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE)

1049: -- GET_INPUT_VALUE_ID --
1050: -----------------------------------------------------
1051: FUNCTION GET_INPUT_VALUE_ID(
1052: P_ELEMENT_TYPE_ID IN NUMBER,
1053: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE)
1054: RETURN NUMBER
1055: IS
1056: l_input_value_id NUMBER;
1057:

Line 1059: select /+ INDEX(PAY_INPUT_VALUES_F_UK2 PIV) /

1055: IS
1056: l_input_value_id NUMBER;
1057:
1058: CURSOR get_input_value_id IS
1059: select /*+ INDEX(PAY_INPUT_VALUES_F_UK2 PIV) */
1060: min(piv.input_value_id)
1061: from pay_input_values_f piv
1062: where piv.element_type_id = p_element_type_id
1063: and piv.name=p_input_value_name;

Line 1061: from pay_input_values_f piv

1057:
1058: CURSOR get_input_value_id IS
1059: select /*+ INDEX(PAY_INPUT_VALUES_F_UK2 PIV) */
1060: min(piv.input_value_id)
1061: from pay_input_values_f piv
1062: where piv.element_type_id = p_element_type_id
1063: and piv.name=p_input_value_name;
1064: BEGIN
1065: OPEN get_input_value_id;

Line 1080: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,

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
1084: IS

Line 1114: p_input_value_disp_seq in pay_input_values_f.display_sequence%type,

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
1118: IS

Line 1126: from pay_input_values_f piv

1122: --
1123: cursor csr_input_value
1124: is
1125: select piv.input_value_id
1126: from pay_input_values_f piv
1127: where piv.element_type_id = l_element_type_id
1128: and piv.display_sequence = p_input_value_disp_seq
1129: /* Validate if input value is owned as JP legislation code */
1130: and piv.legislation_code = decode(p_legislation_code,'JP',p_legislation_code,null)

Line 1134: from pay_input_values_f piv2

1130: and piv.legislation_code = decode(p_legislation_code,'JP',p_legislation_code,null)
1131: /* Validate if there are another input value of same display sequence */
1132: and not exists(
1133: select null
1134: from pay_input_values_f piv2
1135: where piv2.element_type_id = piv.element_type_id
1136: and piv2.display_sequence = piv.display_sequence
1137: and piv2.input_value_id <> piv.input_value_id);
1138: --