DBA Data[Home] [Help]

APPS.IEM_DB_CONNECTIONS_PVT dependencies on FND_API

Line 11: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

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,

Line 12: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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,

Line 18: -- p_conn_desc IN VARCHAR2:=FND_API.G_MISS_CHAR,

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

Line 32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 33: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 73: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

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,

Line 74: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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:

Line 91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 92: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 108: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

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,

Line 109: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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,

Line 130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 131: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

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:

Line 173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 190: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,