[Home] [Help]
35:
36: CURSOR ak_prompt_csr(p_ak_region VARCHAR2, p_ak_attribute VARCHAR2) IS
37: --start modified abhsaxen for performance SQLID 20562566
38: select a.attribute_label_long
39: from ak_region_items ri, ak_regions r, ak_attributes_vl a
40: where ri.region_code = r.region_code
41: and ri.region_application_id = r.region_application_id
42: and ri.attribute_code = a.attribute_code
43: and ri.attribute_application_id = a.attribute_application_id
45: and ri.attribute_code = p_ak_attribute
46: --end modified abhsaxen for performance SQLID 20562566
47: ;
48:
49: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
50: BEGIN
51: OPEN ak_prompt_csr(p_ak_region, p_ak_attribute);
52: FETCH ak_prompt_csr INTO l_ak_prompt;
53: CLOSE ak_prompt_csr;
3882: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3883: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3884: l_object_code VARCHAR2(30) DEFAULT NULL;
3885:
3886: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
3887:
3888: BEGIN
3889:
3890: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(
4177: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4178: l_object_code VARCHAR2(30) DEFAULT NULL;
4179: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4180:
4181: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4182:
4183: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4184: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4185: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4813: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4814: l_object_code VARCHAR2(30) DEFAULT NULL;
4815: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4816:
4817: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4818:
4819: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4820: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4821: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5535: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5536: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5537: l_object_code VARCHAR2(30) DEFAULT NULL;
5538:
5539: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
5540: l_chr_id NUMBER;
5541:
5542: CURSOR l_chk_cust_acc_csr(p_cust_acc_id1 VARCHAR2, p_name VARCHAR2) IS
5543: SELECT COUNT(1)
5810: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5811: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5812: l_object_code VARCHAR2(30) DEFAULT NULL;
5813:
5814: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
5815: l_chr_id NUMBER;
5816:
5817: cursor l_get_cust_id_csr(p_name VARCHAR2) is
5818: select OKX_PARTY.ID1, OKX_PARTY.ID2
6571: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6572: l_object_code VARCHAR2(30) DEFAULT NULL;
6573: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;
6574:
6575: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
6576: l_chr_id NUMBER;
6577: row_cnt NUMBER;
6578: l_rgp_id NUMBER := NULL;
6579: l_rul_id NUMBER := NULL;
8251: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8252: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8253: l_object_code VARCHAR2(30) DEFAULT NULL;
8254:
8255: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
8256: l_chr_id NUMBER;
8257: row_cnt NUMBER;
8258:
8259: CURSOR l_load_hdr_csr IS