eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_REV_DISTRIBUTIONS

Line 9262: -- copy_oks_rev_distributions

9258:
9259: END copy_oks_k_lines_tl;
9260:
9261: --===================================================
9262: -- copy_oks_rev_distributions
9263: -- Parameters: P_From_Chr_ID : Header ID of source contract
9264: -- P_To_Chr_ID : Header ID of target contract
9265: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9266: -- or as part of component copy from UI (value = 'Y')

Line 9268: PROCEDURE copy_oks_rev_distributions(P_From_Chr_ID IN NUMBER

9264: -- P_To_Chr_ID : Header ID of target contract
9265: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9266: -- or as part of component copy from UI (value = 'Y')
9267: --====================================================
9268: PROCEDURE copy_oks_rev_distributions(P_From_Chr_ID IN NUMBER
9269: ,P_To_Chr_ID IN NUMBER
9270: ,P_Partial_Copy_YN IN VARCHAR2
9271: ,P_Lines_Count IN NUMBER DEFAULT 0
9272: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 9274: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_REV_DISTRIBUTIONS';

9270: ,P_Partial_Copy_YN IN VARCHAR2
9271: ,P_Lines_Count IN NUMBER DEFAULT 0
9272: ,x_return_status OUT NOCOPY VARCHAR2) IS
9273:
9274: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_REV_DISTRIBUTIONS';
9275: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
9276: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
9277:
9278: CURSOR GetOksRDFull IS

Line 9290: OKS_REV_DISTRIBUTIONS oksRD

9286: , oksRD.PERCENT AS OksRD_PERCENT
9287: , 1 AS OksRD_OBJECT_VERSION_NUMBER
9288: , oksRD.SECURITY_GROUP_ID AS OksRD_SECURITY_GROUP_ID
9289: FROM
9290: OKS_REV_DISTRIBUTIONS oksRD
9291: ,OKC_K_LINES_B okcB
9292: WHERE oksRD.CLE_ID = okcB.ORIG_SYSTEM_ID1
9293: AND okcB.DNZ_CHR_ID = P_To_Chr_ID;
9294:

Line 9307: OKS_REV_DISTRIBUTIONS oksRD

9303: , oksRD.PERCENT AS OksRD_PERCENT
9304: , 1 AS OksRD_OBJECT_VERSION_NUMBER
9305: , oksRD.SECURITY_GROUP_ID AS OksRD_SECURITY_GROUP_ID
9306: FROM
9307: OKS_REV_DISTRIBUTIONS oksRD
9308: ,OKC_K_LINES_B_TEMP okcBT
9309: WHERE oksRD.CLE_ID = okcBT.ORIG_SYSTEM_ID1
9310: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID;
9311:

Line 9349: INSERT INTO OKS_REV_DISTRIBUTIONS

9345:
9346: End If;
9347:
9348: FORALL i IN OksRDRecTab.OksRD_NewID.FIRST .. OksRDRecTab.OksRD_NewID.LAST
9349: INSERT INTO OKS_REV_DISTRIBUTIONS
9350: (ID
9351: , CHR_ID
9352: , CLE_ID
9353: , ACCOUNT_CLASS

Line 9405: End copy_oks_rev_distributions;

9401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9402: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
9403: RAISE;
9404:
9405: End copy_oks_rev_distributions;
9406:
9407: --===================================================
9408: -- copy_oks_qualifiers
9409: -- Parameters: P_From_Chr_ID : Header ID of source contract

Line 19514: ------------Copy of OKS_REV_DISTRIBUTIONS--------------------------

19510: RAISE G_EXCEPTION_HALT_VALIDATION;
19511: End If;
19512: End;
19513: ---------------------------------------------------------------------
19514: ------------Copy of OKS_REV_DISTRIBUTIONS--------------------------
19515: Begin
19516: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19517: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19518: FND_LOG.string(FND_LOG.level_statement

Line 19519: ,l_module_name||'.copy_oks_rev_distributions'

19515: Begin
19516: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19517: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19518: FND_LOG.string(FND_LOG.level_statement
19519: ,l_module_name||'.copy_oks_rev_distributions'
19520: ,'Before call to copy_oks_rev_distributions'
19521: );
19522: END IF;
19523: END IF;

Line 19520: ,'Before call to copy_oks_rev_distributions'

19516: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19517: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19518: FND_LOG.string(FND_LOG.level_statement
19519: ,l_module_name||'.copy_oks_rev_distributions'
19520: ,'Before call to copy_oks_rev_distributions'
19521: );
19522: END IF;
19523: END IF;
19524:

Line 19525: copy_oks_rev_distributions(P_From_Chr_ID => P_From_Chr_ID

19521: );
19522: END IF;
19523: END IF;
19524:
19525: copy_oks_rev_distributions(P_From_Chr_ID => P_From_Chr_ID
19526: ,P_To_Chr_ID => P_To_Chr_ID
19527: ,P_Partial_Copy_YN => 'N'
19528: ,x_return_status => l_return_status);
19529:

Line 19533: ,l_module_name||'.copy_oks_rev_distributions'

19529:
19530: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19531: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19532: FND_LOG.string(FND_LOG.level_statement
19533: ,l_module_name||'.copy_oks_rev_distributions'
19534: ,'After call to copy_oks_rev_distributions: x_return_status:'||l_return_status
19535: ||' '||SQLERRM
19536: );
19537: END IF;

Line 19534: ,'After call to copy_oks_rev_distributions: x_return_status:'||l_return_status

19530: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19531: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19532: FND_LOG.string(FND_LOG.level_statement
19533: ,l_module_name||'.copy_oks_rev_distributions'
19534: ,'After call to copy_oks_rev_distributions: x_return_status:'||l_return_status
19535: ||' '||SQLERRM
19536: );
19537: END IF;
19538: END IF;

Line 24846: ------------Copy of OKS_REV_DISTRIBUTIONS--------------------------

24842: End If;
24843: End;
24844: END IF;
24845: ---------------------------------------------------------------------
24846: ------------Copy of OKS_REV_DISTRIBUTIONS--------------------------
24847: IF (P_Lines_Tbl.COUNT > 0) then
24848: Begin
24849: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24850: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN

Line 24852: ,l_module_name||'.copy_oks_rev_distributions'

24848: Begin
24849: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24850: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24851: FND_LOG.string(FND_LOG.level_statement
24852: ,l_module_name||'.copy_oks_rev_distributions'
24853: ,'Before call to copy_oks_rev_distributions'
24854: );
24855: END IF;
24856: END IF;

Line 24853: ,'Before call to copy_oks_rev_distributions'

24849: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24850: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24851: FND_LOG.string(FND_LOG.level_statement
24852: ,l_module_name||'.copy_oks_rev_distributions'
24853: ,'Before call to copy_oks_rev_distributions'
24854: );
24855: END IF;
24856: END IF;
24857:

Line 24858: copy_oks_rev_distributions(P_From_Chr_ID => P_From_Chr_ID

24854: );
24855: END IF;
24856: END IF;
24857:
24858: copy_oks_rev_distributions(P_From_Chr_ID => P_From_Chr_ID
24859: ,P_To_Chr_ID => P_To_Chr_ID
24860: ,P_Partial_Copy_YN => 'Y'
24861: ,P_Lines_Count => P_Lines_Tbl.COUNT
24862: ,x_return_status => l_return_status);

Line 24867: ,l_module_name||'.copy_oks_rev_distributions'

24863:
24864: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24865: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24866: FND_LOG.string(FND_LOG.level_statement
24867: ,l_module_name||'.copy_oks_rev_distributions'
24868: ,'After call to copy_oks_rev_distributions: x_return_status:'||l_return_status
24869: ||' '||SQLERRM
24870: );
24871: END IF;

Line 24868: ,'After call to copy_oks_rev_distributions: x_return_status:'||l_return_status

24864: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24865: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24866: FND_LOG.string(FND_LOG.level_statement
24867: ,l_module_name||'.copy_oks_rev_distributions'
24868: ,'After call to copy_oks_rev_distributions: x_return_status:'||l_return_status
24869: ||' '||SQLERRM
24870: );
24871: END IF;
24872: END IF;