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 588: 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)

584: l_query_stmt VARCHAR2(100);
585: TYPE l_csr_typ IS REF CURSOR;
586: l_ref_csr l_csr_typ;
587: CURSOR c_get_prefix(c_table_name IN VARCHAR2) IS
588: 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)
589: FROM okl_system_params;
590: l_prefix VARCHAR2(30);
591: l_value VARCHAR(250);
592: BEGIN

Line 687: FROM OKL_LEASE_QUOTES_B LSQ

683: CURSOR l_lsq_dtls_csr(p_lap_id NUMBER)
684: IS
685: SELECT LSQ.ID LSQ_ID
686: , LSQ.TERM
687: FROM OKL_LEASE_QUOTES_B LSQ
688: WHERE LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
689: AND LSQ.PRIMARY_QUOTE= 'Y'
690: AND LSQ.PARENT_OBJECT_ID = p_lap_id;
691: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;

Line 1089: , OKL_LEASE_QUOTES_B LQ

1085: , LQ.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
1086: --Added Bug 5647107 ssdeshpa start
1087: FROM OKL_LEASE_APPLICATIONS_B LAB
1088: , OKL_LEASE_APPLICATIONS_TL LAT
1089: , OKL_LEASE_QUOTES_B LQ
1090: WHERE LAB.ID = LAT.ID
1091: AND LAT.LANGUAGE = USERENV('LANG')
1092: AND LQ.PARENT_OBJECT_ID = LAB.ID
1093: AND LQ.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 1868: p_source_lsq_id IN OKL_LEASE_QUOTES_B.ID%TYPE,

1864: p_init_msg_list IN VARCHAR2,
1865: x_return_status OUT NOCOPY VARCHAR2,
1866: x_msg_count OUT NOCOPY NUMBER,
1867: x_msg_data OUT NOCOPY VARCHAR2,
1868: p_source_lsq_id IN OKL_LEASE_QUOTES_B.ID%TYPE,
1869: p_lapv_rec IN lapv_rec_type,
1870: p_lsqv_rec IN lsqv_rec_type)
1871: IS
1872: -- Variables Declarations

Line 1884: FROM OKL_LEASE_QUOTES_B LQ

1880: --BUG 4951955 PAGARG Instead of Lease Opp id, Lease Quote id is the input
1881: --Cursor to query the default values from lease quote
1882: CURSOR lsq_db_val_csr(cp_lsq_id NUMBER, cp_lsqv_rec lsqv_rec_type) IS
1883: SELECT LQ.REFERENCE_NUMBER REFERENCE_NUMBER
1884: FROM OKL_LEASE_QUOTES_B LQ
1885: WHERE LQ.ID = cp_lsq_id
1886: -- AND NVL(LQ.PRICING_METHOD, OKL_API.G_MISS_CHAR) = NVL(cp_lsqv_rec.PRICING_METHOD, OKL_API.G_MISS_CHAR)
1887: AND NVL(LQ.EXPECTED_START_DATE, OKL_API.G_MISS_DATE) = NVL(cp_lsqv_rec.EXPECTED_START_DATE, OKL_API.G_MISS_DATE)
1888: AND NVL(LQ.VALID_FROM, OKL_API.G_MISS_DATE) = NVL(cp_lsqv_rec.VALID_FROM, OKL_API.G_MISS_DATE)

Line 1944: FROM OKL_LEASE_QUOTES_B LQ

1940: --Cursor to obtain parent object information of lease quote
1941: CURSOR lsq_parent_csr(cp_lsq_id NUMBER) IS
1942: SELECT LQ.PARENT_OBJECT_CODE PARENT_OBJECT_CODE
1943: , LQ.PARENT_OBJECT_ID PARENT_OBJECT_ID
1944: FROM OKL_LEASE_QUOTES_B LQ
1945: WHERE LQ.ID = cp_lsq_id;
1946: lsq_parent_rec lsq_parent_csr%ROWTYPE;
1947: BEGIN
1948: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2223: ,OKL_LEASE_QUOTES_B LSQ

2219: ,LAB.CREDIT_LINE_ID CREDIT_LINE_ID
2220: ,LSQ.ID LSQ_ID
2221: FROM OKL_LEASE_APPLICATIONS_B LAB
2222: ,OKL_LEASEAPP_TEMPLATES LAT
2223: ,OKL_LEASE_QUOTES_B LSQ
2224: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
2225: WHERE LATV.ID = LAB.LEASEAPP_TEMPLATE_ID
2226: AND LAT.ID = LATV.LEASEAPP_TEMPLATE_ID
2227: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 2901: , OKL_LEASE_QUOTES_B LSQ

2897: IS
2898: SELECT LSQ.ID LSQ_ID
2899: , LOP.ID LOP_ID
2900: FROM OKL_LEASE_OPPORTUNITIES_B LOP
2901: , OKL_LEASE_QUOTES_B LSQ
2902: WHERE
2903: LSQ.PARENT_OBJECT_ID = LOP.ID
2904: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'
2905: AND LSQ.STATUS = 'CT-ACCEPTED'

