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_OTHERBG_APL_API dependencies on IRC_ASSIGNMENT_STATUSES

Line 67: i_assignment_status_id irc_assignment_statuses.assignment_id%type;

63: l_business_group_id per_all_people_f.business_group_id%TYPE;
64: l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
65: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
66:
67: i_assignment_status_id irc_assignment_statuses.assignment_id%type;
68: i_object_version_number irc_assignment_statuses.object_version_number%type;
69:
70: t_effective_start_date per_all_people_f.effective_start_date%TYPE;
71: t_effective_end_date per_all_people_f.effective_end_date%TYPE;

Line 68: i_object_version_number irc_assignment_statuses.object_version_number%type;

64: l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
65: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
66:
67: i_assignment_status_id irc_assignment_statuses.assignment_id%type;
68: i_object_version_number irc_assignment_statuses.object_version_number%type;
69:
70: t_effective_start_date per_all_people_f.effective_start_date%TYPE;
71: t_effective_end_date per_all_people_f.effective_end_date%TYPE;
72: t_remove_fut_asg_warning BOOLEAN;

Line 410: from irc_assignment_statuses iass

406:
407: cursor irc_asg_status(l_asg_status_type_id
408: per_assignment_status_types.assignment_status_type_id%TYPE) is
409: select iass.assignment_status_id, iass.object_version_number
410: from irc_assignment_statuses iass
411: where iass.assignment_status_id =
412: (select max(iass.assignment_status_id)
413: from irc_assignment_statuses iass
414: where iass.assignment_id = apl_assignment_id

Line 413: from irc_assignment_statuses iass

409: select iass.assignment_status_id, iass.object_version_number
410: from irc_assignment_statuses iass
411: where iass.assignment_status_id =
412: (select max(iass.assignment_status_id)
413: from irc_assignment_statuses iass
414: where iass.assignment_id = apl_assignment_id
415: and iass.assignment_status_type_id = l_asg_status_type_id);
416:
417: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;

Line 418: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;

414: where iass.assignment_id = apl_assignment_id
415: and iass.assignment_status_type_id = l_asg_status_type_id);
416:
417: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
418: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
419: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
420: --- Fix For Bug # 12654541 ---
421:
422: -- bug 12868703

Line 419: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;

415: and iass.assignment_status_type_id = l_asg_status_type_id);
416:
417: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
418: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
419: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
420: --- Fix For Bug # 12654541 ---
421:
422: -- bug 12868703
423: l_apl_bg_id number;