APPS.OKL_ITI_PVT dependencies on OKX_ORGANIZATION_DEFS_V

Line 1005: -- Description : Validate against OKX_ORGANIZATION_DEFS_V

1001: --------------------------------------14------------------------------------------
1002: -- Start of Commnets
1003: -- Badrinath Kuchibholta
1004: -- Procedure Name : validate_inv_org_id
1005: -- Description : Validate against OKX_ORGANIZATION_DEFS_V
1006: -- Business Rules :
1007: -- Parameters : OUT Return Status, IN Rec Info
1008: -- Version : 1.0
1009: -- End of Commnets

Line 1014: CURSOR c_inventory_org_id_validate(p_id1 OKX_ORGANIZATION_DEFS_V.ID1%TYPE) is

1010:
1011: PROCEDURE validate_inv_org_id(x_return_status OUT NOCOPY VARCHAR2,
1012: p_itiv_rec IN itiv_rec_type) IS
1013: ln_dummy number := 0;
1014: CURSOR c_inventory_org_id_validate(p_id1 OKX_ORGANIZATION_DEFS_V.ID1%TYPE) is
1015: SELECT 1
1016: FROM DUAL
1017: WHERE EXISTS (SELECT '1'
1018: FROM OKX_ORGANIZATION_DEFS_V

Line 1018: FROM OKX_ORGANIZATION_DEFS_V

1014: CURSOR c_inventory_org_id_validate(p_id1 OKX_ORGANIZATION_DEFS_V.ID1%TYPE) is
1015: SELECT 1
1016: FROM DUAL
1017: WHERE EXISTS (SELECT '1'
1018: FROM OKX_ORGANIZATION_DEFS_V
1019: WHERE id2 = G_ID2
1020: AND organization_type = 'INV'
1021: AND id1 = p_id1);
1022: BEGIN