DBA Data[Home] [Help]

APPS.OKL_SUB_PVT dependencies on OKL_SUBSIDIES_V

Line 186: -- FUNCTION get_rec for: OKL_SUBSIDIES_V

182: );
183: END add_language;
184:
185: ---------------------------------------------------------------------------
186: -- FUNCTION get_rec for: OKL_SUBSIDIES_V
187: ---------------------------------------------------------------------------
188: FUNCTION get_rec (
189: p_subv_rec IN subv_rec_type,
190: x_no_data_found OUT NOCOPY BOOLEAN

Line 192: CURSOR okl_subsidies_v_pk_csr (p_id IN NUMBER) IS

188: FUNCTION get_rec (
189: p_subv_rec IN subv_rec_type,
190: x_no_data_found OUT NOCOPY BOOLEAN
191: ) RETURN subv_rec_type IS
192: CURSOR okl_subsidies_v_pk_csr (p_id IN NUMBER) IS
193: SELECT
194: ID,
195: OBJECT_VERSION_NUMBER,
196: SFWT_FLAG,

Line 250: FROM Okl_Subsidies_V

246: LAST_UPDATE_LOGIN,
247: -- sjalasut added new column for subsidy pools enhancement. start
248: SUBSIDY_POOL_ID
249: -- sjalasut added new column for subsidy pools enhancement. end
250: FROM Okl_Subsidies_V
251: WHERE okl_subsidies_v.id = p_id;
252: l_okl_subsidies_v_pk okl_subsidies_v_pk_csr%ROWTYPE;
253: l_subv_rec subv_rec_type;
254: BEGIN

Line 251: WHERE okl_subsidies_v.id = p_id;

247: -- sjalasut added new column for subsidy pools enhancement. start
248: SUBSIDY_POOL_ID
249: -- sjalasut added new column for subsidy pools enhancement. end
250: FROM Okl_Subsidies_V
251: WHERE okl_subsidies_v.id = p_id;
252: l_okl_subsidies_v_pk okl_subsidies_v_pk_csr%ROWTYPE;
253: l_subv_rec subv_rec_type;
254: BEGIN
255: x_no_data_found := TRUE;

Line 252: l_okl_subsidies_v_pk okl_subsidies_v_pk_csr%ROWTYPE;

248: SUBSIDY_POOL_ID
249: -- sjalasut added new column for subsidy pools enhancement. end
250: FROM Okl_Subsidies_V
251: WHERE okl_subsidies_v.id = p_id;
252: l_okl_subsidies_v_pk okl_subsidies_v_pk_csr%ROWTYPE;
253: l_subv_rec subv_rec_type;
254: BEGIN
255: x_no_data_found := TRUE;
256: -- Get current database values

Line 257: OPEN okl_subsidies_v_pk_csr (p_subv_rec.id);

253: l_subv_rec subv_rec_type;
254: BEGIN
255: x_no_data_found := TRUE;
256: -- Get current database values
257: OPEN okl_subsidies_v_pk_csr (p_subv_rec.id);
258: FETCH okl_subsidies_v_pk_csr INTO
259: l_subv_rec.id,
260: l_subv_rec.object_version_number,
261: l_subv_rec.sfwt_flag,

Line 258: FETCH okl_subsidies_v_pk_csr INTO

254: BEGIN
255: x_no_data_found := TRUE;
256: -- Get current database values
257: OPEN okl_subsidies_v_pk_csr (p_subv_rec.id);
258: FETCH okl_subsidies_v_pk_csr INTO
259: l_subv_rec.id,
260: l_subv_rec.object_version_number,
261: l_subv_rec.sfwt_flag,
262: l_subv_rec.org_id,

Line 315: x_no_data_found := okl_subsidies_v_pk_csr%NOTFOUND;

311: l_subv_rec.last_update_login,
312: -- sjalasut added new column for subsidy pools enhancement. start
313: l_subv_rec.subsidy_pool_id;
314: -- sjalasut added new column for subsidy pools enhancement. end
315: x_no_data_found := okl_subsidies_v_pk_csr%NOTFOUND;
316: CLOSE okl_subsidies_v_pk_csr;
317: RETURN(l_subv_rec);
318: END get_rec;
319:

Line 316: CLOSE okl_subsidies_v_pk_csr;

312: -- sjalasut added new column for subsidy pools enhancement. start
313: l_subv_rec.subsidy_pool_id;
314: -- sjalasut added new column for subsidy pools enhancement. end
315: x_no_data_found := okl_subsidies_v_pk_csr%NOTFOUND;
316: CLOSE okl_subsidies_v_pk_csr;
317: RETURN(l_subv_rec);
318: END get_rec;
319:
320: ------------------------------------------------------------------

Line 583: -- FUNCTION null_out_defaults for: OKL_SUBSIDIES_V

579: BEGIN
580: RETURN(get_rec(p_subb_rec, l_row_not_found));
581: END get_rec;
582: ---------------------------------------------------------------------------
583: -- FUNCTION null_out_defaults for: OKL_SUBSIDIES_V
584: ---------------------------------------------------------------------------
585: FUNCTION null_out_defaults (
586: p_subv_rec IN subv_rec_type
587: ) RETURN subv_rec_type IS

Line 1740: -- Validate_Attributes for:OKL_SUBSIDIES_V --

1736: ---------------------------------------------------------------------------
1737: -- FUNCTION Validate_Attributes
1738: ---------------------------------------------------------------------------
1739: ---------------------------------------------
1740: -- Validate_Attributes for:OKL_SUBSIDIES_V --
1741: ---------------------------------------------
1742: FUNCTION Validate_Attributes (
1743: p_subv_rec IN subv_rec_type
1744: ) RETURN VARCHAR2 IS

Line 1973: -- Validate Record for:OKL_SUBSIDIES_V --

1969: ---------------------------------------------------------------------------
1970: -- PROCEDURE Validate_Record
1971: ---------------------------------------------------------------------------
1972: -----------------------------------------
1973: -- Validate Record for:OKL_SUBSIDIES_V --
1974: -----------------------------------------
1975: FUNCTION Validate_Record (
1976: p_subv_rec IN subv_rec_type,
1977: p_db_subv_rec IN subv_rec_type

Line 2360: -- Validate Record for:OKL_SUBSIDIES_V --

2356: ---------------------------------------------------------------------------
2357: -- PROCEDURE Validate_Record
2358: ---------------------------------------------------------------------------
2359: -----------------------------------------
2360: -- Validate Record for:OKL_SUBSIDIES_V --
2361: -----------------------------------------
2362: FUNCTION Validate_Record (
2363: p_subv_rec IN subv_rec_type,
2364: p_db_subv_rec IN subv_rec_type

Line 2375: CURSOR okl_subsidies_v_fk1_csr (p_lookup_code IN VARCHAR2) IS

2371: p_subv_rec IN subv_rec_type,
2372: p_db_subv_rec IN subv_rec_type
2373: ) RETURN VARCHAR2 IS
2374: item_not_found_error EXCEPTION;
2375: CURSOR okl_subsidies_v_fk1_csr (p_lookup_code IN VARCHAR2) IS
2376: SELECT 'x'
2377: FROM Fnd_Lookup_Values
2378: WHERE fnd_lookup_values.lookup_code = p_lookup_code;
2379: l_okl_subsidies_v_fk1 okl_subsidies_v_fk1_csr%ROWTYPE;

Line 2379: l_okl_subsidies_v_fk1 okl_subsidies_v_fk1_csr%ROWTYPE;

2375: CURSOR okl_subsidies_v_fk1_csr (p_lookup_code IN VARCHAR2) IS
2376: SELECT 'x'
2377: FROM Fnd_Lookup_Values
2378: WHERE fnd_lookup_values.lookup_code = p_lookup_code;
2379: l_okl_subsidies_v_fk1 okl_subsidies_v_fk1_csr%ROWTYPE;
2380:
2381: CURSOR okl_subsidies_v_fk2_csr (p_id IN NUMBER,
2382: p_org_id IN NUMBER) IS
2383: SELECT 'x'

Line 2381: CURSOR okl_subsidies_v_fk2_csr (p_id IN NUMBER,

2377: FROM Fnd_Lookup_Values
2378: WHERE fnd_lookup_values.lookup_code = p_lookup_code;
2379: l_okl_subsidies_v_fk1 okl_subsidies_v_fk1_csr%ROWTYPE;
2380:
2381: CURSOR okl_subsidies_v_fk2_csr (p_id IN NUMBER,
2382: p_org_id IN NUMBER) IS
2383: SELECT 'x'
2384: FROM Okl_Formulae_B
2385: WHERE okl_formulae_b.id = p_id

Line 2387: l_okl_subsidies_v_fk2 okl_subsidies_v_fk2_csr%ROWTYPE;

2383: SELECT 'x'
2384: FROM Okl_Formulae_B
2385: WHERE okl_formulae_b.id = p_id
2386: AND okl_formulae_b.org_id = p_org_id;
2387: l_okl_subsidies_v_fk2 okl_subsidies_v_fk2_csr%ROWTYPE;
2388:
2389: CURSOR okl_subsidies_v_fk6_csr (p_id IN NUMBER) IS
2390: SELECT 'x'
2391: FROM Okl_Strm_Type_B

Line 2389: CURSOR okl_subsidies_v_fk6_csr (p_id IN NUMBER) IS

2385: WHERE okl_formulae_b.id = p_id
2386: AND okl_formulae_b.org_id = p_org_id;
2387: l_okl_subsidies_v_fk2 okl_subsidies_v_fk2_csr%ROWTYPE;
2388:
2389: CURSOR okl_subsidies_v_fk6_csr (p_id IN NUMBER) IS
2390: SELECT 'x'
2391: FROM Okl_Strm_Type_B
2392: WHERE okl_strm_type_b.id = p_id;
2393: l_okl_subsidies_v_fk6 okl_subsidies_v_fk6_csr%ROWTYPE;

Line 2393: l_okl_subsidies_v_fk6 okl_subsidies_v_fk6_csr%ROWTYPE;

2389: CURSOR okl_subsidies_v_fk6_csr (p_id IN NUMBER) IS
2390: SELECT 'x'
2391: FROM Okl_Strm_Type_B
2392: WHERE okl_strm_type_b.id = p_id;
2393: l_okl_subsidies_v_fk6 okl_subsidies_v_fk6_csr%ROWTYPE;
2394:
2395: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2396: l_row_notfound BOOLEAN := TRUE;
2397: BEGIN

Line 2402: OPEN okl_subsidies_v_fk1_csr (p_subv_rec.SUBSIDY_CALC_BASIS);

2398: IF ((p_subv_rec.SUBSIDY_CALC_BASIS IS NOT NULL)
2399: AND
2400: (p_subv_rec.SUBSIDY_CALC_BASIS <> p_db_subv_rec.SUBSIDY_CALC_BASIS))
2401: THEN
2402: OPEN okl_subsidies_v_fk1_csr (p_subv_rec.SUBSIDY_CALC_BASIS);
2403: FETCH okl_subsidies_v_fk1_csr INTO l_okl_subsidies_v_fk1;
2404: l_row_notfound := okl_subsidies_v_fk1_csr%NOTFOUND;
2405: CLOSE okl_subsidies_v_fk1_csr;
2406: IF (l_row_notfound) THEN

Line 2403: FETCH okl_subsidies_v_fk1_csr INTO l_okl_subsidies_v_fk1;

2399: AND
2400: (p_subv_rec.SUBSIDY_CALC_BASIS <> p_db_subv_rec.SUBSIDY_CALC_BASIS))
2401: THEN
2402: OPEN okl_subsidies_v_fk1_csr (p_subv_rec.SUBSIDY_CALC_BASIS);
2403: FETCH okl_subsidies_v_fk1_csr INTO l_okl_subsidies_v_fk1;
2404: l_row_notfound := okl_subsidies_v_fk1_csr%NOTFOUND;
2405: CLOSE okl_subsidies_v_fk1_csr;
2406: IF (l_row_notfound) THEN
2407: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SUBSIDY_CALC_BASIS');

Line 2404: l_row_notfound := okl_subsidies_v_fk1_csr%NOTFOUND;

2400: (p_subv_rec.SUBSIDY_CALC_BASIS <> p_db_subv_rec.SUBSIDY_CALC_BASIS))
2401: THEN
2402: OPEN okl_subsidies_v_fk1_csr (p_subv_rec.SUBSIDY_CALC_BASIS);
2403: FETCH okl_subsidies_v_fk1_csr INTO l_okl_subsidies_v_fk1;
2404: l_row_notfound := okl_subsidies_v_fk1_csr%NOTFOUND;
2405: CLOSE okl_subsidies_v_fk1_csr;
2406: IF (l_row_notfound) THEN
2407: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SUBSIDY_CALC_BASIS');
2408: RAISE item_not_found_error;

Line 2405: CLOSE okl_subsidies_v_fk1_csr;

2401: THEN
2402: OPEN okl_subsidies_v_fk1_csr (p_subv_rec.SUBSIDY_CALC_BASIS);
2403: FETCH okl_subsidies_v_fk1_csr INTO l_okl_subsidies_v_fk1;
2404: l_row_notfound := okl_subsidies_v_fk1_csr%NOTFOUND;
2405: CLOSE okl_subsidies_v_fk1_csr;
2406: IF (l_row_notfound) THEN
2407: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SUBSIDY_CALC_BASIS');
2408: RAISE item_not_found_error;
2409: END IF;

Line 2417: OPEN okl_subsidies_v_fk2_csr (p_subv_rec.FORMULA_ID,

2413: AND
2414: ((p_subv_rec.FORMULA_ID <> p_db_subv_rec.FORMULA_ID) OR
2415: (p_subv_rec.ORG_ID <> p_db_subv_rec.ORG_ID)))
2416: THEN
2417: OPEN okl_subsidies_v_fk2_csr (p_subv_rec.FORMULA_ID,
2418: p_subv_rec.ORG_ID);
2419: FETCH okl_subsidies_v_fk2_csr INTO l_okl_subsidies_v_fk2;
2420: l_row_notfound := okl_subsidies_v_fk2_csr%NOTFOUND;
2421: CLOSE okl_subsidies_v_fk2_csr;

Line 2419: FETCH okl_subsidies_v_fk2_csr INTO l_okl_subsidies_v_fk2;

2415: (p_subv_rec.ORG_ID <> p_db_subv_rec.ORG_ID)))
2416: THEN
2417: OPEN okl_subsidies_v_fk2_csr (p_subv_rec.FORMULA_ID,
2418: p_subv_rec.ORG_ID);
2419: FETCH okl_subsidies_v_fk2_csr INTO l_okl_subsidies_v_fk2;
2420: l_row_notfound := okl_subsidies_v_fk2_csr%NOTFOUND;
2421: CLOSE okl_subsidies_v_fk2_csr;
2422: IF (l_row_notfound) THEN
2423: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'FORMULA_ID');

