DBA Data[Home] [Help]

APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_K_HEADERS_B_S

Line 5321: l_contract_start_date okc_k_headers_b.start_date%TYPE;

5317: l_copied_id NUMBER;
5318: l_gov_id NUMBER;
5319: l_capital_amount NUMBER;
5320: l_contract_currency okc_k_headers_b.currency_code%TYPE;
5321: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5322: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5323: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5324: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;
5325: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;

Line 7306: l_sts_code okc_k_headers_b.sts_code%TYPE;

7302: l_prid_tab l_prid_type;
7303: l_probject1_id1_tab l_probject1_id1_type;
7304:
7305: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7306: l_sts_code okc_k_headers_b.sts_code%TYPE;
7307: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7308:
7309: --Bug# 16425139: Changing the global variables to local variables
7310: l_created_by NUMBER := fnd_global.user_id;

Line 7307: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;

7303: l_probject1_id1_tab l_probject1_id1_type;
7304:
7305: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7306: l_sts_code okc_k_headers_b.sts_code%TYPE;
7307: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7308:
7309: --Bug# 16425139: Changing the global variables to local variables
7310: l_created_by NUMBER := fnd_global.user_id;
7311: l_last_updated_by NUMBER := fnd_global.user_id;

Line 20672: SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;

20668: l_sts_code_orig := c1rec.sts_code;
20669:
20670: l_curr_pos := 'okl_copy_lease_contract:4';
20671: -- kmotepal populating contract id from sys guid instead of using OKC sequence which fixes the bug 4436545 (Reverted back for OKL.H)
20672: SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;
20673: --l_copied_id := okc_p_util.raw_to_number(sys_guid());
20674:
20675: l_contract_currency := c1rec.currency_code;
20676: l_contract_start_date := c1rec.start_date;

Line 22330: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;

22326: orig_system_id1
22327: From okc_k_headers_b
22328: where id = p_chr_id;
22329:
22330: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;
22331: l_orig_chr_id okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;
22332:
22333: --Bug # 2792330 S and O
22334: --get the status of source contract

Line 22340: l_sts_code okc_k_headers_b.STS_CODE%TYPE;

22336: Select sts_code
22337: From OKC_K_HEADERS_B
22338: Where id = pchrid;
22339:
22340: l_sts_code okc_k_headers_b.STS_CODE%TYPE;
22341: l_quote_chr_id okc_k_headers_b.ID%TYPE;
22342:
22343: --Bug# 3621663
22344: --cursor to get multi-gaap reporting book transaction