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_SETUP_DISB_RULES_PVT dependencies on OKL_DISB_RULE_VENDOR_SITES

Line 21: l_vsite_start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE;

17: sty_count NUMBER;
18: vsite_count NUMBER;
19: l_disb_start_date OKL_DISB_RULES_B.START_DATE%TYPE;
20: l_disb_end_date OKL_DISB_RULES_B.END_DATE%TYPE;
21: l_vsite_start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE;
22: l_vsite_end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE;
23: l_exist_start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE;
24: l_exist_end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE;
25:

Line 22: l_vsite_end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE;

18: vsite_count NUMBER;
19: l_disb_start_date OKL_DISB_RULES_B.START_DATE%TYPE;
20: l_disb_end_date OKL_DISB_RULES_B.END_DATE%TYPE;
21: l_vsite_start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE;
22: l_vsite_end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE;
23: l_exist_start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE;
24: l_exist_end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE;
25:
26:

Line 23: l_exist_start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE;

19: l_disb_start_date OKL_DISB_RULES_B.START_DATE%TYPE;
20: l_disb_end_date OKL_DISB_RULES_B.END_DATE%TYPE;
21: l_vsite_start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE;
22: l_vsite_end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE;
23: l_exist_start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE;
24: l_exist_end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE;
25:
26:
27: CURSOR vendor_site_eff_dates_csr( p_sty_purpose IN OKL_DISB_RULE_STY_TYPES.STREAM_TYPE_PURPOSE%TYPE

Line 24: l_exist_end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE;

20: l_disb_end_date OKL_DISB_RULES_B.END_DATE%TYPE;
21: l_vsite_start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE;
22: l_vsite_end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE;
23: l_exist_start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE;
24: l_exist_end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE;
25:
26:
27: CURSOR vendor_site_eff_dates_csr( p_sty_purpose IN OKL_DISB_RULE_STY_TYPES.STREAM_TYPE_PURPOSE%TYPE
28: , p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_ID%TYPE

Line 28: , p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_ID%TYPE

24: l_exist_end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE;
25:
26:
27: CURSOR vendor_site_eff_dates_csr( p_sty_purpose IN OKL_DISB_RULE_STY_TYPES.STREAM_TYPE_PURPOSE%TYPE
28: , p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_ID%TYPE
29: , p_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_SITE_ID%TYPE
30: , p_disb_rule_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_VENDOR_SITE_ID%TYPE)
31: IS
32: SELECT disb_vsites.start_date

Line 29: , p_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_SITE_ID%TYPE

25:
26:
27: CURSOR vendor_site_eff_dates_csr( p_sty_purpose IN OKL_DISB_RULE_STY_TYPES.STREAM_TYPE_PURPOSE%TYPE
28: , p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_ID%TYPE
29: , p_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_SITE_ID%TYPE
30: , p_disb_rule_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_VENDOR_SITE_ID%TYPE)
31: IS
32: SELECT disb_vsites.start_date
33: , disb_vsites.end_date

Line 30: , p_disb_rule_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_VENDOR_SITE_ID%TYPE)

26:
27: CURSOR vendor_site_eff_dates_csr( p_sty_purpose IN OKL_DISB_RULE_STY_TYPES.STREAM_TYPE_PURPOSE%TYPE
28: , p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_ID%TYPE
29: , p_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_SITE_ID%TYPE
30: , p_disb_rule_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_VENDOR_SITE_ID%TYPE)
31: IS
32: SELECT disb_vsites.start_date
33: , disb_vsites.end_date
34: FROM okl_disb_rule_sty_types disb_sty,

Line 35: okl_disb_rule_vendor_sites disb_vsites

31: IS
32: SELECT disb_vsites.start_date
33: , disb_vsites.end_date
34: FROM okl_disb_rule_sty_types disb_sty,
35: okl_disb_rule_vendor_sites disb_vsites
36: WHERE disb_sty.stream_type_purpose = p_sty_purpose
37: AND disb_sty.disb_rule_id = disb_vsites.disb_rule_id
38: AND disb_vsites.vendor_id = p_vendor_id
39: AND disb_vsites.vendor_site_id = p_vendor_site_id

Line 206: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES

202: -- Function : validates disbursement rule vendor sites sequence range.
203: -- Parameters :
204: -- IN : p_api_version - Standard input parameter
205: -- p_init_msg_list - Standard input parameter
206: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES
207: -- Version : 1.0
208: -- History : gboomina created.
209: -- End of comments
210:

Line 223: l_new_seq_start OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;

219: l_api_name CONSTANT VARCHAR2(40) := 'validate_sequence_range';
220: l_api_version CONSTANT NUMBER := 1;
221: l_init_msg_list VARCHAR2(1);
222: vsite_count NUMBER;
223: l_new_seq_start OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;
224: l_new_seq_end OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
225: l_existing_seq_start OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;
226: l_existing_seq_end OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
227:

Line 224: l_new_seq_end OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;

220: l_api_version CONSTANT NUMBER := 1;
221: l_init_msg_list VARCHAR2(1);
222: vsite_count NUMBER;
223: l_new_seq_start OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;
224: l_new_seq_end OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
225: l_existing_seq_start OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;
226: l_existing_seq_end OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
227:
228:

Line 225: l_existing_seq_start OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;

221: l_init_msg_list VARCHAR2(1);
222: vsite_count NUMBER;
223: l_new_seq_start OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;
224: l_new_seq_end OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
225: l_existing_seq_start OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;
226: l_existing_seq_end OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
227:
228:
229: CURSOR vendor_site_seq_range_csr( p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_ID%TYPE

Line 226: l_existing_seq_end OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;

222: vsite_count NUMBER;
223: l_new_seq_start OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;
224: l_new_seq_end OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
225: l_existing_seq_start OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;
226: l_existing_seq_end OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
227:
228:
229: CURSOR vendor_site_seq_range_csr( p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_ID%TYPE
230: , p_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_SITE_ID%TYPE

Line 229: CURSOR vendor_site_seq_range_csr( p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_ID%TYPE

225: l_existing_seq_start OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;
226: l_existing_seq_end OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
227:
228:
229: CURSOR vendor_site_seq_range_csr( p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_ID%TYPE
230: , p_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_SITE_ID%TYPE
231: , p_disb_rule_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_VENDOR_SITE_ID%TYPE)
232: IS
233: SELECT disb_vsites.invoice_seq_start

Line 230: , p_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_SITE_ID%TYPE

226: l_existing_seq_end OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
227:
228:
229: CURSOR vendor_site_seq_range_csr( p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_ID%TYPE
230: , p_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_SITE_ID%TYPE
231: , p_disb_rule_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_VENDOR_SITE_ID%TYPE)
232: IS
233: SELECT disb_vsites.invoice_seq_start
234: , disb_vsites.invoice_seq_end

Line 231: , p_disb_rule_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_VENDOR_SITE_ID%TYPE)

227:
228:
229: CURSOR vendor_site_seq_range_csr( p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_ID%TYPE
230: , p_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_SITE_ID%TYPE
231: , p_disb_rule_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_VENDOR_SITE_ID%TYPE)
232: IS
233: SELECT disb_vsites.invoice_seq_start
234: , disb_vsites.invoice_seq_end
235: FROM okl_disb_rule_vendor_sites disb_vsites

Line 235: FROM okl_disb_rule_vendor_sites disb_vsites

231: , p_disb_rule_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_VENDOR_SITE_ID%TYPE)
232: IS
233: SELECT disb_vsites.invoice_seq_start
234: , disb_vsites.invoice_seq_end
235: FROM okl_disb_rule_vendor_sites disb_vsites
236: WHERE disb_vsites.vendor_id = p_vendor_id
237: AND disb_vsites.vendor_site_id = p_vendor_site_id
238: AND disb_vsites.disb_rule_vendor_site_id <> NVL (p_disb_rule_vendor_site_id , -1) ;
239:

Line 342: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES

338: -- Parameters :
339: -- IN : p_api_version - Standard input parameter
340: -- p_init_msg_list - Standard input parameter
341: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES
342: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES
343: -- Version : 1.0
344: -- History : gboomina created.
345: -- End of comments
346:

Line 353: , p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.vendor_id%TYPE

349: , x_return_status OUT NOCOPY VARCHAR2
350: , x_msg_count OUT NOCOPY NUMBER
351: , x_msg_data OUT NOCOPY VARCHAR2
352: , p_disb_rule_id IN okl_disb_rules_v.disb_rule_id%TYPE
353: , p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.vendor_id%TYPE
354: , p_new_drv_tbl IN drv_tbl_type
355: )
356: IS
357: l_api_name CONSTANT VARCHAR2(40) := 'del_disb_rule_vendor_sites';

Line 368: /* CURSOR old_disb_vendor_sites_csr( p_disb_rule_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_ID%TYPE )

364:
365: l_drv_del_tbl drv_tbl_type;
366:
367:
368: /* CURSOR old_disb_vendor_sites_csr( p_disb_rule_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_ID%TYPE )
369: IS
370: SELECT disb_rule_vendor_site_id
371: FROM okl_disb_rule_vendor_sites
372: WHERE disb_rule_id = p_disb_rule_id;

Line 371: FROM okl_disb_rule_vendor_sites

367:
368: /* CURSOR old_disb_vendor_sites_csr( p_disb_rule_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_ID%TYPE )
369: IS
370: SELECT disb_rule_vendor_site_id
371: FROM okl_disb_rule_vendor_sites
372: WHERE disb_rule_id = p_disb_rule_id;
373: */
374:
375: CURSOR old_disb_vendor_sites_csr( p_disb_rule_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_ID%TYPE ,

Line 375: CURSOR old_disb_vendor_sites_csr( p_disb_rule_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_ID%TYPE ,

371: FROM okl_disb_rule_vendor_sites
372: WHERE disb_rule_id = p_disb_rule_id;
373: */
374:
375: CURSOR old_disb_vendor_sites_csr( p_disb_rule_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_ID%TYPE ,
376: p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.vendor_id%TYPE)
377: IS
378: SELECT disb_rule_vendor_site_id
379: FROM okl_disb_rule_vendor_sites

Line 376: p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.vendor_id%TYPE)

372: WHERE disb_rule_id = p_disb_rule_id;
373: */
374:
375: CURSOR old_disb_vendor_sites_csr( p_disb_rule_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_ID%TYPE ,
376: p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.vendor_id%TYPE)
377: IS
378: SELECT disb_rule_vendor_site_id
379: FROM okl_disb_rule_vendor_sites
380: WHERE disb_rule_id = p_disb_rule_id

Line 379: FROM okl_disb_rule_vendor_sites

375: CURSOR old_disb_vendor_sites_csr( p_disb_rule_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_ID%TYPE ,
376: p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.vendor_id%TYPE)
377: IS
378: SELECT disb_rule_vendor_site_id
379: FROM okl_disb_rule_vendor_sites
380: WHERE disb_rule_id = p_disb_rule_id
381: AND vendor_id = NVL(p_vendor_id , vendor_id);
382:
383: old_vendor_site_rec old_disb_vendor_sites_csr%ROWTYPE;

Line 423: -- delete record from OKL_DISB_RULE_VENDOR_SITES

419: END IF;
420: END LOOP;
421:
422: IF ( l_drv_del_tbl.COUNT > 0 ) THEN
423: -- delete record from OKL_DISB_RULE_VENDOR_SITES
424: okl_drv_pvt.delete_row( p_api_version => l_api_version
425: , p_init_msg_list => p_init_msg_list
426: , x_return_status => x_return_status
427: , x_msg_count => x_msg_count

Line 470: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES

466: -- API name : create_v_disbursement_rulete_v_disbursement_rule
467: -- Pre-reqs : None
468: -- Function : Associate the Vendor with the Rule uses
469: -- OKL_DISB_RULES_B, OKL_DISB_RULES_TL,
470: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES
471: -- Parameters :
472: -- IN : p_api_version - Standard input parameter
473: -- p_init_msg_list - Standard input parameter
474: -- p_drv_tbl - record type for OKL_DISB_RULE_VENDOR_SITES

Line 474: -- p_drv_tbl - record type for OKL_DISB_RULE_VENDOR_SITES

470: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES
471: -- Parameters :
472: -- IN : p_api_version - Standard input parameter
473: -- p_init_msg_list - Standard input parameter
474: -- p_drv_tbl - record type for OKL_DISB_RULE_VENDOR_SITES
475: -- Version : 1.0
476: -- History : gkhuntet created.
477: -- End of comments
478:

Line 510: l_old_start_seq_no OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;

506: lp_drv_rec drv_rec_type;
507: lx_drv_tbl drv_tbl_type;
508: l_drv_Updt_tbl drv_tbl_type;
509: l_drv_Crt_tbl drv_tbl_type;
510: l_old_start_seq_no OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;
511: l_next_seq_no OKL_DISB_RULE_VENDOR_SITES.NEXT_INV_SEQ%TYPE;
512: l_old_end_seq_no OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
513:
514: flag VARCHAR(50);

Line 511: l_next_seq_no OKL_DISB_RULE_VENDOR_SITES.NEXT_INV_SEQ%TYPE;

507: lx_drv_tbl drv_tbl_type;
508: l_drv_Updt_tbl drv_tbl_type;
509: l_drv_Crt_tbl drv_tbl_type;
510: l_old_start_seq_no OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;
511: l_next_seq_no OKL_DISB_RULE_VENDOR_SITES.NEXT_INV_SEQ%TYPE;
512: l_old_end_seq_no OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
513:
514: flag VARCHAR(50);
515:

Line 512: l_old_end_seq_no OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;

508: l_drv_Updt_tbl drv_tbl_type;
509: l_drv_Crt_tbl drv_tbl_type;
510: l_old_start_seq_no OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE;
511: l_next_seq_no OKL_DISB_RULE_VENDOR_SITES.NEXT_INV_SEQ%TYPE;
512: l_old_end_seq_no OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_END%TYPE;
513:
514: flag VARCHAR(50);
515:
516: CURSOR get_drav_rec(c_disb_rule_id OKL_DISB_RULES_B.DISB_RULE_ID%TYPE) IS

Line 527: CURSOR get_seq_no(c_disb_rule_vendor_site_id OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE) IS

523: SELECT DISB_RULE_ID ,STREAM_TYPE_PURPOSE ,DISB_RULE_STY_TYPE_ID
524: FROM OKL_DISB_RULE_STY_TYPES
525: WHERE DISB_RULE_ID = c_disb_rule_id;
526:
527: CURSOR get_seq_no(c_disb_rule_vendor_site_id OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE) IS
528: SELECT INVOICE_SEQ_START ,NEXT_INV_SEQ ,INVOICE_SEQ_END
529: FROM OKL_DISB_RULE_VENDOR_SITES
530: WHERE DISB_RULE_VENDOR_SITE_ID = c_disb_rule_vendor_site_id;
531:

Line 529: FROM OKL_DISB_RULE_VENDOR_SITES

525: WHERE DISB_RULE_ID = c_disb_rule_id;
526:
527: CURSOR get_seq_no(c_disb_rule_vendor_site_id OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE) IS
528: SELECT INVOICE_SEQ_START ,NEXT_INV_SEQ ,INVOICE_SEQ_END
529: FROM OKL_DISB_RULE_VENDOR_SITES
530: WHERE DISB_RULE_VENDOR_SITE_ID = c_disb_rule_vendor_site_id;
531:
532:
533: /*CURSOR get_count_disb_ruleid(c_disb_rule_vendor_site_id OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_ID%TYPE) IS

Line 533: /*CURSOR get_count_disb_ruleid(c_disb_rule_vendor_site_id OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_ID%TYPE) IS

529: FROM OKL_DISB_RULE_VENDOR_SITES
530: WHERE DISB_RULE_VENDOR_SITE_ID = c_disb_rule_vendor_site_id;
531:
532:
533: /*CURSOR get_count_disb_ruleid(c_disb_rule_vendor_site_id OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_ID%TYPE) IS
534: SELECT COUNT(DISB_RULE_VENDOR_SITE_ID)
535: FROM OKL_DISB_RULE_VENDOR_SITES
536: WHERE DISB_RULE_VENDOR_SITE_ID = c_disb_rule_vendor_site_id;*/
537:

Line 535: FROM OKL_DISB_RULE_VENDOR_SITES

531:
532:
533: /*CURSOR get_count_disb_ruleid(c_disb_rule_vendor_site_id OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_ID%TYPE) IS
534: SELECT COUNT(DISB_RULE_VENDOR_SITE_ID)
535: FROM OKL_DISB_RULE_VENDOR_SITES
536: WHERE DISB_RULE_VENDOR_SITE_ID = c_disb_rule_vendor_site_id;*/
537:
538: v_disb_rule_rec get_drav_rec%ROWTYPE;
539: v_dsbrule_strm_prpse_rec get_drs_tbl%ROWTYPE;

Line 750: -- Update record in OKL_DISB_RULE_VENDOR_SITES

746: END IF;
747: END LOOP;
748:
749: --DBMS_OUTPUT.PUT_LINE('COUNT ' || l_drv_Updt_tbl.COUNT || ' ' ||l_drv_Crt_tbl.COUNT);
750: -- Update record in OKL_DISB_RULE_VENDOR_SITES
751: ----g_debug_proc('Gaurav 5 ' || l_drv_Updt_tbl.COUNT || ' ' ||l_drv_Crt_tbl.COUNT);
752:
753: IF ( l_drv_Updt_tbl.COUNT > 0 ) THEN
754: okl_drv_pvt.update_row( p_api_version => l_api_version

Line 771: -- Create record in OKL_DISB_RULE_VENDOR_SITES

767:
768: ----g_debug_proc('Gaurav 6');
769:
770: IF ( l_drv_Crt_tbl.COUNT > 0 ) THEN
771: -- Create record in OKL_DISB_RULE_VENDOR_SITES
772: okl_drv_pvt.insert_row( p_api_version => l_api_version
773: , p_init_msg_list => p_init_msg_list
774: , x_return_status => x_return_status
775: , x_msg_count => x_msg_count

Line 923: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES

919: -- IN : p_api_version - Standard input parameter
920: -- p_init_msg_list - Standard input parameter
921: -- p_drav_rec - record type for OKL_DISB_RULES_V
922: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES
923: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES
924: -- Version : 1.0
925: -- History : gboomina created.
926: -- End of comments
927:

Line 1087: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES

1083: -- API name : create_disbursement_rule
1084: -- Pre-reqs : None
1085: -- Function : create disbursement rule in the following tables
1086: -- OKL_DISB_RULES_B, OKL_DISB_RULES_TL,
1087: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES
1088: -- Parameters :
1089: -- IN : p_api_version - Standard input parameter
1090: -- p_init_msg_list - Standard input parameter
1091: -- p_drav_rec - record type for OKL_DISB_RULES_V

Line 1093: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES

1089: -- IN : p_api_version - Standard input parameter
1090: -- p_init_msg_list - Standard input parameter
1091: -- p_drav_rec - record type for OKL_DISB_RULES_V
1092: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES
1093: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES
1094: -- Version : 1.0
1095: -- History : gboomina created.
1096: -- End of comments
1097:

Line 1237: -- populate the OKL_DISB_RULE_VENDOR_SITES table with the

1233: END IF;
1234:
1235: END IF;
1236: --g_debug_proc('Stream Inserted');
1237: -- populate the OKL_DISB_RULE_VENDOR_SITES table with the
1238: -- disb rule id returned from the okl_dra_pvt.insert_row
1239: IF ( p_drv_tbl.COUNT > 0) THEN
1240: i := p_drv_tbl.FIRST;
1241: LOOP

Line 1418: -- p_drv_tbl but in the OKL_DISB_RULE_VENDOR_SITES

1414: -- Start of comments
1415: -- API name : del_disb_rule_vendor_sites
1416: -- Pre-reqs : None
1417: -- Function : deletes vendor sites which are not present in the input
1418: -- p_drv_tbl but in the OKL_DISB_RULE_VENDOR_SITES
1419: -- for a disbursement rule. This API deletes stream types from
1420: -- OKL_DISB_RULE_VENDOR_SITES table which user had deleted during
1421: -- update operation.
1422: -- Parameters :

Line 1420: -- OKL_DISB_RULE_VENDOR_SITES table which user had deleted during

1416: -- Pre-reqs : None
1417: -- Function : deletes vendor sites which are not present in the input
1418: -- p_drv_tbl but in the OKL_DISB_RULE_VENDOR_SITES
1419: -- for a disbursement rule. This API deletes stream types from
1420: -- OKL_DISB_RULE_VENDOR_SITES table which user had deleted during
1421: -- update operation.
1422: -- Parameters :
1423: -- IN : p_api_version - Standard input parameter
1424: -- p_init_msg_list - Standard input parameter

Line 1426: -- p_drv_tbl - record type for OKL_DISB_RULE_VENDOR_SITES

1422: -- Parameters :
1423: -- IN : p_api_version - Standard input parameter
1424: -- p_init_msg_list - Standard input parameter
1425: -- p_disb_rule_id - disbursement rule id
1426: -- p_drv_tbl - record type for OKL_DISB_RULE_VENDOR_SITES
1427: -- Version : 1.0
1428: -- History : gboomina created.
1429: -- End of comments
1430:

Line 1438: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES

1434: -- API name : update_disbursement_rule
1435: -- Pre-reqs : None
1436: -- Function : update disbursement rule in the following tables
1437: -- OKL_DISB_RULES_B, OKL_DISB_RULES_TL,
1438: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES
1439: -- Parameters :
1440: -- IN : p_api_version - Standard input parameter
1441: -- p_init_msg_list - Standard input parameter
1442: -- p_drav_rec - record type for OKL_DISB_RULES_V

Line 1444: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES

1440: -- IN : p_api_version - Standard input parameter
1441: -- p_init_msg_list - Standard input parameter
1442: -- p_drav_rec - record type for OKL_DISB_RULES_V
1443: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES
1444: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES
1445: -- Version : 1.0
1446: -- History : gboomina created.
1447: -- End of comments
1448:

Line 1638: -- Check whether we need to create or update in to OKL_DISB_RULE_VENDOR_SITES table

1634:
1635: END IF;
1636: --g_debug_proc('Update DRS');
1637:
1638: -- Check whether we need to create or update in to OKL_DISB_RULE_VENDOR_SITES table
1639: IF ( p_drv_tbl.COUNT > 0) THEN
1640: ins_count := 0;
1641: upd_count := 0;
1642: FOR i in p_drv_tbl.FIRST .. p_drv_tbl.LAST

Line 1655: -- insert record in to OKL_DISB_RULE_VENDOR_SITES

1651: END IF;
1652: END LOOP;
1653:
1654: IF ( l_drv_ins_tbl.COUNT > 0 ) THEN
1655: -- insert record in to OKL_DISB_RULE_VENDOR_SITES
1656: okl_drv_pvt.insert_row( p_api_version => l_api_version
1657: , p_init_msg_list => p_init_msg_list
1658: , x_return_status => x_return_status
1659: , x_msg_count => x_msg_count

Line 1673: -- update record in to OKL_DISB_RULE_VENDOR_SITES

1669:
1670: --g_debug_proc('Update Insert DRV');
1671:
1672: IF ( l_drv_upd_tbl.COUNT > 0 ) THEN
1673: -- update record in to OKL_DISB_RULE_VENDOR_SITES
1674: okl_drv_pvt.update_row( p_api_version => l_api_version
1675: , p_init_msg_list => p_init_msg_list
1676: , x_return_status => x_return_status
1677: , x_msg_count => x_msg_count