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_SPP_PVT dependencies on OKL_SIF_PRICE_PARMS_V

Line 125: -- FUNCTION get_rec for: OKL_SIF_PRICE_PARMS_V

121: BEGIN
122: RETURN(get_rec(p_spp_rec, l_row_notfound));
123: END get_rec;
124: ---------------------------------------------------------------------------
125: -- FUNCTION get_rec for: OKL_SIF_PRICE_PARMS_V
126: ---------------------------------------------------------------------------
127: FUNCTION get_rec (
128: p_sppv_rec IN sppv_rec_type,
129: x_no_data_found OUT NOCOPY BOOLEAN

Line 165: FROM OKL_SIF_PRICE_PARMS_V

161: LAST_UPDATED_BY,
162: CREATION_DATE,
163: LAST_UPDATE_DATE,
164: LAST_UPDATE_LOGIN
165: FROM OKL_SIF_PRICE_PARMS_V
166: WHERE OKL_SIF_PRICE_PARMS_V.id = p_id;
167: l_okl_sppv_pk okl_sppv_pk_csr%ROWTYPE;
168: l_sppv_rec sppv_rec_type;
169: BEGIN

Line 166: WHERE OKL_SIF_PRICE_PARMS_V.id = p_id;

162: CREATION_DATE,
163: LAST_UPDATE_DATE,
164: LAST_UPDATE_LOGIN
165: FROM OKL_SIF_PRICE_PARMS_V
166: WHERE OKL_SIF_PRICE_PARMS_V.id = p_id;
167: l_okl_sppv_pk okl_sppv_pk_csr%ROWTYPE;
168: l_sppv_rec sppv_rec_type;
169: BEGIN
170: x_no_data_found := TRUE;

Line 218: -- FUNCTION null_out_defaults for: OKL_SIF_PRICE_PARMS_V --

214: BEGIN
215: RETURN(get_rec(p_sppv_rec, l_row_notfound));
216: END get_rec;
217: -----------------------------------------------------------
218: -- FUNCTION null_out_defaults for: OKL_SIF_PRICE_PARMS_V --
219: -----------------------------------------------------------
220: FUNCTION null_out_defaults (
221: p_sppv_rec IN sppv_rec_type
222: ) RETURN sppv_rec_type IS

Line 330: -- Validate_Attributes for:OKL_SIF_PRICE_PARMS_V --

326: ---------------------------------------------------------------------------
327: -- PROCEDURE Validate_Attributes
328: ---------------------------------------------------------------------------
329: ---------------------------------------------------
330: -- Validate_Attributes for:OKL_SIF_PRICE_PARMS_V --
331: ---------------------------------------------------
332: FUNCTION Validate_Attributes (
333: p_sppv_rec IN sppv_rec_type
334: ) RETURN VARCHAR2 IS

Line 379: -- Validate_Record for:OKL_SIF_PRICE_PARMS_V --

375: ---------------------------------------------------------------------------
376: -- PROCEDURE Validate_Record
377: ---------------------------------------------------------------------------
378: -----------------------------------------------
379: -- Validate_Record for:OKL_SIF_PRICE_PARMS_V --
380: -----------------------------------------------
381: FUNCTION Validate_Record (
382: p_sppv_rec IN sppv_rec_type
383: ) RETURN VARCHAR2 IS

Line 995: FROM okl_sif_price_parms_v

991: l_row_found BOOLEAN := FALSE;
992: -- Cursor for spp Unique Key
993: CURSOR okl_spp_uk_csr(p_rec sppv_rec_type) IS
994: SELECT '1'
995: FROM okl_sif_price_parms_v
996: WHERE name = p_rec.name
997: AND version = p_rec.version
998: AND id <> NVL(p_rec.id,-9999);
999: BEGIN

Line 1160: -- validate_row for:OKL_SIF_PRICE_PARMS_V --

1156: ---------------------------------------------------------------------------
1157: -- PROCEDURE validate_row
1158: ---------------------------------------------------------------------------
1159: --------------------------------------------
1160: -- validate_row for:OKL_SIF_PRICE_PARMS_V --
1161: --------------------------------------------
1162: PROCEDURE validate_row(
1163: p_api_version IN NUMBER,
1164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1465: -- insert_row for:OKL_SIF_PRICE_PARMS_V --

1461: '_PVT'
1462: );
1463: END insert_row;
1464: ------------------------------------------
1465: -- insert_row for:OKL_SIF_PRICE_PARMS_V --
1466: ------------------------------------------
1467: PROCEDURE insert_row(
1468: p_api_version IN NUMBER,
1469: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1498: -- Set_Attributes for:OKL_SIF_PRICE_PARMS_V --

1494: l_sppv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1495: RETURN(l_sppv_rec);
1496: END fill_who_columns;
1497: ----------------------------------------------
1498: -- Set_Attributes for:OKL_SIF_PRICE_PARMS_V --
1499: ----------------------------------------------
1500: FUNCTION Set_Attributes (
1501: p_sppv_rec IN sppv_rec_type,
1502: x_sppv_rec OUT NOCOPY sppv_rec_type

Line 1795: -- lock_row for:OKL_SIF_PRICE_PARMS_V --

1791: '_PVT'
1792: );
1793: END lock_row;
1794: ----------------------------------------
1795: -- lock_row for:OKL_SIF_PRICE_PARMS_V --
1796: ----------------------------------------
1797: PROCEDURE lock_row(
1798: p_api_version IN NUMBER,
1799: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2224: -- update_row for:OKL_SIF_PRICE_PARMS_V --

2220: '_PVT'
2221: );
2222: END update_row;
2223: ------------------------------------------
2224: -- update_row for:OKL_SIF_PRICE_PARMS_V --
2225: ------------------------------------------
2226: PROCEDURE update_row(
2227: p_api_version IN NUMBER,
2228: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2402: -- Set_Attributes for:OKL_SIF_PRICE_PARMS_V --

2398: END IF;
2399: RETURN(l_return_status);
2400: END populate_new_record;
2401: ----------------------------------------------
2402: -- Set_Attributes for:OKL_SIF_PRICE_PARMS_V --
2403: ----------------------------------------------
2404: FUNCTION Set_Attributes (
2405: p_sppv_rec IN sppv_rec_type,
2406: x_sppv_rec OUT NOCOPY sppv_rec_type

Line 2657: -- delete_row for:OKL_SIF_PRICE_PARMS_V --

2653: '_PVT'
2654: );
2655: END delete_row;
2656: ------------------------------------------
2657: -- delete_row for:OKL_SIF_PRICE_PARMS_V --
2658: ------------------------------------------
2659: PROCEDURE delete_row(
2660: p_api_version IN NUMBER,
2661: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,