DBA Data[Home] [Help]

APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_K_HEADERS_B_S

Line 5245: l_contract_start_date okc_k_headers_b.start_date%TYPE;

5241: l_copied_id NUMBER;
5242: l_gov_id NUMBER;
5243: l_capital_amount NUMBER;
5244: l_contract_currency okc_k_headers_b.currency_code%TYPE;
5245: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5246: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5247: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5248: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;
5249: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;

Line 7224: l_sts_code okc_k_headers_b.sts_code%TYPE;

7220: l_prid_tab l_prid_type;
7221: l_probject1_id1_tab l_probject1_id1_type;
7222:
7223: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7224: l_sts_code okc_k_headers_b.sts_code%TYPE;
7225: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7226:
7227: PROCEDURE validate_currency_code(
7228: x_return_status OUT NOCOPY VARCHAR2,

Line 7225: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;

7221: l_probject1_id1_tab l_probject1_id1_type;
7222:
7223: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7224: l_sts_code okc_k_headers_b.sts_code%TYPE;
7225: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7226:
7227: PROCEDURE validate_currency_code(
7228: x_return_status OUT NOCOPY VARCHAR2,
7229: p_ccy_code IN okc_k_headers_b.currency_code%TYPE) IS

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

20491: l_sts_code_orig := c1rec.sts_code;
20492:
20493: l_curr_pos := 'okl_copy_lease_contract:4';
20494: -- kmotepal populating contract id from sys guid instead of using OKC sequence which fixes the bug 4436545 (Reverted back for OKL.H)
20495: SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;
20496: --l_copied_id := okc_p_util.raw_to_number(sys_guid());
20497:
20498: l_contract_currency := c1rec.currency_code;
20499: l_contract_start_date := c1rec.start_date;

Line 22152: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;

22148: orig_system_id1
22149: From okc_k_headers_b
22150: where id = p_chr_id;
22151:
22152: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;
22153: l_orig_chr_id okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;
22154:
22155: --Bug # 2792330 S and O
22156: --get the status of source contract

Line 22162: l_sts_code okc_k_headers_b.STS_CODE%TYPE;

22158: Select sts_code
22159: From OKC_K_HEADERS_B
22160: Where id = pchrid;
22161:
22162: l_sts_code okc_k_headers_b.STS_CODE%TYPE;
22163: l_quote_chr_id okc_k_headers_b.ID%TYPE;
22164:
22165: --Bug# 3621663
22166: --cursor to get multi-gaap reporting book transaction