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 10284: 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

10280: ,OKC_K_LINES_B_TEMP okcBT
10281: WHERE oksPMA.CLE_ID = okcBT.ORIG_SYSTEM_ID1
10282: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID
10283: AND oksPMA.DNZ_CHR_ID = P_From_Chr_ID
10284: 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
10285: --havent been changed from that on the Source Line
10286:
10287: Begin
10288: x_return_status := l_return_status;

Line 10534: 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

10530: AND oksPMA.DNZ_CHR_ID = okcBT.DNZ_CHR_ID
10531: AND oksPMA.CLE_ID = okcBT.ID
10532: AND oksPMA.DNZ_CHR_ID = P_To_Chr_ID
10533: AND oksPMSL.DNZ_CHR_ID = P_From_Chr_ID
10534: 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
10535: --havent been changed from that on the Source Line
10536: UNION
10537: SELECT
10538: oksPMSL.ID AS oksPMSL_OldID --*

Line 10569: 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

10565: oksPMSL.CLE_ID = okcBT.ORIG_SYSTEM_ID1
10566: AND oksPMSL.ACTIVITY_LINE_ID IS NULL
10567: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID
10568: AND oksPMSL.DNZ_CHR_ID = P_From_Chr_ID
10569: 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
10570: --havent been changed from that on the Source Line
10571:
10572: Begin
10573: x_return_status := l_return_status;

Line 10727: -- copy_oks_pm_schedules

10723: End copy_oks_pm_stream_levels;
10724:
10725: -----------------------------------------------------------
10726: --===================================================
10727: -- copy_oks_pm_schedules
10728: -- Parameters: P_From_Chr_ID : Header ID of source contract
10729: -- P_To_Chr_ID : Header ID of target contract
10730: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
10731: -- or as part of component copy from UI (value = 'Y')

Line 10734: PROCEDURE copy_oks_pm_schedules(P_From_Chr_ID IN NUMBER

10730: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
10731: -- or as part of component copy from UI (value = 'Y')
10732: --====================================================
10733:
10734: PROCEDURE copy_oks_pm_schedules(P_From_Chr_ID IN NUMBER
10735: ,P_To_Chr_ID IN NUMBER
10736: ,P_Partial_Copy_YN IN VARCHAR2
10737: ,P_Lines_Count IN NUMBER DEFAULT 0
10738: ,x_return_status OUT NOCOPY VARCHAR2) IS

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

10736: ,P_Partial_Copy_YN IN VARCHAR2
10737: ,P_Lines_Count IN NUMBER DEFAULT 0
10738: ,x_return_status OUT NOCOPY VARCHAR2) IS
10739:
10740: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_PM_SCHEDULES';
10741: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
10742: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
10743: CURSOR GetOksPMSCHFull IS
10744: SELECT

Line 10765: OKS_PM_SCHEDULES oksPMSCH

10761: ,oksPMSCH.PROGRAM_ID AS oksPMSCH_PROGRAM_ID
10762: ,oksPMSCH.PROGRAM_UPDATE_DATE AS oksPMSCH_PROGRAM_UPDATE_DATE
10763: ,oksPMSCH.REQUEST_ID AS oksPMSCH_REQUEST_ID
10764: FROM
10765: OKS_PM_SCHEDULES oksPMSCH
10766: ,OKS_PM_STREAM_LEVELS oksPMSL
10767: WHERE
10768: oksPMSCH.STREAM_LINE_ID = oksPMSL.ORIG_SYSTEM_ID1
10769: AND oksPMSL.DNZ_CHR_ID = P_To_Chr_ID

Line 10794: OKS_PM_SCHEDULES oksPMSCH

10790: ,oksPMSCH.PROGRAM_ID AS oksPMSCH_PROGRAM_ID
10791: ,oksPMSCH.PROGRAM_UPDATE_DATE AS oksPMSCH_PROGRAM_UPDATE_DATE
10792: ,oksPMSCH.REQUEST_ID AS oksPMSCH_REQUEST_ID
10793: FROM
10794: OKS_PM_SCHEDULES oksPMSCH
10795: ,OKS_PM_STREAM_LEVELS oksPMSL
10796: ,OKC_K_LINES_B_TEMP okcBT
10797: WHERE
10798: oksPMSCH.STREAM_LINE_ID = oksPMSL.ORIG_SYSTEM_ID1

Line 10803: 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

