1 PACKAGE WSH_DATA_PROTECTION AUTHID CURRENT_USER as
2 /* $Header: WSHUTDPS.pls 115.7 2004/04/30 16:29:55 wrudge ship $ */
3
4 --
5 -- Procedure: Get_Disabled_List
6 --
7 -- Parameters: p_entity_type - type of entity: DLVB, DLVY, DLEG, STOP, TRIP
8 -- p_entity_id - Id for entity
9 -- p_parent_entity_id - Parent Id for entity:
10 -- DLVY is parent for DLVB and DLEG
11 -- TRIP is parent for STOP
12 -- p_entity_status - Status of entity
13 -- p_entity_planned_state - Planned state of entity
14 -- p_list_type - Type of column names to choose
15 -- 'WSHFSTRX' will return STF field names
16 -- unless p_caller is like FTE%
17 -- x_disabled_list - list of disabled columns
18 -- x_return_status - Status of procedure call
19 -- p_caller - identify caller; FTE% will get table column names
20 --
21 -- Description: This procedure will return a list of disabled columns for
22 -- update restrictions on the form, unless the first element
23 -- has the value 'FULL', in which case the list is as below:
24 -- 'FULL' and list count = 1, means all columns need to
25 -- be disabled
26 -- 'FULL' and list count > 1, means all columns except
27 -- the columns that follow are disabled or "entered."
28 -- '+column_name' (i.e., column name marked by '+')
29 -- means that column_name has "Entered" status,
30 -- which is disabled only if the column has a
31 -- non-NULL value (i.e., enabled only if NULL).
32
33
34 PROCEDURE Get_Disabled_List(
35 p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40
41 p_entity_type IN VARCHAR2,
42 p_entity_id IN NUMBER,
43 p_parent_entity_id IN NUMBER DEFAULT NULL,
44 p_list_type IN VARCHAR2,
45 x_disabled_list OUT NOCOPY wsh_util_core.column_tab_type,
46 p_caller IN VARCHAR2 DEFAULT NULL
47 );
48
49 END WSH_DATA_PROTECTION;