DBA Data[Home] [Help]

APPS.PAY_APP_INS dependencies on PAY_AU_PROCESS_PARAMETERS

Line 91: -- Insert the row into: pay_au_process_parameters

87: p_rec.object_version_number := 1; -- Initialise the object version
88: --
89: pay_app_shd.g_api_dml := true; -- Set the api dml status
90: --
91: -- Insert the row into: pay_au_process_parameters
92: --
93: insert into pay_au_process_parameters
94: (process_parameter_id
95: ,process_id

Line 93: insert into pay_au_process_parameters

89: pay_app_shd.g_api_dml := true; -- Set the api dml status
90: --
91: -- Insert the row into: pay_au_process_parameters
92: --
93: insert into pay_au_process_parameters
94: (process_parameter_id
95: ,process_id
96: ,internal_name
97: ,data_type

Line 175: Cursor C_Sel1 is select pay_au_process_parameters_s.nextval from sys.dual;

171: Procedure pre_insert
172: (p_rec in out nocopy pay_app_shd.g_rec_type
173: ) is
174: --
175: Cursor C_Sel1 is select pay_au_process_parameters_s.nextval from sys.dual;
176: --
177: Cursor C_Sel2 is
178: Select null
179: from pay_au_process_parameters

Line 179: from pay_au_process_parameters

175: Cursor C_Sel1 is select pay_au_process_parameters_s.nextval from sys.dual;
176: --
177: Cursor C_Sel2 is
178: Select null
179: from pay_au_process_parameters
180: where process_parameter_id =
181: pay_app_ins.g_process_parameter_id_i;
182: --
183: l_proc varchar2(72);

Line 203: fnd_message.set_token('TABLE_NAME','pay_au_process_parameters');

199: --
200: -- The primary key values are already in use.
201: --
202: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
203: fnd_message.set_token('TABLE_NAME','pay_au_process_parameters');
204: fnd_message.raise_error;
205: End If;
206: Close C_Sel2;
207: --