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_PM_SCHEDULES

Line 10239: AND okcBT.DATES_CHANGED_YN = 'N'; --Added to handle Date Effectivity Fix. Do Bulk copy of oks_pm_schedules only for those lines whose dates

10235: ,OKC_K_LINES_B_TEMP okcBT
10236: WHERE oksPMA.CLE_ID = okcBT.ORIG_SYSTEM_ID1
10237: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID
10238: AND oksPMA.DNZ_CHR_ID = P_From_Chr_ID
10239: AND okcBT.DATES_CHANGED_YN = 'N'; --Added to handle Date Effectivity Fix. Do Bulk copy of oks_pm_schedules only for those lines whose dates
10240: --havent been changed from that on the Source Line
10241:
10242: Begin
10243: x_return_status := l_return_status;

Line 10489: AND okcBT.DATES_CHANGED_YN = 'N' --Added to handle Date Effectivity Fix. Do Bulk copy of oks_pm_schedules only for those lines whose dates

10485: AND oksPMA.DNZ_CHR_ID = okcBT.DNZ_CHR_ID
10486: AND oksPMA.CLE_ID = okcBT.ID
10487: AND oksPMA.DNZ_CHR_ID = P_To_Chr_ID
10488: AND oksPMSL.DNZ_CHR_ID = P_From_Chr_ID
10489: AND okcBT.DATES_CHANGED_YN = 'N' --Added to handle Date Effectivity Fix. Do Bulk copy of oks_pm_schedules only for those lines whose dates
10490: --havent been changed from that on the Source Line
10491: UNION
10492: SELECT
10493: oksPMSL.ID AS oksPMSL_OldID --*

Line 10524: AND okcBT.DATES_CHANGED_YN = 'N'; --Added to handle Date Effectivity Fix. Do Bulk copy of oks_pm_schedules only for those lines whose dates

10520: oksPMSL.CLE_ID = okcBT.ORIG_SYSTEM_ID1
10521: AND oksPMSL.ACTIVITY_LINE_ID IS NULL
10522: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID
10523: AND oksPMSL.DNZ_CHR_ID = P_From_Chr_ID
10524: AND okcBT.DATES_CHANGED_YN = 'N'; --Added to handle Date Effectivity Fix. Do Bulk copy of oks_pm_schedules only for those lines whose dates
10525: --havent been changed from that on the Source Line
10526:
10527: Begin
10528: x_return_status := l_return_status;

Line 10682: -- copy_oks_pm_schedules

10678: End copy_oks_pm_stream_levels;
10679:
10680: -----------------------------------------------------------
10681: --===================================================
10682: -- copy_oks_pm_schedules
10683: -- Parameters: P_From_Chr_ID : Header ID of source contract
10684: -- P_To_Chr_ID : Header ID of target contract
10685: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
10686: -- or as part of component copy from UI (value = 'Y')

