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_LEASE_APP_PVT dependencies on OKL_LEASE_QUOTES_B

Line 181: , OKL_LEASE_QUOTES_B LSQ

177: -- Cursor to check if primary quote on the lease app is credit declined
178: CURSOR get_primary_quote_declined IS
179: SELECT 1
180: FROM OKL_LEASE_APPLICATIONS_B LAP
181: , OKL_LEASE_QUOTES_B LSQ
182: WHERE LAP.ID = p_lap_id
183: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
184: AND LSQ.PARENT_OBJECT_ID = LAP.ID
185: AND LSQ.PRIMARY_QUOTE = 'Y'

Line 630: SELECT DECODE(c_table_name,'OKL_LEASE_QUOTES_B',LSEQTE_SEQ_PREFIX_TXT,'OKL_QUICK_QUOTES_B',QCKQTE_SEQ_PREFIX_TXT,'OKL_LEASE_OPPORTUNITIES_B',LSEOPP_SEQ_PREFIX_TXT,'OKL_LEASE_APPLICATIONS_B',LSEAPP_SEQ_PREFIX_TXT)

626: l_query_stmt VARCHAR2(100);
627: TYPE l_csr_typ IS REF CURSOR;
628: l_ref_csr l_csr_typ;
629: CURSOR c_get_prefix(c_table_name IN VARCHAR2) IS
630: SELECT DECODE(c_table_name,'OKL_LEASE_QUOTES_B',LSEQTE_SEQ_PREFIX_TXT,'OKL_QUICK_QUOTES_B',QCKQTE_SEQ_PREFIX_TXT,'OKL_LEASE_OPPORTUNITIES_B',LSEOPP_SEQ_PREFIX_TXT,'OKL_LEASE_APPLICATIONS_B',LSEAPP_SEQ_PREFIX_TXT)
631: FROM okl_system_params;
632: l_prefix VARCHAR2(30);
633: l_value VARCHAR(250);
634: BEGIN

Line 729: FROM OKL_LEASE_QUOTES_B LSQ

725: CURSOR l_lsq_dtls_csr(p_lap_id NUMBER)
726: IS
727: SELECT LSQ.ID LSQ_ID
728: , LSQ.TERM
729: FROM OKL_LEASE_QUOTES_B LSQ
730: WHERE LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
731: AND LSQ.PRIMARY_QUOTE= 'Y'
732: AND LSQ.PARENT_OBJECT_ID = p_lap_id;
733: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;

Line 1131: , OKL_LEASE_QUOTES_B LQ

1127: , LQ.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
1128: --Added Bug 5647107 ssdeshpa start
1129: FROM OKL_LEASE_APPLICATIONS_B LAB
1130: , OKL_LEASE_APPLICATIONS_TL LAT
1131: , OKL_LEASE_QUOTES_B LQ
1132: WHERE LAB.ID = LAT.ID
1133: AND LAT.LANGUAGE = USERENV('LANG')
1134: AND LQ.PARENT_OBJECT_ID = LAB.ID
1135: AND LQ.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 1910: p_source_lsq_id IN OKL_LEASE_QUOTES_B.ID%TYPE,

1906: p_init_msg_list IN VARCHAR2,
1907: x_return_status OUT NOCOPY VARCHAR2,
1908: x_msg_count OUT NOCOPY NUMBER,
1909: x_msg_data OUT NOCOPY VARCHAR2,
1910: p_source_lsq_id IN OKL_LEASE_QUOTES_B.ID%TYPE,
1911: p_lapv_rec IN lapv_rec_type,
1912: p_lsqv_rec IN lsqv_rec_type)
1913: IS
1914: -- Variables Declarations

Line 1926: FROM OKL_LEASE_QUOTES_B LQ

