DBA Data[Home] [Help]

PACKAGE: APPS.IRC_IDT_INS

Source


1 Package irc_idt_ins as
2 /* $Header: iridtrhi.pkh 120.0 2005/07/26 15:07:32 mbocutt noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------------< ins_tl >----------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- {Start of Comments}
9 --
10 -- Description:
11 --   This procedure is the main interface for inserting rows into the
12 --   translated table.  It will insert a row into the translated (_TL)
13 --   table for the base language and every installed language.
14 --
15 -- Pre-requisites:
16 --   A unique surrogate key ID value has been assigned and a valid row
17 --   has been successfully inserted into the non-translated table.
18 --
19 -- In Parameters:
20 --   p_language_code must be set to the base or any installed language.
21 --
22 -- Post Success:
23 --   A fully validated row will be inserted into the _TL table for the
24 --   base language and every installed language.  None of the rows will
25 --   be committed to the database.
26 --
27 -- Post Failure:
28 --   If an error has occurred a pl/sql exception will be raised.
29 --
30 -- Developer Implementation Notes:
31 --   None.
32 --
33 -- Access Status:
34 --   Internal Development Use Only.
35 --
36 -- {End of Comments}
37 -- ----------------------------------------------------------------------------
38 Procedure ins_tl
39   (p_language_code                in varchar2
40   ,p_default_posting_id           in number
41   ,p_org_name                     in varchar2 default null
42   ,p_org_description              in varchar2 default null
43   ,p_job_title                    in varchar2 default null
44   ,p_brief_description            in varchar2 default null
45   ,p_detailed_description         in varchar2 default null
46   ,p_job_requirements             in varchar2 default null
47   ,p_additional_details           in varchar2 default null
48   ,p_how_to_apply                 in varchar2 default null
49   ,p_image_url                    in varchar2 default null
50   ,p_image_url_alt                in varchar2 default null
51   );
52 --
53 end irc_idt_ins;