1 PACKAGE IEC_RLCTRL_PUB AUTHID CURRENT_USER AS
2 /* $Header: IECRCPBS.pls 115.8 2004/05/18 20:28:08 minwang noship $ */
3
4 -- Start of comments
5 -- Procedure : MakeListEntriesAvailable
6 -- Type : Public API
7 -- Usage : Makes list entries with specified do not use reason available by setting
8 -- the DO_NOT_USE_FLAG to 'N' in both IEC_G_RETURN_ENTRIES and
9 -- AMS_LIST_ENTRIES.
10 -- Pre-reqs : None
11 --
12 -- Standard IN Parameters:
13 -- p_api_version IN NUMBER Required
14 -- p_init_msg_list IN VARCHAR2(1) Required
15 -- FND_API.G_FALSE or FND_API.G_TRUE
16 -- p_commit IN VARCHAR2(1) Required
17 -- FND_API.G_FALSE or FND_API.G_TRUE
18 --
19 -- Standard OUT Parameters:
20 -- x_return_status OUT VARCHAR2(1)
21 -- x_msg_count OUT NUMBER
22 -- x_msg_data OUT VARCHAR2(2000)
23 --
24 -- Oher IN Parameters:
25 -- p_resp_appl_id IN NUMBER Optional(1)
26 -- Application identifier
27 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
28 -- p_resp_id IN NUMBER Optional(1)
29 -- Responsibility identifier
30 -- Default = FND_GLOBAL.RESP_ID or NULL
31 -- p_user_id IN NUMBER Optional(1)
32 -- Corresponds to the column USER_ID in the table
33 -- FND_USER, and identifies the Oracle
34 -- Applications user
35 -- Default = FND_GLOBAL.USER_ID
36 -- p_login_id IN NUMBER Optional
37 -- Corresponds to the column LOGIN_ID in the
38 -- table FND_LOGINS, and identifies the login session
39 -- Default = FND_GLOBAL.LOGIN_ID or NULL
40 -- p_list_header_id IN NUMBER Required
41 -- p_dnu_reason_code IN NUMBER Required
42 --
43 -- Version : Initial version 1.0
44 --
45 -- Notes :
46 -- (1) The application ID, responsibility ID, and user ID determine which
47 -- profile values are used as default.
48 --
49 -- End of comments
50
51
52 PROCEDURE MakeListEntriesAvailable
53 (
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2,
56 p_commit IN VARCHAR2,
57 p_resp_appl_id IN NUMBER DEFAULT NULL,
58 p_resp_id IN NUMBER DEFAULT NULL,
59 p_user_id IN NUMBER,
60 p_login_id IN NUMBER DEFAULT NULL,
61 x_return_status IN OUT NOCOPY VARCHAR2,
62 x_msg_count IN OUT NOCOPY NUMBER,
63 x_msg_data IN OUT NOCOPY VARCHAR2,
64 p_list_header_id IN NUMBER,
65 p_dnu_reason_code IN NUMBER
66 );
67
68 -- Start of comments
69 -- Procedure : MakeListEntriesAvailable
70 -- Type : Public API
71 -- Usage : Makes list entries for specified list available (regardless of do not use reason)
72 -- by setting the DO_NOT_USE_FLAG to 'N' in both IEC_G_RETURN_ENTRIES and
73 -- AMS_LIST_ENTRIES.
74 -- Pre-reqs : None
75 --
76 -- Standard IN Parameters:
77 -- p_api_version IN NUMBER Required
78 -- p_init_msg_list IN VARCHAR2(1) Required
79 -- FND_API.G_FALSE or FND_API.G_TRUE
80 -- p_commit IN VARCHAR2(1) Required
81 -- FND_API.G_FALSE or FND_API.G_TRUE
82 --
83 -- Standard OUT Parameters:
84 -- x_return_status OUT VARCHAR2(1)
85 -- x_msg_count OUT NUMBER
86 -- x_msg_data OUT VARCHAR2(2000)
87 --
88 -- Oher IN Parameters:
89 -- p_resp_appl_id IN NUMBER Optional(1)
90 -- Application identifier
91 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
92 -- p_resp_id IN NUMBER Optional(1)
93 -- Responsibility identifier
94 -- Default = FND_GLOBAL.RESP_ID or NULL
95 -- p_user_id IN NUMBER Optional(1)
96 -- Corresponds to the column USER_ID in the table
97 -- FND_USER, and identifies the Oracle
98 -- Applications user
99 -- Default = FND_GLOBAL.USER_ID
100 -- p_login_id IN NUMBER Optional
101 -- Corresponds to the column LOGIN_ID in the
102 -- table FND_LOGINS, and identifies the login session
103 -- Default = FND_GLOBAL.LOGIN_ID or NULL
104 -- p_list_header_id IN NUMBER Required
105 --
106 -- Version : Initial version 1.0
107 --
108 -- Notes :
109 -- (1) The application ID, responsibility ID, and user ID determine which
110 -- profile values are used as default.
111 --
112 -- End of comments
113
114
115 PROCEDURE MakeListEntriesAvailable
116 (
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2,
119 p_commit IN VARCHAR2,
120 p_resp_appl_id IN NUMBER DEFAULT NULL,
121 p_resp_id IN NUMBER DEFAULT NULL,
122 p_user_id IN NUMBER,
123 p_login_id IN NUMBER DEFAULT NULL,
124 x_return_status IN OUT NOCOPY VARCHAR2,
125 x_msg_count IN OUT NOCOPY NUMBER,
126 x_msg_data IN OUT NOCOPY VARCHAR2,
127 p_list_header_id IN NUMBER
128 );
129
130
131 END IEC_RLCTRL_PUB;