1922: --BUG 4951955 PAGARG Instead of Lease Opp id, Lease Quote id is the input
1923: --Cursor to query the default values from lease quote
1924: CURSOR lsq_db_val_csr(cp_lsq_id NUMBER, cp_lsqv_rec lsqv_rec_type) IS
1925: SELECT LQ.REFERENCE_NUMBER REFERENCE_NUMBER
1926: FROM OKL_LEASE_QUOTES_B LQ
1927: WHERE LQ.ID = cp_lsq_id
1928: -- AND NVL(LQ.PRICING_METHOD, OKL_API.G_MISS_CHAR) = NVL(cp_lsqv_rec.PRICING_METHOD, OKL_API.G_MISS_CHAR)
1929: AND NVL(LQ.EXPECTED_START_DATE, OKL_API.G_MISS_DATE) = NVL(cp_lsqv_rec.EXPECTED_START_DATE, OKL_API.G_MISS_DATE)
1930: AND NVL(LQ.VALID_FROM, OKL_API.G_MISS_DATE) = NVL(cp_lsqv_rec.VALID_FROM, OKL_API.G_MISS_DATE)

Line 1986: FROM OKL_LEASE_QUOTES_B LQ

1982: --Cursor to obtain parent object information of lease quote
1983: CURSOR lsq_parent_csr(cp_lsq_id NUMBER) IS
1984: SELECT LQ.PARENT_OBJECT_CODE PARENT_OBJECT_CODE
1985: , LQ.PARENT_OBJECT_ID PARENT_OBJECT_ID
1986: FROM OKL_LEASE_QUOTES_B LQ
1987: WHERE LQ.ID = cp_lsq_id;
1988: lsq_parent_rec lsq_parent_csr%ROWTYPE;
1989: BEGIN
1990: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2265: ,OKL_LEASE_QUOTES_B LSQ

2261: ,LAB.CREDIT_LINE_ID CREDIT_LINE_ID
2262: ,LSQ.ID LSQ_ID
2263: FROM OKL_LEASE_APPLICATIONS_B LAB
2264: ,OKL_LEASEAPP_TEMPLATES LAT
2265: ,OKL_LEASE_QUOTES_B LSQ
2266: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
2267: WHERE LATV.ID = LAB.LEASEAPP_TEMPLATE_ID
2268: AND LAT.ID = LATV.LEASEAPP_TEMPLATE_ID
2269: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 2943: , OKL_LEASE_QUOTES_B LSQ

2939: IS
2940: SELECT LSQ.ID LSQ_ID
2941: , LOP.ID LOP_ID
2942: FROM OKL_LEASE_OPPORTUNITIES_B LOP
2943: , OKL_LEASE_QUOTES_B LSQ
2944: WHERE
2945: LSQ.PARENT_OBJECT_ID = LOP.ID
2946: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'
2947: AND LSQ.STATUS = 'CT-ACCEPTED'

Line 3128: ,'OKL_LEASE_QUOTES_B'

3124: --Bug 4721142 PAGARG set the lease quote reference number form sequence
3125: --Bug 4867953 PAGARG instead of using the sequence directly use function
3126: l_lsqv_rec.reference_number := get_next_seq_num(
3127: 'OKL_LSQ_REF_SEQ'
3128: ,'OKL_LEASE_QUOTES_B'
3129: ,'REFERENCE_NUMBER');
3130: --Bug Fix End
3131: l_lsqv_rec.status := 'PR-INCOMPLETE';
3132: l_lsqv_rec.primary_quote := 'Y';

Line 3660: FROM OKL_LEASE_QUOTES_B LSQ

3656: CURSOR l_lsq_dtls_csr(p_lap_id NUMBER)
3657: IS
3658: SELECT LSQ.ID LSQ_ID
3659: , LSQ.STATUS STATUS
3660: FROM OKL_LEASE_QUOTES_B LSQ
3661: WHERE LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
3662: AND LSQ.PRIMARY_QUOTE= 'Y'
3663: AND LSQ.PARENT_OBJECT_ID = p_lap_id;
3664: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;

Line 4254: FROM OKL_LEASE_QUOTES_B LSQ

