1 PACKAGE EGO_CHANGE_USER_ATTRS_PUB AUTHID CURRENT_USER AS
2 /* $Header: EGOCHUAS.pls 115.3 2003/07/29 05:07:56 akumar noship $ */
3
4
5
6 ----------------------
7 -- Global Variables --
8 ----------------------
9
10 /*
11 * PROCESS_STATUS constants
12 * ------------------------
13 * The following constants are used in the
14 * EGO_ITEM_USER_ATTRS_INTERFACE.PROCESS_STATUS column to describe the processing
15 * status of each row.
16 * G_PS_TO_BE_PROCESSED: *used by the caller* indicates that a row should be
17 * processed
18 * G_PS_IN_PROCESS: *used by the bulkloader* indicates that a row is being
19 * processed
20 * G_PS_ERROR: *used by the bulkloader* indicates that a row encountered an error
21 * (NOTE: the error may have occurred in another interface table row with the same
22 * ROW_IDENTIFIER column value, because all interface table rows with the
23 * same ROW_IDENTIFIER column value are processed as one logical unit)
24 * G_PS_SUCCESS: *used by the bulkloader* indicates that a row was succcessfully
25 * loaded
26 */
27
28 G_PS_TO_BE_PROCESSED CONSTANT NUMBER := 1;
29 G_PS_IN_PROCESS CONSTANT NUMBER := 2;
30 G_PS_ERROR CONSTANT NUMBER := 3;
31 G_PS_SUCCESS CONSTANT NUMBER := 4;
32
33
34
35 ----------------
36 -- Procedures --
37 ----------------
38
39 /*
40 * Process_Item_User_Attrs_Data : Used by Import Process
41 * ----------------------------
42 * This procedure processes all interface table rows
43 * corresponding to the passed-in data set ID. ERRBUF and RETCODE are standard
44 * parameters for concurrent programs, and we ignore them.
45 * p_debug_level: number from 0-3, with 0 for no debug
46 * information and 3 for exhaustive debugs
47 * p_purge_successful_lines: 'T' or 'F', indicating
48 * whether or not to delete all rows in this data set
49 * that are successfully processed
50 */
51 PROCEDURE Process_Change_User_Attrs_Data
52 (
53 ERRBUF OUT NOCOPY VARCHAR2
54 ,RETCODE OUT NOCOPY VARCHAR2
55 ,p_data_set_id IN NUMBER
56 ,p_debug_level IN NUMBER DEFAULT 0
57 ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE
58 );
59
60
61
62
63 /*
64 * Get_Current_Data_Set_Id
65 * -----------------------
66 * (For use by SQL*Loader control file only)
67 */
68 FUNCTION Get_Current_Data_Set_Id
69 RETURN NUMBER;
70
71 /*
72 * Process_Change_User_Attrs : Public API to be called for immediate
73 * processing Change header user attributes
74 */
75 PROCEDURE Process_Change_User_Attrs
76 (
77 p_api_version IN NUMBER := 1.0
78 , p_init_msg_list IN BOOLEAN := FALSE
79 , x_return_status OUT NOCOPY VARCHAR2
80 , x_msg_count OUT NOCOPY NUMBER
81 , p_bo_identifier IN VARCHAR2 := 'ECO'
82 ,p_change_number IN VARCHAR2
83 ,p_change_mgmt_type_code IN VARCHAR2
84 ,p_Organization_Code IN VARCHAR2
85 ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
86 ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
87 , p_debug IN VARCHAR2 := 'N'
88 , p_output_dir IN VARCHAR2 := NULL
89 , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'
90 );
91
92 /*
93 * Process_Change_Line_User_Attrs : Public API to be called for immediate
94 * processing Change line user attributes
95 */
96 PROCEDURE Process_Change_Line_User_Attrs
97 (
98 p_api_version IN NUMBER := 1.0
99 , p_init_msg_list IN BOOLEAN := FALSE
100 , x_return_status OUT NOCOPY VARCHAR2
101 , x_msg_count OUT NOCOPY NUMBER
102 , p_bo_identifier IN VARCHAR2 := 'ECO'
103 ,p_change_number IN VARCHAR2
104 ,p_change_mgmt_type_code IN VARCHAR2
105 ,p_Organization_Code IN VARCHAR2
106 ,p_change_line_sequence_number IN NUMBER
107 ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
108 ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
109 , p_debug IN VARCHAR2 := 'N'
110 , p_output_dir IN VARCHAR2 := NULL
111 , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'
112 );
113 --Begin of Bug:3070807
114
115 PROCEDURE Check_Delete_Associations
116 (
117 p_api_version IN NUMBER
118 ,p_association_id IN NUMBER
119 ,p_classification_code IN VARCHAR2
120 ,p_data_level IN VARCHAR2
121 ,p_attr_group_id IN NUMBER
122 ,p_application_id IN NUMBER
123 ,p_attr_group_type IN VARCHAR2
124 ,p_attr_group_name IN VARCHAR2
125 ,p_enabled_code IN VARCHAR2
126 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
127 ,x_ok_to_delete OUT NOCOPY VARCHAR2
128 ,x_return_status OUT NOCOPY VARCHAR2
129 ,x_errorcode OUT NOCOPY NUMBER
130 ,x_msg_count OUT NOCOPY NUMBER
131 ,x_msg_data OUT NOCOPY VARCHAR2
132 );
133 --End of Bug:3070807
134 END EGO_CHANGE_USER_ATTRS_PUB;
135