1 package ZX_DET_FACTOR_TEMPL_PKG as
2 /* $Header: zxddetfactors.pls 120.4 2005/03/14 10:25:15 scsharma ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out nocopy VARCHAR2,
6 X_DET_FACTOR_TEMPL_ID in NUMBER,
7 X_DET_FACTOR_TEMPL_CODE in VARCHAR2,
8 X_TAX_REGIME_CODE in VARCHAR2,
9 X_LEDGER_ID in NUMBER,
10 X_CHART_OF_ACCOUNTS_ID in NUMBER,
11 X_Template_Usage_Code in VARCHAR2,
12 X_Record_Type_Code in VARCHAR2,
13 X_REQUEST_ID in NUMBER,
14 X_DET_FACTOR_TEMPL_NAME in VARCHAR2,
15 X_DET_FACTOR_TEMPL_DESC in VARCHAR2,
16 X_CREATION_DATE in DATE,
17 X_CREATED_BY in NUMBER,
18 X_LAST_UPDATE_DATE in DATE,
19 X_LAST_UPDATED_BY in NUMBER,
20 X_LAST_UPDATE_LOGIN in NUMBER,
21 X_PROGRAM_APPLICATION_ID in NUMBER,
22 X_PROGRAM_ID in NUMBER,
23 X_PROGRAM_LOGIN_ID in NUMBER,
24 X_OBJECT_VERSION_NUMBER in NUMBER);
25
26 procedure LOCK_ROW (
27 X_DET_FACTOR_TEMPL_ID in NUMBER,
28 X_DET_FACTOR_TEMPL_CODE in VARCHAR2,
29 X_TAX_REGIME_CODE in VARCHAR2,
30 X_LEDGER_ID in NUMBER,
31 X_CHART_OF_ACCOUNTS_ID in NUMBER,
32 X_Template_Usage_Code in VARCHAR2,
33 X_Record_Type_Code in VARCHAR2,
34 X_REQUEST_ID in NUMBER,
35 X_PROGRAM_APPLICATION_ID in NUMBER,
36 X_PROGRAM_ID in NUMBER,
37 X_PROGRAM_LOGIN_ID in NUMBER,
38 X_DET_FACTOR_TEMPL_NAME in VARCHAR2,
39 X_DET_FACTOR_TEMPL_DESC in VARCHAR2,
40 X_OBJECT_VERSION_NUMBER in NUMBER);
41
42 procedure UPDATE_ROW (
43 X_DET_FACTOR_TEMPL_ID in NUMBER,
44 X_DET_FACTOR_TEMPL_CODE in VARCHAR2,
45 X_TAX_REGIME_CODE in VARCHAR2,
46 X_LEDGER_ID in NUMBER,
47 X_CHART_OF_ACCOUNTS_ID in NUMBER,
48 X_Template_Usage_Code in VARCHAR2,
49 X_Record_Type_Code in VARCHAR2,
50 X_REQUEST_ID in NUMBER,
51 X_DET_FACTOR_TEMPL_NAME in VARCHAR2,
52 X_DET_FACTOR_TEMPL_DESC in VARCHAR2,
53 X_LAST_UPDATE_DATE in DATE,
54 X_LAST_UPDATED_BY in NUMBER,
55 X_LAST_UPDATE_LOGIN in NUMBER,
56 X_PROGRAM_APPLICATION_ID in NUMBER,
57 X_PROGRAM_ID in NUMBER,
58 X_PROGRAM_LOGIN_ID in NUMBER,
59 X_OBJECT_VERSION_NUMBER in NUMBER);
60
61 procedure DELETE_ROW (
62 X_DET_FACTOR_TEMPL_ID in NUMBER);
63
64 procedure ADD_LANGUAGE;
65
66 TYPE T_DET_FACTOR_TEMPL_ID
67 is TABLE of zx_det_factor_templ_b.det_factor_templ_id%type
68 index by binary_integer;
69 TYPE T_DET_FACTOR_TEMPL_CODE
70 is TABLE of zx_det_factor_templ_b.det_factor_templ_code%type
71 index by binary_integer;
72 TYPE T_TAX_REGIME_CODE is TABLE of zx_det_factor_templ_b.tax_regime_code%type
73 index by binary_integer;
74 TYPE T_LEDGER_ID is TABLE of zx_det_factor_templ_b.ledger_id%type
75 index by binary_integer;
76 TYPE T_CHART_OF_ACCOUNTS_ID
77 is TABLE of zx_det_factor_templ_b.chart_of_accounts_id%type
78 index by binary_integer;
79 TYPE T_TEMPLATE_USAGE is TABLE of zx_det_factor_templ_b.Template_Usage_Code%type
80 index by binary_integer;
81 TYPE T_RECORD_TYPE is TABLE of zx_det_factor_templ_b.Record_Type_Code%type
82 index by binary_integer;
83 TYPE T_DET_FACTOR_TEMPL_NAME
84 is TABLE of zx_det_factor_templ_tl.det_factor_templ_name%type
85 index by binary_integer;
86 TYPE T_DET_FACTOR_TEMPL_DESC
87 is TABLE of zx_det_factor_templ_tl.det_factor_templ_desc%type
88 index by binary_integer;
89
90 procedure bulk_insert_det_factor_templ (
91 X_DET_FACTOR_TEMPL_ID IN t_det_factor_templ_id,
92 X_DET_FACTOR_TEMPL_CODE IN t_det_factor_templ_code,
93 X_TAX_REGIME_CODE IN t_tax_regime_code,
94 X_LEDGER_ID IN t_ledger_id,
95 X_CHART_OF_ACCOUNTS_ID IN t_chart_of_accounts_id,
96 X_Template_Usage_Code IN t_template_usage,
97 X_Record_Type_Code IN t_record_type,
98 X_DET_FACTOR_TEMPL_NAME IN t_det_factor_templ_name,
99 X_DET_FACTOR_TEMPL_DESC IN t_det_factor_templ_desc);
100
101 end ZX_DET_FACTOR_TEMPL_PKG;