1 PACKAGE FF_LOAD_CONTEXTS_PKG as
2 /* $Header: ffconapi.pkh 120.1 2005/09/23 10:37 arashid noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-------------------------< VALIDATE_NAME >--------------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start Of Comments}
7 --
8 -- Description:
9 -- This procedure is called in the FF_CONTEXTS_BRI triggers to validate
10 -- that the inserted context is permitted.
11 --
12 -- Prerequisites:
13 --
14 -- In Parameters:
15 -- p_context_name
16 -- p_data_type
17 --
18 -- Post Success:
19 -- If the context is a permitted context then VALIDATE_NAME allows the
20 -- calling code to continue.
21 --
22 -- Post Failure:
23 -- An exception is raised if the context is not in the list of
24 -- permitted contexts.
25 --
26 -- Developer Implementation Notes:
27 -- Only to be used by the loader.
28 --
29 -- Access Status:
30 -- This is for Oracle internal use only. The body of VALIDATE_NAME may
31 -- only be updated by the Core Payroll team.
32 --
33 -- {End Of Comments}
34 -- ----------------------------------------------------------------------------
35 procedure validate_name
36 (p_context_name in varchar2
37 ,p_data_type in varchar2
38 );
39 -- ----------------------------------------------------------------------------
40 -- |---------------------------< LOAD_ROW >-----------------------------------|
41 -- ----------------------------------------------------------------------------
42 -- {Start Of Comments}
43 --
44 -- Description:
45 -- This procedure is called by the loader for FF_CONTEXTS table data.
46 -- It first tries to update the row, and if no data is found it tries to
47 -- insert the row. This assumes the data was extracted from a database,
48 -- where the validation was performed.
49 --
50 -- Prerequisites:
51 --
52 -- In Parameter:
53 -- p_context_id
54 -- p_context_level
55 -- p_context_name
56 -- p_data_type
57 --
58 --
59 -- Post Success:
60 -- The row is updated, or inserted.
61 --
62 -- Post Failure:
63 -- An Error is raised and processing stops.
64 --
65 -- Developer Implementation Notes:
66 -- Only to be used by the loader.
67 --
68 -- Access Status:
69 -- Only to be used by the loader.
70 --
71 -- {End Of Comments}
72 -- ----------------------------------------------------------------------------
73 Procedure load_row (
74 p_context_name in ff_contexts.context_name%TYPE
75 ,p_context_level in ff_contexts.context_level%TYPE
76 ,p_data_type in ff_contexts.data_type%TYPE);
77 --
78 end FF_LOAD_CONTEXTS_PKG;