APPS.OKL_SSC_WF dependencies on OKC_K_LINES_V

Line 732: l_asset_number OKC_K_LINES_V.NAME%TYPE;

728: l_old_location_id2 VARCHAR2(100);
729: l_new_location_id2 VARCHAR2(100);
730: l_trx_date DATE;
731: l_asset_id VARCHAR2(100);
732: l_asset_number OKC_K_LINES_V.NAME%TYPE;
733: l_old_location OKX_PARTY_SITE_USES_V.DESCRIPTION%TYPE;
734: l_new_location OKX_PARTY_SITE_USES_V.DESCRIPTION%TYPE;
735:
736: CURSOR c_get_location(cp_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE,

Line 743: CURSOR c_get_asset_dtls(cp_kle_id IN OKC_K_LINES_V.ID%TYPE) IS

739: FROM OKX_PARTY_SITE_USES_V PSU
740: WHERE PSU.ID1 = cp_id1
741: AND PSU.ID2 = cp_id2;
742:
743: CURSOR c_get_asset_dtls(cp_kle_id IN OKC_K_LINES_V.ID%TYPE) IS
744: SELECT NAME
745: FROM OKC_K_LINES_V
746: WHERE ID = cp_kle_id;
747: -- Bug#4274575 - smadhava - 28-Sep-2005 - Added - End

Line 745: FROM OKC_K_LINES_V

741: AND PSU.ID2 = cp_id2;
742:
743: CURSOR c_get_asset_dtls(cp_kle_id IN OKC_K_LINES_V.ID%TYPE) IS
744: SELECT NAME
745: FROM OKC_K_LINES_V
746: WHERE ID = cp_kle_id;
747: -- Bug#4274575 - smadhava - 28-Sep-2005 - Added - End
748:
749:

Line 917: l_asset_id OKC_K_LINES_V.ID%TYPE;

913: l_new_location_id2 VARCHAR2(100);
914: l_old_location_id1 VARCHAR2(100);
915: l_old_location_id2 VARCHAR2(100);
916: l_trx_date OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE;
917: l_asset_id OKC_K_LINES_V.ID%TYPE;
918: l_party_site_id okx_party_site_uses_v.PARTY_SITE_ID%TYPE;
919: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
920:
921: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;