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_LEVEL_ELEMENTS

Line 12711: -- copy_oks_level_elements

12707: End copy_oks_stream_levels_b;
12708:
12709: ------------------------------------------------
12710: --===================================================
12711: -- copy_oks_level_elements
12712: -- Parameters: P_From_Chr_ID : Header ID of source contract
12713: -- P_To_Chr_ID : Header ID of target contract
12714: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
12715: -- or as part of component copy from UI (value = 'Y')

Line 12732: PROCEDURE copy_oks_level_elements(P_From_Chr_ID IN NUMBER

12728: -- End If
12729:
12730: --====================================================
12731:
12732: PROCEDURE copy_oks_level_elements(P_From_Chr_ID IN NUMBER
12733: ,P_To_Chr_ID IN NUMBER
12734: ,P_Partial_Copy_YN IN VARCHAR2
12735: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
12736: ,P_Lines_Count IN NUMBER DEFAULT 0

Line 12739: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_LEVEL_ELEMENTS';

12735: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
12736: ,P_Lines_Count IN NUMBER DEFAULT 0
12737: ,x_return_status OUT NOCOPY VARCHAR2) IS
12738:
12739: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_LEVEL_ELEMENTS';
12740: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
12741: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12742:
12743: /******

Line 12771: OKS_LEVEL_ELEMENTS oksLE

12767: a.ID = oksSL.CLE_ID
12768: and a.DNZ_CHR_ID = P_To_Chr_ID )) AS oksLE_NewParentCleID --*
12769: ,oksLE.DATE_END AS oksLE_DATE_END
12770: FROM
12771: OKS_LEVEL_ELEMENTS oksLE
12772: ,OKS_STREAM_LEVELS_B oksSL
12773: WHERE
12774: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
12775: AND oksSL.DNZ_CHR_ID = P_To_Chr_ID

Line 12801: OKS_LEVEL_ELEMENTS oksLE

12797: ,oksSL.DNZ_CHR_ID AS oksLE_NewDnzChrID --*
12798: ,NULL AS oksLE_NewParentCleID --*
12799: ,oksLE.DATE_END AS oksLE_DATE_END
12800: FROM
12801: OKS_LEVEL_ELEMENTS oksLE
12802: ,OKS_STREAM_LEVELS_B oksSL
12803: WHERE
12804: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
12805: AND oksSL.CHR_ID IS NOT NULL

Line 12831: OKS_LEVEL_ELEMENTS oksLE

12827: ,oksSL.DNZ_CHR_ID AS oksLE_NewDnzChrID --*
12828: ,decode(okcBTarget.CLE_ID,NULL,okcBTarget.ID,okcBTarget.CLE_ID) AS NewParentCleID
12829: ,oksLE.DATE_END AS oksLE_DATE_END
12830: FROM
12831: OKS_LEVEL_ELEMENTS oksLE
12832: ,OKS_STREAM_LEVELS_B oksSL
12833: ,OKC_K_LINES_B okcBTarget
12834: ,OKC_K_LINES_B okcBSource
12835: WHERE

Line 12910: OKS_LEVEL_ELEMENTS oksLE

12906: ,oksSL.DNZ_CHR_ID AS oksLE_NewDnzChrID --*
12907: ,NULL AS oksLE_NewParentCleID --*
12908: ,oksLE.DATE_END AS oksLE_DATE_END
12909: FROM
12910: OKS_LEVEL_ELEMENTS oksLE
12911: ,OKS_STREAM_LEVELS_B oksSL
12912: WHERE
12913: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
12914: AND oksSL.CHR_ID IS NOT NULL

Line 12941: OKS_LEVEL_ELEMENTS oksLE

12937: ,oksSL.DNZ_CHR_ID AS oksLE_NewDnzChrID --*
12938: ,decode(okcBT.CLE_ID,NULL,okcBT.ID,okcBT.CLE_ID) AS NewParentCleID
12939: ,oksLE.DATE_END AS oksLE_DATE_END
12940: FROM
12941: OKS_LEVEL_ELEMENTS oksLE
12942: ,OKS_STREAM_LEVELS_B oksSL
12943: ,OKC_K_LINES_B_TEMP okcBT
12944: WHERE
12945: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1

Line 13042: OKS_LEVEL_ELEMENTS oksLE

13038: ,oksSL.DNZ_CHR_ID AS oksLE_NewDnzChrID --*
13039: ,NULL AS NewParentCleID --*
13040: ,oksLE.DATE_END AS oksLE_DATE_END
13041: FROM
13042: OKS_LEVEL_ELEMENTS oksLE
13043: ,OKS_STREAM_LEVELS_B oksSL
13044: WHERE
13045: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
13046: AND oksSL.CHR_ID IS NOT NULL

Line 13072: OKS_LEVEL_ELEMENTS oksLE

13068: ,oksSL.DNZ_CHR_ID AS oksLE_NewDnzChrID --*
13069: ,decode(okcBT.CLE_ID,NULL,okcBT.ID,okcBT.CLE_ID) AS NewParentCleID
13070: ,oksLE.DATE_END AS oksLE_DATE_END
13071: FROM
13072: OKS_LEVEL_ELEMENTS oksLE
13073: ,OKS_STREAM_LEVELS_B oksSL
13074: ,OKC_K_LINES_B_TEMP okcBT
13075: WHERE
13076: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1

Line 13294: INSERT INTO OKS_LEVEL_ELEMENTS(

13290:
13291: --errorout_hk('GetOksLEPartial_L count -'||OksLERecTab.OksLE_NewID.count);
13292:
13293: FORALL i IN OksLERecTab.OksLE_NewID.FIRST .. OksLERecTab.OksLE_NewID.LAST
13294: INSERT INTO OKS_LEVEL_ELEMENTS(
13295: ID
13296: ,SEQUENCE_NUMBER
13297: ,DATE_START
13298: ,AMOUNT

Line 13386: End copy_oks_level_elements;

13382: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
13383: RAISE;
13384:
13385:
13386: End copy_oks_level_elements;
13387:
13388:
13389: --==============================================================
13390: --Procedure update_line_inv_and_acct_rule: This procedure will be called just before Billing Schedule copy

Line 14227: -- COPY_OKS_STREAM_LEVELS and COPY_OKS_LEVEL_ELEMENTS routines.

14223: -- a) Using the streams of corresponding target top lines
14224: --
14225: --Note: If the Partial Period Setup had existed on the Source Contract or if the Partial Period Setup was NULL on Both Source Contract
14226: -- and in GCD, the Billing Schedules for Target Header and Lines would have been bulk copied using
14227: -- COPY_OKS_STREAM_LEVELS and COPY_OKS_LEVEL_ELEMENTS routines.
14228: --------------------------------------------------------------------*/
14229: Procedure create_bsch_using_PPSetup(P_To_Chr_ID IN NUMBER
14230: ,P_From_Chr_ID IN NUMBER
14231: ,P_Partial_Copy_YN IN VARCHAR2

Line 19840: -------------Copy of OKS_LEVEL_ELEMENTS---------------------------

19836: RAISE G_EXCEPTION_HALT_VALIDATION;
19837: End If;
19838: End;
19839: -------------------------------------------------------------------
19840: -------------Copy of OKS_LEVEL_ELEMENTS---------------------------
19841: Begin
19842: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19843: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19844: FND_LOG.string(FND_LOG.level_statement

Line 19845: ,l_module_name||'.copy_oks_level_elements'

19841: Begin
19842: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19843: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19844: FND_LOG.string(FND_LOG.level_statement
19845: ,l_module_name||'.copy_oks_level_elements'
19846: ,'Before call to copy_oks_level_elements'
19847: );
19848: END IF;
19849: END IF;

Line 19846: ,'Before call to copy_oks_level_elements'

19842: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19843: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19844: FND_LOG.string(FND_LOG.level_statement
19845: ,l_module_name||'.copy_oks_level_elements'
19846: ,'Before call to copy_oks_level_elements'
19847: );
19848: END IF;
19849: END IF;
19850:

Line 19851: copy_oks_level_elements(P_From_Chr_ID => P_From_Chr_ID

19847: );
19848: END IF;
19849: END IF;
19850:
19851: copy_oks_level_elements(P_From_Chr_ID => P_From_Chr_ID
19852: ,P_To_Chr_ID => P_To_Chr_ID
19853: ,P_Partial_Copy_YN => 'N'
19854: ,x_return_status => l_return_status);
19855:

Line 19859: ,l_module_name||'.copy_oks_level_elements'

19855:
19856: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19857: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19858: FND_LOG.string(FND_LOG.level_statement
19859: ,l_module_name||'.copy_oks_level_elements'
19860: ,'After call to copy_oks_level_elements: x_return_status:'||l_return_status
19861: ||' '||SQLERRM
19862: );
19863: END IF;

Line 19860: ,'After call to copy_oks_level_elements: x_return_status:'||l_return_status

19856: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19857: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19858: FND_LOG.string(FND_LOG.level_statement
19859: ,l_module_name||'.copy_oks_level_elements'
19860: ,'After call to copy_oks_level_elements: x_return_status:'||l_return_status
19861: ||' '||SQLERRM
19862: );
19863: END IF;
19864: END IF;

Line 25161: -------------Copy of OKS_LEVEL_ELEMENTS---------------------------

25157: End If;
25158: End;
25159: -------------------------------------------------------------------
25160:
25161: -------------Copy of OKS_LEVEL_ELEMENTS---------------------------
25162: Begin
25163: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25164: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25165: FND_LOG.string(FND_LOG.level_statement

Line 25166: ,l_module_name||'.copy_oks_level_elements'

25162: Begin
25163: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25164: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25165: FND_LOG.string(FND_LOG.level_statement
25166: ,l_module_name||'.copy_oks_level_elements'
25167: ,'Before call to copy_oks_level_elements'
25168: );
25169: END IF;
25170: END IF;

Line 25167: ,'Before call to copy_oks_level_elements'

25163: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25164: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25165: FND_LOG.string(FND_LOG.level_statement
25166: ,l_module_name||'.copy_oks_level_elements'
25167: ,'Before call to copy_oks_level_elements'
25168: );
25169: END IF;
25170: END IF;
25171:

Line 25172: copy_oks_level_elements(P_From_Chr_ID => P_From_Chr_ID

25168: );
25169: END IF;
25170: END IF;
25171:
25172: copy_oks_level_elements(P_From_Chr_ID => P_From_Chr_ID
25173: ,P_To_Chr_ID => P_To_Chr_ID
25174: ,P_Partial_Copy_YN => 'Y'
25175: ,P_Target_Contract_New_YN => P_Target_Contract_New_YN
25176: ,P_Lines_Count => P_Lines_Tbl.COUNT

Line 25182: ,l_module_name||'.copy_oks_level_elements'

25178:
25179: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25180: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25181: FND_LOG.string(FND_LOG.level_statement
25182: ,l_module_name||'.copy_oks_level_elements'
25183: ,'After call to copy_oks_level_elements: x_return_status:'||l_return_status
25184: ||' '||SQLERRM
25185: );
25186: END IF;

Line 25183: ,'After call to copy_oks_level_elements: x_return_status:'||l_return_status

25179: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25180: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25181: FND_LOG.string(FND_LOG.level_statement
25182: ,l_module_name||'.copy_oks_level_elements'
25183: ,'After call to copy_oks_level_elements: x_return_status:'||l_return_status
25184: ||' '||SQLERRM
25185: );
25186: END IF;
25187: END IF;