DBA Data[Home] [Help]

APPS.PAY_PTA_INS dependencies on PAY_DATED_TABLES

Line 65: -- Insert the row into: pay_dated_tables

61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: --
64: --
65: -- Insert the row into: pay_dated_tables
66: --
67: insert into pay_dated_tables
68: (dated_table_id
69: ,table_name

Line 67: insert into pay_dated_tables

63: --
64: --
65: -- Insert the row into: pay_dated_tables
66: --
67: insert into pay_dated_tables
68: (dated_table_id
69: ,table_name
70: ,application_id
71: ,surrogate_key_name

Line 163: Cursor C_Sel1 is select pay_dated_tables_s.nextval from sys.dual;

159: ) is
160: --
161: l_proc varchar2(72) := g_package||'pre_insert';
162: --
163: Cursor C_Sel1 is select pay_dated_tables_s.nextval from sys.dual;
164: --
165: Cursor C_Sel2 is select application_id
166: from fnd_tables where table_name = p_rec.table_name;
167: Begin

Line 260: (p_module_name => 'PAY_DATED_TABLES'

256: --
257: when hr_api.cannot_find_prog_unit then
258: --
259: hr_api.cannot_find_prog_unit_error
260: (p_module_name => 'PAY_DATED_TABLES'
261: ,p_hook_type => 'AI');
262: --
263: end;
264: --