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_STREAM_LEVELS_B

Line 12025: -- copy_oks_stream_levels_b

12021: End copy_oks_billrate_schedules;
12022:
12023: ------------------------------------------------------------
12024: --===================================================
12025: -- copy_oks_stream_levels_b
12026: -- Parameters: P_From_Chr_ID : Header ID of source contract
12027: -- P_To_Chr_ID : Header ID of target contract
12028: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
12029: -- or as part of component copy from UI (value = 'Y')

Line 12049: PROCEDURE copy_oks_stream_levels_b(P_From_Chr_ID IN NUMBER

12045: -- End If
12046: -- End If
12047: --====================================================
12048:
12049: PROCEDURE copy_oks_stream_levels_b(P_From_Chr_ID IN NUMBER
12050: ,P_To_Chr_ID IN NUMBER
12051: ,P_Partial_Copy_YN IN VARCHAR2
12052: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
12053: ,P_Lines_Count IN NUMBER DEFAULT 0

Line 12056: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_STREAM_LEVELS_B';

12052: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
12053: ,P_Lines_Count IN NUMBER DEFAULT 0
12054: ,x_return_status OUT NOCOPY VARCHAR2) IS
12055:
12056: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_STREAM_LEVELS_B';
12057: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
12058: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12059:
12060: CURSOR GetOksSLFull IS

Line 12088: OKS_STREAM_LEVELS_B oksSL

12084: ,oksSL.ID AS oksSL_ORIG_SYSTEM_ID1
12085: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12086: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12087: FROM
12088: OKS_STREAM_LEVELS_B oksSL
12089: ,OKC_K_HEADERS_B okcH
12090: WHERE
12091: oksSL.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
12092: AND okcH.ID = P_To_Chr_ID

Line 12124: OKS_STREAM_LEVELS_B oksSL

12120: ,oksSL.ID AS oksSL_ORIG_SYSTEM_ID1
12121: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12122: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12123: FROM
12124: OKS_STREAM_LEVELS_B oksSL
12125: ,OKC_K_LINES_B okcBTarget
12126: ,OKC_K_LINES_B okcBSource
12127: WHERE
12128: oksSL.CLE_ID = okcBTarget.ORIG_SYSTEM_ID1

Line 12207: OKS_STREAM_LEVELS_B oksSL

12203: ,oksSL.ID AS oksSL_ORIG_SYSTEM_ID1
12204: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12205: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12206: FROM
12207: OKS_STREAM_LEVELS_B oksSL
12208: ,OKC_K_HEADERS_B okcH
12209: WHERE
12210: oksSL.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
12211: AND okcH.ID = P_To_Chr_ID

Line 12243: OKS_STREAM_LEVELS_B oksSL

12239: ,oksSL.ID AS oksSL_ORIG_SYSTEM_ID1
12240: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12241: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12242: FROM
12243: OKS_STREAM_LEVELS_B oksSL
12244: ,OKC_K_LINES_B_TEMP okcBT
12245: WHERE
12246: oksSL.CLE_ID = okcBT.ORIG_SYSTEM_ID1
12247: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID

Line 12349: OKS_STREAM_LEVELS_B oksSL

12345: ,oksSL.ID AS oksSL_ORIG_SYSTEM_ID1
12346: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12347: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12348: FROM
12349: OKS_STREAM_LEVELS_B oksSL
12350: ,OKC_K_HEADERS_B okcH
12351: WHERE
12352: oksSL.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
12353: AND okcH.ID = P_To_Chr_ID

Line 12389: OKS_STREAM_LEVELS_B oksSL

12385: ,oksSL.ID AS oksSL_ORIG_SYSTEM_ID1
12386: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12387: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12388: FROM
12389: OKS_STREAM_LEVELS_B oksSL
12390: ,OKC_K_LINES_B_TEMP okcBT
12391: WHERE
12392: oksSL.CLE_ID = okcBT.ORIG_SYSTEM_ID1
12393: AND oksSL.DNZ_CHR_ID = P_From_Chr_ID

Line 12465: --errorout_hk('Entered copy_oks_stream_levels_b');

12461: ;
12462:
12463: Begin
12464: x_return_status := l_return_status;
12465: --errorout_hk('Entered copy_oks_stream_levels_b');
12466: If (P_Partial_Copy_YN = 'N') then
12467: OPEN GetOksSLFull;
12468: ElsIf (P_Partial_Copy_YN = 'Y') then
12469: If (P_Target_Contract_New_YN = 'Y' and P_Lines_Count = 0) then

Line 12603: INSERT INTO OKS_STREAM_LEVELS_B (

12599: End If;
12600: --errorout_hk('GetOksLEPartial_L count -'||OksLERecTab.OksLE_NewID.count);
12601:
12602: FORALL i IN OksSLRecTab.OksSL_NewID.FIRST .. OksSLRecTab.OksSL_NewID.LAST
12603: INSERT INTO OKS_STREAM_LEVELS_B (
12604: ID
12605: ,CHR_ID
12606: ,CLE_ID
12607: ,DNZ_CHR_ID

Line 12707: End copy_oks_stream_levels_b;

12703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12704: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
12705: RAISE;
12706:
12707: End copy_oks_stream_levels_b;
12708:
12709: ------------------------------------------------
12710: --===================================================
12711: -- copy_oks_level_elements

Line 12772: ,OKS_STREAM_LEVELS_B oksSL

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
12776: AND oksLE.DNZ_CHR_ID = P_From_Chr_ID;

Line 12802: ,OKS_STREAM_LEVELS_B oksSL

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
12806: AND oksSL.CLE_ID IS NULL

Line 12832: ,OKS_STREAM_LEVELS_B oksSL

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
12836: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1

Line 12911: ,OKS_STREAM_LEVELS_B oksSL

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
12915: AND oksSL.CLE_ID IS NULL

Line 12942: ,OKS_STREAM_LEVELS_B oksSL

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
12946: AND oksSL.CHR_ID IS NULL

Line 13043: ,OKS_STREAM_LEVELS_B oksSL

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
13047: AND oksSL.CLE_ID IS NULL

Line 13073: ,OKS_STREAM_LEVELS_B oksSL

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
13077: AND oksSL.CHR_ID IS NULL

Line 13712: OKS_STREAM_LEVELS_B where CLE_ID = l_Source_Top_Line_ID

13708: ,DUE_ARR_YN
13709: ,AMOUNT
13710: ,LINES_DETAILED_YN
13711: FROM
13712: OKS_STREAM_LEVELS_B where CLE_ID = l_Source_Top_Line_ID
13713: ORDER BY SEQUENCE_NO;
13714:
13715: TYPE l_SourceStreams_tbl_Type IS TABLE OF GetStreamsForSourceTopLine%ROWTYPE INDEX BY BINARY_INTEGER;
13716: l_SourceStreams_tbl l_SourceStreams_tbl_Type;

Line 14361: OKS_STREAM_LEVELS_B where CHR_ID = P_To_Chr_ID AND

14357: ,DUE_ARR_YN
14358: ,AMOUNT
14359: ,LINES_DETAILED_YN
14360: FROM
14361: OKS_STREAM_LEVELS_B where CHR_ID = P_To_Chr_ID AND
14362: CLE_ID IS NULL
14363: ORDER BY SEQUENCE_NO;
14364:
14365: TYPE l_TrgHdrStreams_Tbl_Type IS TABLE OF GetStreamsForTargetHeader%ROWTYPE INDEX BY BINARY_INTEGER;

Line 14375: OKS_STREAM_LEVELS_B

14371: SELECT
14372: INVOICE_OFFSET_DAYS
14373: ,INTERFACE_OFFSET_DAYS
14374: FROM
14375: OKS_STREAM_LEVELS_B
14376: WHERE CLE_ID = P_From_Cle_ID
14377: AND dnz_chr_id = P_FROM_CHR_ID
14378: ORDER BY SEQUENCE_NO;
14379: -- End NECHATUR Bug#5349539

Line 14403: OKS_STREAM_LEVELS_B

14399: ,DUE_ARR_YN
14400: ,AMOUNT
14401: ,LINES_DETAILED_YN
14402: FROM
14403: OKS_STREAM_LEVELS_B
14404: WHERE CLE_ID = P_From_Cle_ID
14405: AND dnz_chr_id = P_FROM_CHR_ID
14406: ORDER BY SEQUENCE_NO;
14407:

Line 19809: -------------Copy of OKS_STREAM_LEVELS_B---------------------------

19805: ) THEN -- Bulk Copy of Billing Schedule can be done from Source
19806:
19807: --================Start of Billing Schedule copy for Header and Lines==========
19808:
19809: -------------Copy of OKS_STREAM_LEVELS_B---------------------------
19810: Begin
19811: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19812: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19813: FND_LOG.string(FND_LOG.level_statement

Line 19814: ,l_module_name||'.copy_oks_stream_levels_b'

19810: Begin
19811: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19812: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19813: FND_LOG.string(FND_LOG.level_statement
19814: ,l_module_name||'.copy_oks_stream_levels_b'
19815: ,'Before call to copy_oks_stream_levels_b'
19816: );
19817: END IF;
19818: END IF;

Line 19815: ,'Before call to copy_oks_stream_levels_b'

19811: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19812: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19813: FND_LOG.string(FND_LOG.level_statement
19814: ,l_module_name||'.copy_oks_stream_levels_b'
19815: ,'Before call to copy_oks_stream_levels_b'
19816: );
19817: END IF;
19818: END IF;
19819:

Line 19820: copy_oks_stream_levels_b(P_From_Chr_ID => P_From_Chr_ID

19816: );
19817: END IF;
19818: END IF;
19819:
19820: copy_oks_stream_levels_b(P_From_Chr_ID => P_From_Chr_ID
19821: ,P_To_Chr_ID => P_To_Chr_ID
19822: ,P_Partial_Copy_YN => 'N'
19823: ,x_return_status => l_return_status);
19824:

Line 19828: ,l_module_name||'.copy_oks_stream_levels_b'

19824:
19825: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19826: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19827: FND_LOG.string(FND_LOG.level_statement
19828: ,l_module_name||'.copy_oks_stream_levels_b'
19829: ,'After call to copy_oks_stream_levels_b: x_return_status:'||l_return_status
19830: ||' '||SQLERRM
19831: );
19832: END IF;

Line 19829: ,'After call to copy_oks_stream_levels_b: x_return_status:'||l_return_status

19825: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19826: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19827: FND_LOG.string(FND_LOG.level_statement
19828: ,l_module_name||'.copy_oks_stream_levels_b'
19829: ,'After call to copy_oks_stream_levels_b: x_return_status:'||l_return_status
19830: ||' '||SQLERRM
19831: );
19832: END IF;
19833: END IF;

Line 25127: -------------Copy of OKS_STREAM_LEVELS_B---------------------------

25123: IF (P_Target_Contract_New_YN = 'Y') then
25124: IF ( (l_SrcContractPPSetupExists_YN = 'Y') OR (l_SrcContractPPSetupExists_YN = 'N' AND l_GCDPPSetupExists_YN = 'N')) THEN
25125: -- Bulk Copy of Billing Schedule can be done from Source
25126: --errorout_hk('Copy Line Components, Copy of bill sch');
25127: -------------Copy of OKS_STREAM_LEVELS_B---------------------------
25128: Begin
25129: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25130: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25131: FND_LOG.string(FND_LOG.level_statement

Line 25132: ,l_module_name||'.copy_oks_stream_levels_b'

25128: Begin
25129: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25130: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25131: FND_LOG.string(FND_LOG.level_statement
25132: ,l_module_name||'.copy_oks_stream_levels_b'
25133: ,'Before call to copy_oks_stream_levels_b'
25134: );
25135: END IF;
25136: END IF;

Line 25133: ,'Before call to copy_oks_stream_levels_b'

25129: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25130: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25131: FND_LOG.string(FND_LOG.level_statement
25132: ,l_module_name||'.copy_oks_stream_levels_b'
25133: ,'Before call to copy_oks_stream_levels_b'
25134: );
25135: END IF;
25136: END IF;
25137:

Line 25138: copy_oks_stream_levels_b(P_From_Chr_ID => P_From_Chr_ID

25134: );
25135: END IF;
25136: END IF;
25137:
25138: copy_oks_stream_levels_b(P_From_Chr_ID => P_From_Chr_ID
25139: ,P_To_Chr_ID => P_To_Chr_ID
25140: ,P_Partial_Copy_YN => 'Y'
25141: ,P_Target_Contract_New_YN => P_Target_Contract_New_YN
25142: ,P_Lines_Count => P_Lines_Tbl.COUNT

Line 25148: ,l_module_name||'.copy_oks_stream_levels_b'

25144:
25145: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25146: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25147: FND_LOG.string(FND_LOG.level_statement
25148: ,l_module_name||'.copy_oks_stream_levels_b'
25149: ,'After call to copy_oks_stream_levels_b: x_return_status:'||l_return_status
25150: ||' '||SQLERRM
25151: );
25152: END IF;

Line 25149: ,'After call to copy_oks_stream_levels_b: x_return_status:'||l_return_status

25145: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25146: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25147: FND_LOG.string(FND_LOG.level_statement
25148: ,l_module_name||'.copy_oks_stream_levels_b'
25149: ,'After call to copy_oks_stream_levels_b: x_return_status:'||l_return_status
25150: ||' '||SQLERRM
25151: );
25152: END IF;
25153: END IF;