1 PACKAGE OTAFRUDT AUTHID CURRENT_USER AS
2 /* $Header: otafrudt.pkh 120.1 2005/06/20 06:36:03 sbairagi noship $ */
3
4 PROCEDURE insert_table_data (P_BUSINESS_GROUP_ID_ITD IN number,
5 P_LEGISLATION_CODE_ITD IN varchar2,
6 P_APPLICATION_ID_ITD IN number,
7 P_RANGE_OR_MATCH_ITD IN varchar2,
8 P_USER_KEY_UNITS_ITD IN varchar2,
9 P_USER_TABLE_NAME_ITD IN varchar2,
10 P_USER_ROW_TITLE_ITD IN varchar2);
11
12 PROCEDURE create_table (P_BUSINESS_GROUP_ID_CT IN number,
13 P_APPLICATION_ID_CT IN number,
14 P_RANGE_OR_MATCH_CT IN varchar2,
15 P_USER_KEY_UNITS_CT IN varchar2,
16 P_USER_TABLE_NAME_CT IN varchar2,
17 P_USER_ROW_TITLE_CT IN varchar2);
18
19 PROCEDURE create_column (P_BUSINESS_GROUP_ID_CC IN number,
20 P_USER_TABLE_NAME_CC IN varchar2,
21 P_USER_COLUMN_NAME_CC IN varchar2);
22
23 PROCEDURE create_row (P_BUSINESS_GROUP_ID_CR IN number,
24 P_USER_TABLE_NAME_CR IN varchar2,
25 P_USER_COLUMN_NAME_CR IN varchar2,
26 P_ROW_LOW_RANGE_OR_NAME_CR IN varchar2,
27 P_DISPLAY_SEQUENCE_CR IN number,
28 P_VALUE_CR IN varchar2);
29
30 PROCEDURE create_from_lookup (P_BUSINESS_GROUP_ID IN varchar2,
31 P_REQUIRED_DEFAULTS IN varchar2,
32 P_DEFAULT_VALUE IN varchar2,
33 P_LOOKUP_TYPE IN varchar2,
34 P_USER_COLUMN_NAME IN varchar2,
35 P_USER_KEY_UNITS IN varchar2);
36
37 procedure load_alternate_lookup (l_business_group_id in number);
38
39 END OTAFRUDT;