APPS.OKE_CLE_PVT dependencies on OKE_K_LINES

Line 12: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_LINES_V';

8: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
9:
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_LINES_V';
13:
14: G_EXCEPTION_HALT_VALIDATION exception;
15: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
16:

Line 25: SELECT 'x' FROM OKE_K_LINES_V

21: x_return_status OUT NOCOPY VARCHAR2
22: ) IS
23:
24: CURSOR l_csr IS
25: SELECT 'x' FROM OKE_K_LINES_V
26: WHERE K_LINE_ID = p_cle_rec.PARENT_LINE_ID;
27:
28: l_dummy_val VARCHAR2(1) := '?';
29:

Line 51: p_token3_value => 'OKE_K_LINES_V');

47: p_token1_value => 'parent_line_id',
48: p_token2 => g_child_table_token,
49: p_token2_value => G_VIEW,
50: p_token3 => g_parent_table_token,
51: p_token3_value => 'OKE_K_LINES_V');
52: -- notify caller of an error
53: x_return_status := OKE_API.G_RET_STS_ERROR;
54: End If;
55:

Line 245: FROM OKC_ANCESTRYS AN, OKE_K_LINES KE

241: WHERE ID = p_cle_rec.K_LINE_ID;
242:
243: CURSOR get_higher IS
244: SELECT KE.PROJECT_ID,KE.TASK_ID
245: FROM OKC_ANCESTRYS AN, OKE_K_LINES KE
246: WHERE AN.CLE_ID=L_PARENT_LINE_ID AND KE.PROJECT_ID IS NOT NULL
247: AND AN.CLE_ID_ASCENDANT = KE.K_LINE_ID
248: ORDER BY AN.LEVEL_SEQUENCE DESC;
249:

Line 252: FROM OKE_K_LINES

248: ORDER BY AN.LEVEL_SEQUENCE DESC;
249:
250: CURSOR get_parent IS
251: SELECT PROJECT_ID, TASK_ID
252: FROM OKE_K_LINES
253: WHERE K_LINE_ID = L_PARENT_LINE_ID;
254:
255:
256: l_project_id_from NUMBER; /* the parent project */

Line 443: FROM OKC_ANCESTRYS AN, OKE_K_LINES KE

439: WHERE ID = p_cle_rec.K_LINE_ID;
440:
441: CURSOR get_higher IS
442: SELECT KE.PROJECT_ID,KE.TASK_ID
443: FROM OKC_ANCESTRYS AN, OKE_K_LINES KE
444: WHERE AN.CLE_ID=L_PARENT_LINE_ID AND KE.PROJECT_ID IS NOT NULL
445: AND AN.CLE_ID_ASCENDANT = KE.K_LINE_ID
446: ORDER BY AN.LEVEL_SEQUENCE DESC;
447:

Line 450: FROM OKE_K_LINES

446: ORDER BY AN.LEVEL_SEQUENCE DESC;
447:
448: CURSOR get_parent IS
449: SELECT PROJECT_ID, TASK_ID
450: FROM OKE_K_LINES
451: WHERE K_LINE_ID = L_PARENT_LINE_ID;
452:
453:
454:

Line 2154: FROM OKE_K_LINES

2150: LAST_UPDATE_LOGIN ,
2151: LAST_UPDATE_DATE ,
2152: COST_OF_SALE_RATE
2153:
2154: FROM OKE_K_LINES
2155: WHERE OKE_K_LINES.K_LINE_ID = p_id;
2156:
2157: l_cle_pk cle_pk_csr%ROWTYPE;
2158: l_cle_rec cle_rec_type;

Line 2155: WHERE OKE_K_LINES.K_LINE_ID = p_id;

2151: LAST_UPDATE_DATE ,
2152: COST_OF_SALE_RATE
2153:
2154: FROM OKE_K_LINES
2155: WHERE OKE_K_LINES.K_LINE_ID = p_id;
2156:
2157: l_cle_pk cle_pk_csr%ROWTYPE;
2158: l_cle_rec cle_rec_type;
2159:

Line 3265: -- insert data into oke_k_lines

3261: '_PVT'
3262: );
3263: END validate_row;
3264:
3265: -- insert data into oke_k_lines
3266:
3267: PROCEDURE insert_row(
3268: p_api_version IN NUMBER,
3269: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 3302: -- Set_Attributes for:OKE_K_LINES

3298: RETURN(l_cle_rec);
3299:
3300: END fill_who_columns;
3301:
3302: -- Set_Attributes for:OKE_K_LINES
3303:
3304:
3305: FUNCTION Set_Attributes (
3306: p_cle_rec IN cle_rec_type,

Line 3400: INSERT INTO OKE_K_LINES(

3396: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
3397: RAISE OKE_API.G_EXCEPTION_ERROR;
3398: END IF;
3399:
3400: INSERT INTO OKE_K_LINES(
3401: K_LINE_ID ,
3402: PARENT_LINE_ID ,
3403: PROJECT_ID ,
3404: TASK_ID ,

Line 3723: -- update oke_k_lines

3719: '_PVT'
3720: );
3721: END insert_row;
3722:
3723: -- update oke_k_lines
3724:
3725: PROCEDURE update_row(
3726: p_api_version IN NUMBER,
3727: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 4191: -- set attributes for oke_k_lines

4187: RETURN(l_return_status);
4188:
4189: END populate_new_record;
4190:
4191: -- set attributes for oke_k_lines
4192:
4193: FUNCTION set_attributes(
4194: p_cle_rec IN cle_rec_type,
4195: x_cle_rec OUT NOCOPY cle_rec_type

Line 4306: UPDATE OKE_K_LINES

4302: END IF;
4303:
4304:
4305:
4306: UPDATE OKE_K_LINES
4307: SET
4308: PARENT_LINE_ID = l_def_cle_rec.PARENT_LINE_ID,
4309: PROJECT_ID = l_def_cle_rec.PROJECT_ID,
4310: TASK_ID = l_def_cle_rec.TASK_ID,

Line 4557: DELETE FROM OKE_K_LINES

4553: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4554: RAISE OKE_API.G_EXCEPTION_ERROR;
4555: END IF;
4556:
4557: DELETE FROM OKE_K_LINES
4558: WHERE K_LINE_ID = l_cle_rec.K_LINE_ID;
4559:
4560: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
4561: