DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_SETUP_UTIL_PUB

Line 15806: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */

15802: /*
15803: ,decode(l_SrcContractPPSetupExists_YN
15804: ,'Y'
15805: ,oksB.PRICE_UOM
15806: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */
15807: ,decode(l_SrcContractPPSetupExists_YN
15808: ,'Y'
15809: ,oksB.PRICE_UOM
15810: ,decode(l_TrgtHeaderPriceUomExists_YN

Line 16070: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */

16066: /*
16067: ,decode(l_SrcContractPPSetupExists_YN
16068: ,'Y'
16069: ,oksB.PRICE_UOM
16070: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */
16071: ,decode(l_SrcContractPPSetupExists_YN
16072: ,'Y'
16073: ,oksB.PRICE_UOM
16074: ,decode(l_TrgtHeaderPriceUomExists_YN

Line 16335: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */

16331: /*
16332: ,decode(l_SrcContractPPSetupExists_YN
16333: ,'Y'
16334: ,oksB.PRICE_UOM
16335: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */
16336: ,decode(l_SrcContractPPSetupExists_YN
16337: ,'Y'
16338: ,oksB.PRICE_UOM
16339: ,decode(l_TrgtHeaderPriceUomExists_YN

Line 16600: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */

16596: /*
16597: ,decode(l_SrcContractPPSetupExists_YN
16598: ,'Y'
16599: ,oksB.PRICE_UOM
16600: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */
16601: ,decode(l_SrcContractPPSetupExists_YN
16602: ,'Y'
16603: ,oksB.PRICE_UOM
16604: ,decode(l_TrgtHeaderPriceUomExists_YN

Line 16853: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */

16849: /*
16850: ,decode(l_SrcContractPPSetupExists_YN
16851: ,'Y'
16852: ,oksB.PRICE_UOM
16853: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */
16854: ,decode(l_SrcContractPPSetupExists_YN
16855: ,'Y'
16856: ,oksB.PRICE_UOM
16857: ,decode(l_TrgtHeaderPriceUomExists_YN

Line 17054: IF (OKS_SETUP_UTIL_PUB.G_GCD_PERIOD_START IS NOT NULL and OKS_SETUP_UTIL_PUB.G_GCD_PERIOD_TYPE IS NOT NULL) then

17050:
17051: x_return_status := l_return_status;
17052:
17053: --Setting Variable to indicate existence of Partial Period Setup in GCD--
17054: IF (OKS_SETUP_UTIL_PUB.G_GCD_PERIOD_START IS NOT NULL and OKS_SETUP_UTIL_PUB.G_GCD_PERIOD_TYPE IS NOT NULL) then
17055: l_GCDPPSetupExists_YN := 'Y';
17056: ELSE
17057: l_GCDPPSetupExists_YN := 'N';
17058: END IF;

Line 19420: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst for all Subscription Lines'

19416:
19417: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19418: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19419: FND_LOG.string(FND_LOG.level_statement
19420: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst for all Subscription Lines'
19421: ,'Before call to OKS_SETUP_UTIL_PUB.copy_subscr_inst for all Subscription Lines'
19422: ||to_char(sysdate,'DD/MM/YYYY HH:MI:SS')
19423: );
19424: END IF;

Line 19421: ,'Before call to OKS_SETUP_UTIL_PUB.copy_subscr_inst for all Subscription Lines'

19417: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19418: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19419: FND_LOG.string(FND_LOG.level_statement
19420: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst for all Subscription Lines'
19421: ,'Before call to OKS_SETUP_UTIL_PUB.copy_subscr_inst for all Subscription Lines'
19422: ||to_char(sysdate,'DD/MM/YYYY HH:MI:SS')
19423: );
19424: END IF;
19425: END IF;

Line 19427: OKS_SETUP_UTIL_PUB.copy_subscr_inst(p_new_chr_id => P_To_Chr_ID

19423: );
19424: END IF;
19425: END IF;
19426:
19427: OKS_SETUP_UTIL_PUB.copy_subscr_inst(p_new_chr_id => P_To_Chr_ID
19428: ,p_cle_id => NULL
19429: ,p_intent => 'COPY'
19430: ,x_return_status => l_return_status);
19431:

Line 19435: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst'

19431:
19432: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19433: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19434: FND_LOG.string(FND_LOG.level_statement
19435: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst'
19436: ,'After call to OKS_SETUP_UTIL_PUB.copy_subscr_inst: x_return_status:'||l_return_status
19437: ||to_char(sysdate,'DD/MM/YYYY HH:MI:SS')
19438: ||' '||SQLERRM
19439: );

Line 19436: ,'After call to OKS_SETUP_UTIL_PUB.copy_subscr_inst: x_return_status:'||l_return_status

19432: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19433: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19434: FND_LOG.string(FND_LOG.level_statement
19435: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst'
19436: ,'After call to OKS_SETUP_UTIL_PUB.copy_subscr_inst: x_return_status:'||l_return_status
19437: ||to_char(sysdate,'DD/MM/YYYY HH:MI:SS')
19438: ||' '||SQLERRM
19439: );
19440: END IF;

Line 20362: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE

20358: ) AS OkcBT_TERM_CANCEL_SOURCE --Making it null for 4641561, Added the decode for bug 4747648
20359: ,decode(okcBT.DATES_CHANGED_YN
20360: ,'N'
20361: ,okcBT.ANNUALIZED_FACTOR
20362: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE
20363: ,okcBT.END_DATE
20364: ,okcBT.LSE_ID)
20365: ) AS OkcBT_ANNUALIZED_FACTOR
20366: -- hkamdar 17-Apr-2006 Bug # 4722452 as per Aaron's feedback on 07-Apr-2006.

Line 20421: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)

20417: ,'Y'
20418: ,decode(l_SrcContractPPSetupExists_YN
20419: ,'Y'
20420: ,oksB.PRICE_UOM
20421: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)
20422: ,oksB.PRICE_UOM --The value of Price_UOM when copying to an existing Target Contract
20423: --is subsequently updated based on whether Partial Period Setup on
20424: --Target Contract existed or not
20425: ) AS OksB_PRICE_UOM */

Line 20679: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE

20675: ) AS OkcBT_TERM_CANCEL_SOURCE --Making it null for 4641561, Added the decode for bug 4747648
20676: ,decode(okcBT.DATES_CHANGED_YN
20677: ,'N'
20678: ,okcBT.ANNUALIZED_FACTOR
20679: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE
20680: ,okcBT.END_DATE
20681: ,okcBT.LSE_ID)
20682: ) AS OkcBT_ANNUALIZED_FACTOR
20683: -- hkamdar 17-Apr-2006 Bug # 4722452 as per Aaron's feedback on 07-Apr-2006.

Line 20738: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)

20734: ,'Y'
20735: ,decode(l_SrcContractPPSetupExists_YN
20736: ,'Y'
20737: ,oksB.PRICE_UOM
20738: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)
20739: ,oksB.PRICE_UOM --The value of Price_UOM when copying to an existing Target Contract
20740: --is subsequently updated based on whether Partial Period Setup on
20741: --Target Contract existed or not
20742: ) AS OksB_PRICE_UOM */

Line 20997: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE

20993: ) AS OkcBT_TERM_CANCEL_SOURCE --Making it null for 4641561, Added the decode for bug 4747648
20994: ,decode(okcBT.DATES_CHANGED_YN
20995: ,'N'
20996: ,okcBT.ANNUALIZED_FACTOR
20997: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE
20998: ,okcBT.END_DATE
20999: ,okcBT.LSE_ID)
21000: ) AS OkcBT_ANNUALIZED_FACTOR
21001: -- hkamdar 17-Apr-2006 Bug # 4722452 as per Aaron's feedback on 07-Apr-2006.

Line 21056: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)

21052: ,'Y'
21053: ,decode(l_SrcContractPPSetupExists_YN
21054: ,'Y'
21055: ,oksB.PRICE_UOM
21056: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)
21057: ,oksB.PRICE_UOM --The value of Price_UOM when copying to an existing Target Contract
21058: --is subsequently updated based on whether Partial Period Setup on
21059: --Target Contract existed or not
21060: ) AS OksB_PRICE_UOM */

Line 21315: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE

21311: ) AS OkcBT_TERM_CANCEL_SOURCE --Making it null for 4641561, Added the decode for bug 4747648
21312: ,decode(okcBT.DATES_CHANGED_YN
21313: ,'N'
21314: ,okcBT.ANNUALIZED_FACTOR
21315: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE
21316: ,okcBT.END_DATE
21317: ,okcBT.LSE_ID)
21318: ) AS OkcBT_ANNUALIZED_FACTOR
21319: -- hkamdar 17-Apr-2006 Bug # 4722452 as per Aaron's feedback on 07-Apr-2006.

Line 21374: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)

21370: ,'Y'
21371: ,decode(l_SrcContractPPSetupExists_YN
21372: ,'Y'
21373: ,oksB.PRICE_UOM
21374: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)
21375: ,oksB.PRICE_UOM --The value of Price_UOM when copying to an existing Target Contract
21376: --is subsequently updated based on whether Partial Period Setup on
21377: --Target Contract existed or not
21378: ) AS OksB_PRICE_UOM */

Line 21511: IF (OKS_SETUP_UTIL_PUB.G_GCD_PERIOD_START IS NOT NULL and OKS_SETUP_UTIL_PUB.G_GCD_PERIOD_TYPE IS NOT NULL) then

21507: END IF;
21508: END IF;
21509: --Setting Variable to indicate existence of Partial Period Setup in GCD , only checked if copying to a new contract in Component Copy--
21510: IF (P_Target_Contract_New_YN = 'Y') THEN
21511: IF (OKS_SETUP_UTIL_PUB.G_GCD_PERIOD_START IS NOT NULL and OKS_SETUP_UTIL_PUB.G_GCD_PERIOD_TYPE IS NOT NULL) then
21512: l_GCDPPSetupExists_YN := 'Y';
21513: ELSE
21514: l_GCDPPSetupExists_YN := 'N';
21515: END IF;

Line 24524: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst for Lines chosen by user'

24520: Begin
24521: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24522: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24523: FND_LOG.string(FND_LOG.level_statement
24524: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst for Lines chosen by user'
24525: ,'Before call to OKS_SETUP_UTIL_PUB.copy_subscr_inst for Lines chosen by user'
24526: ||':'||to_char(sysdate,'DD/MM/YY HH:MI:SS')
24527: );
24528: END IF;

Line 24525: ,'Before call to OKS_SETUP_UTIL_PUB.copy_subscr_inst for Lines chosen by user'

24521: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24522: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24523: FND_LOG.string(FND_LOG.level_statement
24524: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst for Lines chosen by user'
24525: ,'Before call to OKS_SETUP_UTIL_PUB.copy_subscr_inst for Lines chosen by user'
24526: ||':'||to_char(sysdate,'DD/MM/YY HH:MI:SS')
24527: );
24528: END IF;
24529: END IF;

Line 24531: OKS_SETUP_UTIL_PUB.copy_subscr_inst(p_new_chr_id => P_To_Chr_ID

24527: );
24528: END IF;
24529: END IF;
24530:
24531: OKS_SETUP_UTIL_PUB.copy_subscr_inst(p_new_chr_id => P_To_Chr_ID
24532: ,p_cle_id => OKCOKSLinesRecTab.OkcB_NewOkcLineID(i)
24533: ,p_intent => 'COPY'
24534: ,x_return_status => l_return_status);
24535:

Line 24539: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst'

24535:
24536: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24537: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24538: FND_LOG.string(FND_LOG.level_statement
24539: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst'
24540: ,'After call to OKS_SETUP_UTIL_PUB.copy_subscr_inst: x_return_status:'||l_return_status
24541: ||':'||to_char(sysdate,'DD/MM/YY HH:MI:SS')
24542: ||' '||SQLERRM
24543: );

Line 24540: ,'After call to OKS_SETUP_UTIL_PUB.copy_subscr_inst: x_return_status:'||l_return_status

24536: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24537: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24538: FND_LOG.string(FND_LOG.level_statement
24539: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst'
24540: ,'After call to OKS_SETUP_UTIL_PUB.copy_subscr_inst: x_return_status:'||l_return_status
24541: ||':'||to_char(sysdate,'DD/MM/YY HH:MI:SS')
24542: ||' '||SQLERRM
24543: );
24544: END IF;

Line 25900: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'

25896: /*--Call to copy source contract record in OKS_K_HEADERS_B */
25897: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25898: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25899: FND_LOG.string(FND_LOG.level_statement
25900: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
25901: ,'Before call to oks_setup_util_pub.copy_hdr_attr'
25902: ||' P_From_Chr_ID = '||p_chr_id
25903: ||',P_To_Chr_ID = '||l_to_chr_id
25904: );

Line 25901: ,'Before call to oks_setup_util_pub.copy_hdr_attr'

25897: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25898: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25899: FND_LOG.string(FND_LOG.level_statement
25900: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
25901: ,'Before call to oks_setup_util_pub.copy_hdr_attr'
25902: ||' P_From_Chr_ID = '||p_chr_id
25903: ||',P_To_Chr_ID = '||l_to_chr_id
25904: );
25905: END IF;

Line 25908: OKS_SETUP_UTIL_PUB.copy_hdr_attr

25904: );
25905: END IF;
25906: END IF;
25907:
25908: OKS_SETUP_UTIL_PUB.copy_hdr_attr
25909: (p_chr_id => p_chr_id --Source Contract Header ID
25910: ,p_new_chr_id => l_to_chr_id --Target Contract Header ID
25911: ,p_duration_match => NULL
25912: ,p_renew_ref_YN => P_Renew_Ref_YN

Line 25917: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'

25913: ,x_return_status => l_return_status);
25914: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25915: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25916: FND_LOG.string(FND_LOG.level_statement
25917: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
25918: ,'After call to oks_setup_util_pub.copy_hdr_attr: x_return_status:'||l_return_status
25919: ||' '||SQLERRM
25920: );
25921: END IF;

Line 25918: ,'After call to oks_setup_util_pub.copy_hdr_attr: x_return_status:'||l_return_status

25914: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25915: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25916: FND_LOG.string(FND_LOG.level_statement
25917: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
25918: ,'After call to oks_setup_util_pub.copy_hdr_attr: x_return_status:'||l_return_status
25919: ||' '||SQLERRM
25920: );
25921: END IF;
25922: END IF;

Line 26786: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'

26782: /*--Call to copy source contract record in OKS_K_HEADERS_B */
26783: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
26784: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
26785: FND_LOG.string(FND_LOG.level_statement
26786: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
26787: ,'Before call to oks_setup_util_pub.copy_hdr_attr'
26788: ||' P_From_Chr_ID = '||p_from_chr_id
26789: ||',P_To_Chr_ID = '||l_to_chr_id
26790: );

Line 26787: ,'Before call to oks_setup_util_pub.copy_hdr_attr'

26783: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
26784: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
26785: FND_LOG.string(FND_LOG.level_statement
26786: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
26787: ,'Before call to oks_setup_util_pub.copy_hdr_attr'
26788: ||' P_From_Chr_ID = '||p_from_chr_id
26789: ||',P_To_Chr_ID = '||l_to_chr_id
26790: );
26791: END IF;

Line 26794: OKS_SETUP_UTIL_PUB.copy_hdr_attr

26790: );
26791: END IF;
26792: END IF;
26793:
26794: OKS_SETUP_UTIL_PUB.copy_hdr_attr
26795: (p_chr_id => p_from_chr_id --Source Contract Header ID
26796: ,p_new_chr_id => l_to_chr_id --Target Contract Header ID
26797: ,p_duration_match => NULL
26798: ,p_renew_ref_YN => 'N'

Line 26803: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'

26799: ,x_return_status => l_return_status);
26800: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
26801: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
26802: FND_LOG.string(FND_LOG.level_statement
26803: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
26804: ,'After call to oks_setup_util_pub.copy_hdr_attr: x_return_status:'||l_return_status
26805: ||' '||SQLERRM
26806: );
26807: END IF;

Line 26804: ,'After call to oks_setup_util_pub.copy_hdr_attr: x_return_status:'||l_return_status

26800: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
26801: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
26802: FND_LOG.string(FND_LOG.level_statement
26803: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
26804: ,'After call to oks_setup_util_pub.copy_hdr_attr: x_return_status:'||l_return_status
26805: ||' '||SQLERRM
26806: );
26807: END IF;
26808: END IF;