Line 3086: ,'OKL_LEASE_QUOTES_B'

3082: --Bug 4721142 PAGARG set the lease quote reference number form sequence
3083: --Bug 4867953 PAGARG instead of using the sequence directly use function
3084: l_lsqv_rec.reference_number := get_next_seq_num(
3085: 'OKL_LSQ_REF_SEQ'
3086: ,'OKL_LEASE_QUOTES_B'
3087: ,'REFERENCE_NUMBER');
3088: --Bug Fix End
3089: l_lsqv_rec.status := 'PR-INCOMPLETE';
3090: l_lsqv_rec.primary_quote := 'Y';

Line 3572: FROM OKL_LEASE_QUOTES_B LSQ

3568: CURSOR l_lsq_dtls_csr(p_lap_id NUMBER)
3569: IS
3570: SELECT LSQ.ID LSQ_ID
3571: , LSQ.STATUS STATUS
3572: FROM OKL_LEASE_QUOTES_B LSQ
3573: WHERE LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
3574: AND LSQ.PRIMARY_QUOTE= 'Y'
3575: AND LSQ.PARENT_OBJECT_ID = p_lap_id;
3576: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;

Line 4166: FROM OKL_LEASE_QUOTES_B LSQ

4162: CURSOR lse_qte_dtls_csr(cp_lop_id NUMBER) IS
4163: SELECT LSQ.ID
4164: , LSQ.REFERENCE_NUMBER
4165: , LSQ.STATUS
4166: FROM OKL_LEASE_QUOTES_B LSQ
4167: , OKL_LEASE_OPPORTUNITIES_B LOP
4168: WHERE LOP.ID = cp_lop_id
4169: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'
4170: AND LSQ.PARENT_OBJECT_ID = LOP.ID

Line 5417: FROM OKL_LEASE_QUOTES_B LSQ

5413: --Cursor to obtain Source Lease App details
5414: CURSOR src_lse_app_dtls_csr(cp_lap_id NUMBER)
5415: IS
5416: SELECT LSQ.ID LSQ_ID
5417: FROM OKL_LEASE_QUOTES_B LSQ
5418: , OKL_LEASE_APPLICATIONS_B LAP
5419: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
5420: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
5421: AND LSQ.PRIMARY_QUOTE = 'Y'

Line 5432: , OKL_LEASE_QUOTES_B LSQ

5428: IS
5429: SELECT LSQ.ID LSQ_ID
5430: , LOP.ID LOP_ID
5431: FROM OKL_LEASE_OPPORTUNITIES_B LOP
5432: , OKL_LEASE_QUOTES_B LSQ
5433: WHERE
5434: LSQ.PARENT_OBJECT_ID = LOP.ID
5435: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'
5436: AND LSQ.STATUS = 'CT-ACCEPTED'

Line 5624: ,'OKL_LEASE_QUOTES_B'

5620: --Bug 4721142 PAGARG set the lease quote reference number form sequence
5621: --Bug 4867953 PAGARG instead of using the sequence directly use function
5622: l_lsqv_rec.reference_number := get_next_seq_num(
5623: 'OKL_LSQ_REF_SEQ'
5624: ,'OKL_LEASE_QUOTES_B'
5625: ,'REFERENCE_NUMBER');
5626: --Bug Fix End
5627: l_lsqv_rec.primary_quote := 'Y';
5628: l_lsqv_rec.status := 'PR-INCOMPLETE';

Line 6066: FROM OKL_LEASE_QUOTES_B LSQ

6062: CURSOR l_lsq_dtls_csr(p_lap_id NUMBER)
6063: IS
6064: SELECT LSQ.ID LSQ_ID
6065: , LSQ.STATUS STATUS
6066: FROM OKL_LEASE_QUOTES_B LSQ
6067: WHERE LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
6068: AND LSQ.PRIMARY_QUOTE= 'Y'
6069: AND LSQ.PARENT_OBJECT_ID = p_lap_id;
6070: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;

Line 6466: FROM OKL_LEASE_QUOTES_B LSQ

6462: CURSOR l_lsq_dtls_csr(p_lap_id NUMBER)
6463: IS
6464: SELECT LSQ.ID LSQ_ID
6465: , LSQ.REFERENCE_NUMBER REFERENCE_NUMBER
6466: FROM OKL_LEASE_QUOTES_B LSQ
6467: WHERE LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
6468: AND LSQ.PRIMARY_QUOTE= 'Y'
6469: AND LSQ.PARENT_OBJECT_ID = p_lap_id;
6470: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;

Line 7540: FROM OKL_LEASE_QUOTES_B LSQ