4250: CURSOR lse_qte_dtls_csr(cp_lop_id NUMBER) IS
4251: SELECT LSQ.ID
4252: , LSQ.REFERENCE_NUMBER
4253: , LSQ.STATUS
4254: FROM OKL_LEASE_QUOTES_B LSQ
4255: , OKL_LEASE_OPPORTUNITIES_B LOP
4256: WHERE LOP.ID = cp_lop_id
4257: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'
4258: AND LSQ.PARENT_OBJECT_ID = LOP.ID

Line 5505: FROM OKL_LEASE_QUOTES_B LSQ

5501: --Cursor to obtain Source Lease App details
5502: CURSOR src_lse_app_dtls_csr(cp_lap_id NUMBER)
5503: IS
5504: SELECT LSQ.ID LSQ_ID
5505: FROM OKL_LEASE_QUOTES_B LSQ
5506: , OKL_LEASE_APPLICATIONS_B LAP
5507: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
5508: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
5509: AND LSQ.PRIMARY_QUOTE = 'Y'

Line 5520: , OKL_LEASE_QUOTES_B LSQ

5516: IS
5517: SELECT LSQ.ID LSQ_ID
5518: , LOP.ID LOP_ID
5519: FROM OKL_LEASE_OPPORTUNITIES_B LOP
5520: , OKL_LEASE_QUOTES_B LSQ
5521: WHERE
5522: LSQ.PARENT_OBJECT_ID = LOP.ID
5523: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'
5524: AND LSQ.STATUS = 'CT-ACCEPTED'

Line 5712: ,'OKL_LEASE_QUOTES_B'

5708: --Bug 4721142 PAGARG set the lease quote reference number form sequence
5709: --Bug 4867953 PAGARG instead of using the sequence directly use function
5710: l_lsqv_rec.reference_number := get_next_seq_num(
5711: 'OKL_LSQ_REF_SEQ'
5712: ,'OKL_LEASE_QUOTES_B'
5713: ,'REFERENCE_NUMBER');
5714: --Bug Fix End
5715: l_lsqv_rec.primary_quote := 'Y';
5716: l_lsqv_rec.status := 'PR-INCOMPLETE';

Line 6197: FROM OKL_LEASE_QUOTES_B LSQ

6193: CURSOR l_lsq_dtls_csr(p_lap_id NUMBER)
6194: IS
6195: SELECT LSQ.ID LSQ_ID
6196: , LSQ.STATUS STATUS
6197: FROM OKL_LEASE_QUOTES_B LSQ
6198: WHERE LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
6199: AND LSQ.PRIMARY_QUOTE= 'Y'
6200: AND LSQ.PARENT_OBJECT_ID = p_lap_id;
6201: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;

Line 6597: FROM OKL_LEASE_QUOTES_B LSQ

6593: CURSOR l_lsq_dtls_csr(p_lap_id NUMBER)
6594: IS
6595: SELECT LSQ.ID LSQ_ID
6596: , LSQ.REFERENCE_NUMBER REFERENCE_NUMBER
6597: FROM OKL_LEASE_QUOTES_B LSQ
6598: WHERE LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
6599: AND LSQ.PRIMARY_QUOTE= 'Y'
6600: AND LSQ.PARENT_OBJECT_ID = p_lap_id;
6601: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;

Line 7671: FROM OKL_LEASE_QUOTES_B LSQ

7667: IS
7668: SELECT LSQ.ID LSQ_ID
7669: , LAP.APPLICATION_STATUS LAP_STATUS
7670: , LAP.REFERENCE_NUMBER LAP_NUMBER
7671: FROM OKL_LEASE_QUOTES_B LSQ
7672: , OKL_LEASE_APPLICATIONS_B LAP
7673: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
7674: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
7675: AND LSQ.PRIMARY_QUOTE = 'Y'

Line 8164: FROM OKL_LEASE_QUOTES_B LSQ

8160: IS
8161: SELECT ID
8162: , REFERENCE_NUMBER
8163: , STATUS
8164: FROM OKL_LEASE_QUOTES_B LSQ
8165: WHERE PARENT_OBJECT_CODE = 'LEASEAPP'
8166: AND STATUS IN ('CR-RECOMMENDATION', 'CR-INCOMPLETE')
8167: AND PARENT_OBJECT_ID = cp_lap_id;
8168:

Line 8312: FROM OKL_LEASE_QUOTES_B

8308: FETCH ocm_counter_offer_csr INTO l_recom_mean;
8309: IF ocm_counter_offer_csr%NOTFOUND
8310: THEN
8311: SELECT OBJECT_VERSION_NUMBER INTO l_lsqv_rec.object_version_number
8312: FROM OKL_LEASE_QUOTES_B
8313: WHERE ID = okl_counter_offer_rec.id;
8314:
8315: l_lsqv_rec.id := okl_counter_offer_rec.id;
8316: l_lsqv_rec.parent_object_id := -1;

Line 8478: FROM OKL_LEASE_QUOTES_B LSQ

8474: CURSOR src_lse_app_dtls_csr(cp_lap_id NUMBER)
8475: IS
8476: SELECT LSQ.ID LSQ_ID
8477: , CRR.CREDIT_REQUEST_ID
8478: FROM OKL_LEASE_QUOTES_B LSQ
8479: , OKL_LEASE_APPLICATIONS_B LAP
8480: , AR_CMGT_CREDIT_REQUESTS CRR
8481: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
8482: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 8614: ,'OKL_LEASE_QUOTES_B'

8610: l_lsqv_rec.parent_object_code := 'LEASEAPP';
8611: l_lsqv_rec.parent_object_id := x_lapv_rec.id;
8612: l_lsqv_rec.reference_number := get_next_seq_num(
8613: 'OKL_LSQ_REF_SEQ'
8614: ,'OKL_LEASE_QUOTES_B'
8615: ,'REFERENCE_NUMBER');
8616: l_lsqv_rec.status := 'PR-INCOMPLETE';
8617: l_lsqv_rec.primary_quote := 'Y';
8618:

Line 9288: FROM OKL_LEASE_QUOTES_B LSQ

9284: SELECT LSQ.ID LSQ_ID
9285: , CRR.CREDIT_REQUEST_ID
9286: , LAP.APPLICATION_STATUS
9287: , LAP.APPLICATION_STATUS APPEAL_SCOPE
9288: FROM OKL_LEASE_QUOTES_B LSQ
9289: , OKL_LEASE_APPLICATIONS_B LAP
9290: , AR_CMGT_CREDIT_REQUESTS CRR
9291: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
9292: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 9423: ,'OKL_LEASE_QUOTES_B'

9419: l_lsqv_rec.parent_object_code := 'LEASEAPP';
9420: l_lsqv_rec.parent_object_id := x_lapv_rec.id;
9421: l_lsqv_rec.reference_number := get_next_seq_num(
9422: 'OKL_LSQ_REF_SEQ'
9423: ,'OKL_LEASE_QUOTES_B'
9424: ,'REFERENCE_NUMBER');
9425: l_lsqv_rec.status := 'CT-ACCEPTED';
9426: l_lsqv_rec.primary_quote := 'Y';
9427:

Line 10296: FROM OKL_LEASE_QUOTES_B LSQ

10292: CURSOR l_lsq_dtls_csr(p_lap_id NUMBER)
10293: IS
10294: SELECT LSQ.ID LSQ_ID
10295: , LSQ.STATUS STATUS
10296: FROM OKL_LEASE_QUOTES_B LSQ
10297: WHERE LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
10298: AND LSQ.PRIMARY_QUOTE= 'Y'
10299: AND LSQ.PARENT_OBJECT_ID = p_lap_id;
10300: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;

Line 11864: FROM OKL_LEASE_QUOTES_B LSQ

11860: IS
11861: SELECT LSQ.REFERENCE_NUMBER LSE_QTE
11862: , LOP.REFERENCE_NUMBER LSE_OPP
11863: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
11864: FROM OKL_LEASE_QUOTES_B LSQ
11865: , OKL_LEASE_APPLICATIONS_B CLAB
11866: , OKL_LEASE_OPPORTUNITIES_B LOP
11867: , OKC_K_HEADERS_B CHR
11868: , OKC_STATUSES_V CSTS