Line 10689: PROCEDURE copy_oks_pm_schedules(P_From_Chr_ID IN NUMBER

10685: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
10686: -- or as part of component copy from UI (value = 'Y')
10687: --====================================================
10688:
10689: PROCEDURE copy_oks_pm_schedules(P_From_Chr_ID IN NUMBER
10690: ,P_To_Chr_ID IN NUMBER
10691: ,P_Partial_Copy_YN IN VARCHAR2
10692: ,P_Lines_Count IN NUMBER DEFAULT 0
10693: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 10695: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_PM_SCHEDULES';

10691: ,P_Partial_Copy_YN IN VARCHAR2
10692: ,P_Lines_Count IN NUMBER DEFAULT 0
10693: ,x_return_status OUT NOCOPY VARCHAR2) IS
10694:
10695: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_PM_SCHEDULES';
10696: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
10697: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
10698: CURSOR GetOksPMSCHFull IS
10699: SELECT

Line 10720: OKS_PM_SCHEDULES oksPMSCH

10716: ,oksPMSCH.PROGRAM_ID AS oksPMSCH_PROGRAM_ID
10717: ,oksPMSCH.PROGRAM_UPDATE_DATE AS oksPMSCH_PROGRAM_UPDATE_DATE
10718: ,oksPMSCH.REQUEST_ID AS oksPMSCH_REQUEST_ID
10719: FROM
10720: OKS_PM_SCHEDULES oksPMSCH
10721: ,OKS_PM_STREAM_LEVELS oksPMSL
10722: WHERE
10723: oksPMSCH.STREAM_LINE_ID = oksPMSL.ORIG_SYSTEM_ID1
10724: AND oksPMSL.DNZ_CHR_ID = P_To_Chr_ID

Line 10749: OKS_PM_SCHEDULES oksPMSCH

10745: ,oksPMSCH.PROGRAM_ID AS oksPMSCH_PROGRAM_ID
10746: ,oksPMSCH.PROGRAM_UPDATE_DATE AS oksPMSCH_PROGRAM_UPDATE_DATE
10747: ,oksPMSCH.REQUEST_ID AS oksPMSCH_REQUEST_ID
10748: FROM
10749: OKS_PM_SCHEDULES oksPMSCH
10750: ,OKS_PM_STREAM_LEVELS oksPMSL
10751: ,OKC_K_LINES_B_TEMP okcBT
10752: WHERE
10753: oksPMSCH.STREAM_LINE_ID = oksPMSL.ORIG_SYSTEM_ID1

Line 10758: AND okcBT.DATES_CHANGED_YN = 'N'; --Added to handle Date Effectivity Fix. Do Bulk copy of oks_pm_schedules only for those lines whose dates

10754: AND oksPMSL.DNZ_CHR_ID = okcBT.DNZ_CHR_ID
10755: AND oksPMSL.CLE_ID = okcBT.ID
10756: AND oksPMSL.DNZ_CHR_ID = P_To_Chr_ID
10757: AND oksPMSCH.DNZ_CHR_ID = P_From_Chr_ID
10758: AND okcBT.DATES_CHANGED_YN = 'N'; --Added to handle Date Effectivity Fix. Do Bulk copy of oks_pm_schedules only for those lines whose dates
10759: --havent been changed from that on the Source Line
10760:
10761: Begin
10762: x_return_status := l_return_status;

Line 10818: INSERT INTO OKS_PM_SCHEDULES(

10814:
10815: End If;
10816:
10817: FORALL i IN OksPMSCHRecTab.OksPMSCH_NewID.FIRST .. OksPMSCHRecTab.OksPMSCH_NewID.LAST
10818: INSERT INTO OKS_PM_SCHEDULES(
10819: ID
10820: ,RULE_ID
10821: ,OBJECT_VERSION_NUMBER
10822: ,DNZ_CHR_ID

Line 10893: End copy_oks_pm_schedules;

10889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10890: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
10891: RAISE;
10892:
10893: End copy_oks_pm_schedules;
10894:
10895: -----------------------------------------------------------
10896: --==============================================================
10897: --Procedure copy_pm_for_SkippedLines: Used to create PM Stream levels and PM Schedules for those lines

Line 19857: -------------Copy of OKS_PM_SCHEDULES----------------------------------

19853: RAISE G_EXCEPTION_HALT_VALIDATION;
19854: End If;
19855: End;
19856: ---------------------------------------------------------------------
19857: -------------Copy of OKS_PM_SCHEDULES----------------------------------
19858: Begin
19859: copy_oks_pm_schedules(P_From_Chr_ID => P_From_Chr_ID
19860: ,P_To_Chr_ID => P_To_Chr_ID
19861: ,P_Partial_Copy_YN => 'N'

Line 19859: copy_oks_pm_schedules(P_From_Chr_ID => P_From_Chr_ID

19855: End;
19856: ---------------------------------------------------------------------
19857: -------------Copy of OKS_PM_SCHEDULES----------------------------------
19858: Begin
19859: copy_oks_pm_schedules(P_From_Chr_ID => P_From_Chr_ID
19860: ,P_To_Chr_ID => P_To_Chr_ID
19861: ,P_Partial_Copy_YN => 'N'
19862: ,x_return_status => l_return_status);
19863:

Line 25212: -------------Copy of OKS_PM_SCHEDULES--------------------------------

25208: End If;
25209: End;
25210:
25211: ---------------------------------------------------------------------
25212: -------------Copy of OKS_PM_SCHEDULES--------------------------------
25213: Begin
25214: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25215: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25216: FND_LOG.string(FND_LOG.level_statement

Line 25217: ,l_module_name||'.copy_oks_pm_schedules'

25213: Begin
25214: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25215: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25216: FND_LOG.string(FND_LOG.level_statement
25217: ,l_module_name||'.copy_oks_pm_schedules'
25218: ,'Before call to copy_oks_pm_schedules'
25219: );
25220: END IF;
25221: END IF;

Line 25218: ,'Before call to copy_oks_pm_schedules'

25214: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25215: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25216: FND_LOG.string(FND_LOG.level_statement
25217: ,l_module_name||'.copy_oks_pm_schedules'
25218: ,'Before call to copy_oks_pm_schedules'
25219: );
25220: END IF;
25221: END IF;
25222:

Line 25223: copy_oks_pm_schedules(P_From_Chr_ID => P_From_Chr_ID

25219: );
25220: END IF;
25221: END IF;
25222:
25223: copy_oks_pm_schedules(P_From_Chr_ID => P_From_Chr_ID
25224: ,P_To_Chr_ID => P_To_Chr_ID
25225: ,P_Partial_Copy_YN => 'Y'
25226: ,P_Lines_Count => P_Lines_Tbl.COUNT
25227: ,x_return_status => l_return_status);

Line 25232: ,l_module_name||'.copy_oks_pm_schedules'

25228:
25229: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25230: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25231: FND_LOG.string(FND_LOG.level_statement
25232: ,l_module_name||'.copy_oks_pm_schedules'
25233: ,'After call to copy_oks_pm_schedules: x_return_status:'||l_return_status
25234: ||' '||SQLERRM
25235: );
25236: END IF;

Line 25233: ,'After call to copy_oks_pm_schedules: x_return_status:'||l_return_status

25229: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25230: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25231: FND_LOG.string(FND_LOG.level_statement
25232: ,l_module_name||'.copy_oks_pm_schedules'
25233: ,'After call to copy_oks_pm_schedules: x_return_status:'||l_return_status
25234: ||' '||SQLERRM
25235: );
25236: END IF;
25237: END IF;