7536: IS
7537: SELECT LSQ.ID LSQ_ID
7538: , LAP.APPLICATION_STATUS LAP_STATUS
7539: , LAP.REFERENCE_NUMBER LAP_NUMBER
7540: FROM OKL_LEASE_QUOTES_B LSQ
7541: , OKL_LEASE_APPLICATIONS_B LAP
7542: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
7543: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
7544: AND LSQ.PRIMARY_QUOTE = 'Y'

Line 8033: FROM OKL_LEASE_QUOTES_B LSQ

8029: IS
8030: SELECT ID
8031: , REFERENCE_NUMBER
8032: , STATUS
8033: FROM OKL_LEASE_QUOTES_B LSQ
8034: WHERE PARENT_OBJECT_CODE = 'LEASEAPP'
8035: AND STATUS IN ('CR-RECOMMENDATION', 'CR-INCOMPLETE')
8036: AND PARENT_OBJECT_ID = cp_lap_id;
8037:

Line 8181: FROM OKL_LEASE_QUOTES_B

8177: FETCH ocm_counter_offer_csr INTO l_recom_mean;
8178: IF ocm_counter_offer_csr%NOTFOUND
8179: THEN
8180: SELECT OBJECT_VERSION_NUMBER INTO l_lsqv_rec.object_version_number
8181: FROM OKL_LEASE_QUOTES_B
8182: WHERE ID = okl_counter_offer_rec.id;
8183:
8184: l_lsqv_rec.id := okl_counter_offer_rec.id;
8185: l_lsqv_rec.parent_object_id := -1;

Line 8347: FROM OKL_LEASE_QUOTES_B LSQ

8343: CURSOR src_lse_app_dtls_csr(cp_lap_id NUMBER)
8344: IS
8345: SELECT LSQ.ID LSQ_ID
8346: , CRR.CREDIT_REQUEST_ID
8347: FROM OKL_LEASE_QUOTES_B LSQ
8348: , OKL_LEASE_APPLICATIONS_B LAP
8349: , AR_CMGT_CREDIT_REQUESTS CRR
8350: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
8351: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 8483: ,'OKL_LEASE_QUOTES_B'

8479: l_lsqv_rec.parent_object_code := 'LEASEAPP';
8480: l_lsqv_rec.parent_object_id := x_lapv_rec.id;
8481: l_lsqv_rec.reference_number := get_next_seq_num(
8482: 'OKL_LSQ_REF_SEQ'
8483: ,'OKL_LEASE_QUOTES_B'
8484: ,'REFERENCE_NUMBER');
8485: l_lsqv_rec.status := 'PR-INCOMPLETE';
8486: l_lsqv_rec.primary_quote := 'Y';
8487:

Line 9157: FROM OKL_LEASE_QUOTES_B LSQ

9153: SELECT LSQ.ID LSQ_ID
9154: , CRR.CREDIT_REQUEST_ID
9155: , LAP.APPLICATION_STATUS
9156: , LAP.APPLICATION_STATUS APPEAL_SCOPE
9157: FROM OKL_LEASE_QUOTES_B LSQ
9158: , OKL_LEASE_APPLICATIONS_B LAP
9159: , AR_CMGT_CREDIT_REQUESTS CRR
9160: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
9161: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 9292: ,'OKL_LEASE_QUOTES_B'

9288: l_lsqv_rec.parent_object_code := 'LEASEAPP';
9289: l_lsqv_rec.parent_object_id := x_lapv_rec.id;
9290: l_lsqv_rec.reference_number := get_next_seq_num(
9291: 'OKL_LSQ_REF_SEQ'
9292: ,'OKL_LEASE_QUOTES_B'
9293: ,'REFERENCE_NUMBER');
9294: l_lsqv_rec.status := 'CT-ACCEPTED';
9295: l_lsqv_rec.primary_quote := 'Y';
9296:

Line 10144: FROM OKL_LEASE_QUOTES_B LSQ

10140: CURSOR l_lsq_dtls_csr(p_lap_id NUMBER)
10141: IS
10142: SELECT LSQ.ID LSQ_ID
10143: , LSQ.STATUS STATUS
10144: FROM OKL_LEASE_QUOTES_B LSQ
10145: WHERE LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
10146: AND LSQ.PRIMARY_QUOTE= 'Y'
10147: AND LSQ.PARENT_OBJECT_ID = p_lap_id;
10148: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;

Line 11712: FROM OKL_LEASE_QUOTES_B LSQ

11708: IS
11709: SELECT LSQ.REFERENCE_NUMBER LSE_QTE
11710: , LOP.REFERENCE_NUMBER LSE_OPP
11711: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
11712: FROM OKL_LEASE_QUOTES_B LSQ
11713: , OKL_LEASE_APPLICATIONS_B CLAB
11714: , OKL_LEASE_OPPORTUNITIES_B LOP
11715: , OKC_K_HEADERS_B CHR
11716: , OKC_STATUSES_V CSTS