Line 2420: l_row_notfound := okl_subsidies_v_fk2_csr%NOTFOUND;

2416: THEN
2417: OPEN okl_subsidies_v_fk2_csr (p_subv_rec.FORMULA_ID,
2418: p_subv_rec.ORG_ID);
2419: FETCH okl_subsidies_v_fk2_csr INTO l_okl_subsidies_v_fk2;
2420: l_row_notfound := okl_subsidies_v_fk2_csr%NOTFOUND;
2421: CLOSE okl_subsidies_v_fk2_csr;
2422: IF (l_row_notfound) THEN
2423: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'FORMULA_ID');
2424: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ORG_ID');

Line 2421: CLOSE okl_subsidies_v_fk2_csr;

2417: OPEN okl_subsidies_v_fk2_csr (p_subv_rec.FORMULA_ID,
2418: p_subv_rec.ORG_ID);
2419: FETCH okl_subsidies_v_fk2_csr INTO l_okl_subsidies_v_fk2;
2420: l_row_notfound := okl_subsidies_v_fk2_csr%NOTFOUND;
2421: CLOSE okl_subsidies_v_fk2_csr;
2422: IF (l_row_notfound) THEN
2423: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'FORMULA_ID');
2424: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ORG_ID');
2425: RAISE item_not_found_error;

