APPS.OKL_TAL_PVT dependencies on OKX_ASST_CATGRS_V

Line 276: -- Description : FK validation with OKX_ASST_CATGRS_V

272: ---------------------------------4-----------------------------------------------
273: -- Start of Commnets
274: -- Badrinath Kuchibholta
275: -- Procedure Name : Validate_iay_id
276: -- Description : FK validation with OKX_ASST_CATGRS_V
277: -- Business Rules :
278: -- Parameters : OUT Return Status, IN Rec Info
279: -- Version : 1.0
280: -- End of Commnets

Line 290: FROM OKX_ASST_CATGRS_V

286: CURSOR c_iay_id_validate(p_id number) is
287: SELECT 1
288: FROM DUAL
289: WHERE EXISTS (SELECT id1
290: FROM OKX_ASST_CATGRS_V
291: WHERE id1 = p_id
292: AND id2 = G_ID2);
293: BEGIN
294: -- initialize return status

Line 350: -- Description : FK validation with OKX_ASST_CATGRS_V

346: ----------------------------------5----------------------------------------------
347: -- Start of Commnets
348: -- Badrinath Kuchibholta
349: -- Procedure Name : Validate_iay_id_new
350: -- Description : FK validation with OKX_ASST_CATGRS_V
351: -- Business Rules :
352: -- Parameters : OUT Return Status, IN Rec Info
353: -- Version : 1.0
354: -- End of Commnets

Line 364: FROM OKX_ASST_CATGRS_V

360: CURSOR c_iay_id_new_validate(p_id number) is
361: SELECT 1
362: FROM DUAL
363: WHERE EXISTS (SELECT id1
364: FROM OKX_ASST_CATGRS_V
365: WHERE id1 = p_id
366: AND id2 = G_ID2);
367: BEGIN
368: -- initialize return status

Line 803: -- Description : FK validation with OKX_ASST_CATGRS_V

799: -----------------------------------------13---------------------------------------
800: -- Start of Commnets
801: -- Badrinath Kuchibholta
802: -- Procedure Name : Validate_deprn_id
803: -- Description : FK validation with OKX_ASST_CATGRS_V
804: -- Business Rules :
805: -- Parameters : OUT Return Status, IN Rec Info
806: -- Version : 1.0
807: -- End of Commnets

Line 813: CURSOR c_deprn_id_validate(p_id1 OKX_ASST_CATGRS_V.ID1%type) is

809: PROCEDURE validate_deprn_id(x_return_status OUT NOCOPY VARCHAR2,
810: p_talv_rec IN talv_rec_type) IS
811:
812: ln_dummy number := 0;
813: CURSOR c_deprn_id_validate(p_id1 OKX_ASST_CATGRS_V.ID1%type) is
814: SELECT 1
815: FROM DUAL
816: WHERE EXISTS (SELECT '1'
817: FROM OKX_ASST_CATGRS_V

Line 817: FROM OKX_ASST_CATGRS_V

813: CURSOR c_deprn_id_validate(p_id1 OKX_ASST_CATGRS_V.ID1%type) is
814: SELECT 1
815: FROM DUAL
816: WHERE EXISTS (SELECT '1'
817: FROM OKX_ASST_CATGRS_V
818: WHERE id1 = p_id1
819: and id2 = G_ID2);
820: BEGIN
821: -- initialize return status