DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_PM_ACTIVITIES

Line 10216: -- copy_oks_pm_activities

10212: End copy_oks_coverage_times;
10213:
10214: -----------------------------------------------------------
10215: --===================================================
10216: -- copy_oks_pm_activities
10217: -- Parameters: P_From_Chr_ID : Header ID of source contract
10218: -- P_To_Chr_ID : Header ID of target contract
10219: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
10220: -- or as part of component copy from UI (value = 'Y')

Line 10223: PROCEDURE copy_oks_pm_activities(P_From_Chr_ID IN NUMBER

10219: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
10220: -- or as part of component copy from UI (value = 'Y')
10221: --====================================================
10222:
10223: PROCEDURE copy_oks_pm_activities(P_From_Chr_ID IN NUMBER
10224: ,P_To_Chr_ID IN NUMBER
10225: ,P_Partial_Copy_YN IN VARCHAR2
10226: ,P_Lines_Count IN NUMBER DEFAULT 0
10227: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 10229: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_PM_ACTIVITIES';

10225: ,P_Partial_Copy_YN IN VARCHAR2
10226: ,P_Lines_Count IN NUMBER DEFAULT 0
10227: ,x_return_status OUT NOCOPY VARCHAR2) IS
10228:
10229: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_PM_ACTIVITIES';
10230: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
10231: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
10232:
10233: CURSOR GetOksPMAFull IS

Line 10253: OKS_PM_ACTIVITIES oksPMA

10249: ,oksPMA.ID AS oksPMA_ORIG_SYSTEM_ID1 --*
10250: ,NULL AS oksPMA_ORIG_SYSTEM_SOURCE_CODE --*
10251: ,'COPY' AS oksPMA_ORIG_SYSTEM_REFERENCE1 --*
10252: FROM
10253: OKS_PM_ACTIVITIES oksPMA
10254: ,OKC_K_LINES_B okcB
10255: WHERE oksPMA.CLE_ID = okcB.ORIG_SYSTEM_ID1
10256: AND okcB.DNZ_CHR_ID = P_To_Chr_ID
10257: AND oksPMA.DNZ_CHR_ID = P_From_Chr_ID;

Line 10279: OKS_PM_ACTIVITIES oksPMA

10275: ,oksPMA.ID AS oksPMA_ORIG_SYSTEM_ID1 --*
10276: ,NULL AS oksPMA_ORIG_SYSTEM_SOURCE_CODE --*
10277: ,'COPY' AS oksPMA_ORIG_SYSTEM_REFERENCE1 --*
10278: FROM
10279: OKS_PM_ACTIVITIES oksPMA
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

Line 10340: INSERT INTO OKS_PM_ACTIVITIES(

10336: LIMIT G_BULK_FETCH_LIMIT;
10337:
10338: End If;
10339: FORALL i IN OksPMARecTab.OksPMA_NewID.FIRST .. OksPMARecTab.OksPMA_NewID.LAST
10340: INSERT INTO OKS_PM_ACTIVITIES(
10341: ID
10342: ,CLE_ID
10343: ,DNZ_CHR_ID
10344: ,ACTIVITY_ID

Line 10413: End copy_oks_pm_activities;

10409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10410: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
10411: RAISE;
10412:
10413: End copy_oks_pm_activities;
10414:
10415: -----------------------------------------------------------
10416: --===================================================
10417: -- copy_oks_pm_stream_levels

Line 10460: ,OKS_PM_ACTIVITIES oksPMA

10456: ,NULL AS oksPMSL_ORIG_SYS_SOURCE_CODE --*
10457: ,'COPY' AS oksPMSL_ORIG_SYS_REFERENCE1 --*
10458: FROM
10459: OKS_PM_STREAM_LEVELS oksPMSL
10460: ,OKS_PM_ACTIVITIES oksPMA
10461: WHERE
10462: oksPMSL.ACTIVITY_LINE_ID = oksPMA.ORIG_SYSTEM_ID1
10463: AND oksPMA.DNZ_CHR_ID = P_To_Chr_ID
10464: AND oksPMSL.DNZ_CHR_ID = P_From_Chr_ID

Line 10526: ,OKS_PM_ACTIVITIES oksPMA

10522: ,NULL AS oksPMSL_ORIG_SYS_SOURCE_CODE --*
10523: ,'COPY' AS oksPMSL_ORIG_SYS_REFERENCE1 --*
10524: FROM
10525: OKS_PM_STREAM_LEVELS oksPMSL
10526: ,OKS_PM_ACTIVITIES oksPMA
10527: ,OKC_K_LINES_B_TEMP okcBT
10528: WHERE
10529: oksPMSL.ACTIVITY_LINE_ID = oksPMA.ORIG_SYSTEM_ID1
10530: AND oksPMA.DNZ_CHR_ID = okcBT.DNZ_CHR_ID

Line 19980: -------------Copy of OKS_PM_ACTIVITIES-----------------------------

19976:
19977:
19978: --=======================Start of PM Schedule Copy for Line=====================
19979:
19980: -------------Copy of OKS_PM_ACTIVITIES-----------------------------
19981: Begin
19982: copy_oks_pm_activities(P_From_Chr_ID => P_From_Chr_ID
19983: ,P_To_Chr_ID => P_To_Chr_ID
19984: ,P_Partial_Copy_YN => 'N'

Line 19982: copy_oks_pm_activities(P_From_Chr_ID => P_From_Chr_ID

19978: --=======================Start of PM Schedule Copy for Line=====================
19979:
19980: -------------Copy of OKS_PM_ACTIVITIES-----------------------------
19981: Begin
19982: copy_oks_pm_activities(P_From_Chr_ID => P_From_Chr_ID
19983: ,P_To_Chr_ID => P_To_Chr_ID
19984: ,P_Partial_Copy_YN => 'N'
19985: ,x_return_status => l_return_status);
19986:

Line 25342: -------------Copy of OKS_PM_ACTIVITIES-------------------------------

25338:
25339: --=======================Start of PM Schedule Copy for Line=====================
25340:
25341: IF (P_Lines_Tbl.COUNT > 0) then
25342: -------------Copy of OKS_PM_ACTIVITIES-------------------------------
25343: Begin
25344: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25345: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25346: FND_LOG.string(FND_LOG.level_statement

Line 25347: ,l_module_name||'.copy_oks_pm_activities'

25343: Begin
25344: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25345: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25346: FND_LOG.string(FND_LOG.level_statement
25347: ,l_module_name||'.copy_oks_pm_activities'
25348: ,'Before call to copy_oks_pm_activities'
25349: );
25350: END IF;
25351: END IF;

Line 25348: ,'Before call to copy_oks_pm_activities'

25344: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25345: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25346: FND_LOG.string(FND_LOG.level_statement
25347: ,l_module_name||'.copy_oks_pm_activities'
25348: ,'Before call to copy_oks_pm_activities'
25349: );
25350: END IF;
25351: END IF;
25352:

Line 25353: copy_oks_pm_activities(P_From_Chr_ID => P_From_Chr_ID

25349: );
25350: END IF;
25351: END IF;
25352:
25353: copy_oks_pm_activities(P_From_Chr_ID => P_From_Chr_ID
25354: ,P_To_Chr_ID => P_To_Chr_ID
25355: ,P_Partial_Copy_YN => 'Y'
25356: ,P_Lines_Count => P_Lines_Tbl.COUNT
25357: ,x_return_status => l_return_status);

Line 25362: ,l_module_name||'.copy_oks_pm_activities'

25358:
25359: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25360: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25361: FND_LOG.string(FND_LOG.level_statement
25362: ,l_module_name||'.copy_oks_pm_activities'
25363: ,'After call to copy_oks_pm_activities: x_return_status:'||l_return_status
25364: ||' '||SQLERRM
25365: );
25366: END IF;

Line 25363: ,'After call to copy_oks_pm_activities: x_return_status:'||l_return_status

25359: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25360: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25361: FND_LOG.string(FND_LOG.level_statement
25362: ,l_module_name||'.copy_oks_pm_activities'
25363: ,'After call to copy_oks_pm_activities: x_return_status:'||l_return_status
25364: ||' '||SQLERRM
25365: );
25366: END IF;
25367: END IF;