10: l_proc varchar2(72) := g_package||'chk_mandatory_arg';
11: --
12: BEGIN
13: --
14: hr_utility.set_location('Entering:'|| l_proc, 10);
15:
16: if p_argument is null then
17: fnd_message.set_name( 'PAY', 'PAY_75178_NO_DATA' );
18: fnd_message.set_token('VALUE1' , l_proc);
19: fnd_message.set_token('VALUE2' , p_column) ;
20: fnd_message.raise_error;
21: end if;
22:
23: hr_utility.set_location(' Leaving:'|| l_proc, 20);
24: --
25: END chk_mandatory_arg;
26:
27:
47: where upper(short_name) = upper(p_upg_def_short_name);
48: --
49: BEGIN
50: --
51: hr_utility.set_location('Entering:'|| l_proc, 10);
52:
53: -- Check for mandatory arguments.
54:
55: chk_mandatory_arg( p_upg_def_short_name, 'SHORT_NAME' );
86: p_last_update_login,
87: p_created_by,
88: p_creation_date);
89:
90: hr_utility.set_location(' Leaving:'|| l_proc, 20);
91: --
92: END Insert_Row;
93:
94: PROCEDURE Update_Row (
104: l_proc varchar2(100) := g_package || 'Update_Row';
105: --
106: BEGIN
107: --
108: hr_utility.set_location('Entering:'|| l_proc, 10);
109:
110: -- Check for mandatory arguments.
111:
112: chk_mandatory_arg( p_upgrade_definition_id, 'UPGRADE_DEFINITION_ID' );
125: if (sql%notfound) then
126: raise no_data_found;
127: end if;
128:
129: hr_utility.set_location(' Leaving:'|| l_proc, 20);
130: --
131: END Update_Row;
132:
133: PROCEDURE Load_Row (
164: --
165:
166: BEGIN
167: --
168: hr_utility.set_location('Entering:'|| l_proc, 10);
169:
170: if p_owner = 'SEED' then
171: hr_general2.init_fndload
172: (p_resp_appl_id => 801
229: );
230:
231: end if;
232:
233: hr_utility.set_location('Leaving:'|| l_proc, 20);
234: --
235: END Load_Row;
236:
237: END PAY_UPGRADE_PARAMETERS_PKG;