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_ASSIGNMENT_DETAILS_API dependencies on IRC_ASSIGNMENT_DETAILS_F

Line 28: l_latest_details irc_assignment_details_f.latest_details%TYPE;

24: ) is
25: --
26: -- Declare cursors and local variables
27: --
28: l_latest_details irc_assignment_details_f.latest_details%TYPE;
29: -- out variables
30: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;
31: l_details_version irc_assignment_details_f.details_version%TYPE;
32: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;

Line 30: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;

26: -- Declare cursors and local variables
27: --
28: l_latest_details irc_assignment_details_f.latest_details%TYPE;
29: -- out variables
30: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;
31: l_details_version irc_assignment_details_f.details_version%TYPE;
32: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;
33: l_effective_end_date irc_assignment_details_f.effective_end_date%TYPE;
34: l_object_version_number irc_assignment_details_f.object_version_number%TYPE;

Line 31: l_details_version irc_assignment_details_f.details_version%TYPE;

27: --
28: l_latest_details irc_assignment_details_f.latest_details%TYPE;
29: -- out variables
30: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;
31: l_details_version irc_assignment_details_f.details_version%TYPE;
32: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;
33: l_effective_end_date irc_assignment_details_f.effective_end_date%TYPE;
34: l_object_version_number irc_assignment_details_f.object_version_number%TYPE;
35:

Line 32: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;

28: l_latest_details irc_assignment_details_f.latest_details%TYPE;
29: -- out variables
30: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;
31: l_details_version irc_assignment_details_f.details_version%TYPE;
32: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;
33: l_effective_end_date irc_assignment_details_f.effective_end_date%TYPE;
34: l_object_version_number irc_assignment_details_f.object_version_number%TYPE;
35:
36: l_effective_date date;

Line 33: l_effective_end_date irc_assignment_details_f.effective_end_date%TYPE;

29: -- out variables
30: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;
31: l_details_version irc_assignment_details_f.details_version%TYPE;
32: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;
33: l_effective_end_date irc_assignment_details_f.effective_end_date%TYPE;
34: l_object_version_number irc_assignment_details_f.object_version_number%TYPE;
35:
36: l_effective_date date;
37: l_proc varchar2(72) := g_package||'create_assignment_details';

Line 34: l_object_version_number irc_assignment_details_f.object_version_number%TYPE;

30: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;
31: l_details_version irc_assignment_details_f.details_version%TYPE;
32: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;
33: l_effective_end_date irc_assignment_details_f.effective_end_date%TYPE;
34: l_object_version_number irc_assignment_details_f.object_version_number%TYPE;
35:
36: l_effective_date date;
37: l_proc varchar2(72) := g_package||'create_assignment_details';
38: l_considered varchar2(30);

Line 196: l_latest_details irc_assignment_details_f.latest_details%TYPE;

192: ) is
193: --
194: -- Declare cursors and local variables
195: --
196: l_latest_details irc_assignment_details_f.latest_details%TYPE;
197: -- out variables
198: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;
199: l_details_version irc_assignment_details_f.details_version%TYPE;
200: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;

Line 198: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;

194: -- Declare cursors and local variables
195: --
196: l_latest_details irc_assignment_details_f.latest_details%TYPE;
197: -- out variables
198: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;
199: l_details_version irc_assignment_details_f.details_version%TYPE;
200: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;
201: l_effective_end_date irc_assignment_details_f.effective_end_date%TYPE;
202: l_object_version_number irc_assignment_details_f.object_version_number%TYPE;

Line 199: l_details_version irc_assignment_details_f.details_version%TYPE;

195: --
196: l_latest_details irc_assignment_details_f.latest_details%TYPE;
197: -- out variables
198: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;
199: l_details_version irc_assignment_details_f.details_version%TYPE;
200: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;
201: l_effective_end_date irc_assignment_details_f.effective_end_date%TYPE;
202: l_object_version_number irc_assignment_details_f.object_version_number%TYPE;
203:

Line 200: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;

196: l_latest_details irc_assignment_details_f.latest_details%TYPE;
197: -- out variables
198: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;
199: l_details_version irc_assignment_details_f.details_version%TYPE;
200: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;
201: l_effective_end_date irc_assignment_details_f.effective_end_date%TYPE;
202: l_object_version_number irc_assignment_details_f.object_version_number%TYPE;
203:
204: l_effective_date date;

Line 201: l_effective_end_date irc_assignment_details_f.effective_end_date%TYPE;

197: -- out variables
198: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;
199: l_details_version irc_assignment_details_f.details_version%TYPE;
200: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;
201: l_effective_end_date irc_assignment_details_f.effective_end_date%TYPE;
202: l_object_version_number irc_assignment_details_f.object_version_number%TYPE;
203:
204: l_effective_date date;
205: l_proc varchar2(72) := g_package||'update_assignment_details';

Line 202: l_object_version_number irc_assignment_details_f.object_version_number%TYPE;

198: l_assignment_details_id irc_assignment_details_f.assignment_details_id%TYPE;
199: l_details_version irc_assignment_details_f.details_version%TYPE;
200: l_effective_start_date irc_assignment_details_f.effective_start_date%TYPE;
201: l_effective_end_date irc_assignment_details_f.effective_end_date%TYPE;
202: l_object_version_number irc_assignment_details_f.object_version_number%TYPE;
203:
204: l_effective_date date;
205: l_proc varchar2(72) := g_package||'update_assignment_details';
206: l_considered varchar2(30);

Line 367: l_assignment_details_id irc_assignment_details_f.assignment_details_id%type;

363: -- Declare cursors and local variables
364: --
365: l_proc varchar2(72) := g_package||'copy_assignment_details';
366: --
367: l_assignment_details_id irc_assignment_details_f.assignment_details_id%type;
368: --
369: cursor csr_assignment_details is
370: select *
371: from irc_assignment_details_f

Line 371: from irc_assignment_details_f

367: l_assignment_details_id irc_assignment_details_f.assignment_details_id%type;
368: --
369: cursor csr_assignment_details is
370: select *
371: from irc_assignment_details_f
372: where assignment_id = p_source_assignment_id;
373: --
374: Cursor C_Sel1 is select irc_assignment_details_s.nextval from sys.dual;
375: --

Line 394: insert into irc_assignment_details_f

390: Open C_Sel1;
391: Fetch C_Sel1 Into l_assignment_details_id;
392: Close C_Sel1;
393: --
394: insert into irc_assignment_details_f
395: (assignment_details_id
396: ,assignment_id
397: ,effective_start_date
398: ,effective_end_date