Line 2432: OPEN okl_subsidies_v_fk6_csr (p_subv_rec.STREAM_TYPE_ID);

2428: IF ((p_subv_rec.STREAM_TYPE_ID IS NOT NULL)
2429: AND
2430: (p_subv_rec.STREAM_TYPE_ID <> p_db_subv_rec.STREAM_TYPE_ID))
2431: THEN
2432: OPEN okl_subsidies_v_fk6_csr (p_subv_rec.STREAM_TYPE_ID);
2433: FETCH okl_subsidies_v_fk6_csr INTO l_okl_subsidies_v_fk6;
2434: l_row_notfound := okl_subsidies_v_fk6_csr%NOTFOUND;
2435: CLOSE okl_subsidies_v_fk6_csr;
2436: IF (l_row_notfound) THEN

Line 2433: FETCH okl_subsidies_v_fk6_csr INTO l_okl_subsidies_v_fk6;

2429: AND
2430: (p_subv_rec.STREAM_TYPE_ID <> p_db_subv_rec.STREAM_TYPE_ID))
2431: THEN
2432: OPEN okl_subsidies_v_fk6_csr (p_subv_rec.STREAM_TYPE_ID);
2433: FETCH okl_subsidies_v_fk6_csr INTO l_okl_subsidies_v_fk6;
2434: l_row_notfound := okl_subsidies_v_fk6_csr%NOTFOUND;
2435: CLOSE okl_subsidies_v_fk6_csr;
2436: IF (l_row_notfound) THEN
2437: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'STREAM_TYPE_ID');

