124: -------------------------------2--------------------------------------------------
125: -- Start of Commnets
126: -- Badrinath Kuchibholta
127: -- Procedure Name : Validate_ilo_id
128: -- Description : FK validation with OKX_AST_LOCS_V
129: -- Business Rules :
130: -- Parameters : OUT Return Status, IN Rec Info
131: -- Version : 1.0
132: -- End of Commnets
138: CURSOR c_ilo_id_validate(p_id number) is
139: SELECT 1
140: FROM DUAL
141: WHERE EXISTS (SELECT id1
142: FROM OKX_AST_LOCS_V
143: WHERE id1 = p_id
144: AND id2 = G_ID2);
145:
146: BEGIN
198: --------------------------------3-------------------------------------------------
199: -- Start of Commnets
200: -- Badrinath Kuchibholta
201: -- Procedure Name : Validate_ilo_id_old
202: -- Description : FK validation with OKX_AST_LOCS_V
203: -- Business Rules :
204: -- Parameters : OUT Return Status, IN Rec Info
205: -- Version : 1.0
206: -- End of Commnets
212: CURSOR c_ilo_id_old_validate(p_id number) is
213: SELECT 1
214: FROM DUAL
215: WHERE EXISTS (SELECT id1
216: FROM OKX_AST_LOCS_V
217: WHERE id1 = p_id
218: AND id2 = G_ID2);
219:
220: BEGIN
883: PROCEDURE validate_fa_location_id(x_return_status OUT NOCOPY VARCHAR2,
884: p_talv_rec IN talv_rec_type) IS
885:
886: ln_dummy number := 0;
887: CURSOR c_fa_location_id_validate(p_fa_location_id OKX_AST_LOCS_V.LOCATION_ID%TYPE) is
888: SELECT 1
889: FROM DUAL
890: WHERE EXISTS (SELECT '1'
891: FROM OKX_AST_LOCS_V
887: CURSOR c_fa_location_id_validate(p_fa_location_id OKX_AST_LOCS_V.LOCATION_ID%TYPE) is
888: SELECT 1
889: FROM DUAL
890: WHERE EXISTS (SELECT '1'
891: FROM OKX_AST_LOCS_V
892: WHERE id1 = p_fa_location_id
893: AND id2 = G_ID2);
894:
895: BEGIN