eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CSH_ORDER_SEQ_PVT dependencies on OKL_STRM_TYP_ALLOCS

Line 94: FROM OKL_STRM_TYP_ALLOCS

90: SELECT SEQUENCE_NUMBER, ID
91: ,STY_ID, CAT_ID, OBJECT_VERSION_NUMBER
92: ,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE
93: ,LAST_UPDATE_LOGIN
94: FROM OKL_STRM_TYP_ALLOCS
95: WHERE SEQUENCE_NUMBER > l_sequence_number
96: --------------------------------------------------------------------------------------
97: AND CAT_ID = l_cat_id; -- multi org compliant
98: --------------------------------------------------------------------------------------

Line 202: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

198:
199: IF (l_countgreat > 0) THEN
200:
201:
202: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
203: IF(L_DEBUG_ENABLED='Y') THEN
204: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
205: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
206: END IF;

Line 209: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

205: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
206: END IF;
207: IF(IS_DEBUG_PROCEDURE_ON) THEN
208: BEGIN
209: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
210: END;
211: END IF;
212: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
213: ,l_init_msg_list

Line 212: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version

208: BEGIN
209: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
210: END;
211: END IF;
212: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
213: ,l_init_msg_list
214: ,l_return_status
215: ,l_msg_count
216: ,l_msg_data

Line 222: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

218: ,x_stav_tbl
219: );
220: IF(IS_DEBUG_PROCEDURE_ON) THEN
221: BEGIN
222: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
223: END;
224: END IF;
225: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
226: END IF;

Line 225: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

221: BEGIN
222: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
223: END;
224: END IF;
225: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
226: END IF;
227:
228: l_stav_rec.SEQUENCE_NUMBER := currseq;
229:

Line 231: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.insert_strm_typ_allocs

227:
228: l_stav_rec.SEQUENCE_NUMBER := currseq;
229:
230: -- Insert the new record
231: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.insert_strm_typ_allocs
232: IF(IS_DEBUG_PROCEDURE_ON) THEN
233: BEGIN
234: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');
235: END;

Line 234: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');

