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_OVT_PVT dependencies on OKL_OVD_RUL_TMLS_V

Line 86: -- FUNCTION get_rec for: OKL_OVD_RUL_TMLS_V

82: BEGIN
83: RETURN(get_rec(p_ovt_rec, l_row_notfound));
84: END get_rec;
85: ---------------------------------------------------------------------------
86: -- FUNCTION get_rec for: OKL_OVD_RUL_TMLS_V
87: ---------------------------------------------------------------------------
88: FUNCTION get_rec (
89: p_ovtv_rec IN ovtv_rec_type,
90: x_no_data_found OUT NOCOPY BOOLEAN

Line 104: FROM Okl_Ovd_Rul_Tmls_V

100: CREATION_DATE,
101: LAST_UPDATED_BY,
102: LAST_UPDATE_DATE,
103: LAST_UPDATE_LOGIN
104: FROM Okl_Ovd_Rul_Tmls_V
105: WHERE okl_ovd_rul_tmls_v.id = p_id;
106: l_okl_ovtv_pk okl_ovtv_pk_csr%ROWTYPE;
107: l_ovtv_rec ovtv_rec_type;
108: BEGIN

Line 105: WHERE okl_ovd_rul_tmls_v.id = p_id;

101: LAST_UPDATED_BY,
102: LAST_UPDATE_DATE,
103: LAST_UPDATE_LOGIN
104: FROM Okl_Ovd_Rul_Tmls_V
105: WHERE okl_ovd_rul_tmls_v.id = p_id;
106: l_okl_ovtv_pk okl_ovtv_pk_csr%ROWTYPE;
107: l_ovtv_rec ovtv_rec_type;
108: BEGIN
109: x_no_data_found := TRUE;

Line 137: -- FUNCTION null_out_defaults for: OKL_OVD_RUL_TMLS_V --

133: RETURN(get_rec(p_ovtv_rec, l_row_notfound));
134: END get_rec;
135:
136: --------------------------------------------------------
137: -- FUNCTION null_out_defaults for: OKL_OVD_RUL_TMLS_V --
138: --------------------------------------------------------
139: FUNCTION null_out_defaults (
140: p_ovtv_rec IN ovtv_rec_type
141: ) RETURN ovtv_rec_type IS

Line 180: -- Validate_Attributes for:OKL_OVD_RUL_TMLS_V --

176: ---------------------------------------------------------------------------
177: -- PROCEDURE Validate_Attributes
178: ---------------------------------------------------------------------------
179: ------------------------------------------------
180: -- Validate_Attributes for:OKL_OVD_RUL_TMLS_V --
181: ------------------------------------------------
182: FUNCTION Validate_Attributes (
183: p_ovtv_rec IN ovtv_rec_type
184: ) RETURN VARCHAR2 IS

Line 220: -- Validate_Record for:OKL_OVD_RUL_TMLS_V --

216: ---------------------------------------------------------------------------
217: -- PROCEDURE Validate_Record
218: ---------------------------------------------------------------------------
219: --------------------------------------------
220: -- Validate_Record for:OKL_OVD_RUL_TMLS_V --
221: --------------------------------------------
222: FUNCTION Validate_Record (
223: p_ovtv_rec IN ovtv_rec_type
224: ) RETURN VARCHAR2 IS

Line 755: CURSOR c1(p_ovd_id okl_ovd_rul_tmls_v.ovd_id%TYPE,

751: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
752: l_unq_tbl OKC_UTIL.unq_tbl_type;
753: l_ovt_status VARCHAR2(1);
754: l_row_found Boolean := False;
755: CURSOR c1(p_ovd_id okl_ovd_rul_tmls_v.ovd_id%TYPE,
756: p_rul_id okl_ovd_rul_tmls_v.rul_id%TYPE) is
757: SELECT '1'
758: FROM okl_ovd_rul_tmls_v
759: WHERE ovd_id = p_ovd_id

Line 756: p_rul_id okl_ovd_rul_tmls_v.rul_id%TYPE) is

752: l_unq_tbl OKC_UTIL.unq_tbl_type;
753: l_ovt_status VARCHAR2(1);
754: l_row_found Boolean := False;
755: CURSOR c1(p_ovd_id okl_ovd_rul_tmls_v.ovd_id%TYPE,
756: p_rul_id okl_ovd_rul_tmls_v.rul_id%TYPE) is
757: SELECT '1'
758: FROM okl_ovd_rul_tmls_v
759: WHERE ovd_id = p_ovd_id
760: AND rul_id = p_rul_id

Line 758: FROM okl_ovd_rul_tmls_v

754: l_row_found Boolean := False;
755: CURSOR c1(p_ovd_id okl_ovd_rul_tmls_v.ovd_id%TYPE,
756: p_rul_id okl_ovd_rul_tmls_v.rul_id%TYPE) is
757: SELECT '1'
758: FROM okl_ovd_rul_tmls_v
759: WHERE ovd_id = p_ovd_id
760: AND rul_id = p_rul_id
761: AND id <> nvl(p_ovtv_rec.id,-9999);
762: BEGIN

Line 772: OKC_API.set_message(G_APP_NAME,G_UNQS,G_TABLE_TOKEN, 'Okl_Ovd_Rul_Tmls_V'); ---CHG001

768: FETCH c1 into l_ovt_status;
769: l_row_found := c1%FOUND;
770: CLOSE c1;
771: IF l_row_found then
772: OKC_API.set_message(G_APP_NAME,G_UNQS,G_TABLE_TOKEN, 'Okl_Ovd_Rul_Tmls_V'); ---CHG001
773: x_return_status := OKC_API.G_RET_STS_ERROR;
774: END IF;
775: EXCEPTION
776: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 889: -- validate_row for:OKL_OVD_RUL_TMLS_V --

885: ---------------------------------------------------------------------------
886: -- PROCEDURE validate_row
887: ---------------------------------------------------------------------------
888: -----------------------------------------
889: -- validate_row for:OKL_OVD_RUL_TMLS_V --
890: -----------------------------------------
891: PROCEDURE validate_row(
892: p_api_version IN NUMBER,
893: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1147: -- insert_row for:OKL_OVD_RUL_TMLS_V --

1143: '_PVT'
1144: );
1145: END insert_row;
1146: ---------------------------------------
1147: -- insert_row for:OKL_OVD_RUL_TMLS_V --
1148: ---------------------------------------
1149: PROCEDURE insert_row(
1150: p_api_version IN NUMBER,
1151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1181: -- Set_Attributes for:OKL_OVD_RUL_TMLS_V --

1177: l_ovtv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1178: RETURN(l_ovtv_rec);
1179: END fill_who_columns;
1180: -------------------------------------------
1181: -- Set_Attributes for:OKL_OVD_RUL_TMLS_V --
1182: -------------------------------------------
1183: FUNCTION Set_Attributes (
1184: p_ovtv_rec IN ovtv_rec_type,
1185: x_ovtv_rec OUT NOCOPY ovtv_rec_type

Line 1476: -- lock_row for:OKL_OVD_RUL_TMLS_V --

1472: '_PVT'
1473: );
1474: END lock_row;
1475: -------------------------------------
1476: -- lock_row for:OKL_OVD_RUL_TMLS_V --
1477: -------------------------------------
1478: PROCEDURE lock_row(
1479: p_api_version IN NUMBER,
1480: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1793: -- update_row for:OKL_OVD_RUL_TMLS_V --

1789: '_PVT'
1790: );
1791: END update_row;
1792: ---------------------------------------
1793: -- update_row for:OKL_OVD_RUL_TMLS_V --
1794: ---------------------------------------
1795: PROCEDURE update_row(
1796: p_api_version IN NUMBER,
1797: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1884: -- Set_Attributes for:OKL_OVD_RUL_TMLS_V --

1880: END IF;
1881: RETURN(l_return_status);
1882: END populate_new_record;
1883: -------------------------------------------
1884: -- Set_Attributes for:OKL_OVD_RUL_TMLS_V --
1885: -------------------------------------------
1886: FUNCTION Set_Attributes (
1887: p_ovtv_rec IN ovtv_rec_type,
1888: x_ovtv_rec OUT NOCOPY ovtv_rec_type

Line 2137: -- delete_row for:OKL_OVD_RUL_TMLS_V --

2133: '_PVT'
2134: );
2135: END delete_row;
2136: ---------------------------------------
2137: -- delete_row for:OKL_OVD_RUL_TMLS_V --
2138: ---------------------------------------
2139: PROCEDURE delete_row(
2140: p_api_version IN NUMBER,
2141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,