Line 2434: l_row_notfound := okl_subsidies_v_fk6_csr%NOTFOUND;

2430: (p_subv_rec.STREAM_TYPE_ID <> p_db_subv_rec.STREAM_TYPE_ID))
2431: THEN
2432: OPEN okl_subsidies_v_fk6_csr (p_subv_rec.STREAM_TYPE_ID);
2433: FETCH okl_subsidies_v_fk6_csr INTO l_okl_subsidies_v_fk6;
2434: l_row_notfound := okl_subsidies_v_fk6_csr%NOTFOUND;
2435: CLOSE okl_subsidies_v_fk6_csr;
2436: IF (l_row_notfound) THEN
2437: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'STREAM_TYPE_ID');
2438: RAISE item_not_found_error;

Line 2435: CLOSE okl_subsidies_v_fk6_csr;

2431: THEN
2432: OPEN okl_subsidies_v_fk6_csr (p_subv_rec.STREAM_TYPE_ID);
2433: FETCH okl_subsidies_v_fk6_csr INTO l_okl_subsidies_v_fk6;
2434: l_row_notfound := okl_subsidies_v_fk6_csr%NOTFOUND;
2435: CLOSE okl_subsidies_v_fk6_csr;
2436: IF (l_row_notfound) THEN
2437: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'STREAM_TYPE_ID');
2438: RAISE item_not_found_error;
2439: END IF;

