APPS.IRC_VARIABLE_COMP_ELEMENT_SWI dependencies on IRC_VARIABLE_COMP_ELEMENTS

Line 120: l_object_version_number irc_variable_comp_elements.object_version_number%TYPE;

116: ,p_return_status out nocopy varchar2
117: ) is
118: --
119: --
120: l_object_version_number irc_variable_comp_elements.object_version_number%TYPE;
121: --
122: cursor get_object_version_number(p_vacancy_id irc_variable_comp_elements.vacancy_id%TYPE,
123: p_variable_comp_lookup irc_variable_comp_elements.variable_comp_lookup%TYPE) is
124: select object_version_number

Line 122: cursor get_object_version_number(p_vacancy_id irc_variable_comp_elements.vacancy_id%TYPE,

118: --
119: --
120: l_object_version_number irc_variable_comp_elements.object_version_number%TYPE;
121: --
122: cursor get_object_version_number(p_vacancy_id irc_variable_comp_elements.vacancy_id%TYPE,
123: p_variable_comp_lookup irc_variable_comp_elements.variable_comp_lookup%TYPE) is
124: select object_version_number
125: from irc_variable_comp_elements
126: where vacancy_id = p_vacancy_id

Line 123: p_variable_comp_lookup irc_variable_comp_elements.variable_comp_lookup%TYPE) is

119: --
120: l_object_version_number irc_variable_comp_elements.object_version_number%TYPE;
121: --
122: cursor get_object_version_number(p_vacancy_id irc_variable_comp_elements.vacancy_id%TYPE,
123: p_variable_comp_lookup irc_variable_comp_elements.variable_comp_lookup%TYPE) is
124: select object_version_number
125: from irc_variable_comp_elements
126: where vacancy_id = p_vacancy_id
127: and variable_comp_lookup = p_variable_comp_lookup;

Line 125: from irc_variable_comp_elements

121: --
122: cursor get_object_version_number(p_vacancy_id irc_variable_comp_elements.vacancy_id%TYPE,
123: p_variable_comp_lookup irc_variable_comp_elements.variable_comp_lookup%TYPE) is
124: select object_version_number
125: from irc_variable_comp_elements
126: where vacancy_id = p_vacancy_id
127: and variable_comp_lookup = p_variable_comp_lookup;
128: --
129: -- Variables for API Boolean parameters