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.IRC_ASG_STATUS_API dependencies on IRC_ASSIGNMENT_STATUSES

Line 29: from irc_assignment_statuses

25: ) IS
26: --
27: cursor csr_after_date is
28: select assignment_status_id, object_Version_number
29: from irc_assignment_statuses
30: where assignment_id = p_assignment_id
31: and trunc(status_change_date) > trunc(p_status_change_date);
32: --
33: cursor csr_get_status is

Line 35: from irc_assignment_statuses

31: and trunc(status_change_date) > trunc(p_status_change_date);
32: --
33: cursor csr_get_status is
34: select assignment_status_type_id
35: from irc_assignment_statuses
36: where assignment_id = p_assignment_id
37: and status_change_date = (select max(status_change_date)
38: from irc_assignment_statuses
39: where assignment_id = p_assignment_id);

Line 38: from irc_assignment_statuses

34: select assignment_status_type_id
35: from irc_assignment_statuses
36: where assignment_id = p_assignment_id
37: and status_change_date = (select max(status_change_date)
38: from irc_assignment_statuses
39: where assignment_id = p_assignment_id);
40: -- and status_change_date < p_status_change_date);
41: -- Modified for 5838786
42: l_assignment_status_type_id irc_assignment_statuses.assignment_status_type_id%type;

Line 42: l_assignment_status_type_id irc_assignment_statuses.assignment_status_type_id%type;

38: from irc_assignment_statuses
39: where assignment_id = p_assignment_id);
40: -- and status_change_date < p_status_change_date);
41: -- Modified for 5838786
42: l_assignment_status_type_id irc_assignment_statuses.assignment_status_type_id%type;
43: l_status_change_comments irc_assignment_statuses.status_change_comments%type;
44: l_status_change_reason irc_assignment_statuses.status_change_reason%type;
45: l_proc varchar2(72) := g_package||'dt_update_irc_asg_status';
46: begin

Line 43: l_status_change_comments irc_assignment_statuses.status_change_comments%type;

39: where assignment_id = p_assignment_id);
40: -- and status_change_date < p_status_change_date);
41: -- Modified for 5838786
42: l_assignment_status_type_id irc_assignment_statuses.assignment_status_type_id%type;
43: l_status_change_comments irc_assignment_statuses.status_change_comments%type;
44: l_status_change_reason irc_assignment_statuses.status_change_reason%type;
45: l_proc varchar2(72) := g_package||'dt_update_irc_asg_status';
46: begin
47: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 44: l_status_change_reason irc_assignment_statuses.status_change_reason%type;

40: -- and status_change_date < p_status_change_date);
41: -- Modified for 5838786
42: l_assignment_status_type_id irc_assignment_statuses.assignment_status_type_id%type;
43: l_status_change_comments irc_assignment_statuses.status_change_comments%type;
44: l_status_change_reason irc_assignment_statuses.status_change_reason%type;
45: l_proc varchar2(72) := g_package||'dt_update_irc_asg_status';
46: begin
47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: if p_datetrack_mode = 'UPDATE_OVERRIDE' then

Line 114: l_assignment_id irc_assignment_statuses.assignment_id%type;

110: , p_object_version_number in number
111: , p_effective_date in date
112: , p_datetrack_mode in varchar2) IS
113: --
114: l_assignment_id irc_assignment_statuses.assignment_id%type;
115: cursor csr_ass is
116: select assignment_id from irc_assignment_statuses
117: where assignment_status_id = p_assignment_status_id;
118: --

Line 116: select assignment_id from irc_assignment_statuses

112: , p_datetrack_mode in varchar2) IS
113: --
114: l_assignment_id irc_assignment_statuses.assignment_id%type;
115: cursor csr_ass is
116: select assignment_id from irc_assignment_statuses
117: where assignment_status_id = p_assignment_status_id;
118: --
119: cursor csr_after_date is
120: select assignment_status_id, object_Version_number

Line 121: from irc_assignment_statuses

