1290: lp_chrv_rec.object_version_number := 1.0;
1291: lp_chrv_rec.sts_code := G_STS_CODE; -- 'ENTERED';
1292: lp_chrv_rec.scs_code := 'LEASE';
1293: lp_chrv_rec.contract_number := p_contract_number;
1294: lp_chrv_rec.authoring_org_id := OKL_CONTEXT.GET_OKC_ORG_ID;
1295: lp_chrv_rec.inv_organization_id := OKL_CONTEXT.get_okc_organization_id;
1296: -- lp_chrv_rec.currency_code := OKC_CURRENCY_API.GET_OU_CURRENCY(OKL_CONTEXT.GET_OKC_ORG_ID);
1297:
1298: lp_chrv_rec.cust_acct_id := l_cust_acct_id;
1291: lp_chrv_rec.sts_code := G_STS_CODE; -- 'ENTERED';
1292: lp_chrv_rec.scs_code := 'LEASE';
1293: lp_chrv_rec.contract_number := p_contract_number;
1294: lp_chrv_rec.authoring_org_id := OKL_CONTEXT.GET_OKC_ORG_ID;
1295: lp_chrv_rec.inv_organization_id := OKL_CONTEXT.get_okc_organization_id;
1296: -- lp_chrv_rec.currency_code := OKC_CURRENCY_API.GET_OU_CURRENCY(OKL_CONTEXT.GET_OKC_ORG_ID);
1297:
1298: lp_chrv_rec.cust_acct_id := l_cust_acct_id;
1299: lp_chrv_rec.currency_code := l_currency_code;
1292: lp_chrv_rec.scs_code := 'LEASE';
1293: lp_chrv_rec.contract_number := p_contract_number;
1294: lp_chrv_rec.authoring_org_id := OKL_CONTEXT.GET_OKC_ORG_ID;
1295: lp_chrv_rec.inv_organization_id := OKL_CONTEXT.get_okc_organization_id;
1296: -- lp_chrv_rec.currency_code := OKC_CURRENCY_API.GET_OU_CURRENCY(OKL_CONTEXT.GET_OKC_ORG_ID);
1297:
1298: lp_chrv_rec.cust_acct_id := l_cust_acct_id;
1299: lp_chrv_rec.currency_code := l_currency_code;
1300:
1718: lp_chrv_rec.object_version_number := 1.0;
1719: lp_chrv_rec.sts_code := G_STS_CODE; -- 'ENTERED';
1720: lp_chrv_rec.scs_code := p_scs_code;
1721: lp_chrv_rec.contract_number := p_contract_number;
1722: lp_chrv_rec.authoring_org_id := OKL_CONTEXT.GET_OKC_ORG_ID;
1723: lp_chrv_rec.inv_organization_id := OKL_CONTEXT.get_okc_organization_id;
1724: lp_chrv_rec.currency_code := OKC_CURRENCY_API.GET_OU_CURRENCY(OKL_CONTEXT.GET_OKC_ORG_ID);
1725: lp_chrv_rec.currency_code_renewed := NULL;
1726: lp_chrv_rec.template_yn := 'N';
1719: lp_chrv_rec.sts_code := G_STS_CODE; -- 'ENTERED';
1720: lp_chrv_rec.scs_code := p_scs_code;
1721: lp_chrv_rec.contract_number := p_contract_number;
1722: lp_chrv_rec.authoring_org_id := OKL_CONTEXT.GET_OKC_ORG_ID;
1723: lp_chrv_rec.inv_organization_id := OKL_CONTEXT.get_okc_organization_id;
1724: lp_chrv_rec.currency_code := OKC_CURRENCY_API.GET_OU_CURRENCY(OKL_CONTEXT.GET_OKC_ORG_ID);
1725: lp_chrv_rec.currency_code_renewed := NULL;
1726: lp_chrv_rec.template_yn := 'N';
1727: lp_chrv_rec.chr_type := 'CYA';
1720: lp_chrv_rec.scs_code := p_scs_code;
1721: lp_chrv_rec.contract_number := p_contract_number;
1722: lp_chrv_rec.authoring_org_id := OKL_CONTEXT.GET_OKC_ORG_ID;
1723: lp_chrv_rec.inv_organization_id := OKL_CONTEXT.get_okc_organization_id;
1724: lp_chrv_rec.currency_code := OKC_CURRENCY_API.GET_OU_CURRENCY(OKL_CONTEXT.GET_OKC_ORG_ID);
1725: lp_chrv_rec.currency_code_renewed := NULL;
1726: lp_chrv_rec.template_yn := 'N';
1727: lp_chrv_rec.chr_type := 'CYA';
1728: lp_chrv_rec.archived_yn := 'N';
1979: lp_chrv_rec.object_version_number := 1.0;
1980: lp_chrv_rec.sts_code := G_STS_CODE; -- 'ENTERED';
1981: lp_chrv_rec.scs_code := p_scs_code;
1982: lp_chrv_rec.contract_number := p_contract_number;
1983: lp_chrv_rec.authoring_org_id := OKL_CONTEXT.GET_OKC_ORG_ID;
1984: lp_chrv_rec.inv_organization_id := OKL_CONTEXT.get_okc_organization_id;
1985: lp_chrv_rec.currency_code := OKC_CURRENCY_API.GET_OU_CURRENCY(OKL_CONTEXT.GET_OKC_ORG_ID);
1986: lp_chrv_rec.currency_code_renewed := NULL;
1987: lp_chrv_rec.template_yn := 'N';
1980: lp_chrv_rec.sts_code := G_STS_CODE; -- 'ENTERED';
1981: lp_chrv_rec.scs_code := p_scs_code;
1982: lp_chrv_rec.contract_number := p_contract_number;
1983: lp_chrv_rec.authoring_org_id := OKL_CONTEXT.GET_OKC_ORG_ID;
1984: lp_chrv_rec.inv_organization_id := OKL_CONTEXT.get_okc_organization_id;
1985: lp_chrv_rec.currency_code := OKC_CURRENCY_API.GET_OU_CURRENCY(OKL_CONTEXT.GET_OKC_ORG_ID);
1986: lp_chrv_rec.currency_code_renewed := NULL;
1987: lp_chrv_rec.template_yn := 'N';
1988: lp_chrv_rec.chr_type := 'CYA';
1981: lp_chrv_rec.scs_code := p_scs_code;
1982: lp_chrv_rec.contract_number := p_contract_number;
1983: lp_chrv_rec.authoring_org_id := OKL_CONTEXT.GET_OKC_ORG_ID;
1984: lp_chrv_rec.inv_organization_id := OKL_CONTEXT.get_okc_organization_id;
1985: lp_chrv_rec.currency_code := OKC_CURRENCY_API.GET_OU_CURRENCY(OKL_CONTEXT.GET_OKC_ORG_ID);
1986: lp_chrv_rec.currency_code_renewed := NULL;
1987: lp_chrv_rec.template_yn := 'N';
1988: lp_chrv_rec.chr_type := 'CYA';
1989: lp_chrv_rec.archived_yn := 'N';
2294: lp_chrv_rec.object_version_number := 1.0;
2295: lp_chrv_rec.sts_code := G_STS_CODE; -- 'ENTERED';
2296: lp_chrv_rec.scs_code := p_scs_code;
2297: lp_chrv_rec.contract_number := p_contract_number;
2298: lp_chrv_rec.authoring_org_id := OKL_CONTEXT.GET_OKC_ORG_ID;
2299: lp_chrv_rec.inv_organization_id := OKL_CONTEXT.get_okc_organization_id;
2300:
2301: -- lp_chrv_rec.currency_code := OKC_CURRENCY_API.GET_OU_CURRENCY(OKL_CONTEXT.GET_OKC_ORG_ID);
2302: lp_chrv_rec.currency_code := OKL_ACCOUNTING_UTIL.get_func_curr_code;
2295: lp_chrv_rec.sts_code := G_STS_CODE; -- 'ENTERED';
2296: lp_chrv_rec.scs_code := p_scs_code;
2297: lp_chrv_rec.contract_number := p_contract_number;
2298: lp_chrv_rec.authoring_org_id := OKL_CONTEXT.GET_OKC_ORG_ID;
2299: lp_chrv_rec.inv_organization_id := OKL_CONTEXT.get_okc_organization_id;
2300:
2301: -- lp_chrv_rec.currency_code := OKC_CURRENCY_API.GET_OU_CURRENCY(OKL_CONTEXT.GET_OKC_ORG_ID);
2302: lp_chrv_rec.currency_code := OKL_ACCOUNTING_UTIL.get_func_curr_code;
2303:
2297: lp_chrv_rec.contract_number := p_contract_number;
2298: lp_chrv_rec.authoring_org_id := OKL_CONTEXT.GET_OKC_ORG_ID;
2299: lp_chrv_rec.inv_organization_id := OKL_CONTEXT.get_okc_organization_id;
2300:
2301: -- lp_chrv_rec.currency_code := OKC_CURRENCY_API.GET_OU_CURRENCY(OKL_CONTEXT.GET_OKC_ORG_ID);
2302: lp_chrv_rec.currency_code := OKL_ACCOUNTING_UTIL.get_func_curr_code;
2303:
2304: lp_chrv_rec.currency_code_renewed := NULL;
2305: lp_chrv_rec.template_yn := 'N';
2368: END IF;
2369: l_kplv_tbl(i).attribute_category := null;
2370: END LOOP;
2371:
2372: IF okl_context.get_okc_org_id IS NULL THEN
2373: l_chr_id := x_chr_id;
2374: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
2375: END IF;
2376:
2370: END LOOP;
2371:
2372: IF okl_context.get_okc_org_id IS NULL THEN
2373: l_chr_id := x_chr_id;
2374: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
2375: END IF;
2376:
2377: /*OKL_COPY_CONTRACT_PUB.copy_party_roles(
2378: p_api_version => p_api_version,
3299: x_msg_data => x_msg_data,
3300: p_old_khr_id => p_old_khr_id,
3301: p_source_id => p_source_id,
3302: p_dest_id => p_dest_id,
3303: p_org_id => okl_context.get_okc_org_id,
3304: p_organization_id => okl_context.get_okc_organization_id
3305: );
3306:
3307: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3300: p_old_khr_id => p_old_khr_id,
3301: p_source_id => p_source_id,
3302: p_dest_id => p_dest_id,
3303: p_org_id => okl_context.get_okc_org_id,
3304: p_organization_id => okl_context.get_okc_organization_id
3305: );
3306:
3307: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3308: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3322: x_msg_count => x_msg_count,
3323: x_msg_data => x_msg_data,
3324: p_source_id => p_source_id, -- vp id
3325: p_dest_id => p_dest_id, -- k id
3326: p_org_id => okl_context.get_okc_org_id,
3327: p_organization_id => okl_context.get_okc_organization_id
3328: );
3329:
3330: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3323: x_msg_data => x_msg_data,
3324: p_source_id => p_source_id, -- vp id
3325: p_dest_id => p_dest_id, -- k id
3326: p_org_id => okl_context.get_okc_org_id,
3327: p_organization_id => okl_context.get_okc_organization_id
3328: );
3329:
3330: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3331: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3342: x_msg_count => x_msg_count,
3343: x_msg_data => x_msg_data,
3344: p_source_id => p_source_id, -- vp id
3345: p_dest_id => p_dest_id, -- k id
3346: p_org_id => okl_context.get_okc_org_id,
3347: p_organization_id => okl_context.get_okc_organization_id
3348: );
3349:
3350: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3343: x_msg_data => x_msg_data,
3344: p_source_id => p_source_id, -- vp id
3345: p_dest_id => p_dest_id, -- k id
3346: p_org_id => okl_context.get_okc_org_id,
3347: p_organization_id => okl_context.get_okc_organization_id
3348: );
3349:
3350: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3351: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4414: END IF;
4415: */
4416: l_chr_id := x_chr_id;
4417:
4418: IF okl_context.get_okc_org_id IS NULL THEN
4419: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
4420: END IF;
4421:
4422: -- bug 4227922 property tax options defaulting onto contract
4415: */
4416: l_chr_id := x_chr_id;
4417:
4418: IF okl_context.get_okc_org_id IS NULL THEN
4419: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
4420: END IF;
4421:
4422: -- bug 4227922 property tax options defaulting onto contract
4423: IF ( p_scs_code = 'LEASE') THEN
5138: END IF;
5139:
5140: l_chr_id := x_chr_id;
5141:
5142: IF okl_context.get_okc_org_id IS NULL THEN
5143: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
5144: END IF;
5145:
5146: -- bug 4227922 property tax options defaulting onto contract
5139:
5140: l_chr_id := x_chr_id;
5141:
5142: IF okl_context.get_okc_org_id IS NULL THEN
5143: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
5144: END IF;
5145:
5146: -- bug 4227922 property tax options defaulting onto contract
5147: IF ( p_scs_code = 'LEASE') THEN
5457: row_cnt NUMBER;
5458:
5459: BEGIN
5460:
5461: IF okl_context.get_okc_org_id IS NULL THEN
5462: l_chr_id := p_chrv_rec.id;
5463: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
5464: END IF;
5465:
5459: BEGIN
5460:
5461: IF okl_context.get_okc_org_id IS NULL THEN
5462: l_chr_id := p_chrv_rec.id;
5463: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
5464: END IF;
5465:
5466: x_return_status := OKC_API.START_ACTIVITY(
5467: p_api_name => l_api_name,
5834: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5835:
5836: BEGIN
5837:
5838: IF okl_context.get_okc_org_id IS NULL THEN
5839: l_chr_id := p_chr_id;
5840: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
5841: END IF;
5842:
5836: BEGIN
5837:
5838: IF okl_context.get_okc_org_id IS NULL THEN
5839: l_chr_id := p_chr_id;
5840: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
5841: END IF;
5842:
5843: x_return_status := OKC_API.START_ACTIVITY(
5844: p_api_name => l_api_name,
6687:
6688:
6689: BEGIN
6690:
6691: IF okl_context.get_okc_org_id IS NULL THEN
6692: l_chr_id := p_durv_rec.chr_id;
6693: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
6694: END IF;
6695:
6689: BEGIN
6690:
6691: IF okl_context.get_okc_org_id IS NULL THEN
6692: l_chr_id := p_durv_rec.chr_id;
6693: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
6694: END IF;
6695:
6696: x_return_status := OKC_API.START_ACTIVITY(
6697: p_api_name => l_api_name,
7959: END IF;
7960:
7961: END IF;
7962:
7963: IF okl_context.get_okc_org_id IS NULL THEN
7964: l_chr_id := p_durv_rec.chr_id;
7965: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
7966: END IF;
7967:
7961: END IF;
7962:
7963: IF okl_context.get_okc_org_id IS NULL THEN
7964: l_chr_id := p_durv_rec.chr_id;
7965: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
7966: END IF;
7967:
7968: IF (p_durv_rec.program_contract_number IS NOT NULL OR old_khr_id IS NOT NULL) THEN
7969:
7976: p_old_khr_id => old_khr_id,
7977: p_prog_override_yn => p_durv_rec.khr_generate_accrual_yn, -- program flag yn
7978: p_source_id => x_durv_rec.khr_khr_id, -- program id
7979: p_dest_id => p_durv_rec.chr_id,
7980: p_org_id => okl_context.get_okc_org_id,
7981: p_organization_id => okl_context.get_okc_organization_id
7982: );
7983:
7984: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7977: p_prog_override_yn => p_durv_rec.khr_generate_accrual_yn, -- program flag yn
7978: p_source_id => x_durv_rec.khr_khr_id, -- program id
7979: p_dest_id => p_durv_rec.chr_id,
7980: p_org_id => okl_context.get_okc_org_id,
7981: p_organization_id => okl_context.get_okc_organization_id
7982: );
7983:
7984: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7985: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8179:
8180:
8181: BEGIN
8182:
8183: IF okl_context.get_okc_org_id IS NULL THEN
8184: l_chr_id := p_durv_rec.chr_id;
8185: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
8186: END IF;
8187:
8181: BEGIN
8182:
8183: IF okl_context.get_okc_org_id IS NULL THEN
8184: l_chr_id := p_durv_rec.chr_id;
8185: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
8186: END IF;
8187:
8188: x_return_status := OKC_API.START_ACTIVITY(
8189: p_api_name => l_api_name,