APPS.OKL_AUTO_INSURANCE_PVT dependencies on OKL_AUTO_INSURANCE_PVT

Line 1: PACKAGE BODY OKL_AUTO_INSURANCE_PVT AS

1: PACKAGE BODY OKL_AUTO_INSURANCE_PVT AS
2: /* $Header: OKLRICXB.pls 120.18 2007/10/10 11:21:06 zrehman noship $ */
3: ---------------------------------------------------------------------------
4:
5: FUNCTION get_trx_type

Line 1005: workflow_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type ;

1001: AND RUL.RGP_ID = GRUL.ID
1002: AND RUL.rule_information_category = 'INVNIN'
1003: AND GRUL.CHR_ID = p_khr_id ;
1004:
1005: workflow_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type ;
1006: policy_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;
1007: noins_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;
1008: error_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;
1009: l_okl_provider_id NUMBER;

Line 1006: policy_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;

1002: AND RUL.rule_information_category = 'INVNIN'
1003: AND GRUL.CHR_ID = p_khr_id ;
1004:
1005: workflow_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type ;
1006: policy_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;
1007: noins_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;
1008: error_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;
1009: l_okl_provider_id NUMBER;
1010: l_blanket_ins_yn VARCHAR2(3) ;

Line 1007: noins_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;

1003: AND GRUL.CHR_ID = p_khr_id ;
1004:
1005: workflow_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type ;
1006: policy_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;
1007: noins_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;
1008: error_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;
1009: l_okl_provider_id NUMBER;
1010: l_blanket_ins_yn VARCHAR2(3) ;
1011: l_insurable_yn VARCHAR2(3) ;

Line 1008: error_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;

1004:
1005: workflow_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type ;
1006: policy_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;
1007: noins_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;
1008: error_tbl_type OKL_AUTO_INSURANCE_PVT.policy_tbl_type;
1009: l_okl_provider_id NUMBER;
1010: l_blanket_ins_yn VARCHAR2(3) ;
1011: l_insurable_yn VARCHAR2(3) ;
1012: l_prm_lessor_sell VARCHAR2(3) ;

Line 1453: END OKL_AUTO_INSURANCE_PVT;

1449: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
1450: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
1451: END;
1452: END auto_ins_establishment ;
1453: END OKL_AUTO_INSURANCE_PVT;