230: -- Insert the new record
231: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.insert_strm_typ_allocs
232: IF(IS_DEBUG_PROCEDURE_ON) THEN
233: BEGIN
234: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');
235: END;
236: END IF;
237: okl_strm_typ_allocs_pub.insert_strm_typ_allocs(l_api_version
238: ,l_init_msg_list

Line 237: okl_strm_typ_allocs_pub.insert_strm_typ_allocs(l_api_version

233: BEGIN
234: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');
235: END;
236: END IF;
237: okl_strm_typ_allocs_pub.insert_strm_typ_allocs(l_api_version
238: ,l_init_msg_list
239: ,l_return_status
240: ,l_msg_count
241: ,l_msg_data

Line 247: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');

243: ,x_stav_rec
244: );
245: IF(IS_DEBUG_PROCEDURE_ON) THEN
246: BEGIN
247: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');
248: END;
249: END IF;
250: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.insert_strm_typ_allocs
251:

Line 250: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.insert_strm_typ_allocs

246: BEGIN
247: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');
248: END;
249: END IF;
250: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.insert_strm_typ_allocs
251:
252: x_return_status := l_return_status ;
253: x_msg_count := l_msg_count ;
254: x_msg_data := l_msg_data ;

Line 334: FROM OKL_STRM_TYP_ALLOCS

330:
331: -- Get all the orders for update
332: CURSOR c_csh_ordr_seq_all(l_cat_id IN NUMBER) IS
333: SELECT SEQUENCE_NUMBER, ID
334: FROM OKL_STRM_TYP_ALLOCS
335: --FROM OKL_BPD_CSH_ORDER_UV
336: WHERE STREAM_ALLC_TYPE = 'ODD'
337: ------------------------------
338: AND CAT_ID = l_cat_id

Line 378: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.insert_strm_typ_allocs

374:
375: END LOOP;
376:
377: -- Insert the new record(s)
378: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.insert_strm_typ_allocs
379: IF(L_DEBUG_ENABLED='Y') THEN
380: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
381: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
382: END IF;

Line 385: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');

381: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
382: END IF;
383: IF(IS_DEBUG_PROCEDURE_ON) THEN
384: BEGIN
385: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');
386: END;
387: END IF;
388: okl_strm_typ_allocs_pub.insert_strm_typ_allocs(l_api_version
389: ,l_init_msg_list

Line 388: okl_strm_typ_allocs_pub.insert_strm_typ_allocs(l_api_version

384: BEGIN
385: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');
386: END;
387: END IF;
388: okl_strm_typ_allocs_pub.insert_strm_typ_allocs(l_api_version
389: ,l_init_msg_list
390: ,l_return_status
391: ,l_msg_count
392: ,l_msg_data

Line 398: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');

394: ,x_stav_tbl
395: );
396: IF(IS_DEBUG_PROCEDURE_ON) THEN
397: BEGIN
398: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');
399: END;
400: END IF;
401: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.insert_strm_typ_allocs
402:

Line 401: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.insert_strm_typ_allocs

397: BEGIN
398: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');
399: END;
400: END IF;
401: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.insert_strm_typ_allocs
402:
403: x_return_status := l_return_status ;
404: x_msg_count := l_msg_count ;
405: x_msg_data := l_msg_data ;

Line 426: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

422: i := i + 1;
423:
424: END LOOP;
425:
426: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
427: IF(IS_DEBUG_PROCEDURE_ON) THEN
428: BEGIN
429: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
430: END;

Line 429: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

425:
426: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
427: IF(IS_DEBUG_PROCEDURE_ON) THEN
428: BEGIN
429: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
430: END;
431: END IF;
432: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
433: ,l_init_msg_list

Line 432: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version

428: BEGIN
429: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
430: END;
431: END IF;
432: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
433: ,l_init_msg_list
434: ,l_return_status
435: ,l_msg_count
436: ,l_msg_data

Line 442: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

438: ,x_stav_tbl
439: );
440: IF(IS_DEBUG_PROCEDURE_ON) THEN
441: BEGIN
442: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
443: END;
444: END IF;
445: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
446:

Line 445: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

441: BEGIN
442: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
443: END;
444: END IF;
445: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
446:
447: x_return_status := l_return_status ;
448: x_msg_count := l_msg_count ;
449: x_msg_data := l_msg_data ;

Line 496: l_cshorder_id OKL_STRM_TYP_ALLOCS.ID%TYPE;

492: l_msg_count NUMBER;
493: l_msg_data VARCHAR2(2000);
494: i NUMBER;
495:
496: l_cshorder_id OKL_STRM_TYP_ALLOCS.ID%TYPE;
497: l_cshorder_sequence OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE;
498: l_cshorder_seqmax OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE;
499: l_cat_id OKL_STRM_TYP_ALLOCS.CAT_ID%TYPE;
500: l_countless INTEGER;

Line 497: l_cshorder_sequence OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE;

493: l_msg_data VARCHAR2(2000);
494: i NUMBER;
495:
496: l_cshorder_id OKL_STRM_TYP_ALLOCS.ID%TYPE;
497: l_cshorder_sequence OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE;
498: l_cshorder_seqmax OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE;
499: l_cat_id OKL_STRM_TYP_ALLOCS.CAT_ID%TYPE;
500: l_countless INTEGER;
501: l_greatrownum INTEGER;

Line 498: l_cshorder_seqmax OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE;

494: i NUMBER;
495:
496: l_cshorder_id OKL_STRM_TYP_ALLOCS.ID%TYPE;
497: l_cshorder_sequence OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE;
498: l_cshorder_seqmax OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE;
499: l_cat_id OKL_STRM_TYP_ALLOCS.CAT_ID%TYPE;
500: l_countless INTEGER;
501: l_greatrownum INTEGER;
502: l_lessrownum INTEGER;

Line 499: l_cat_id OKL_STRM_TYP_ALLOCS.CAT_ID%TYPE;

495:
496: l_cshorder_id OKL_STRM_TYP_ALLOCS.ID%TYPE;
497: l_cshorder_sequence OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE;
498: l_cshorder_seqmax OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE;
499: l_cat_id OKL_STRM_TYP_ALLOCS.CAT_ID%TYPE;
500: l_countless INTEGER;
501: l_greatrownum INTEGER;
502: l_lessrownum INTEGER;
503: l_count INTEGER;

Line 526: FROM OKL_STRM_TYP_ALLOCS sta

522: -------------------
523: -- Get the order with highest sequence less than the given seq
524: CURSOR c_csh_ordr_seq (l_sequence_number IN NUMBER, l_id IN NUMBER, l_cat_id IN NUMBER) IS
525: SELECT max(sta.SEQUENCE_NUMBER) MAXSEQ
526: FROM OKL_STRM_TYP_ALLOCS sta
527: WHERE sta.SEQUENCE_NUMBER <= l_sequence_number
528: AND ID <> l_id
529: ---------------------------------------------------------------------------
530: AND CAT_ID = l_cat_id -- multi org compliant

Line 539: FROM OKL_STRM_TYP_ALLOCS

535:
536: -- Get the count of total orders
537: CURSOR c_csh_ordr_count (l_cat_id IN NUMBER)IS
538: SELECT count(*) COUNT
539: FROM OKL_STRM_TYP_ALLOCS
540: ---------------------------------------------------------------------------
541: WHERE CAT_ID = l_cat_id; -- multi org compliant
542: ---------------------------------------------------------------------------
543:

Line 547: FROM OKL_STRM_TYP_ALLOCS

543:
544: -- Get the corders with highest sequence less than the given seq
545: CURSOR c_csh_ordr_seqless (l_sequence_number IN NUMBER, l_id IN NUMBER, l_cat_id IN NUMBER) IS
546: SELECT SEQUENCE_NUMBER, ID
547: FROM OKL_STRM_TYP_ALLOCS
548: WHERE SEQUENCE_NUMBER <= l_sequence_number
549: AND ID <> l_id
550: ---------------------------------------------------------------------------
551: AND CAT_ID = l_cat_id -- multi org compliant

Line 558: FROM OKL_STRM_TYP_ALLOCS sta

554:
555: -- Get the count of orders with highest sequence less than the given seq
556: CURSOR c_csh_ordr_countless (l_sequence_number IN NUMBER, l_id IN NUMBER, l_cat_id IN NUMBER) IS
557: SELECT count(*) COUNT
558: FROM OKL_STRM_TYP_ALLOCS sta
559: WHERE sta.SEQUENCE_NUMBER <= l_sequence_number
560: AND ID <> l_id
561: ---------------------------------------------------------------------------
562: AND CAT_ID = l_cat_id; -- multi org compliant

Line 569: FROM OKL_STRM_TYP_ALLOCS

565: -- Get the orders with sequence number greater than highest sequence
566: -- less than given seq
567: CURSOR c_csh_ordr_seqgreat (l_sequence_number IN NUMBER, l_id IN NUMBER, l_cat_id IN NUMBER) IS
568: SELECT SEQUENCE_NUMBER, ID
569: FROM OKL_STRM_TYP_ALLOCS
570: WHERE SEQUENCE_NUMBER > l_sequence_number
571: AND ID <> l_id
572: ---------------------------------------------------------------------------
573: AND CAT_ID = l_cat_id; -- multi org compliant

Line 580: FROM OKL_STRM_TYP_ALLOCS

576: -- Get the count of orders with sequence number greater than highest sequence
577: -- less than given seq
578: CURSOR c_csh_ordr_seqgreat_count (l_sequence_number IN NUMBER, l_id IN NUMBER, l_cat_id IN NUMBER) IS
579: SELECT count(*) COUNT
580: FROM OKL_STRM_TYP_ALLOCS
581: WHERE SEQUENCE_NUMBER > l_sequence_number
582: AND ID <> l_id
583: ---------------------------------------------------------------------------
584: AND CAT_ID = l_cat_id; -- multi org compliant

Line 629: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

625: END LOOP;
626:
627: IF (l_countless > 0) THEN
628:
629: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
630: IF(L_DEBUG_ENABLED='Y') THEN
631: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
632: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
633: END IF;

Line 636: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

632: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
633: END IF;
634: IF(IS_DEBUG_PROCEDURE_ON) THEN
635: BEGIN
636: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
637: END;
638: END IF;
639: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
640: ,l_init_msg_list

Line 639: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version

635: BEGIN
636: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
637: END;
638: END IF;
639: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
640: ,l_init_msg_list
641: ,l_return_status
642: ,l_msg_count
643: ,l_msg_data

Line 649: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

645: ,x_stav_tbl
646: );
647: IF(IS_DEBUG_PROCEDURE_ON) THEN
648: BEGIN
649: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
650: END;
651: END IF;
652: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
653:

Line 652: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

648: BEGIN
649: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
650: END;
651: END IF;
652: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
653:
654: END IF;
655:
656:

Line 691: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

687: END LOOP;
688:
689: IF (l_countgreat > 0) THEN
690:
691: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
692: IF(IS_DEBUG_PROCEDURE_ON) THEN
693: BEGIN
694: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
695: END;

Line 694: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

690:
691: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
692: IF(IS_DEBUG_PROCEDURE_ON) THEN
693: BEGIN
694: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
695: END;
696: END IF;
697: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
698: ,l_init_msg_list

Line 697: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version

693: BEGIN
694: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
695: END;
696: END IF;
697: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
698: ,l_init_msg_list
699: ,l_return_status
700: ,l_msg_count
701: ,l_msg_data

Line 707: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

703: ,x_stav_tbl
704: );
705: IF(IS_DEBUG_PROCEDURE_ON) THEN
706: BEGIN
707: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
708: END;
709: END IF;
710: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
711:

Line 710: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

706: BEGIN
707: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
708: END;
709: END IF;
710: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
711:
712: END IF;
713:
714: l_stav_rec.SEQUENCE_NUMBER := currseq;

Line 718: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

714: l_stav_rec.SEQUENCE_NUMBER := currseq;
715: l_stav_rec.ID := l_cshorder_id;
716:
717: -- Update the current record
718: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
719: IF(IS_DEBUG_PROCEDURE_ON) THEN
720: BEGIN
721: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
722: END;

Line 721: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

717: -- Update the current record
718: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
719: IF(IS_DEBUG_PROCEDURE_ON) THEN
720: BEGIN
721: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
722: END;
723: END IF;
724: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
725: ,l_init_msg_list

Line 724: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version

720: BEGIN
721: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
722: END;
723: END IF;
724: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
725: ,l_init_msg_list
726: ,l_return_status
727: ,l_msg_count
728: ,l_msg_data

Line 734: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

730: ,x_stav_rec
731: );
732: IF(IS_DEBUG_PROCEDURE_ON) THEN
733: BEGIN
734: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
735: END;
736: END IF;
737: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
738:

Line 737: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

733: BEGIN
734: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
735: END;
736: END IF;
737: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
738:
739: x_return_status := l_return_status ;
740: x_msg_count := l_msg_count ;
741: x_msg_data := l_msg_data ;

Line 816: FROM OKL_STRM_TYP_ALLOCS

812:
813: --Get all the orders
814: CURSOR c_csh_ordr_all (l_cat_id IN NUMBER) IS
815: SELECT SEQUENCE_NUMBER, ID
816: FROM OKL_STRM_TYP_ALLOCS
817: WHERE CAT_ID = l_cat_id
818: ORDER BY SEQUENCE_NUMBER;
819:
820: c_csh_ordr_all_rec c_csh_ordr_all%ROWTYPE;

Line 842: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

838:
839: END LOOP;
840:
841: -- Update the current table
842: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
843: IF(L_DEBUG_ENABLED='Y') THEN
844: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
845: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
846: END IF;

Line 849: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

845: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
846: END IF;
847: IF(IS_DEBUG_PROCEDURE_ON) THEN
848: BEGIN
849: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
850: END;
851: END IF;
852: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
853: ,l_init_msg_list

Line 852: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version

848: BEGIN
849: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
850: END;
851: END IF;
852: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
853: ,l_init_msg_list
854: ,l_return_status
855: ,l_msg_count
856: ,l_msg_data

Line 862: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

858: ,x_stav_tbl
859: );
860: IF(IS_DEBUG_PROCEDURE_ON) THEN
861: BEGIN
862: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
863: END;
864: END IF;
865: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
866:

Line 865: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

861: BEGIN
862: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
863: END;
864: END IF;
865: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
866:
867: x_return_status := l_return_status ;
868: x_msg_count := l_msg_count ;
869: x_msg_data := l_msg_data ;

Line 887: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

883: i := i + 1;
884:
885: END LOOP;
886:
887: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
888: IF(IS_DEBUG_PROCEDURE_ON) THEN
889: BEGIN
890: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
891: END;

Line 890: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

886:
887: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
888: IF(IS_DEBUG_PROCEDURE_ON) THEN
889: BEGIN
890: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
891: END;
892: END IF;
893: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
894: ,l_init_msg_list

Line 893: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version

889: BEGIN
890: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
891: END;
892: END IF;
893: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
894: ,l_init_msg_list
895: ,l_return_status
896: ,l_msg_count
897: ,l_msg_data

Line 903: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

899: ,x_stav_tbl
900: );
901: IF(IS_DEBUG_PROCEDURE_ON) THEN
902: BEGIN
903: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
904: END;
905: END IF;
906: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
907:

Line 906: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

902: BEGIN
903: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
904: END;
905: END IF;
906: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
907:
908: END IF;
909:
910: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN

Line 971: FROM OKL_STRM_TYP_ALLOCS

967:
968: -- Get all the orders in the table
969: CURSOR c_csh_ordr_seq (l_cat_id IN NUMBER) IS
970: SELECT ID, SEQUENCE_NUMBER
971: FROM OKL_STRM_TYP_ALLOCS
972: WHERE STREAM_ALLC_TYPE = 'ODD'
973: AND CAT_ID = l_cat_id
974: ORDER BY SEQUENCE_NUMBER;
975:

Line 979: FROM OKL_STRM_TYP_ALLOCS

975:
976: --Check if the record exists
977: CURSOR c_csh_ordr_exists(l_csh_ordr_id NUMBER, l_cat_id IN NUMBER) IS
978: SELECT count(*) COUNT
979: FROM OKL_STRM_TYP_ALLOCS
980: WHERE ID = l_csh_ordr_id
981: AND CAT_ID = l_cat_id;
982:
983: c_csh_ordr_seq_rec c_csh_ordr_seq%ROWTYPE;

Line 1004: okl_strm_typ_allocs_pub.delete_strm_typ_allocs(l_api_version

1000: --c_csh_ordr_exists_rec.COUNT);
1001:
1002: IF (c_csh_ordr_exists_rec.COUNT > 0) THEN
1003:
1004: okl_strm_typ_allocs_pub.delete_strm_typ_allocs(l_api_version
1005: ,l_init_msg_list
1006: ,l_return_status
1007: ,l_msg_count
1008: ,l_msg_data

Line 1034: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

1030: i := i + 1;
1031:
1032: END LOOP;
1033:
1034: -- Start of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
1035: IF(L_DEBUG_ENABLED='Y') THEN
1036: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1037: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1038: END IF;

Line 1041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

1037: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1038: END IF;
1039: IF(IS_DEBUG_PROCEDURE_ON) THEN
1040: BEGIN
1041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
1042: END;
1043: END IF;
1044: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
1045: ,l_init_msg_list

Line 1044: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version

1040: BEGIN
1041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
1042: END;
1043: END IF;
1044: okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
1045: ,l_init_msg_list
1046: ,l_return_status
1047: ,l_msg_count
1048: ,l_msg_data

Line 1054: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

1050: ,x_stav_tbl
1051: );
1052: IF(IS_DEBUG_PROCEDURE_ON) THEN
1053: BEGIN
1054: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
1055: END;
1056: END IF;
1057: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
1058:

Line 1057: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs

1053: BEGIN
1054: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');
1055: END;
1056: END IF;
1057: -- End of wraper code generated automatically by Debug code generator for okl_strm_typ_allocs_pub.update_strm_typ_allocs
1058:
1059: x_return_status := l_return_status ;
1060: x_msg_count := l_msg_count ;
1061: x_msg_data := l_msg_data ;