547: --
548: l_dummy VARCHAR2(1);
549: --
550: -- Start of bug 3564129
551: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
552: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
553: -- End of bug 3564129
554: --
555: -- Bug 518669. Increased length of l_col_name from 30 to 200, so it matches
548: l_dummy VARCHAR2(1);
549: --
550: -- Start of bug 3564129
551: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
552: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
553: -- End of bug 3564129
554: --
555: -- Bug 518669. Increased length of l_col_name from 30 to 200, so it matches
556: -- the max len of the column in the DB. Pashun. 16-Sep-97.
2764:
2765: -- Added for the bug 6497082 starts here
2766:
2767: l_assignment_status_type_id number;
2768: l_assignment_status_id irc_assignment_statuses.assignment_status_id%type;
2769: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
2770:
2771: -- Added for the bug 6497082 Ends here
2772:
2765: -- Added for the bug 6497082 starts here
2766:
2767: l_assignment_status_type_id number;
2768: l_assignment_status_id irc_assignment_statuses.assignment_status_id%type;
2769: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
2770:
2771: -- Added for the bug 6497082 Ends here
2772:
2773:
4982: l_rowcount number;
4983:
4984: --fix for bug 6036285 Starts here.
4985: l_assignment_status_type_id number;
4986: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
4987: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
4988:
4989: --fix for bug 6036285 ends here.
4990:
4983:
4984: --fix for bug 6036285 Starts here.
4985: l_assignment_status_type_id number;
4986: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
4987: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
4988:
4989: --fix for bug 6036285 ends here.
4990:
4991: --