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 12666: -- copy_oks_level_elements

12662: End copy_oks_stream_levels_b;
12663:
12664: ------------------------------------------------
12665: --===================================================
12666: -- copy_oks_level_elements
12667: -- Parameters: P_From_Chr_ID : Header ID of source contract
12668: -- P_To_Chr_ID : Header ID of target contract
12669: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
12670: -- or as part of component copy from UI (value = 'Y')

Line 12687: PROCEDURE copy_oks_level_elements(P_From_Chr_ID IN NUMBER

12683: -- End If
12684:
12685: --====================================================
12686:
12687: PROCEDURE copy_oks_level_elements(P_From_Chr_ID IN NUMBER
12688: ,P_To_Chr_ID IN NUMBER
12689: ,P_Partial_Copy_YN IN VARCHAR2
12690: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
12691: ,P_Lines_Count IN NUMBER DEFAULT 0

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

12690: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
12691: ,P_Lines_Count IN NUMBER DEFAULT 0
12692: ,x_return_status OUT NOCOPY VARCHAR2) IS
12693:
12694: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_LEVEL_ELEMENTS';
12695: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
12696: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12697:
12698: /******

Line 12726: OKS_LEVEL_ELEMENTS oksLE

12722: a.ID = oksSL.CLE_ID
12723: and a.DNZ_CHR_ID = P_To_Chr_ID )) AS oksLE_NewParentCleID --*
12724: ,oksLE.DATE_END AS oksLE_DATE_END
12725: FROM
12726: OKS_LEVEL_ELEMENTS oksLE
12727: ,OKS_STREAM_LEVELS_B oksSL
12728: WHERE
12729: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
12730: AND oksSL.DNZ_CHR_ID = P_To_Chr_ID

Line 12756: OKS_LEVEL_ELEMENTS oksLE

12752: ,oksSL.DNZ_CHR_ID AS oksLE_NewDnzChrID --*
12753: ,NULL AS oksLE_NewParentCleID --*
12754: ,oksLE.DATE_END AS oksLE_DATE_END
12755: FROM
12756: OKS_LEVEL_ELEMENTS oksLE
12757: ,OKS_STREAM_LEVELS_B oksSL
12758: WHERE
12759: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
12760: AND oksSL.CHR_ID IS NOT NULL

Line 12786: OKS_LEVEL_ELEMENTS oksLE

12782: ,oksSL.DNZ_CHR_ID AS oksLE_NewDnzChrID --*
12783: ,decode(okcBTarget.CLE_ID,NULL,okcBTarget.ID,okcBTarget.CLE_ID) AS NewParentCleID
12784: ,oksLE.DATE_END AS oksLE_DATE_END
12785: FROM
12786: OKS_LEVEL_ELEMENTS oksLE
12787: ,OKS_STREAM_LEVELS_B oksSL
12788: ,OKC_K_LINES_B okcBTarget
12789: ,OKC_K_LINES_B okcBSource
12790: WHERE

Line 12865: OKS_LEVEL_ELEMENTS oksLE

12861: ,oksSL.DNZ_CHR_ID AS oksLE_NewDnzChrID --*
12862: ,NULL AS oksLE_NewParentCleID --*
12863: ,oksLE.DATE_END AS oksLE_DATE_END
12864: FROM
12865: OKS_LEVEL_ELEMENTS oksLE
12866: ,OKS_STREAM_LEVELS_B oksSL
12867: WHERE
12868: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
12869: AND oksSL.CHR_ID IS NOT NULL

Line 12896: OKS_LEVEL_ELEMENTS oksLE

12892: ,oksSL.DNZ_CHR_ID AS oksLE_NewDnzChrID --*
12893: ,decode(okcBT.CLE_ID,NULL,okcBT.ID,okcBT.CLE_ID) AS NewParentCleID
12894: ,oksLE.DATE_END AS oksLE_DATE_END
12895: FROM
12896: OKS_LEVEL_ELEMENTS oksLE
12897: ,OKS_STREAM_LEVELS_B oksSL
12898: ,OKC_K_LINES_B_TEMP okcBT
12899: WHERE
12900: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1

Line 12997: OKS_LEVEL_ELEMENTS oksLE

12993: ,oksSL.DNZ_CHR_ID AS oksLE_NewDnzChrID --*
12994: ,NULL AS NewParentCleID --*
12995: ,oksLE.DATE_END AS oksLE_DATE_END
12996: FROM
12997: OKS_LEVEL_ELEMENTS oksLE
12998: ,OKS_STREAM_LEVELS_B oksSL
12999: WHERE
13000: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
13001: AND oksSL.CHR_ID IS NOT NULL

Line 13027: OKS_LEVEL_ELEMENTS oksLE

13023: ,oksSL.DNZ_CHR_ID AS oksLE_NewDnzChrID --*
13024: ,decode(okcBT.CLE_ID,NULL,okcBT.ID,okcBT.CLE_ID) AS NewParentCleID
13025: ,oksLE.DATE_END AS oksLE_DATE_END
13026: FROM
13027: OKS_LEVEL_ELEMENTS oksLE
13028: ,OKS_STREAM_LEVELS_B oksSL
13029: ,OKC_K_LINES_B_TEMP okcBT
13030: WHERE
13031: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1

Line 13249: INSERT INTO OKS_LEVEL_ELEMENTS(

13245:
13246: --errorout_hk('GetOksLEPartial_L count -'||OksLERecTab.OksLE_NewID.count);
13247:
13248: FORALL i IN OksLERecTab.OksLE_NewID.FIRST .. OksLERecTab.OksLE_NewID.LAST
13249: INSERT INTO OKS_LEVEL_ELEMENTS(
13250: ID
13251: ,SEQUENCE_NUMBER
13252: ,DATE_START
13253: ,AMOUNT

Line 13341: End copy_oks_level_elements;

13337: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
13338: RAISE;
13339:
13340:
13341: End copy_oks_level_elements;
13342:
13343:
13344: --==============================================================
13345: --Procedure update_line_inv_and_acct_rule: This procedure will be called just before Billing Schedule copy

Line 14182: -- COPY_OKS_STREAM_LEVELS and COPY_OKS_LEVEL_ELEMENTS routines.

14178: -- a) Using the streams of corresponding target top lines
14179: --
14180: --Note: If the Partial Period Setup had existed on the Source Contract or if the Partial Period Setup was NULL on Both Source Contract
14181: -- and in GCD, the Billing Schedules for Target Header and Lines would have been bulk copied using
14182: -- COPY_OKS_STREAM_LEVELS and COPY_OKS_LEVEL_ELEMENTS routines.
14183: --------------------------------------------------------------------*/
14184: Procedure create_bsch_using_PPSetup(P_To_Chr_ID IN NUMBER
14185: ,P_From_Chr_ID IN NUMBER
14186: ,P_Partial_Copy_YN IN VARCHAR2

Line 19693: -------------Copy of OKS_LEVEL_ELEMENTS---------------------------

19689: RAISE G_EXCEPTION_HALT_VALIDATION;
19690: End If;
19691: End;
19692: -------------------------------------------------------------------
19693: -------------Copy of OKS_LEVEL_ELEMENTS---------------------------
19694: Begin
19695: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19696: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19697: FND_LOG.string(FND_LOG.level_statement

Line 19698: ,l_module_name||'.copy_oks_level_elements'

19694: Begin
19695: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19696: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19697: FND_LOG.string(FND_LOG.level_statement
19698: ,l_module_name||'.copy_oks_level_elements'
19699: ,'Before call to copy_oks_level_elements'
19700: );
19701: END IF;
19702: END IF;

Line 19699: ,'Before call to copy_oks_level_elements'

19695: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19696: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19697: FND_LOG.string(FND_LOG.level_statement
19698: ,l_module_name||'.copy_oks_level_elements'
19699: ,'Before call to copy_oks_level_elements'
19700: );
19701: END IF;
19702: END IF;
19703:

Line 19704: copy_oks_level_elements(P_From_Chr_ID => P_From_Chr_ID

19700: );
19701: END IF;
19702: END IF;
19703:
19704: copy_oks_level_elements(P_From_Chr_ID => P_From_Chr_ID
19705: ,P_To_Chr_ID => P_To_Chr_ID
19706: ,P_Partial_Copy_YN => 'N'
19707: ,x_return_status => l_return_status);
19708:

Line 19712: ,l_module_name||'.copy_oks_level_elements'

19708:
19709: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19710: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19711: FND_LOG.string(FND_LOG.level_statement
19712: ,l_module_name||'.copy_oks_level_elements'
19713: ,'After call to copy_oks_level_elements: x_return_status:'||l_return_status
19714: ||' '||SQLERRM
19715: );
19716: END IF;

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

19709: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19710: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19711: FND_LOG.string(FND_LOG.level_statement
19712: ,l_module_name||'.copy_oks_level_elements'
19713: ,'After call to copy_oks_level_elements: x_return_status:'||l_return_status
19714: ||' '||SQLERRM
19715: );
19716: END IF;
19717: END IF;

Line 24966: -------------Copy of OKS_LEVEL_ELEMENTS---------------------------

24962: End If;
24963: End;
24964: -------------------------------------------------------------------
24965:
24966: -------------Copy of OKS_LEVEL_ELEMENTS---------------------------
24967: Begin
24968: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24969: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24970: FND_LOG.string(FND_LOG.level_statement

Line 24971: ,l_module_name||'.copy_oks_level_elements'

24967: Begin
24968: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24969: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24970: FND_LOG.string(FND_LOG.level_statement
24971: ,l_module_name||'.copy_oks_level_elements'
24972: ,'Before call to copy_oks_level_elements'
24973: );
24974: END IF;
24975: END IF;

Line 24972: ,'Before call to copy_oks_level_elements'

24968: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24969: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24970: FND_LOG.string(FND_LOG.level_statement
24971: ,l_module_name||'.copy_oks_level_elements'
24972: ,'Before call to copy_oks_level_elements'
24973: );
24974: END IF;
24975: END IF;
24976:

Line 24977: copy_oks_level_elements(P_From_Chr_ID => P_From_Chr_ID

24973: );
24974: END IF;
24975: END IF;
24976:
24977: copy_oks_level_elements(P_From_Chr_ID => P_From_Chr_ID
24978: ,P_To_Chr_ID => P_To_Chr_ID
24979: ,P_Partial_Copy_YN => 'Y'
24980: ,P_Target_Contract_New_YN => P_Target_Contract_New_YN
24981: ,P_Lines_Count => P_Lines_Tbl.COUNT

Line 24987: ,l_module_name||'.copy_oks_level_elements'

24983:
24984: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24985: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24986: FND_LOG.string(FND_LOG.level_statement
24987: ,l_module_name||'.copy_oks_level_elements'
24988: ,'After call to copy_oks_level_elements: x_return_status:'||l_return_status
24989: ||' '||SQLERRM
24990: );
24991: END IF;

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

24984: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24985: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24986: FND_LOG.string(FND_LOG.level_statement
24987: ,l_module_name||'.copy_oks_level_elements'
24988: ,'After call to copy_oks_level_elements: x_return_status:'||l_return_status
24989: ||' '||SQLERRM
24990: );
24991: END IF;
24992: END IF;