12: -- Pre-reqs : None.
13: -- Parameters :
14: -- IN : p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
14: -- IN : p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
21: -- p_default_all
22: -- p_type
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
21: -- p_default_all
22: -- p_type
23: -- OUT : x_return_status OUT VARCHAR2(1)
24: -- x_msg_count OUT NUMBER
34: -- End of comments
35:
36: PROCEDURE Get_Valid_Plan_Statuses
37: ( p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_default_all IN VARCHAR2 := FND_API.G_FALSE,
42: p_type IN VARCHAR2 := 'COMPPLANPROCESS',
35:
36: PROCEDURE Get_Valid_Plan_Statuses
37: ( p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_default_all IN VARCHAR2 := FND_API.G_FALSE,
42: p_type IN VARCHAR2 := 'COMPPLANPROCESS',
43: x_values_tab OUT NOCOPY string_tabletype,
36: PROCEDURE Get_Valid_Plan_Statuses
37: ( p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_default_all IN VARCHAR2 := FND_API.G_FALSE,
42: p_type IN VARCHAR2 := 'COMPPLANPROCESS',
43: x_values_tab OUT NOCOPY string_tabletype,
44: x_meanings_tab OUT NOCOPY string_tabletype,
37: ( p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_default_all IN VARCHAR2 := FND_API.G_FALSE,
42: p_type IN VARCHAR2 := 'COMPPLANPROCESS',
43: x_values_tab OUT NOCOPY string_tabletype,
44: x_meanings_tab OUT NOCOPY string_tabletype,
45: x_return_status OUT NOCOPY VARCHAR2 ,
83: -- Pre-reqs : None.
84: -- Parameters :
85: -- IN : p_api_version IN NUMBER Required
86: -- p_init_msg_list IN VARCHAR2 Optional
87: -- Default = FND_API.G_FALSE
88: -- p_commit IN VARCHAR2 Optional
89: -- Default = FND_API.G_FALSE
90: -- p_validation_level IN NUMBER Optional
91: -- Default = FND_API.G_VALID_LEVEL_FULL
85: -- IN : p_api_version IN NUMBER Required
86: -- p_init_msg_list IN VARCHAR2 Optional
87: -- Default = FND_API.G_FALSE
88: -- p_commit IN VARCHAR2 Optional
89: -- Default = FND_API.G_FALSE
90: -- p_validation_level IN NUMBER Optional
91: -- Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_org_code IN VARCHAR2 := NULL,
93: -- p_date IN VARCHAR2,
87: -- Default = FND_API.G_FALSE
88: -- p_commit IN VARCHAR2 Optional
89: -- Default = FND_API.G_FALSE
90: -- p_validation_level IN NUMBER Optional
91: -- Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_org_code IN VARCHAR2 := NULL,
93: -- p_date IN VARCHAR2,
94: -- x_update_groups OUT DBMS_SQL.NUMBER_TABLE,
95: -- x_view_groups OUT DBMS_SQL.NUMBER_TABLE,
106: -- End of comments
107:
108: PROCEDURE Get_All_Groups_Access
109: ( p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: p_org_code IN VARCHAR2 := NULL,
114: p_date IN VARCHAR2,
107:
108: PROCEDURE Get_All_Groups_Access
109: ( p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: p_org_code IN VARCHAR2 := NULL,
114: p_date IN VARCHAR2,
115: x_update_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
108: PROCEDURE Get_All_Groups_Access
109: ( p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: p_org_code IN VARCHAR2 := NULL,
114: p_date IN VARCHAR2,
115: x_update_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
116: x_view_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
126: -- Pre-reqs : None.
127: -- Parameters :
128: -- IN : p_api_version IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional
130: -- Default = FND_API.G_FALSE
131: -- p_commit IN VARCHAR2 Optional
132: -- Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional
134: -- Default = FND_API.G_VALID_LEVEL_FULL
128: -- IN : p_api_version IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional
130: -- Default = FND_API.G_FALSE
131: -- p_commit IN VARCHAR2 Optional
132: -- Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional
134: -- Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_default_all
136: -- p_group_id
130: -- Default = FND_API.G_FALSE
131: -- p_commit IN VARCHAR2 Optional
132: -- Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional
134: -- Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_default_all
136: -- p_group_id
137: -- p_update_groups IN DBMS_SQL.NUMBER_TABLE,
138: -- p_view_groups IN DBMS_SQL.NUMBER_TABLE,
150:
151:
152: PROCEDURE Get_Group_Access
153: ( p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_group_id IN NUMBER,
158: p_update_groups IN DBMS_SQL.NUMBER_TABLE,
151:
152: PROCEDURE Get_Group_Access
153: ( p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_group_id IN NUMBER,
158: p_update_groups IN DBMS_SQL.NUMBER_TABLE,
159: p_view_groups IN DBMS_SQL.NUMBER_TABLE,
152: PROCEDURE Get_Group_Access
153: ( p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_group_id IN NUMBER,
158: p_update_groups IN DBMS_SQL.NUMBER_TABLE,
159: p_view_groups IN DBMS_SQL.NUMBER_TABLE,
160: x_privilege OUT NOCOPY VARCHAR2,