32: l_request_id number := null;
33:
34: l_sql_stmt varchar2(250);
35:
36: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
37: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
38: l_upg_mthd pay_upgrade_definitions.upgrade_method%type;
39:
40: /*
33:
34: l_sql_stmt varchar2(250);
35:
36: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
37: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
38: l_upg_mthd pay_upgrade_definitions.upgrade_method%type;
39:
40: /*
41: ** Local variables for use by get_request_status
34: l_sql_stmt varchar2(250);
35:
36: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
37: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
38: l_upg_mthd pay_upgrade_definitions.upgrade_method%type;
39:
40: /*
41: ** Local variables for use by get_request_status
42: */
60: cursor csr_get_update_details is
61: select upgrade_definition_id,
62: upgrade_level,
63: upgrade_method
64: from pay_upgrade_definitions
65: where short_name = p_update_name;
66:
67: /*
68: ** This cursor is used to get the status of a GUP
316:
317: cursor csr_get_update_details is
318: select upgrade_definition_id,
319: upgrade_level
320: from pay_upgrade_definitions
321: where short_name = p_update_name;
322:
323: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
324: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
319: upgrade_level
320: from pay_upgrade_definitions
321: where short_name = p_update_name;
322:
323: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
324: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
325:
326: begin
327:
320: from pay_upgrade_definitions
321: where short_name = p_update_name;
322:
323: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
324: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
325:
326: begin
327:
328:
353:
354: cursor csr_get_update_details is
355: select upgrade_definition_id,
356: upgrade_level
357: from pay_upgrade_definitions
358: where short_name = p_update_name;
359:
360: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
361: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
356: upgrade_level
357: from pay_upgrade_definitions
358: where short_name = p_update_name;
359:
360: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
361: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
362:
363: begin
364:
357: from pay_upgrade_definitions
358: where short_name = p_update_name;
359:
360: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
361: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
362:
363: begin
364:
365: