APPS.OKL_CSH_ORDER_SEQ_PUB dependencies on OKL_STRM_TYP_ALLOCS

Line 377: l_id OKL_STRM_TYP_ALLOCS.ID%TYPE;

373: l_msg_data VARCHAR2(2000);
374: l_msg_count NUMBER;
375: l_count INTEGER;
376:
377: l_id OKL_STRM_TYP_ALLOCS.ID%TYPE;
378: l_sty_id OKL_BPD_CSH_ORDER_UV.STY_ID%TYPE;
379: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;
380: l_seq_num OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;
381: l_strm_type OKL_BPD_CSH_ORDER_UV.STREAM_ALLC_TYPE%TYPE;

Line 401: FROM OKL_STRM_TYP_ALLOCS sta

397:
398: -- get id of record to be updated or deleted for ODD
399: CURSOR c_get_id_odd (l_sty_id IN NUMBER, l_cat_id IN NUMBER) IS
400: SELECT id
401: FROM OKL_STRM_TYP_ALLOCS sta
402: WHERE sta.STY_ID = l_sty_id
403: AND sta.CAT_ID = l_cat_id
404: AND sta.STREAM_ALLC_TYPE = 'ODD';
405:

Line 409: FROM OKL_STRM_TYP_ALLOCS sta

405:
406: -- get id of record to be updated or deleted for PRO
407: CURSOR c_get_id_pro (l_sty_id IN NUMBER, l_cat_id IN NUMBER) IS
408: SELECT id
409: FROM OKL_STRM_TYP_ALLOCS sta
410: WHERE sta.STY_ID = l_sty_id
411: AND sta.CAT_ID = l_cat_id
412: AND sta.STREAM_ALLC_TYPE = 'PRO';
413:

Line 417: FROM OKL_STRM_TYP_ALLOCS sta

413:
414: --Find whether it's insert or update for ordered sequence
415: CURSOR c_csh_ins_upd_flag (l_sty_id IN NUMBER, l_cat_id IN NUMBER) IS
416: SELECT count(*) COUNT
417: FROM OKL_STRM_TYP_ALLOCS sta
418: WHERE sta.STY_ID = l_sty_id
419: AND sta.CAT_ID = l_cat_id
420: AND sta.STREAM_ALLC_TYPE = 'ODD';
421:

Line 425: FROM OKL_STRM_TYP_ALLOCS sta

421:
422: --Find whether it's new insert or duplicate for prorate sequence
423: CURSOR c_csh_ins_yn_flag (l_sty_id IN NUMBER, l_cat_id IN NUMBER) IS
424: SELECT count(*) COUNT
425: FROM OKL_STRM_TYP_ALLOCS sta
426: WHERE sta.STY_ID = l_sty_id
427: AND sta.CAT_ID = l_cat_id
428: AND sta.STREAM_ALLC_TYPE = 'PRO'
429: AND sta.ID is not null;