eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_KHR_PVT dependencies on OKL_K_HEADERS_V

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

8:
9:
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12: G_VIEW CONSTANT VARCHAR2(200) := 'OKL_K_HEADERS_V';
13:
14: G_EXCEPTION_HALT_VALIDATION exception;
15:
16:

Line 53: p_token3_value=> 'OKL_K_HEADERS_V');

49: p_token1_value=> 'khr_id',
50: p_token2 => g_child_table_token,
51: p_token2_value=> G_VIEW,
52: p_token3 => g_parent_table_token,
53: p_token3_value=> 'OKL_K_HEADERS_V');
54: -- notify caller of an error
55: x_return_status := OKC_API.G_RET_STS_ERROR;
56: End If;
57: end if;

Line 110: p_token3_value=> 'OKL_K_HEADERS_V');

106: p_token1_value=> 'pdt_id',
107: p_token2 => g_child_table_token,
108: p_token2_value=> G_VIEW,
109: p_token3 => g_parent_table_token,
110: p_token3_value=> 'OKL_K_HEADERS_V');
111: -- notify caller of an error
112: x_return_status := OKC_API.G_RET_STS_ERROR;
113: End If;
114: end if;

Line 755: p_token3_value => 'OKL_K_HEADERS_V');

751: p_token1_value => 'crs_id',
752: p_token2 => g_child_table_token,
753: p_token2_value => G_VIEW,
754: p_token3 => g_parent_table_token,
755: p_token3_value => 'OKL_K_HEADERS_V');
756: -- notify caller of an error
757: x_return_status := OKC_API.G_RET_STS_ERROR;
758: End If;
759: end if;

Line 983: -- Validate_Attributes for: OKL_K_HEADERS_V --

979: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
980: end validate_OBJECT_VERSION_NUMBER;
981:
982: ---------------------------------------------
983: -- Validate_Attributes for: OKL_K_HEADERS_V --
984: ---------------------------------------------
985: FUNCTION Validate_Attributes (
986: p_khrv_rec IN khrv_rec_type
987: ) RETURN VARCHAR2 IS

Line 1645: -- FUNCTION get_rec for: OKL_K_HEADERS_V

1641: END get_rec;
1642:
1643:
1644: ---------------------------------------------------------------------------
1645: -- FUNCTION get_rec for: OKL_K_HEADERS_V
1646: ---------------------------------------------------------------------------
1647: FUNCTION get_rec (
1648: p_khrv_rec IN khrv_rec_type,
1649: x_no_data_found OUT NOCOPY BOOLEAN

Line 1651: CURSOR okl_k_headers_v_pk_csr (p_id IN NUMBER) IS

1647: FUNCTION get_rec (
1648: p_khrv_rec IN khrv_rec_type,
1649: x_no_data_found OUT NOCOPY BOOLEAN
1650: ) RETURN khrv_rec_type IS
1651: CURSOR okl_k_headers_v_pk_csr (p_id IN NUMBER) IS
1652: SELECT
1653: ID,
1654: OBJECT_VERSION_NUMBER,
1655: ISG_ID,

Line 1742: FROM OKL_K_HEADERS_V

1738: TRADEIN_AMOUNT,
1739: TRADEIN_DESCRIPTION,
1740: --Added by dpsingh for LE uptake
1741: LEGAL_ENTITY_ID
1742: FROM OKL_K_HEADERS_V
1743: WHERE OKL_K_HEADERS_V.id = p_id;
1744:
1745: l_khrv_rec khrv_rec_type;
1746: BEGIN

Line 1743: WHERE OKL_K_HEADERS_V.id = p_id;

1739: TRADEIN_DESCRIPTION,
1740: --Added by dpsingh for LE uptake
1741: LEGAL_ENTITY_ID
1742: FROM OKL_K_HEADERS_V
1743: WHERE OKL_K_HEADERS_V.id = p_id;
1744:
1745: l_khrv_rec khrv_rec_type;
1746: BEGIN
1747:

Line 1750: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);

1746: BEGIN
1747:
1748: x_no_data_found := TRUE;
1749: -- Get current database values
1750: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);
1751: FETCH okl_k_headers_v_pk_csr INTO
1752: l_khrv_rec.ID,
1753: l_khrv_rec.OBJECT_VERSION_NUMBER,
1754: l_khrv_rec.ISG_ID,

Line 1751: FETCH okl_k_headers_v_pk_csr INTO

1747:
1748: x_no_data_found := TRUE;
1749: -- Get current database values
1750: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);
1751: FETCH okl_k_headers_v_pk_csr INTO
1752: l_khrv_rec.ID,
1753: l_khrv_rec.OBJECT_VERSION_NUMBER,
1754: l_khrv_rec.ISG_ID,
1755: l_khrv_rec.KHR_ID,

Line 1841: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;

1837: l_khrv_rec.TRADEIN_AMOUNT,
1838: l_khrv_rec.TRADEIN_DESCRIPTION,
1839: --Added by dpsingh for LE uptake
1840: l_khrv_rec.LEGAL_ENTITY_ID ;
1841: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;
1842: CLOSE okl_k_headers_v_pk_csr;
1843: RETURN(l_khrv_rec);
1844: END get_rec;
1845:

