APPS.PAY_UPGRADE_PARAMETERS_PKG dependencies on PAY_UPGRADE_DEFINITIONS

Line 40: l_upgrade_definition_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;

36: ,P_CREATION_DATE in DATE
37:
38: ) is
39: --
40: l_upgrade_definition_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;
41: l_exists varchar2(1);
42: l_proc varchar2(100) := g_package || 'Insert_Row';
43:
44: cursor csr_exists is

Line 46: from pay_upgrade_definitions

42: l_proc varchar2(100) := g_package || 'Insert_Row';
43:
44: cursor csr_exists is
45: select upgrade_definition_id
46: from pay_upgrade_definitions
47: where upper(short_name) = upper(p_upg_def_short_name);
48: --
49: BEGIN
50: --

Line 141: l_upgrade_def_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;

137: , P_OWNER in VARCHAR2
138: ) is
139: --
140: l_proc varchar2(100) := g_package || 'Load_Row';
141: l_upgrade_def_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;
142:
143: l_sysdate date := sysdate;
144: l_created_by PAY_UPGRADE_PARAMETERS.CREATED_BY%TYPE;
145: l_creation_date PAY_UPGRADE_PARAMETERS.CREATION_DATE%TYPE;

Line 153: from pay_upgrade_definitions

149:
150:
151: cursor csr_existing_upd_def is
152: select upgrade_definition_id
153: from pay_upgrade_definitions
154: where upper(short_name) = upper(p_short_name) ;
155:
156: cursor csr_existing_upd_param(p_def_id in varchar2) is
157: select null