1 PACKAGE PQP_FLXDU_COLUMNS_PKG AS
2 /* $Header: pqpflxcol.pkh 120.0 2006/04/26 23:52:37 pbhure noship $ */
3
4 -- =============================================================================
5 -- This procedure loads data into pqp_flxdu_columns table
6 -- If data is already there then update else insert
7 -- =============================================================================
8 PROCEDURE load_row
9 (x_flxdu_column_id IN NUMBER
10 ,x_flxdu_column_name IN VARCHAR2
11 ,x_flxdu_column_xml_tag IN VARCHAR2
12 ,x_flxdu_column_data_type IN VARCHAR2
13 ,x_flxdu_column_data_length IN VARCHAR2
14 ,x_flxdu_seq_num IN NUMBER
15 ,x_flxdu_group_name IN VARCHAR2
16 ,x_entity_type IN VARCHAR2
17 ,x_required_flag IN VARCHAR2
18 ,x_display_flag IN VARCHAR2
19 ,x_description IN VARCHAR2
20 ,x_flxdu_column_xml_data IN VARCHAR2
21 ,x_object_version_number IN NUMBER);
22
23 -- =============================================================================
24 -- This procedure inserts data into pqp_flxdu_columns table
25 -- =============================================================================
26 PROCEDURE insert_row
27 (x_flxdu_column_id IN NUMBER
28 ,x_flxdu_column_name IN VARCHAR2
29 ,x_flxdu_column_xml_tag IN VARCHAR2
30 ,x_flxdu_column_data_type IN VARCHAR2
31 ,x_flxdu_column_data_length IN VARCHAR2
32 ,x_flxdu_seq_num IN NUMBER
33 ,x_flxdu_group_name IN VARCHAR2
34 ,x_entity_type IN VARCHAR2
35 ,x_required_flag IN VARCHAR2
36 ,x_display_flag IN VARCHAR2
37 ,x_description IN VARCHAR2
38 ,x_flxdu_column_xml_data IN VARCHAR2
39 ,x_object_version_number IN NUMBER
40 ,x_created_by IN NUMBER
41 ,x_creation_date IN DATE
42 ,x_last_update_date IN DATE
43 ,x_last_updated_by IN NUMBER
44 ,x_last_update_login IN NUMBER);
45
46 -- =============================================================================
47 -- This procedure updates data in pqp_flxdu_columns table
48 -- =============================================================================
49 PROCEDURE update_row
50 (x_flxdu_column_id IN NUMBER
51 ,x_flxdu_column_name IN VARCHAR2
52 ,x_flxdu_column_xml_tag IN VARCHAR2
53 ,x_flxdu_column_data_type IN VARCHAR2
54 ,x_flxdu_column_data_length IN VARCHAR2
55 ,x_flxdu_seq_num IN NUMBER
56 ,x_flxdu_group_name IN VARCHAR2
57 ,x_entity_type IN VARCHAR2
58 ,x_required_flag IN VARCHAR2
59 ,x_display_flag IN VARCHAR2
60 ,x_description IN VARCHAR2
61 ,x_flxdu_column_xml_data IN VARCHAR2
62 ,x_object_version_number IN NUMBER
63 ,x_created_by IN NUMBER
64 ,x_creation_date IN DATE
65 ,x_last_update_date IN DATE
66 ,x_last_updated_by IN NUMBER
67 ,x_last_update_login IN NUMBER);
68
69 END pqp_flxdu_columns_pkg;