1 PACKAGE ZPB_BUSAREA_VAL AS
2 /* $Header: ZPBVBAVS.pls 120.3 2007/12/04 14:37:44 mbhat noship $ */
3
4
5 ------------------------------------------------------------------------------------------------------
6 /*
7
8 LOCK_OUT_USER
9
10 This procedure updates ZPB_ACCOUNT_STATES.READ_SCOPE
11 WRITE_SCOPE
12 OWNERSHIP
13 setting these columns to 2 (locked) as needed.
14
15 Also inserts the invalid query's name and path details into the ZPB_VALIDATION_TEMP_DATA table for
16 later retrieval in java layer.
17
18 -- p_baId -- Business Area Id
19 -- p_user_id -- User id pulled from query
20 -- p_queryName -- The Invalid Query Object Name
21 -- p_queryPath -- The Invalid Query object path
22 -- p_queryType -- G_READ_RULE,G_WRITE_RULE,G_OWNER_RULE
23 -- p_queryErrorType -- Tells whether the query is to be fixed + marked as Invalid ("F")
24 -- OR Just Refrshed ("R"). "R" only if a dimension has been removed
25 -- -- in which case fixing is not going to work.
26 -- p_init_fix -- Flag to confirm whether MD fixing should be done or not
27 -- We do not fix for real-time validation from UI.
28 */
29 ------------------------------------------------------------------------------------------------------
30 PROCEDURE LOCK_OUT_USER(p_baId IN NUMBER,
31 p_userid IN FND_USER.USER_ID%type,
32 p_queryName IN VARCHAR2,
33 p_queryPath IN ZPB_STATUS_SQL.QUERY_PATH%type,
34 p_queryType IN VARCHAR2,
35 p_queryErrorType IN VARCHAR2,
36 p_init_fix IN VARCHAR2,
37 p_statusSqlId IN ZPB_STATUS_SQL.STATUS_SQL_ID%type);
38
39
40 -------------------------------------------------------------------------
41 -- VAL_AGAINST_EPF - Validates the Business Area version against EPF, to
42 -- ensure all metadata exists and is enabled in EPF
43 --
44 -- IN: p_version_id - The Version ID to validate
45 -- p_init_msg_list - Whether to initialize the message list
46 --
47 -- OUT: x_return_status - The return status
48 -- x_msg_count - The message count
49 -- x_msg_data - The message data
50 -------------------------------------------------------------------------
51 PROCEDURE VAL_AGAINST_EPF (p_version_id IN NUMBER);
52
53 -------------------------------------------------------------------------
54 -- VAL_DEFINITION - Validates the Business Area version against itself, to
55 -- ensure there are no internal inconsistencies
56 --
57 -- IN: p_version_id - The Version ID to validate
58 -- p_init_msg_list - Whether to initialize the message list
59 --
60 -- OUT: x_return_status - The return status
61 -- x_msg_count - The message count
62 -- x_msg_data - The message data
63 -------------------------------------------------------------------------
64 PROCEDURE VAL_DEFINITION (p_version_id IN NUMBER);
65
66 -------------------------------------------------------------------------
67 -- VAL_AGAINST_EPB - Validates the Business Area version against EPB, to
68 -- find any places where EPB will be adversely affected
69 --
70 -- IN: p_version_id - The Version ID to validate
71 -- p_init_msg_list - Whether to initialize the message list
72 --
73 -- OUT: x_return_status - The return status
74 -- x_msg_count - The message count
75 -- x_msg_data - The message data
76 -------------------------------------------------------------------------
77 PROCEDURE VAL_AGAINST_EPB (p_version_id IN NUMBER,
78 p_init_fix IN VARCHAR2 DEFAULT 'N');
79
80 END ZPB_BUSAREA_VAL;