[Home] [Help]
37: -- Procedure Name : lease_app_cre
38: -- Description : This procedure is a wrapper that creates records for
39: -- : lease application.
40: -- Business Rules : This procedure inserts records into the
41: -- OKL_LEASE_APPLICATIONS_B and _TL table
42: -- Parameters :
43: -- Version : 1.0
44: -- History : 20-MAY-2005 PAGARG created
45: --
63: -- Procedure Name : lease_app_upd
64: -- Description : This procedure is a wrapper that updates records for
65: -- : lease application.
66: -- Business Rules : This procedure updates records into the
67: -- OKL_LEASE_APPLICATIONS_B and _TL table
68: -- Parameters :
69: -- Version : 1.0
70: -- History : 20-MAY-2005 PAGARG created
71: --
488: p_init_msg_list IN VARCHAR2,
489: x_return_status OUT NOCOPY VARCHAR2,
490: x_msg_count OUT NOCOPY NUMBER,
491: x_msg_data OUT NOCOPY VARCHAR2,
492: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
493: x_lapv_rec OUT NOCOPY lapv_rec_type,
494: x_lsqv_rec OUT NOCOPY lsqv_rec_type);
495:
496: -------------------------------------------------------------------------------
527: -- End of comments
528: PROCEDURE lease_app_qa_val(
529: p_api_version IN NUMBER,
530: p_init_msg_list IN VARCHAR2,
531: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
532: x_return_status OUT NOCOPY VARCHAR2,
533: x_msg_count OUT NOCOPY NUMBER,
534: x_msg_data OUT NOCOPY VARCHAR2,
535: x_qa_result OUT NOCOPY VARCHAR2);
549: -- End of comments
550: PROCEDURE lease_app_price(
551: p_api_version IN NUMBER,
552: p_init_msg_list IN VARCHAR2,
553: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
554: x_return_status OUT NOCOPY VARCHAR2,
555: x_msg_count OUT NOCOPY NUMBER,
556: x_msg_data OUT NOCOPY VARCHAR2);
557:
571: -- End of comments
572: PROCEDURE set_lease_app_status(
573: p_api_version IN NUMBER,
574: p_init_msg_list IN VARCHAR2,
575: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
576: p_lap_status IN VARCHAR2,
577: x_return_status OUT NOCOPY VARCHAR2,
578: x_msg_count OUT NOCOPY NUMBER,
579: x_msg_data OUT NOCOPY VARCHAR2);
595: -- End of comments
596: PROCEDURE set_lease_app_expdays(
597: p_api_version IN NUMBER,
598: p_init_msg_list IN VARCHAR2,
599: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
600: p_lap_expdays IN NUMBER,
601: x_return_status OUT NOCOPY VARCHAR2,
602: x_msg_count OUT NOCOPY NUMBER,
603: x_msg_data OUT NOCOPY VARCHAR2);
681: -- End of comments
682: PROCEDURE lease_app_unaccept(
683: p_api_version IN NUMBER,
684: p_init_msg_list IN VARCHAR2,
685: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
686: x_return_status OUT NOCOPY VARCHAR2,
687: x_msg_count OUT NOCOPY NUMBER,
688: x_msg_data OUT NOCOPY VARCHAR2);
689:
726: -- End of comments
727: PROCEDURE create_contract(
728: p_api_version IN NUMBER,
729: p_init_msg_list IN VARCHAR2,
730: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
731: x_return_status OUT NOCOPY VARCHAR2,
732: x_msg_count OUT NOCOPY NUMBER,
733: x_msg_data OUT NOCOPY VARCHAR2,
734: x_chr_id OUT NOCOPY NUMBER,
753: -- End of comments
754: PROCEDURE revert_to_orig_status(
755: p_api_version IN NUMBER,
756: p_init_msg_list IN VARCHAR2,
757: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
758: x_return_status OUT NOCOPY VARCHAR2,
759: x_msg_count OUT NOCOPY NUMBER,
760: x_msg_data OUT NOCOPY VARCHAR2);
761:
817: -- End of comments
818: PROCEDURE appeal_recommendations(
819: p_api_version IN NUMBER,
820: p_init_msg_list IN VARCHAR2,
821: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
822: p_cr_dec_apl_flag IN VARCHAR2,
823: p_exp_date_apl_flag IN VARCHAR2,
824: p_cr_conds IN name_val_tbl_type,
825: p_addl_rcmnds IN name_val_tbl_type,
844: -- End of comments
845: PROCEDURE create_contract_val(
846: p_api_version IN NUMBER,
847: p_init_msg_list IN VARCHAR2,
848: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
849: x_return_status OUT NOCOPY VARCHAR2,
850: x_msg_count OUT NOCOPY NUMBER,
851: x_msg_data OUT NOCOPY VARCHAR2);
852: