7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN
10: -- p_api_version_number IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
13: -- p_db_link IN VARCHAR2,
14: -- p_db_username IN VARCHAR2,
15: -- p_db_password IN VARCHAR2,
8: -- Parameters :
9: -- IN
10: -- p_api_version_number IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
13: -- p_db_link IN VARCHAR2,
14: -- p_db_username IN VARCHAR2,
15: -- p_db_password IN VARCHAR2,
16: -- p_db_server_id IN NUMBER,
14: -- p_db_username IN VARCHAR2,
15: -- p_db_password IN VARCHAR2,
16: -- p_db_server_id IN NUMBER,
17: -- p_is_admin IN VARCHAR2,
18: -- p_conn_desc IN VARCHAR2:=FND_API.G_MISS_CHAR,
19: --
20: -- OUT
21: -- x_return_status OUT VARCHAR2
22: -- x_msg_count OUT NUMBER
28: -- End of comments
29: -- **********************************************************
30:
31: PROCEDURE create_item (p_api_version_number IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_db_link IN VARCHAR2,
35: p_db_username IN VARCHAR2,
36: p_db_password IN VARCHAR2,
29: -- **********************************************************
30:
31: PROCEDURE create_item (p_api_version_number IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_db_link IN VARCHAR2,
35: p_db_username IN VARCHAR2,
36: p_db_password IN VARCHAR2,
37: p_db_server_id IN NUMBER,
69: -- Pre-reqs : None.
70: -- Parameters :
71: -- IN
72: -- p_api_version_number IN NUMBER Required
73: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
75: -- p_db_conn_id in number:=null,
76: -- p_db_username IN VARCHAR2 :=null,
77: -- p_db_server_id IN NUMBER:=null,
70: -- Parameters :
71: -- IN
72: -- p_api_version_number IN NUMBER Required
73: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
75: -- p_db_conn_id in number:=null,
76: -- p_db_username IN VARCHAR2 :=null,
77: -- p_db_server_id IN NUMBER:=null,
78:
87: -- End of comments
88: -- **********************************************************
89:
90: PROCEDURE delete_item (p_api_version_number IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_db_conn_id in number:=null,
94: p_db_username IN VARCHAR2 :=null,
95: p_db_server_id IN NUMBER:=null,
88: -- **********************************************************
89:
90: PROCEDURE delete_item (p_api_version_number IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_db_conn_id in number:=null,
94: p_db_username IN VARCHAR2 :=null,
95: p_db_server_id IN NUMBER:=null,
96: x_return_status OUT NOCOPY VARCHAR2,
104: -- Pre-reqs : None.
105: -- Parameters :
106: -- IN
107: -- p_api_version_number IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
110: -- p_db_conn_id IN NUMBER:=NULL,
111: -- p_db_link IN VARCHAR2:=NULL,
112: -- p_db_username IN VARCHAR2:=NULL,
105: -- Parameters :
106: -- IN
107: -- p_api_version_number IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
110: -- p_db_conn_id IN NUMBER:=NULL,
111: -- p_db_link IN VARCHAR2:=NULL,
112: -- p_db_username IN VARCHAR2:=NULL,
113: -- p_db_password IN VARCHAR2:=NULL,
126: -- End of comments
127: -- **********************************************************
128:
129: PROCEDURE update_item (p_api_version_number IN NUMBER,
130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
132: p_db_conn_id IN NUMBER:=null,
133: p_db_link IN VARCHAR2:=null,
134: p_db_username IN VARCHAR2:=null,
127: -- **********************************************************
128:
129: PROCEDURE update_item (p_api_version_number IN NUMBER,
130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
132: p_db_conn_id IN NUMBER:=null,
133: p_db_link IN VARCHAR2:=null,
134: p_db_username IN VARCHAR2:=null,
135: p_db_password IN VARCHAR2:=null,
168: -- Pre-reqs : None.
169: -- Parameters :
170: -- IN
171: -- p_api_version_number IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174: -- p_email_account_id in number:=null,
175: -- p_is_admin IN VARCHAR2 :=null,
176:
169: -- Parameters :
170: -- IN
171: -- p_api_version_number IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174: -- p_email_account_id in number:=null,
175: -- p_is_admin IN VARCHAR2 :=null,
176:
177: -- OUT
185: --
186: -- End of comments
187: -- **********************************************************
188: PROCEDURE select_item (p_api_version_number IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_db_server_id in number:=null,
192: p_is_admin IN VARCHAR2 :=null,
193: x_db_link OUT NOCOPY VARCHAR2,
186: -- End of comments
187: -- **********************************************************
188: PROCEDURE select_item (p_api_version_number IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_db_server_id in number:=null,
192: p_is_admin IN VARCHAR2 :=null,
193: x_db_link OUT NOCOPY VARCHAR2,
194: x_return_status OUT NOCOPY VARCHAR2,