27: -- Parameters
28: --
29: -- IN
30: -- p_api_version_number IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
32: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Optional Default =FND_API.G_VALID_LEVEL_FULL,
34:
35: -- p_list_header_id IN ListHeaderId Required
28: --
29: -- IN
30: -- p_api_version_number IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
32: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Optional Default =FND_API.G_VALID_LEVEL_FULL,
34:
35: -- p_list_header_id IN ListHeaderId Required
36: --
29: -- IN
30: -- p_api_version_number IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
32: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Optional Default =FND_API.G_VALID_LEVEL_FULL,
34:
35: -- p_list_header_id IN ListHeaderId Required
36: --
37: -- OUT
44: --
45:
46: PROCEDURE Generate_List
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: p_list_header_id IN NUMBER ,
52: x_return_status OUT NOCOPY VARCHAR2,
45:
46: PROCEDURE Generate_List
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: p_list_header_id IN NUMBER ,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
46: PROCEDURE Generate_List
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: p_list_header_id IN NUMBER ,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2
56:
57:
58: PROCEDURE create_list_from_query
59: ( p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_list_name in varchar2,
64: p_list_type in varchar2,
57:
58: PROCEDURE create_list_from_query
59: ( p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_list_name in varchar2,
64: p_list_type in varchar2,
65: p_owner_user_id in number,
58: PROCEDURE create_list_from_query
59: ( p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_list_name in varchar2,
64: p_list_type in varchar2,
65: p_owner_user_id in number,
66: p_list_header_id in number,
74: ) ;
75:
76: PROCEDURE create_list_from_query
77: ( p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: p_list_name in varchar2,
82: p_list_type in varchar2,
75:
76: PROCEDURE create_list_from_query
77: ( p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: p_list_name in varchar2,
82: p_list_type in varchar2,
83: p_owner_user_id in number,
76: PROCEDURE create_list_from_query
77: ( p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: p_list_name in varchar2,
82: p_list_type in varchar2,
83: p_owner_user_id in number,
84: p_list_header_id in number,