APPS.PAY_CORE_UTILS dependencies on PAY_UPGRADE_STATUS

Line 2004: l_status pay_upgrade_status.status%type;

2000: l_upgrade_level pay_upgrade_definitions.upgrade_level%type;
2001: l_failure_point pay_upgrade_definitions.failure_point%type;
2002: l_legislatively_enabled pay_upgrade_definitions.legislatively_enabled%type;
2003: l_bg_leg_code per_business_groups.legislation_code%type;
2004: l_status pay_upgrade_status.status%type;
2005: l_upgrade_status pay_upgrade_status.status%type;
2006: l_check_upgrade boolean;
2007: l_dummy number;
2008: --

Line 2005: l_upgrade_status pay_upgrade_status.status%type;

2001: l_failure_point pay_upgrade_definitions.failure_point%type;
2002: l_legislatively_enabled pay_upgrade_definitions.legislatively_enabled%type;
2003: l_bg_leg_code per_business_groups.legislation_code%type;
2004: l_status pay_upgrade_status.status%type;
2005: l_upgrade_status pay_upgrade_status.status%type;
2006: l_check_upgrade boolean;
2007: l_dummy number;
2008: --
2009: begin

Line 2096: from pay_upgrade_status pus

2092: begin
2093: --
2094: select pus.status
2095: into l_upgrade_status
2096: from pay_upgrade_status pus
2097: where pus.upgrade_definition_id = l_upgrade_definition_id
2098: and pus.business_group_id = p_bus_grp_id;
2099: --
2100: if (l_upgrade_status = 'C') then

Line 2135: from pay_upgrade_status pus

2131: begin
2132: --
2133: select pus.status
2134: into l_upgrade_status
2135: from pay_upgrade_status pus
2136: where pus.upgrade_definition_id = l_upgrade_definition_id
2137: and pus.legislation_code = l_bg_leg_code;
2138: --
2139: if (l_upgrade_status = 'C') then

Line 2174: from pay_upgrade_status pus

2170: begin
2171: --
2172: select pus.status
2173: into l_upgrade_status
2174: from pay_upgrade_status pus
2175: where pus.upgrade_definition_id = l_upgrade_definition_id
2176: and pus.legislation_code is null
2177: and pus.business_group_id is null;
2178: --

Line 2237: l_status pay_upgrade_status.status%type;

2233: p_bus_grp_id in number,
2234: p_short_name in varchar2,
2235: p_raise_error in varchar2 default 'TRUE') return varchar2
2236: is
2237: l_status pay_upgrade_status.status%type;
2238: begin
2239: get_upgrade_status(
2240: p_bus_grp_id => p_bus_grp_id,
2241: p_short_name => p_short_name,