1 Package hr_lot_ins as
2 /* $Header: hrlotrhi.pkh 120.0 2005/05/31 01:22:20 appldev noship $ */
3 --
4 -- ------------------------------------------------------------------------
5 -- |-----------------------------< ins_tl >-------------------------------|
6 -- --------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure is the main interface for inserting rows into the
11 -- translated table. It will insert a row into the translated (_TL)
12 -- table for the base language and every installed language.
13 --
14 -- Prerequisites:
15 -- A unique surrogate key ID value has been assigned and a valid row
16 -- has been successfully inserted into the non-translated table.
17 --
18 -- p_business_group_id is included even though the column appears
19 -- on the base table HR_LOCATIONS_ALL. This is stored in an
20 -- efficiency global for use when updating. The parameter is
21 -- required to test the validity of p_location_code
22 --
23 -- In Parameters:
24 -- p_language must be set to the base or any installed language.
25 --
26 -- Post Success:
27 -- A fully validated row will be inserted to the _TL table for the
28 -- base language and every installed language. None of the rows will
29 -- be committed to the database.
30 --
31 -- Post Failure:
32 -- If an error has occurred a pl/sql exception will be raised.
33 --
34 -- Developer Implementation Notes:
35 -- None.
36 --
37 -- Access Status:
38 -- Internal Development Use Only.
39 --
40 -- {End Of Comments}
41 -- ------------------------------------------------------------------------
42 Procedure ins_tl
43 (p_language_code in varchar2,
44 p_location_id in number,
45 p_location_code in varchar2,
46 p_description in varchar2,
47 p_business_group_id in number
48 );
49 --
50 end hr_lot_ins;