[Home] [Help]
275: RETURN VARCHAR2
276: IS
277: -- A complex query to find out if a contract has syndication
278: CURSOR syndicate_flag_csr(p_contract_id NUMBER) IS
279: SELECT 'Y' FROM okc_k_headers_b chr
280: WHERE id = p_contract_id
281: AND EXISTS
282: (
283: SELECT 'x' FROM okc_k_items cim
290: AND cle.id = cim.cle_id
291: )
292: AND EXISTS
293: (
294: SELECT 'x' FROM okc_k_headers_b chr2
295: WHERE chr2.id = cim.dnz_chr_id
296: AND chr2.scs_code = 'SYNDICATION'
297: AND chr2.sts_code not in ('TERMINATED','ABANDONED')
298: )
394: CURSOR get_contract_number_csr(p_chr_id NUMBER) IS
395: SELECT a.contract_number,
396: nvl(b.multi_gaap_yn, 'N') multi_gaap_yn,
397: c.reporting_pdt_id -- MGAAP 7263041
398: FROM OKC_K_HEADERS_B a, OKL_K_HEADERS B,
399: OKL_PRODUCTS C
400: WHERE A.id = p_chr_id
401: AND A.id = B.id
402: AND B.PDT_ID = C.ID;
414: --Bug 4740605.Added TRUNC
415: CURSOR check_streams_accrual_csr(p_chr_id NUMBER, p_accrue_till_date DATE,
416: p_reporting_pdt_id NUMBER) IS -- MGAAP
417: SELECT 'N'
418: FROM OKC_K_HEADERS_B CHR
419: WHERE id = p_chr_id
420: AND EXISTS (
421: SELECT 1
422: FROM OKL_STRM_TYPE_B sty,
449: WHERE ID = p_khr_id;
450:
451: CURSOR khr_start_date_csr IS
452: SELECT TRUNC(start_date)
453: FROM OKC_K_HEADERS_B
454: WHERE ID = p_khr_id;
455:
456: --Bug 5036337
457: CURSOR check_actual_trx(p_khr_id NUMBER) IS
1140: -- Get Contract Salesperson
1141: -- 30-Apr-2004. Bug 3596651. Cursor provided by Sarvanan.
1142: CURSOR l_salesperson_csr (cp_chr_id IN NUMBER) IS
1143: SELECT con.object1_id1
1144: FROM OKC_K_HEADERS_B CHR,
1145: OKC_CONTACT_SOURCES cso,
1146: OKC_K_PARTY_ROLES_B kpr,
1147: OKC_CONTACTS con
1148: WHERE CHR.id = cp_chr_id
1169:
1170: -- cursor to get bill-to-site of customer at contract level
1171: CURSOR chr_bill_to_site_csr (p_chr_id NUMBER) IS
1172: SELECT bill_to_site_use_id
1173: FROM OKC_K_HEADERS_B
1174: WHERE id = p_chr_id;
1175:
1176: l_sales_person_id OKC_CONTACTS_V.OBJECT1_ID1%TYPE;
1177: l_counter NUMBER := 1;
2372: khr.generate_accrual_yn,
2373: khr.generate_accrual_override_yn,
2374: khr.deal_type,
2375: pdt.reporting_pdt_id -- MGAAP 7263014
2376: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,
2377: OKL_PRODUCTS pdt
2378: WHERE chr.id = p_ctr_id
2379: AND chr.id = khr.id
2380: AND khr.pdt_id = pdt.id;
3001: ,khr.currency_conversion_type
3002: ,khr.currency_conversion_rate
3003: ,khr.currency_conversion_date
3004: ,pdt.reporting_pdt_id
3005: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,
3006: OKL_PRODUCTS pdt --MGAAP 7263041
3007: WHERE chr.id = p_khr_id
3008: AND chr.id = khr.id
3009: AND khr.pdt_id = pdt.id;
3946:
3947: -- Cursor to select Contract Number
3948: CURSOR get_contract_number_csr(p_ctr_id NUMBER) IS
3949: SELECT contract_number
3950: FROM OKC_K_HEADERS_B
3951: WHERE id = p_ctr_id;
3952:
3953: -- Cursor to select accrual transactions for cancellation using specified tcn_type
3954: CURSOR reverse_trx_csr IS
4182:
4183: -- Cursor to select Contract Number
4184: CURSOR get_contract_number_csr(p_ctr_id NUMBER) IS
4185: SELECT contract_number
4186: FROM OKC_K_HEADERS_B
4187: WHERE id = p_ctr_id;
4188:
4189: -- Cursor to select accrual transactions for cancellation
4190: CURSOR reverse_trx_csr(p_khr_id NUMBER) IS
10010:
10011: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
10012: CURSOR chk_update_header_csr is
10013: SELECT chr.contract_number
10014: FROM OKC_K_HEADERS_B chr,
10015: OKL_K_HEADERS khr,
10016: OKL_PROD_QLTY_VAL_UV pdt
10017: WHERE chr.scs_code = 'LEASE'
10018: AND chr.sts_code IN ('BOOKED','EVERGREEN')
10022: AND pdt.quality_val = p_rev_rec_method
10023: -- modified by zrehman for Bug#6788005 on 04-Feb-2008 start
10024: UNION
10025: SELECT chr.contract_number
10026: FROM OKC_K_HEADERS_B chr,
10027: OKL_K_HEADERS khr
10028: WHERE chr.scs_code = 'INVESTOR'
10029: AND chr.sts_code = 'ACTIVE'
10030: AND chr.id = khr.id
10033:
10034: CURSOR chk_data_volume_csr(p_seq_next VARCHAR2 ) IS
10035: SELECT chr.contract_number contract_number
10036: ,count(cle.id) line_count
10037: FROM OKC_K_HEADERS_B chr, OKC_K_LINES_B cle, okl_parallel_processes opp
10038: WHERE opp.object_value = chr.contract_number
10039: AND opp.assigned_process = p_seq_next
10040: AND opp.object_type = 'ACCRUAL_CONTRACT'
10041: AND chr.scs_code = 'LEASE'
10045: -- modified by zrehman for Bug#6788005 on 04-Feb-2008 start
10046: UNION
10047: SELECT chr.contract_number contract_number
10048: ,count(cle.id) line_count
10049: FROM OKC_K_HEADERS_B chr, OKC_K_LINES_B cle, okl_parallel_processes opp
10050: WHERE opp.object_value = chr.contract_number
10051: AND opp.assigned_process = p_seq_next
10052: AND opp.object_type = 'ACCRUAL_CONTRACT'
10053: AND chr.scs_code = 'INVESTOR'
10100: ,chr.currency_code
10101: ,khr.currency_conversion_type
10102: ,khr.currency_conversion_rate
10103: ,khr.currency_conversion_date
10104: FROM OKC_K_HEADERS_B chr,
10105: OKL_K_HEADERS khr,
10106: OKL_PROD_QLTY_VAL_UV pdt
10107: WHERE chr.contract_number = p_contract_number
10108: AND chr.id = khr.id
10124: ,chr.currency_code
10125: ,khr.currency_conversion_type
10126: ,khr.currency_conversion_rate
10127: ,khr.currency_conversion_date
10128: FROM OKC_K_HEADERS_B chr,
10129: OKL_K_HEADERS khr
10130: WHERE chr.contract_number = p_contract_number
10131: AND chr.id = khr.id
10132: AND chr.scs_code = 'INVESTOR'
10690: ,chr.currency_code
10691: ,khr.currency_conversion_type
10692: ,khr.currency_conversion_rate
10693: ,khr.currency_conversion_date
10694: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
10695: WHERE chr.contract_number = p_khr_num
10696: AND chr.id = khr.id
10697: AND chr.scs_code = 'LEASE'
10698: AND chr.sts_code IN ('BOOKED','EVERGREEN')
10709: ,chr.currency_code
10710: ,khr.currency_conversion_type
10711: ,khr.currency_conversion_rate
10712: ,khr.currency_conversion_date
10713: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
10714: WHERE chr.contract_number = p_khr_num
10715: AND chr.id = khr.id
10716: AND chr.scs_code = 'INVESTOR'
10717: AND chr.sts_code = 'ACTIVE'
10737: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
10738:
10739: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;
10740: TYPE req_id_tbl_type IS TABLE OF FND_CONCURRENT_REQUESTS.request_id%TYPE INDEX BY BINARY_INTEGER;
10741: TYPE contract_number_tbl_type IS TABLE OF OKC_K_HEADERS_B.contract_number%TYPE INDEX BY BINARY_INTEGER;
10742:
10743: l_contract_num_tbl contract_number_tbl_type;
10744: l_contract_error_tbl contract_error_tbl_type;
10745: l_accrual_contracts_tbl accrual_contracts_tbl_type; -- Bug# 3020763
11061: ,khr.currency_conversion_type
11062: ,khr.currency_conversion_rate
11063: ,khr.currency_conversion_date
11064: ,pdt.quality_val revenue_recognition_method
11065: FROM OKC_K_HEADERS_B chr,
11066: OKL_K_HEADERS khr,
11067: OKL_PROD_QLTY_VAL_UV pdt
11068: WHERE chr.id = p_khr_id
11069: AND chr.id = khr.id
11084: ,khr.currency_conversion_type
11085: ,khr.currency_conversion_rate
11086: ,khr.currency_conversion_date
11087: ,'STREAMS' revenue_recognition_method
11088: FROM OKC_K_HEADERS_B chr,
11089: OKL_K_HEADERS khr
11090: WHERE chr.id = p_khr_id
11091: AND chr.id = khr.id
11092: AND chr.scs_code = 'INVESTOR'