1 PACKAGE FF_LOAD_FTYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: ffftypapi.pkh 115.0 2004/06/25 05:36 sspratur noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |---------------------------< LOAD_ROW >-----------------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start Of Comments}
7 --
8 -- Description:
9 -- This procedure is called by the loader for FF_FORMULA_TYPES table data.
10 -- It first tries to update the row, and if no data is found it tries to
11 -- insert the row. This assumes the data was extracted from a database,
12 -- where the validation was performed.
13 --
14 -- Prerequisites:
15 --
16 -- In Parameter:
17 -- P_FORMULA_TYPE_NAME
18 -- P_TYPE_DESCRIPTION
19 --
20 -- Post Success:
21 -- The row is udtated, or inserted.
22 --
23 -- Post Failure:
24 -- An Error is raised and processing stops.
25 --
26 -- Developer Implementation Notes:
27 -- Only to be used by the loader.
28 --
29 -- Access Status:
30 -- Only to be used by the loader.
31 --
32 -- {End Of Comments}
33 -- ----------------------------------------------------------------------------
34 Procedure load_row (
35 p_formula_type_name in ff_formula_types.formula_type_name%TYPE
36 ,p_type_description in ff_formula_types.type_description%TYPE
37 ) ;
38 --
39 -- ------------------------------------------------------------------------------------------
40 -- |---------------------------< load_row_context_usages >-----------------------------------|
41 -- ------------------------------------------------------------------------------------------
42 -- {Start Of Comments}
43 --
44 -- Description:
45 -- This procedure is called by the loader for FF_FTYPE_CONTEXT_USAGES table.
46 -- It first tries to update the row, and if no data is found it tries to
47 -- insert the row.
48 -- This assumes the data was extracted from a database
49 -- , where the validation was performed.
50 --
51 -- Prerequisites:
52 --
53 -- In Parameter:
54 -- P_FORMULA_TYPE_NAME
55 -- P_CONTEXT_NAME
56 --
57 -- Post Success:
58 -- The row is udtated, or inserted.
59 --
60 -- Post Failure:
61 -- An Error is raised and processing stops.
62 --
63 -- Developer Implementation Notes:
64 -- Only to be used by the loader.
65 --
66 -- Access Status:
67 -- Only to be used by the loader.
68 --
69 -- {End Of Comments}
70 -- ----------------------------------------------------------------------------
71
72 Procedure load_row_context_usages (
73 p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE
74 ,p_context_name in FF_CONTEXTS.context_name%TYPE);
75
76 --
77 end ff_load_ftypes_pkg;