10799: AND oksPMSL.DNZ_CHR_ID = okcBT.DNZ_CHR_ID
10800: AND oksPMSL.CLE_ID = okcBT.ID
10801: AND oksPMSL.DNZ_CHR_ID = P_To_Chr_ID
10802: AND oksPMSCH.DNZ_CHR_ID = P_From_Chr_ID
10803: 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
10804: --havent been changed from that on the Source Line
10805:
10806: Begin
10807: x_return_status := l_return_status;

Line 10863: INSERT INTO OKS_PM_SCHEDULES(

10859:
10860: End If;
10861:
10862: FORALL i IN OksPMSCHRecTab.OksPMSCH_NewID.FIRST .. OksPMSCHRecTab.OksPMSCH_NewID.LAST
10863: INSERT INTO OKS_PM_SCHEDULES(
10864: ID
10865: ,RULE_ID
10866: ,OBJECT_VERSION_NUMBER
10867: ,DNZ_CHR_ID

Line 10938: End copy_oks_pm_schedules;

10934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10935: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
10936: RAISE;
10937:
10938: End copy_oks_pm_schedules;
10939:
10940: -----------------------------------------------------------
10941: --==============================================================
10942: --Procedure copy_pm_for_SkippedLines: Used to create PM Stream levels and PM Schedules for those lines

Line 20004: -------------Copy of OKS_PM_SCHEDULES----------------------------------

20000: RAISE G_EXCEPTION_HALT_VALIDATION;
20001: End If;
20002: End;
20003: ---------------------------------------------------------------------
20004: -------------Copy of OKS_PM_SCHEDULES----------------------------------
20005: Begin
20006: copy_oks_pm_schedules(P_From_Chr_ID => P_From_Chr_ID
20007: ,P_To_Chr_ID => P_To_Chr_ID
20008: ,P_Partial_Copy_YN => 'N'

Line 20006: copy_oks_pm_schedules(P_From_Chr_ID => P_From_Chr_ID

20002: End;
20003: ---------------------------------------------------------------------
20004: -------------Copy of OKS_PM_SCHEDULES----------------------------------
20005: Begin
20006: copy_oks_pm_schedules(P_From_Chr_ID => P_From_Chr_ID
20007: ,P_To_Chr_ID => P_To_Chr_ID
20008: ,P_Partial_Copy_YN => 'N'
20009: ,x_return_status => l_return_status);
20010:

Line 25407: -------------Copy of OKS_PM_SCHEDULES--------------------------------

25403: End If;
25404: End;
25405:
25406: ---------------------------------------------------------------------
25407: -------------Copy of OKS_PM_SCHEDULES--------------------------------
25408: Begin
25409: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25410: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25411: FND_LOG.string(FND_LOG.level_statement

Line 25412: ,l_module_name||'.copy_oks_pm_schedules'

25408: Begin
25409: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25410: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25411: FND_LOG.string(FND_LOG.level_statement
25412: ,l_module_name||'.copy_oks_pm_schedules'
25413: ,'Before call to copy_oks_pm_schedules'
25414: );
25415: END IF;
25416: END IF;

Line 25413: ,'Before call to copy_oks_pm_schedules'

25409: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25410: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25411: FND_LOG.string(FND_LOG.level_statement
25412: ,l_module_name||'.copy_oks_pm_schedules'
25413: ,'Before call to copy_oks_pm_schedules'
25414: );
25415: END IF;
25416: END IF;
25417:

Line 25418: copy_oks_pm_schedules(P_From_Chr_ID => P_From_Chr_ID

25414: );
25415: END IF;
25416: END IF;
25417:
25418: copy_oks_pm_schedules(P_From_Chr_ID => P_From_Chr_ID
25419: ,P_To_Chr_ID => P_To_Chr_ID
25420: ,P_Partial_Copy_YN => 'Y'
25421: ,P_Lines_Count => P_Lines_Tbl.COUNT
25422: ,x_return_status => l_return_status);

Line 25427: ,l_module_name||'.copy_oks_pm_schedules'

25423:
25424: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25425: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25426: FND_LOG.string(FND_LOG.level_statement
25427: ,l_module_name||'.copy_oks_pm_schedules'
25428: ,'After call to copy_oks_pm_schedules: x_return_status:'||l_return_status
25429: ||' '||SQLERRM
25430: );
25431: END IF;

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

25424: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25425: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25426: FND_LOG.string(FND_LOG.level_statement
25427: ,l_module_name||'.copy_oks_pm_schedules'
25428: ,'After call to copy_oks_pm_schedules: x_return_status:'||l_return_status
25429: ||' '||SQLERRM
25430: );
25431: END IF;
25432: END IF;