DBA Data[Home] [Help]

APPS.OKC_CHR_PVT dependencies on OKC_CONTEXT

Line 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

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);

Line 5328: x_chrv_rec.AUTHORING_ORG_ID := nvl(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);

Line 5329: x_chrv_rec.INV_ORGANIZATION_ID := nvl(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;

Line 5331: x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99);

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);

Line 5332: x_chrv_rec.INV_ORGANIZATION_ID := nvl(OKC_CONTEXT.GET_OKC_ORGANIZATION_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

Line 5335: ---x_chrv_rec.AUTHORING_ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID, - 99);

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

Line 5336: x_chrv_rec.ORG_ID := nvl(OKC_CONTEXT.GET_OKC_ORG_ID, - 99); --mmadhavi added for MOAC

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);

Line 5337: ---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);
5341: FETCH l_app_csr INTO l_application_id;