1 PACKAGE PO_UDA_IMPORT_PKG AUTHID CURRENT_USER AS
2 /* $Header: PO_UDA_IMPORT_PKG.pls 120.4.12020000.2 2013/02/10 18:07:56 vegajula ship $ */
3
4 PROCEDURE POPULATE_STRUCTURES
5 (
6 p_transaction_id IN NUMBER DEFAULT NULL
7 ,p_attr_grp_type IN VARCHAR2
8 ,p_pk1_value IN NUMBER
9 ,p_pk2_value IN NUMBER
10 ,p_pk3_value IN NUMBER
11 ,p_pk4_value IN NUMBER
12 ,p_pk5_value IN NUMBER
13 ,x_base_object_name IN OUT NOCOPY VARCHAR2
14 ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
15 ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
16 ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
17 ,x_class_code_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
18 ,x_return_status OUT NOCOPY VARCHAR2
19 ,x_errorcode OUT NOCOPY NUMBER
20 ,x_msg_count OUT NOCOPY NUMBER
21 ,x_msg_data OUT NOCOPY VARCHAR2
22 );
23
24 PROCEDURE POPULATE_REMAINING_ATTRIBUTES
25 (
26 x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
27 ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
28 ,x_return_status OUT NOCOPY VARCHAR2
29 ,x_errorcode OUT NOCOPY NUMBER
30 ,x_msg_count OUT NOCOPY NUMBER
31 ,x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE POPULATE_EMPTY_AGS
35 (
36 p_template_id IN NUMBER
37 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
38 ,p_external_attr_value_pairs IN EGO_COL_NAME_VALUE_PAIR_TABLE
39 ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
40 ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
41 ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
42 ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
43 ,x_return_status OUT NOCOPY VARCHAR2
44 ,x_errorcode OUT NOCOPY NUMBER
45 ,x_msg_count OUT NOCOPY NUMBER
46 ,x_msg_data OUT NOCOPY VARCHAR2
47 );
48
49 PROCEDURE EXECUTE_IMPORT_UDA_FUNCTION
50 (
51 p_template_id IN NUMBER
52 ,p_event IN VARCHAR2
53 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
54 ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
55 ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
56 ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_errorcode OUT NOCOPY NUMBER
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2
61 );
62
63 PROCEDURE IMPORT_UDA_ATTRS
64 (
65 p_attr_grp_type IN VARCHAR2
66 ,p_pk1_value IN NUMBER
67 ,p_pk2_value IN NUMBER DEFAULT NULL
68 ,p_pk3_value IN NUMBER DEFAULT NULL
69 ,p_pk4_value IN NUMBER DEFAULT NULL
70 ,p_pk5_value IN NUMBER DEFAULT NULL
71 ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
72 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
73 ,x_return_status OUT NOCOPY VARCHAR2
74 ,x_errorcode OUT NOCOPY NUMBER
75 ,x_msg_count OUT NOCOPY NUMBER
76 ,x_msg_data OUT NOCOPY VARCHAR2
77 ,p_commit_flag IN VARCHAR2 DEFAULT 'Y' --CLM Release4
78 ,p_transaction_id IN NUMBER DEFAULT NULL
79 );
80
81 PROCEDURE HANDLE_ERROR
82 (
83 p_msg IN VARCHAR2
84 ,p_msg_code IN VARCHAR2
85 ,p_attr_grp_id IN NUMBER
86 );
87
88 PROCEDURE UPDATE_STATUS
89 (
90 p_process_status IN NUMBER
91 ,p_pre_process_status IN NUMBER
92 ,p_process_phase IN VARCHAR2
93 ,p_pk1_value IN NUMBER
94 ,p_pk2_value IN NUMBER
95 ,p_pk3_value IN NUMBER
96 ,p_pk4_value IN NUMBER
97 ,p_pk5_value IN NUMBER
98 );
99
100 PROCEDURE TRANSFER_UDA_DATA
101 (
102 p_header_id IN NUMBER,
103 p_draft_id IN NUMBER,
104 p_attr_display_name_list IN po_tbl_varchar100 default NULL,
105 p_transaction_id IN NUMBER
106 );
107
108 END PO_UDA_IMPORT_PKG;