APPS.PER_PYP_INS dependencies on PER_PAY_PROPOSALS

Line 84: -- Insert the row into: per_pay_proposals

80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: per_pyp_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: per_pay_proposals
85: --
86: insert into per_pay_proposals
87: ( pay_proposal_id,
88: assignment_id,

Line 86: insert into per_pay_proposals

82: per_pyp_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: per_pay_proposals
85: --
86: insert into per_pay_proposals
87: ( pay_proposal_id,
88: assignment_id,
89: event_id,
90: business_group_id,

Line 236: Cursor C_Sel1 is select per_pay_proposals_s.nextval from sys.dual;

232: Procedure pre_insert(p_rec in out nocopy per_pyp_shd.g_rec_type) is
233: --
234: l_proc varchar2(72) := g_package||'pre_insert';
235: --
236: Cursor C_Sel1 is select per_pay_proposals_s.nextval from sys.dual;
237: --
238: --
239: cursor c_sel2 is
240: select null

Line 241: from per_pay_proposals

237: --
238: --
239: cursor c_sel2 is
240: select null
241: from per_pay_proposals
242: where pay_proposal_id =
243: per_pyp_ins.g_pay_proposal_id_i;
244: --
245: l_exists varchar2(1);

Line 262: fnd_message.set_token('table_name','per_pay_proposals');

258: --
259: -- the primary key values are already in use.
260: --
261: fnd_message.set_name('per','per_289391_key_already_used');
262: fnd_message.set_token('table_name','per_pay_proposals');
263: fnd_message.raise_error;
264: end if;
265: close c_sel2;
266: --

Line 546: (p_module_name => 'PER_PAY_PROPOSALS'

542:
543: exception
544: when hr_api.cannot_find_prog_unit then
545: hr_api.cannot_find_prog_unit_error
546: (p_module_name => 'PER_PAY_PROPOSALS'
547: ,p_hook_type => 'AI'
548: );
549: end;
550: -- End of API User Hook for post_insert.