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.PER_US_ASG_EXT_INFO_CHK dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 42: p_assignment_id per_assignment_extra_info.assignment_id%TYPE,

38: deduction category while inserting assignment EIT records.
39: *******************************************************************************/
40:
41: PROCEDURE CHK_DUP_PRORATION_INS(
42: p_assignment_id per_assignment_extra_info.assignment_id%TYPE,
43: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
44: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
45: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
46: ) IS

Line 43: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,

39: *******************************************************************************/
40:
41: PROCEDURE CHK_DUP_PRORATION_INS(
42: p_assignment_id per_assignment_extra_info.assignment_id%TYPE,
43: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
44: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
45: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
46: ) IS
47:

Line 44: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,

40:
41: PROCEDURE CHK_DUP_PRORATION_INS(
42: p_assignment_id per_assignment_extra_info.assignment_id%TYPE,
43: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
44: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
45: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
46: ) IS
47:
48: CURSOR c_dup_records IS

Line 45: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE

41: PROCEDURE CHK_DUP_PRORATION_INS(
42: p_assignment_id per_assignment_extra_info.assignment_id%TYPE,
43: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
44: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
45: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
46: ) IS
47:
48: CURSOR c_dup_records IS
49: SELECT COUNT(1)

Line 50: FROM per_assignment_extra_info

46: ) IS
47:
48: CURSOR c_dup_records IS
49: SELECT COUNT(1)
50: FROM per_assignment_extra_info
51: WHERE assignment_id = p_assignment_id
52: AND aei_information1 = p_aei_information1
53: AND aei_information2 = p_aei_information2
54: AND ((assignment_extra_info_id <> GLB_ASG_EXTRA_INFO_ID AND GLB_MODE IS NOT NULL) OR

Line 97: p_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE,

93: deduction category while updating assignment EIT records.
94: *******************************************************************************/
95:
96: PROCEDURE CHK_DUP_PRORATION_UPD(
97: p_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE,
98: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
99: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
100: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
101: ) IS

Line 98: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,

94: *******************************************************************************/
95:
96: PROCEDURE CHK_DUP_PRORATION_UPD(
97: p_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE,
98: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
99: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
100: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
101: ) IS
102: CURSOR c_asg_id IS

Line 99: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,

95:
96: PROCEDURE CHK_DUP_PRORATION_UPD(
97: p_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE,
98: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
99: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
100: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
101: ) IS
102: CURSOR c_asg_id IS
103: SELECT assignment_id

Line 100: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE

96: PROCEDURE CHK_DUP_PRORATION_UPD(
97: p_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE,
98: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
99: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
100: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
101: ) IS
102: CURSOR c_asg_id IS
103: SELECT assignment_id
104: FROM per_assignment_extra_info

Line 104: FROM per_assignment_extra_info

100: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
101: ) IS
102: CURSOR c_asg_id IS
103: SELECT assignment_id
104: FROM per_assignment_extra_info
105: WHERE assignment_extra_info_id = p_assignment_extra_info_id;
106:
107: l_asg_id per_assignment_extra_info.assignment_id%TYPE;
108: l_proc_name varchar2(100);

Line 107: l_asg_id per_assignment_extra_info.assignment_id%TYPE;

103: SELECT assignment_id
104: FROM per_assignment_extra_info
105: WHERE assignment_extra_info_id = p_assignment_extra_info_id;
106:
107: l_asg_id per_assignment_extra_info.assignment_id%TYPE;
108: l_proc_name varchar2(100);
109: BEGIN
110: l_proc_name := 'PER_US_ASG_EXT_INFO_CHK.CHK_DUP_PRORATION_UPD';
111: hr_utility.trace('Entering '||l_proc_name);