117: where assignment_status_id = p_assignment_status_id;
118: --
119: cursor csr_after_date is
120: select assignment_status_id, object_Version_number
121: from irc_assignment_statuses
122: where assignment_id = l_assignment_id
123: and (trunc(status_change_date) > trunc(p_effective_date)
124: or p_datetrack_mode <> 'FUTURE_CHANGE')
125: and (trunc(status_change_date) >= trunc(p_effective_date)

Line 129: from irc_assignment_statuses

125: and (trunc(status_change_date) >= trunc(p_effective_date)
126: or p_datetrack_mode <> 'DELETE')
127: and (p_datetrack_mode <> 'DELETE_NEXT_CHANGE'
128: or trunc(status_change_date) = (select trunc(min(status_change_date))
129: from irc_assignment_statuses
130: where assignment_id = l_assignment_id
131: and status_change_date >
132: p_effective_date));
133: --

Line 166: l_assignment_status_id irc_assignment_statuses.assignment_id%type;

162: -- Declare cursors and local variables
163: --
164: l_proc varchar2(72) := g_package||'create_irc_asg_status';
165: l_object_version_number number;
166: l_assignment_status_id irc_assignment_statuses.assignment_id%type;
167: l_status_change_date irc_assignment_statuses.status_change_date%type;
168: l_per_system_status per_assignment_status_types.per_system_status%type;
169: l_status_change_by irc_assignment_statuses.status_change_by%type;
170: l_status_change_reason irc_assignment_statuses.status_change_reason%type;

Line 167: l_status_change_date irc_assignment_statuses.status_change_date%type;

163: --
164: l_proc varchar2(72) := g_package||'create_irc_asg_status';
165: l_object_version_number number;
166: l_assignment_status_id irc_assignment_statuses.assignment_id%type;
167: l_status_change_date irc_assignment_statuses.status_change_date%type;
168: l_per_system_status per_assignment_status_types.per_system_status%type;
169: l_status_change_by irc_assignment_statuses.status_change_by%type;
170: l_status_change_reason irc_assignment_statuses.status_change_reason%type;
171:

Line 169: l_status_change_by irc_assignment_statuses.status_change_by%type;

165: l_object_version_number number;
166: l_assignment_status_id irc_assignment_statuses.assignment_id%type;
167: l_status_change_date irc_assignment_statuses.status_change_date%type;
168: l_per_system_status per_assignment_status_types.per_system_status%type;
169: l_status_change_by irc_assignment_statuses.status_change_by%type;
170: l_status_change_reason irc_assignment_statuses.status_change_reason%type;
171:
172: --
173: cursor c_status_type is

Line 170: l_status_change_reason irc_assignment_statuses.status_change_reason%type;

166: l_assignment_status_id irc_assignment_statuses.assignment_id%type;
167: l_status_change_date irc_assignment_statuses.status_change_date%type;
168: l_per_system_status per_assignment_status_types.per_system_status%type;
169: l_status_change_by irc_assignment_statuses.status_change_by%type;
170: l_status_change_reason irc_assignment_statuses.status_change_reason%type;
171:
172: --
173: cursor c_status_type is
174: select per_system_status

Line 179: from irc_assignment_statuses

175: from per_assignment_status_types
176: where assignment_status_type_id = p_assignment_status_type_id;
177: cursor c_max_status_change_date is
178: select max(status_change_date)
179: from irc_assignment_statuses
180: where assignment_id = p_assignment_id;
181: PROCEDURE UPDATE_INTERVIEW(
182: p_assignment_id in NUMBER
183: ,p_assignment_status_type_id in NUMBER

Line 434: l_status_change_date irc_assignment_statuses.status_change_date%type;

430: -- Declare cursors and local variables
431: --
432: l_proc varchar2(72) := g_package||'update_irc_asg_status';
433: l_object_version_number number := p_object_version_number;
434: l_status_change_date irc_assignment_statuses.status_change_date%type;
435: l_status_change_reason irc_assignment_statuses.status_change_reason%type;
436: --
437: begin
438: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 435: l_status_change_reason irc_assignment_statuses.status_change_reason%type;

431: --
432: l_proc varchar2(72) := g_package||'update_irc_asg_status';
433: l_object_version_number number := p_object_version_number;
434: l_status_change_date irc_assignment_statuses.status_change_date%type;
435: l_status_change_reason irc_assignment_statuses.status_change_reason%type;
436: --
437: begin
438: hr_utility.set_location('Entering:'|| l_proc, 10);
439: --