1 Package hr_ort_ins AUTHID CURRENT_USER as
2 /* $Header: hrortrhi.pkh 120.0 2005/05/31 01:52:48 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< set_base_key_value >----------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start of Comments}
8 -- Description:
9 -- This procedure is called to register the next ID value from the database
10 -- sequence.
11 --
12 -- Prerequisites:
13 --
14 -- In Parameters:
15 -- Primary Key
16 --
17 -- Post Success:
18 --
19 -- Post Failure:
20 --
21 -- Developer Implementation Notes:
22 -- None.
23 --
24 -- Access Status:
25 -- Internal Development Use Only.
26 --
27 -- {End of Comments}
28 -- ----------------------------------------------------------------------------
29 procedure set_base_key_value
30 (p_organization_id in number);
31 --
32 -- ----------------------------------------------------------------------------
33 -- |------------------------------< ins_tl >----------------------------------|
34 -- ----------------------------------------------------------------------------
35 --
36 -- {Start of Comments}
37 --
38 -- Description:
39 -- This procedure is the main interface for inserting rows into the
40 -- translated table. It will insert a row into the translated (_TL)
41 -- table for the base language and every installed language.
42 --
43 -- Pre-requisites:
44 -- A unique surrogate key ID value has been assigned and a valid row
45 -- has been successfully inserted into the non-translated table.
46 --
47 -- In Parameters:
48 -- p_language_code must be set to the base or any installed language.
49 --
50 -- Post Success:
51 -- A fully validated row will be inserted into the _TL table for the
52 -- base language and every installed language. None of the rows will
53 -- be committed to the database.
54 --
55 -- Post Failure:
56 -- If an error has occurred a pl/sql exception will be raised.
57 --
58 -- Developer Implementation Notes:
59 -- None.
60 --
61 -- Access Status:
62 -- Internal Development Use Only.
63 --
64 -- {End of Comments}
65 -- ----------------------------------------------------------------------------
66 Procedure ins_tl
67 (p_language_code in varchar2
68 ,p_organization_id in number
69 ,p_name in varchar2
70 );
71 --
72 end hr_ort_ins;