Line 2617: -- validate_row for:OKL_SUBSIDIES_V --

2613: ---------------------------------------------------------------------------
2614: -- PROCEDURE validate_row
2615: ---------------------------------------------------------------------------
2616: --------------------------------------
2617: -- validate_row for:OKL_SUBSIDIES_V --
2618: --------------------------------------
2619: PROCEDURE validate_row(
2620: p_api_version IN NUMBER,
2621: p_init_msg_list IN VARCHAR2,

Line 2694: -- PL/SQL TBL validate_row for:OKL_SUBSIDIES_V --

2690: '_PVT'
2691: );
2692: END validate_row;
2693: -------------------------------------------------
2694: -- PL/SQL TBL validate_row for:OKL_SUBSIDIES_V --
2695: -------------------------------------------------
2696: PROCEDURE validate_row(
2697: p_api_version IN NUMBER,
2698: p_init_msg_list IN VARCHAR2,

Line 2790: -- PL/SQL TBL validate_row for:OKL_SUBSIDIES_V --

2786: );
2787: END validate_row;
2788:
2789: -------------------------------------------------
2790: -- PL/SQL TBL validate_row for:OKL_SUBSIDIES_V --
2791: -------------------------------------------------
2792: PROCEDURE validate_row(
2793: p_api_version IN NUMBER,
2794: p_init_msg_list IN VARCHAR2,

Line 3166: -- insert_row for :OKL_SUBSIDIES_V --

3162: '_PVT'
3163: );
3164: END insert_row;
3165: -------------------------------------
3166: -- insert_row for :OKL_SUBSIDIES_V --
3167: -------------------------------------
3168: PROCEDURE insert_row(
3169: p_api_version IN NUMBER,
3170: p_init_msg_list IN VARCHAR2,

Line 3202: -- Set_Attributes for:OKL_SUBSIDIES_V --

3198: l_subv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3199: RETURN(l_subv_rec);
3200: END fill_who_columns;
3201: ----------------------------------------
3202: -- Set_Attributes for:OKL_SUBSIDIES_V --
3203: ----------------------------------------
3204: FUNCTION Set_Attributes (
3205: p_subv_rec IN subv_rec_type,
3206: x_subv_rec OUT NOCOPY subv_rec_type

Line 3689: -- lock_row for: OKL_SUBSIDIES_V --

3685: '_PVT'
3686: );
3687: END lock_row;
3688: -----------------------------------
3689: -- lock_row for: OKL_SUBSIDIES_V --
3690: -----------------------------------
3691: PROCEDURE lock_row(
3692: p_api_version IN NUMBER,
3693: p_init_msg_list IN VARCHAR2,

Line 4479: -- update_row for:OKL_SUBSIDIES_V --

4475: '_PVT'
4476: );
4477: END update_row;
4478: ------------------------------------
4479: -- update_row for:OKL_SUBSIDIES_V --
4480: ------------------------------------
4481: PROCEDURE update_row(
4482: p_api_version IN NUMBER,
4483: p_init_msg_list IN VARCHAR2,

Line 4741: -- Set_Attributes for:OKL_SUBSIDIES_V --

4737: END IF;
4738: RETURN(l_return_status);
4739: END populate_new_record;
4740: ----------------------------------------
4741: -- Set_Attributes for:OKL_SUBSIDIES_V --
4742: ----------------------------------------
4743: FUNCTION Set_Attributes (
4744: p_subv_rec IN subv_rec_type,
4745: x_subv_rec OUT NOCOPY subv_rec_type

Line 5176: -- delete_row for:OKL_SUBSIDIES_V --

5172: '_PVT'
5173: );
5174: END delete_row;
5175: ------------------------------------
5176: -- delete_row for:OKL_SUBSIDIES_V --
5177: ------------------------------------
5178: PROCEDURE delete_row(
5179: p_api_version IN NUMBER,
5180: p_init_msg_list IN VARCHAR2,

Line 5272: -- PL/SQL TBL delete_row for:OKL_SUBSIDIES_V --

5268: '_PVT'
5269: );
5270: END delete_row;
5271: -----------------------------------------------
5272: -- PL/SQL TBL delete_row for:OKL_SUBSIDIES_V --
5273: -----------------------------------------------
5274: PROCEDURE delete_row(
5275: p_api_version IN NUMBER,
5276: p_init_msg_list IN VARCHAR2,

Line 5368: -- PL/SQL TBL delete_row for:OKL_SUBSIDIES_V --

5364: );
5365: END delete_row;
5366:
5367: -----------------------------------------------
5368: -- PL/SQL TBL delete_row for:OKL_SUBSIDIES_V --
5369: -----------------------------------------------
5370: PROCEDURE delete_row(
5371: p_api_version IN NUMBER,
5372: p_init_msg_list IN VARCHAR2,