APPS.IRC_ASG_STATUS_API dependencies on IRC_ASSIGNMENT_STATUSES

Line 28: from irc_assignment_statuses

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

Line 33: from irc_assignment_statuses

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

Line 36: from irc_assignment_statuses

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

Line 40: l_assignment_status_type_id irc_assignment_statuses.assignment_status_type_id%type;

36: from irc_assignment_statuses
37: where assignment_id = p_assignment_id);
38: -- and status_change_date < p_status_change_date);
39: -- Modified for 5838786
40: l_assignment_status_type_id irc_assignment_statuses.assignment_status_type_id%type;
41: begin
42: if p_datetrack_mode = 'UPDATE_OVERRIDE' then
43: for c_rec in csr_after_date loop
44: delete_irc_asg_status

Line 100: l_assignment_id irc_assignment_statuses.assignment_id%type;

96: , p_object_version_number in number
97: , p_effective_date in date
98: , p_datetrack_mode in varchar2) IS
99:
100: l_assignment_id irc_assignment_statuses.assignment_id%type;
101: cursor csr_ass is
102: select assignment_id from irc_assignment_statuses
103: where assignment_status_id = p_assignment_status_id;
104:

Line 102: select assignment_id from irc_assignment_statuses

98: , p_datetrack_mode in varchar2) IS
99:
100: l_assignment_id irc_assignment_statuses.assignment_id%type;
101: cursor csr_ass is
102: select assignment_id from irc_assignment_statuses
103: where assignment_status_id = p_assignment_status_id;
104:
105: cursor csr_after_date is
106: select assignment_status_id, object_Version_number

Line 107: from irc_assignment_statuses

103: where assignment_status_id = p_assignment_status_id;
104:
105: cursor csr_after_date is
106: select assignment_status_id, object_Version_number
107: from irc_assignment_statuses
108: where assignment_id = l_assignment_id
109: and (trunc(status_change_date) > trunc(p_effective_date)
110: or p_datetrack_mode <> 'FUTURE_CHANGE')
111: and (trunc(status_change_date) >= trunc(p_effective_date)

Line 115: from irc_assignment_statuses

111: and (trunc(status_change_date) >= trunc(p_effective_date)
112: or p_datetrack_mode <> 'DELETE')
113: and (p_datetrack_mode <> 'DELETE_NEXT_CHANGE'
114: or trunc(status_change_date) = (select trunc(min(status_change_date))
115: from irc_assignment_statuses
116: where assignment_id = l_assignment_id
117: and status_change_date >
118: p_effective_date));
119:

Line 152: l_assignment_status_id irc_assignment_statuses.assignment_id%type;

148: -- Declare cursors and local variables
149: --
150: l_proc varchar2(72) := g_package||'create_irc_asg_status';
151: l_object_version_number number;
152: l_assignment_status_id irc_assignment_statuses.assignment_id%type;
153: l_status_change_date irc_assignment_statuses.status_change_date%type;
154: PROCEDURE UPDATE_INTERVIEW(
155: p_assignment_id in NUMBER
156: ,p_assignment_status_type_id in NUMBER

Line 153: l_status_change_date irc_assignment_statuses.status_change_date%type;

149: --
150: l_proc varchar2(72) := g_package||'create_irc_asg_status';
151: l_object_version_number number;
152: l_assignment_status_id irc_assignment_statuses.assignment_id%type;
153: l_status_change_date irc_assignment_statuses.status_change_date%type;
154: PROCEDURE UPDATE_INTERVIEW(
155: p_assignment_id in NUMBER
156: ,p_assignment_status_type_id in NUMBER
157: ) is

Line 359: l_status_change_date irc_assignment_statuses.status_change_date%type;

355: -- Declare cursors and local variables
356: --
357: l_proc varchar2(72) := g_package||'update_irc_asg_status';
358: l_object_version_number number := p_object_version_number;
359: l_status_change_date irc_assignment_statuses.status_change_date%type;
360: --
361: begin
362: hr_utility.set_location('Entering:'|| l_proc, 10);
363: --