DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_FAN_SEQ

Line 4041: SELECT 'OKL'||TO_CHAR(okl_fan_seq.NEXTVAL)

4037: j := j+1;
4038: LOOP
4039: --dbms_output.put_line('Into asset number gen loop');
4040: --dbms_output.put_line('Asset Number'||p_ast_line_rec.asset_number||'.'||to_char(j));
4041: SELECT 'OKL'||TO_CHAR(okl_fan_seq.NEXTVAL)
4042: INTO l_txdv_rec.asset_number FROM dual;
4043: --dbms_output.put_line('Asset Number'||l_txdv_rec.asset_number);
4044: x_return_status := Asset_Number_Exists(l_txdv_rec.asset_number,l_asset_exists);
4045: --dbms_output.put_line('after asset number validate'||x_return_status);