DBA Data[Home] [Help]

APPS.OKC_XPRT_QUESTION_PUB dependencies on FND_API

Line 20: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

16:
17: ------------------------------------------------------------------------------
18: -- GLOBAL CONSTANTS
19: ------------------------------------------------------------------------------
20: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

17: ------------------------------------------------------------------------------
18: -- GLOBAL CONSTANTS
19: ------------------------------------------------------------------------------
20: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:

Line 22: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

18: -- GLOBAL CONSTANTS
19: ------------------------------------------------------------------------------
20: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

Line 23: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

19: ------------------------------------------------------------------------------
20: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

Line 24: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

20: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
28: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

Line 31: ,p_commit IN VARCHAR2 := fnd_api.g_false

27: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
28: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
29:
30: PROCEDURE create_question( p_xprt_question_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type
31: ,p_commit IN VARCHAR2 := fnd_api.g_false
32: )
33: IS
34:
35: x_return_status varchar2(1);

Line 58: ,p_commit IN VARCHAR2 := fnd_api.g_false)

54: RAISE;
55: END create_question;
56:
57: PROCEDURE create_question( p_xprt_question_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type
58: ,p_commit IN VARCHAR2 := fnd_api.g_false)
59: IS
60: l_count NUMBER;
61: BEGIN
62: l_count:=p_xprt_question_tbl.Count;

Line 83: ,p_commit IN VARCHAR2 := fnd_api.g_false)

79:
80:
81:
82: PROCEDURE update_question(p_xprt_update_question_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type
83: ,p_commit IN VARCHAR2 := fnd_api.g_false)
84: IS
85:
86:
87: x_return_status varchar2(1);

Line 112: ,p_commit IN VARCHAR2 := fnd_api.g_false)

108:
109:
110:
111: PROCEDURE update_question(p_xprt_update_question_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type
112: ,p_commit IN VARCHAR2 := fnd_api.g_false)
113: IS
114: l_count NUMBER;
115: BEGIN
116: l_count:=p_xprt_update_question_tbl.Count;

Line 135: ,p_commit IN VARCHAR2 := fnd_api.g_false

131: END update_question;
132:
133:
134: PROCEDURE create_constant( p_xprt_constant_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type
135: ,p_commit IN VARCHAR2 := fnd_api.g_false
136: )
137: IS
138:
139: x_return_status varchar2(1);

Line 161: ,p_commit IN VARCHAR2 := fnd_api.g_false)

157: RAISE;
158: END create_constant;
159:
160: PROCEDURE create_constant( p_xprt_constant_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type
161: ,p_commit IN VARCHAR2 := fnd_api.g_false)
162: IS
163: l_count NUMBER;
164: BEGIN
165: l_count:=p_xprt_constant_tbl.Count;

Line 186: ,p_commit IN VARCHAR2 := fnd_api.g_false)

182:
183:
184:
185: PROCEDURE update_constant(p_xprt_update_constant_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type
186: ,p_commit IN VARCHAR2 := fnd_api.g_false)
187: IS
188:
189:
190: x_return_status varchar2(1);

Line 214: ,p_commit IN VARCHAR2 := fnd_api.g_false)

210:
211:
212:
213: PROCEDURE update_constant(p_xprt_update_constant_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type
214: ,p_commit IN VARCHAR2 := fnd_api.g_false)
215: IS
216: l_count NUMBER;
217: BEGIN
218: l_count:=p_xprt_update_constant_tbl.Count;