APPS.OKC_KEXP_PVT dependencies on OKC_API

Line 21: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

17: TYPE okc_kexp_cur_type IS REF CURSOR;
18: okc_kexp_cur okc_kexp_cur_type;
19:
20: l_block_size NUMBER := 1000;
21: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
22: l_qry VARCHAR2(2000);
23: l_index NUMBER;
24: l_rowid ROWID;
25: l_report_seq NUMBER := 0;

Line 102: x_return_status := OKC_API.G_RET_STS_SUCCESS;

98:
99: -- --------------------------------------------------
100: -- Prepare out parameters for sucessful completion.
101: -- --------------------------------------------------
102: x_return_status := OKC_API.G_RET_STS_SUCCESS;
103: x_report_id := l_report_seq;
104:
105: EXCEPTION
106: WHEN OTHERS THEN

Line 110: OKC_API.set_message(p_app_name => G_APP_NAME,

106: WHEN OTHERS THEN
107: -- --------------------------------------------------
108: -- Store SQL error message on message stack
109: -- --------------------------------------------------
110: OKC_API.set_message(p_app_name => G_APP_NAME,
111: p_msg_name => G_UNEXPECTED_ERROR,
112: p_token1 => G_SQLCODE_TOKEN,
113: p_token1_value => SQLCODE,
114: p_token2 => G_SQLERRM_TOKEN,

Line 121: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

117: -- ------------------------------------------
118: -- Return error status to the caller.
119: -- Notify caller of an error as UNEXPETED error
120: -- ------------------------------------------
121: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
122:
123: END load_ksrch_rows;
124:
125:

Line 147: x_return_status := OKC_API.G_RET_STS_SUCCESS;

143:
144: -- --------------------------------------------------
145: -- Prepare out parameters for sucessful completion.
146: -- --------------------------------------------------
147: x_return_status := OKC_API.G_RET_STS_SUCCESS;
148:
149: COMMIT;
150:
151: ELSE

Line 155: x_return_status := OKC_API.G_RET_STS_ERROR;

151: ELSE
152: -- --------------------------------------------------
153: -- Return error status to the caller.
154: -- --------------------------------------------------
155: x_return_status := OKC_API.G_RET_STS_ERROR;
156:
157: END IF;
158:
159: EXCEPTION

Line 164: OKC_API.set_message(p_app_name => G_APP_NAME,

160: WHEN OTHERS THEN
161: -- --------------------------------------------------
162: -- Store SQL error message on message stack
163: -- --------------------------------------------------
164: OKC_API.set_message(p_app_name => G_APP_NAME,
165: p_msg_name => G_UNEXPECTED_ERROR,
166: p_token1 => G_SQLCODE_TOKEN,
167: p_token1_value => SQLCODE,
168: p_token2 => G_SQLERRM_TOKEN,

Line 175: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

171: -- ------------------------------------------
172: -- Return error status to the caller.
173: -- Notify caller of an error as UNEXPETED error
174: -- ------------------------------------------
175: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
176:
177: END delete_ksrch_rows;
178:
179: FUNCTION get_salesrep_name ( p_id1 IN VARCHAR2,