APPS.OKE_CHR_PVT dependencies on OKE_K_HEADERS

Line 14: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_HEADERS_V';

10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE__CONTRACTS_UNEXPECTED_ERROR';
11:
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
14: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_HEADERS_V';
15: G_EXCEPTION_HALT_VALIDATION exception;
16: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
17:
18:

Line 113: FROM OKE_K_HEADERS

109: p_chr_rec IN chr_rec_type)IS
110: l_dummy_val VARCHAR2(1):= '?';
111: CURSOR l_csr IS
112: SELECT 'x'
113: FROM OKE_K_HEADERS
114: WHERE K_HEADER_ID = p_chr_rec.BOA_ID;
115:
116: BEGIN
117:

Line 1694: FROM oke_k_headers

1690: L_K_NUMBER_DISP VARCHAR2(120);
1691: CURSOR c_do
1692: IS
1693: SELECT k_header_id
1694: FROM oke_k_headers
1695: WHERE boa_id=P_BOA_ID
1696: FOR UPDATE NOWAIT;
1697: BEGIN
1698:

Line 1702: UPDATE oke_k_headers

1698:
1699: FOR l_do_rec IN c_do
1700: LOOP
1701: L_K_NUMBER_DISP := K_Number_Disp(l_do_rec.k_header_id,p_boa_id);
1702: UPDATE oke_k_headers
1703: SET k_number_disp= L_K_NUMBER_DISP
1704: WHERE CURRENT OF c_do;
1705: END LOOP;
1706:

Line 1711: -- Get record from OKE_K_HEADERS

1707: END UPDATE_DO;
1708:
1709: /* Bug 7115155 End*/
1710:
1711: -- Get record from OKE_K_HEADERS
1712:
1713: FUNCTION get_rec(
1714: p_chr_rec IN chr_rec_type,
1715: x_no_data_found OUT NOCOPY BOOLEAN)

Line 1789: FROM OKE_K_HEADERS

1785: UNDEF_LINE_VALUE_TOTAL,
1786: -- END_DATE,
1787: OWNING_ORGANIZATION_ID,
1788: DEFAULT_TASK_ID
1789: FROM OKE_K_HEADERS
1790: WHERE K_HEADER_ID = p_id;
1791:
1792: l_chr_pk chr_pk_csr%ROWTYPE;
1793: l_chr_rec chr_rec_type;

Line 2512: -- Insert row into OKE_K_HEADERS

2508: RETURN(l_return_status);
2509:
2510: END validate_record;
2511:
2512: -- Insert row into OKE_K_HEADERS
2513:
2514: PROCEDURE insert_row(
2515: p_api_version IN NUMBER,
2516: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 2548: --Set Attributes for OKE_K_HEADERS

2544: RETURN(l_chr_rec);
2545:
2546: END fill_who_column;
2547:
2548: --Set Attributes for OKE_K_HEADERS
2549:
2550: FUNCTION set_attributes(
2551: p_chr_rec IN chr_rec_type,
2552: x_chr_rec OUT NOCOPY chr_rec_type) RETURN VARCHAR2 IS

Line 2658: INSERT INTO OKE_K_HEADERS(

2654: l_k_number_disp := K_Number_Disp( l_def_chr_rec.K_HEADER_ID
2655: , l_def_chr_rec.BOA_ID );
2656:
2657:
2658: INSERT INTO OKE_K_HEADERS(
2659:
2660: K_HEADER_ID,
2661: PROGRAM_ID,
2662: PROJECT_ID,

Line 2954: from oke_k_headers

2950: FUNCTION get_k_number_disp(P_HEADER_ID IN NUMBER) RETURN VARCHAR2 IS
2951: l_k_number VARCHAR2(120);
2952: BEGIN
2953: select k_number_disp into l_k_number
2954: from oke_k_headers
2955: where k_header_id=P_HEADER_ID;
2956:
2957: return l_k_number;
2958: exception

Line 3372: UPDATE OKE_K_HEADERS

3368: l_k_number_disp_old := get_k_number_disp( l_def_chr_rec.K_HEADER_ID);
3369: l_k_number_disp := K_Number_Disp( l_def_chr_rec.K_HEADER_ID
3370: , l_def_chr_rec.BOA_ID );
3371:
3372: UPDATE OKE_K_HEADERS
3373: SET PROGRAM_ID = l_def_chr_rec.PROGRAM_ID,
3374: PROJECT_ID = l_def_chr_rec.PROJECT_ID,
3375: BOA_ID = l_def_chr_rec.BOA_ID,
3376: K_NUMBER_DISP = l_k_number_disp,

Line 3610: DELETE FROM OKE_K_HEADERS

3606: RAISE OKE_API.G_EXCEPTION_ERROR;
3607:
3608: END IF;
3609:
3610: DELETE FROM OKE_K_HEADERS
3611: WHERE K_HEADER_ID = l_chr_rec.K_HEADER_ID;
3612:
3613: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
3614:

Line 3665: FROM OKE_K_HEADERS

3661: i NUMBER := 0;
3662: l_dummy_val NUMBER;
3663: CURSOR l_csr IS
3664: SELECT COUNT(1)
3665: FROM OKE_K_HEADERS
3666: WHERE OKE_K_HEADERS.K_HEADER_ID = p_chr_tbl(i).K_HEADER_ID;
3667:
3668: BEGIN
3669:

Line 3666: WHERE OKE_K_HEADERS.K_HEADER_ID = p_chr_tbl(i).K_HEADER_ID;

3662: l_dummy_val NUMBER;
3663: CURSOR l_csr IS
3664: SELECT COUNT(1)
3665: FROM OKE_K_HEADERS
3666: WHERE OKE_K_HEADERS.K_HEADER_ID = p_chr_tbl(i).K_HEADER_ID;
3667:
3668: BEGIN
3669:
3670: OKE_API.init_msg_list(p_init_msg_list);