5323: x_chrv_rec.KEEP_ON_MAIL_LIST := UPPER(x_chrv_rec.KEEP_ON_MAIL_LIST);
5324: --Supports only CYA in this release
5325: x_chrv_rec.CHR_TYPE := 'CYA';
5326: /*--spingali bugfix for bug 12747411 start*/
5327: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (x_chrv_rec.AUTHORING_ORG_ID<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN
5328: x_chrv_rec.AUTHORING_ORG_ID := nvl(x_chrv_rec.AUTHORING_ORG_ID,nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99));
5329: x_chrv_rec.INV_ORGANIZATION_ID := nvl(x_chrv_rec.INV_ORGANIZATION_ID,nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID,-99));
5330: ELSE
5331: x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99);
5324: --Supports only CYA in this release
5325: x_chrv_rec.CHR_TYPE := 'CYA';
5326: /*--spingali bugfix for bug 12747411 start*/
5327: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (x_chrv_rec.AUTHORING_ORG_ID<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN
5328: x_chrv_rec.AUTHORING_ORG_ID := nvl(x_chrv_rec.AUTHORING_ORG_ID,nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99));
5329: x_chrv_rec.INV_ORGANIZATION_ID := nvl(x_chrv_rec.INV_ORGANIZATION_ID,nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID,-99));
5330: ELSE
5331: x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99);
5332: x_chrv_rec.INV_ORGANIZATION_ID := nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID,-99);
5325: x_chrv_rec.CHR_TYPE := 'CYA';
5326: /*--spingali bugfix for bug 12747411 start*/
5327: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (x_chrv_rec.AUTHORING_ORG_ID<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN
5328: x_chrv_rec.AUTHORING_ORG_ID := nvl(x_chrv_rec.AUTHORING_ORG_ID,nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99));
5329: x_chrv_rec.INV_ORGANIZATION_ID := nvl(x_chrv_rec.INV_ORGANIZATION_ID,nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID,-99));
5330: ELSE
5331: x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99);
5332: x_chrv_rec.INV_ORGANIZATION_ID := nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID,-99);
5333: END IF;
5327: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (x_chrv_rec.AUTHORING_ORG_ID<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN
5328: x_chrv_rec.AUTHORING_ORG_ID := nvl(x_chrv_rec.AUTHORING_ORG_ID,nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99));
5329: x_chrv_rec.INV_ORGANIZATION_ID := nvl(x_chrv_rec.INV_ORGANIZATION_ID,nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID,-99));
5330: ELSE
5331: x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99);
5332: x_chrv_rec.INV_ORGANIZATION_ID := nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID,-99);
5333: END IF;
5334: /*--spingali bugfix for bug 12747411-end*/
5335: ---x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID, - 99);
5328: x_chrv_rec.AUTHORING_ORG_ID := nvl(x_chrv_rec.AUTHORING_ORG_ID,nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99));
5329: x_chrv_rec.INV_ORGANIZATION_ID := nvl(x_chrv_rec.INV_ORGANIZATION_ID,nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID,-99));
5330: ELSE
5331: x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99);
5332: x_chrv_rec.INV_ORGANIZATION_ID := nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID,-99);
5333: END IF;
5334: /*--spingali bugfix for bug 12747411-end*/
5335: ---x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID, - 99);
5336: x_chrv_rec.ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID, - 99); --mmadhavi added for MOAC
5331: x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99);
5332: x_chrv_rec.INV_ORGANIZATION_ID := nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID,-99);
5333: END IF;
5334: /*--spingali bugfix for bug 12747411-end*/
5335: ---x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID, - 99);
5336: x_chrv_rec.ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID, - 99); --mmadhavi added for MOAC
5337: ---x_chrv_rec.INV_ORGANIZATION_ID := nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID, - 99);
5338: /* Bug 3652127 */
5339: -- populate application id
5332: x_chrv_rec.INV_ORGANIZATION_ID := nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID,-99);
5333: END IF;
5334: /*--spingali bugfix for bug 12747411-end*/
5335: ---x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID, - 99);
5336: x_chrv_rec.ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID, - 99); --mmadhavi added for MOAC
5337: ---x_chrv_rec.INV_ORGANIZATION_ID := nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID, - 99);
5338: /* Bug 3652127 */
5339: -- populate application id
5340: OPEN l_app_csr(p_chrv_rec.scs_code);
5333: END IF;
5334: /*--spingali bugfix for bug 12747411-end*/
5335: ---x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID, - 99);
5336: x_chrv_rec.ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID, - 99); --mmadhavi added for MOAC
5337: ---x_chrv_rec.INV_ORGANIZATION_ID := nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_ID, - 99);
5338: /* Bug 3652127 */
5339: -- populate application id
5340: OPEN l_app_csr(p_chrv_rec.scs_code);
5341: FETCH l_app_csr INTO l_application_id;