APPS.HRHIRAPL dependencies on IRC_ASSIGNMENT_STATUSES

Line 528: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;

524: --
525: l_dummy VARCHAR2(1);
526: --
527: -- Start of bug 3564129
528: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
529: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
530: -- End of bug 3564129
531: --
532: -- Bug 518669. Increased length of l_col_name from 30 to 200, so it matches

Line 529: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;

525: l_dummy VARCHAR2(1);
526: --
527: -- Start of bug 3564129
528: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
529: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
530: -- End of bug 3564129
531: --
532: -- Bug 518669. Increased length of l_col_name from 30 to 200, so it matches
533: -- the max len of the column in the DB. Pashun. 16-Sep-97.

Line 2664: l_assignment_status_id irc_assignment_statuses.assignment_status_id%type;

2660:
2661: -- Added for the bug 6497082 starts here
2662:
2663: l_assignment_status_type_id number;
2664: l_assignment_status_id irc_assignment_statuses.assignment_status_id%type;
2665: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
2666:
2667: -- Added for the bug 6497082 Ends here
2668:

Line 2665: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;

2661: -- Added for the bug 6497082 starts here
2662:
2663: l_assignment_status_type_id number;
2664: l_assignment_status_id irc_assignment_statuses.assignment_status_id%type;
2665: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
2666:
2667: -- Added for the bug 6497082 Ends here
2668:
2669:

Line 4381: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;

4377: l_rowcount number;
4378:
4379: --fix for bug 6036285 Starts here.
4380: l_assignment_status_type_id number;
4381: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
4382: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
4383:
4384: --fix for bug 6036285 ends here.
4385:

Line 4382: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;

4378:
4379: --fix for bug 6036285 Starts here.
4380: l_assignment_status_type_id number;
4381: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
4382: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
4383:
4384: --fix for bug 6036285 ends here.
4385:
4386: --