1 PACKAGE IEC_AORECDNU_PUB AUTHID CURRENT_USER AS
2 /* $Header: IECRDPBS.pls 115.2 2004/05/18 19:56:40 minwang noship $ */
3
4 -- Start of comments
5 -- Procedure : SetAORecDNU
6 -- Type : Public API
7 -- Usage : Makes Record mark as do_not_use with specified do not use reason
8 --
9 -- Standard IN Parameters:
10 -- p_api_version IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2(1) Required
12 -- pass in FND_API.G_FALSE or FND_API.G_TRUE
13 -- p_commit IN VARCHAR2(1) Required
14 -- pass in FND_API.G_FALSE or FND_API.G_TRUE
15 --
16 -- Standard OUT Parameters:
17 -- x_return_status OUT VARCHAR2(1)
18 -- x_msg_count OUT NUMBER
19 -- x_msg_data OUT VARCHAR2(2000)
20 --
21 -- Other IN Parameters:
22 -- p_user_id IN NUMBER Required
23 -- Corresponds to the column USER_ID in the table
24 -- FND_USER, and identifies the Oracle
25 -- Applications user
26
27 -- p_login_id IN NUMBER Optional
28 -- Corresponds to the column LOGIN_ID in the
29 -- table FND_LOGINS, and identifies the login session
30 -- Default = FND_GLOBAL.LOGIN_ID or NULL
31
32 -- p_list_entry_id IN NUMBER Required
33 -- p_list_header_id IN NUMBER Required
34
35 -- p_dnu_reason_code IN NUMBER DEFAULT null
36 -- dnu_reason_code is seeded in fnd_lookups with lookup_type='IEC_DNU_REASON'
37 --
38 -- Version : Initial version 1.0
39 --
40 -- End of comments
41
42 PROCEDURE SetAORecDNU
43 (
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2,
46 p_commit IN VARCHAR2,
47 p_user_id IN NUMBER,
48 p_login_id IN NUMBER DEFAULT NULL,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_list_entry_id IN NUMBER,
53 p_list_header_id IN NUMBER,
54 p_dnu_reason_code IN NUMBER DEFAULT NULL
55 );
56
57 END IEC_AORECDNU_PUB;
[Home] [Help]