Line 1842: CLOSE okl_k_headers_v_pk_csr;

1838: l_khrv_rec.TRADEIN_DESCRIPTION,
1839: --Added by dpsingh for LE uptake
1840: l_khrv_rec.LEGAL_ENTITY_ID ;
1841: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;
1842: CLOSE okl_k_headers_v_pk_csr;
1843: RETURN(l_khrv_rec);
1844: END get_rec;
1845:
1846: FUNCTION get_rec (

Line 1856: -- FUNCTION null_out_defaults for: OKL_K_HEADERS_V --

1852: END get_rec;
1853:
1854:
1855: -----------------------------------------------------
1856: -- FUNCTION null_out_defaults for: OKL_K_HEADERS_V --
1857: -----------------------------------------------------
1858: FUNCTION null_out_defaults (
1859: p_khrv_rec IN khrv_rec_type
1860: ) RETURN khrv_rec_type IS

Line 2198: -- Validate_Record for: OKL_K_HEADERS_V --

2194: ---------------------------------------------------------------------------
2195:
2196:
2197: -----------------------------------------
2198: -- Validate_Record for: OKL_K_HEADERS_V --
2199: -----------------------------------------
2200: FUNCTION Validate_Record (
2201: p_khrv_rec IN khrv_rec_type
2202: ) RETURN VARCHAR2 IS

Line 2684: -- validate_row for: OKL_K_HEADERS_V --

2680: -- PROCEDURE validate_row
2681: ---------------------------------------------------------------------------
2682:
2683: --------------------------------------
2684: -- validate_row for: OKL_K_HEADERS_V --
2685: --------------------------------------
2686:
2687: PROCEDURE validate_row(
2688:

Line 2772: -- PL/SQL TBL validate_row for: OKL_K_HEADERS_V --

2768: );
2769:
2770: END validate_row;
2771: ------------------------------------------
2772: -- PL/SQL TBL validate_row for: OKL_K_HEADERS_V --
2773: ------------------------------------------
2774:
2775: PROCEDURE validate_row(
2776:

Line 3401: -- insert_row for: OKL_K_HEADERS_V --

3397:
3398: END insert_row;
3399:
3400: ------------------------------------
3401: -- insert_row for: OKL_K_HEADERS_V --
3402: ------------------------------------
3403:
3404: PROCEDURE insert_row(
3405:

Line 3437: -- Set_Attributes for: OKL_K_HEADERS_V --

3433: l_khrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3434: RETURN(l_khrv_rec);
3435: END fill_who_columns;
3436: ----------------------------------------
3437: -- Set_Attributes for: OKL_K_HEADERS_V --
3438: ----------------------------------------
3439: FUNCTION Set_Attributes (
3440: p_khrv_rec IN khrv_rec_type,
3441: x_khrv_rec OUT NOCOPY khrv_rec_type

Line 3566: -- PL/SQL TBL insert_row for: OKL_K_HEADERS_V --

3562:
3563: END insert_row;
3564:
3565: ----------------------------------------
3566: -- PL/SQL TBL insert_row for: OKL_K_HEADERS_V --
3567: ----------------------------------------
3568:
3569: PROCEDURE insert_row(
3570:

Line 3756: -- lock_row for: OKL_K_HEADERS_V --

3752:
3753: END lock_row;
3754:
3755: ----------------------------------
3756: -- lock_row for: OKL_K_HEADERS_V --
3757: ----------------------------------
3758:
3759: PROCEDURE lock_row(
3760:

Line 3845: -- PL/SQL TBL lock_row for: OKL_K_HEADERS_V --

3841: );
3842:
3843: END lock_row;
3844: --------------------------------------
3845: -- PL/SQL TBL lock_row for: OKL_K_HEADERS_V --
3846: --------------------------------------
3847:
3848: PROCEDURE lock_row(
3849:

Line 4477: -- update_row for: OKL_K_HEADERS_V --

4473:
4474: END update_row;
4475:
4476: ------------------------------------
4477: -- update_row for: OKL_K_HEADERS_V --
4478: ------------------------------------
4479:
4480: PROCEDURE update_row(
4481:

Line 4854: -- Set_Attributes for: OKL_K_HEADERS_V --

4850:
4851: RETURN(l_return_status);
4852: END populate_new_record;
4853: ----------------------------------------
4854: -- Set_Attributes for: OKL_K_HEADERS_V --
4855: ----------------------------------------
4856: FUNCTION Set_Attributes (
4857: p_khrv_rec IN khrv_rec_type,
4858: x_khrv_rec OUT NOCOPY khrv_rec_type

Line 4982: -- PL/SQL TBL update_row for: OKL_K_HEADERS_V --

4978: );
4979:
4980: END update_row;
4981: ----------------------------------------
4982: -- PL/SQL TBL update_row for: OKL_K_HEADERS_V --
4983: ----------------------------------------
4984:
4985: PROCEDURE update_row(
4986:

Line 5240: -- PL/SQL TBL delete_row for: OKL_K_HEADERS_V --

5236: );
5237:
5238: END delete_row;
5239: ----------------------------------------
5240: -- PL/SQL TBL delete_row for: OKL_K_HEADERS_V --
5241: ----------------------------------------
5242:
5243: PROCEDURE delete_row(
5244: