DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_SETUP_UTIL_PUB

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

15752: /*
15753: ,decode(l_SrcContractPPSetupExists_YN
15754: ,'Y'
15755: ,oksB.PRICE_UOM
15756: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */
15757: ,decode(l_SrcContractPPSetupExists_YN
15758: ,'Y'
15759: ,oksB.PRICE_UOM
15760: ,decode(l_TrgtHeaderPriceUomExists_YN

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

16011: /*
16012: ,decode(l_SrcContractPPSetupExists_YN
16013: ,'Y'
16014: ,oksB.PRICE_UOM
16015: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */
16016: ,decode(l_SrcContractPPSetupExists_YN
16017: ,'Y'
16018: ,oksB.PRICE_UOM
16019: ,decode(l_TrgtHeaderPriceUomExists_YN

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

16271: /*
16272: ,decode(l_SrcContractPPSetupExists_YN
16273: ,'Y'
16274: ,oksB.PRICE_UOM
16275: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */
16276: ,decode(l_SrcContractPPSetupExists_YN
16277: ,'Y'
16278: ,oksB.PRICE_UOM
16279: ,decode(l_TrgtHeaderPriceUomExists_YN

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

16531: /*
16532: ,decode(l_SrcContractPPSetupExists_YN
16533: ,'Y'
16534: ,oksB.PRICE_UOM
16535: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */
16536: ,decode(l_SrcContractPPSetupExists_YN
16537: ,'Y'
16538: ,oksB.PRICE_UOM
16539: ,decode(l_TrgtHeaderPriceUomExists_YN

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

16783: /*
16784: ,decode(l_SrcContractPPSetupExists_YN
16785: ,'Y'
16786: ,oksB.PRICE_UOM
16787: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM) AS OksB_PRICE_UOM */
16788: ,decode(l_SrcContractPPSetupExists_YN
16789: ,'Y'
16790: ,oksB.PRICE_UOM
16791: ,decode(l_TrgtHeaderPriceUomExists_YN

Line 16970: 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

16966:
16967: x_return_status := l_return_status;
16968:
16969: --Setting Variable to indicate existence of Partial Period Setup in GCD--
16970: 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
16971: l_GCDPPSetupExists_YN := 'Y';
16972: ELSE
16973: l_GCDPPSetupExists_YN := 'N';
16974: END IF;

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

19269:
19270: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19271: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19272: FND_LOG.string(FND_LOG.level_statement
19273: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst for all Subscription Lines'
19274: ,'Before call to OKS_SETUP_UTIL_PUB.copy_subscr_inst for all Subscription Lines'
19275: ||to_char(sysdate,'DD/MM/YYYY HH:MI:SS')
19276: );
19277: END IF;

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

19270: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19271: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19272: FND_LOG.string(FND_LOG.level_statement
19273: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst for all Subscription Lines'
19274: ,'Before call to OKS_SETUP_UTIL_PUB.copy_subscr_inst for all Subscription Lines'
19275: ||to_char(sysdate,'DD/MM/YYYY HH:MI:SS')
19276: );
19277: END IF;
19278: END IF;

Line 19280: OKS_SETUP_UTIL_PUB.copy_subscr_inst(p_new_chr_id => P_To_Chr_ID

19276: );
19277: END IF;
19278: END IF;
19279:
19280: OKS_SETUP_UTIL_PUB.copy_subscr_inst(p_new_chr_id => P_To_Chr_ID
19281: ,p_cle_id => NULL
19282: ,p_intent => 'COPY'
19283: ,x_return_status => l_return_status);
19284:

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

19284:
19285: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19286: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19287: FND_LOG.string(FND_LOG.level_statement
19288: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst'
19289: ,'After call to OKS_SETUP_UTIL_PUB.copy_subscr_inst: x_return_status:'||l_return_status
19290: ||to_char(sysdate,'DD/MM/YYYY HH:MI:SS')
19291: ||' '||SQLERRM
19292: );

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

19285: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19286: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19287: FND_LOG.string(FND_LOG.level_statement
19288: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst'
19289: ,'After call to OKS_SETUP_UTIL_PUB.copy_subscr_inst: x_return_status:'||l_return_status
19290: ||to_char(sysdate,'DD/MM/YYYY HH:MI:SS')
19291: ||' '||SQLERRM
19292: );
19293: END IF;

Line 20215: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE

20211: ) AS OkcBT_TERM_CANCEL_SOURCE --Making it null for 4641561, Added the decode for bug 4747648
20212: ,decode(okcBT.DATES_CHANGED_YN
20213: ,'N'
20214: ,okcBT.ANNUALIZED_FACTOR
20215: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE
20216: ,okcBT.END_DATE
20217: ,okcBT.LSE_ID)
20218: ) AS OkcBT_ANNUALIZED_FACTOR
20219: -- hkamdar 17-Apr-2006 Bug # 4722452 as per Aaron's feedback on 07-Apr-2006.

Line 20274: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)

20270: ,'Y'
20271: ,decode(l_SrcContractPPSetupExists_YN
20272: ,'Y'
20273: ,oksB.PRICE_UOM
20274: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)
20275: ,oksB.PRICE_UOM --The value of Price_UOM when copying to an existing Target Contract
20276: --is subsequently updated based on whether Partial Period Setup on
20277: --Target Contract existed or not
20278: ) AS OksB_PRICE_UOM */

Line 20531: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE

20527: ) AS OkcBT_TERM_CANCEL_SOURCE --Making it null for 4641561, Added the decode for bug 4747648
20528: ,decode(okcBT.DATES_CHANGED_YN
20529: ,'N'
20530: ,okcBT.ANNUALIZED_FACTOR
20531: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE
20532: ,okcBT.END_DATE
20533: ,okcBT.LSE_ID)
20534: ) AS OkcBT_ANNUALIZED_FACTOR
20535: -- hkamdar 17-Apr-2006 Bug # 4722452 as per Aaron's feedback on 07-Apr-2006.

Line 20590: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)

20586: ,'Y'
20587: ,decode(l_SrcContractPPSetupExists_YN
20588: ,'Y'
20589: ,oksB.PRICE_UOM
20590: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)
20591: ,oksB.PRICE_UOM --The value of Price_UOM when copying to an existing Target Contract
20592: --is subsequently updated based on whether Partial Period Setup on
20593: --Target Contract existed or not
20594: ) AS OksB_PRICE_UOM */

Line 20848: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE

20844: ) AS OkcBT_TERM_CANCEL_SOURCE --Making it null for 4641561, Added the decode for bug 4747648
20845: ,decode(okcBT.DATES_CHANGED_YN
20846: ,'N'
20847: ,okcBT.ANNUALIZED_FACTOR
20848: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE
20849: ,okcBT.END_DATE
20850: ,okcBT.LSE_ID)
20851: ) AS OkcBT_ANNUALIZED_FACTOR
20852: -- hkamdar 17-Apr-2006 Bug # 4722452 as per Aaron's feedback on 07-Apr-2006.

Line 20907: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)

20903: ,'Y'
20904: ,decode(l_SrcContractPPSetupExists_YN
20905: ,'Y'
20906: ,oksB.PRICE_UOM
20907: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)
20908: ,oksB.PRICE_UOM --The value of Price_UOM when copying to an existing Target Contract
20909: --is subsequently updated based on whether Partial Period Setup on
20910: --Target Contract existed or not
20911: ) AS OksB_PRICE_UOM */

Line 21165: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE

21161: ) AS OkcBT_TERM_CANCEL_SOURCE --Making it null for 4641561, Added the decode for bug 4747648
21162: ,decode(okcBT.DATES_CHANGED_YN
21163: ,'N'
21164: ,okcBT.ANNUALIZED_FACTOR
21165: ,OKS_SETUP_UTIL_PUB.Get_Annualized_Factor(okcBT.START_DATE
21166: ,okcBT.END_DATE
21167: ,okcBT.LSE_ID)
21168: ) AS OkcBT_ANNUALIZED_FACTOR
21169: -- hkamdar 17-Apr-2006 Bug # 4722452 as per Aaron's feedback on 07-Apr-2006.

Line 21224: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)

21220: ,'Y'
21221: ,decode(l_SrcContractPPSetupExists_YN
21222: ,'Y'
21223: ,oksB.PRICE_UOM
21224: ,OKS_SETUP_UTIL_PUB.G_GCD_PRICE_UOM)
21225: ,oksB.PRICE_UOM --The value of Price_UOM when copying to an existing Target Contract
21226: --is subsequently updated based on whether Partial Period Setup on
21227: --Target Contract existed or not
21228: ) AS OksB_PRICE_UOM */

Line 21360: 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

21356: END IF;
21357: END IF;
21358: --Setting Variable to indicate existence of Partial Period Setup in GCD , only checked if copying to a new contract in Component Copy--
21359: IF (P_Target_Contract_New_YN = 'Y') THEN
21360: 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
21361: l_GCDPPSetupExists_YN := 'Y';
21362: ELSE
21363: l_GCDPPSetupExists_YN := 'N';
21364: END IF;

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

24325: Begin
24326: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24327: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24328: FND_LOG.string(FND_LOG.level_statement
24329: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst for Lines chosen by user'
24330: ,'Before call to OKS_SETUP_UTIL_PUB.copy_subscr_inst for Lines chosen by user'
24331: ||':'||to_char(sysdate,'DD/MM/YY HH:MI:SS')
24332: );
24333: END IF;

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

24326: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24327: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24328: FND_LOG.string(FND_LOG.level_statement
24329: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst for Lines chosen by user'
24330: ,'Before call to OKS_SETUP_UTIL_PUB.copy_subscr_inst for Lines chosen by user'
24331: ||':'||to_char(sysdate,'DD/MM/YY HH:MI:SS')
24332: );
24333: END IF;
24334: END IF;

Line 24336: OKS_SETUP_UTIL_PUB.copy_subscr_inst(p_new_chr_id => P_To_Chr_ID

24332: );
24333: END IF;
24334: END IF;
24335:
24336: OKS_SETUP_UTIL_PUB.copy_subscr_inst(p_new_chr_id => P_To_Chr_ID
24337: ,p_cle_id => OKCOKSLinesRecTab.OkcB_NewOkcLineID(i)
24338: ,p_intent => 'COPY'
24339: ,x_return_status => l_return_status);
24340:

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

24340:
24341: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24342: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24343: FND_LOG.string(FND_LOG.level_statement
24344: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst'
24345: ,'After call to OKS_SETUP_UTIL_PUB.copy_subscr_inst: x_return_status:'||l_return_status
24346: ||':'||to_char(sysdate,'DD/MM/YY HH:MI:SS')
24347: ||' '||SQLERRM
24348: );

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

24341: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24342: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24343: FND_LOG.string(FND_LOG.level_statement
24344: ,l_module_name||'.OKS_SETUP_UTIL_PUB.copy_subscr_inst'
24345: ,'After call to OKS_SETUP_UTIL_PUB.copy_subscr_inst: x_return_status:'||l_return_status
24346: ||':'||to_char(sysdate,'DD/MM/YY HH:MI:SS')
24347: ||' '||SQLERRM
24348: );
24349: END IF;

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

25700: /*--Call to copy source contract record in OKS_K_HEADERS_B */
25701: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25702: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25703: FND_LOG.string(FND_LOG.level_statement
25704: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
25705: ,'Before call to oks_setup_util_pub.copy_hdr_attr'
25706: ||' P_From_Chr_ID = '||p_chr_id
25707: ||',P_To_Chr_ID = '||l_to_chr_id
25708: );

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

25701: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25702: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25703: FND_LOG.string(FND_LOG.level_statement
25704: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
25705: ,'Before call to oks_setup_util_pub.copy_hdr_attr'
25706: ||' P_From_Chr_ID = '||p_chr_id
25707: ||',P_To_Chr_ID = '||l_to_chr_id
25708: );
25709: END IF;

Line 25712: OKS_SETUP_UTIL_PUB.copy_hdr_attr

25708: );
25709: END IF;
25710: END IF;
25711:
25712: OKS_SETUP_UTIL_PUB.copy_hdr_attr
25713: (p_chr_id => p_chr_id --Source Contract Header ID
25714: ,p_new_chr_id => l_to_chr_id --Target Contract Header ID
25715: ,p_duration_match => NULL
25716: ,p_renew_ref_YN => P_Renew_Ref_YN

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

25717: ,x_return_status => l_return_status);
25718: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25719: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25720: FND_LOG.string(FND_LOG.level_statement
25721: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
25722: ,'After call to oks_setup_util_pub.copy_hdr_attr: x_return_status:'||l_return_status
25723: ||' '||SQLERRM
25724: );
25725: END IF;

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

25718: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25719: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25720: FND_LOG.string(FND_LOG.level_statement
25721: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
25722: ,'After call to oks_setup_util_pub.copy_hdr_attr: x_return_status:'||l_return_status
25723: ||' '||SQLERRM
25724: );
25725: END IF;
25726: END IF;

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

26583: /*--Call to copy source contract record in OKS_K_HEADERS_B */
26584: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
26585: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
26586: FND_LOG.string(FND_LOG.level_statement
26587: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
26588: ,'Before call to oks_setup_util_pub.copy_hdr_attr'
26589: ||' P_From_Chr_ID = '||p_from_chr_id
26590: ||',P_To_Chr_ID = '||l_to_chr_id
26591: );

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

26584: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
26585: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
26586: FND_LOG.string(FND_LOG.level_statement
26587: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
26588: ,'Before call to oks_setup_util_pub.copy_hdr_attr'
26589: ||' P_From_Chr_ID = '||p_from_chr_id
26590: ||',P_To_Chr_ID = '||l_to_chr_id
26591: );
26592: END IF;

Line 26595: OKS_SETUP_UTIL_PUB.copy_hdr_attr

26591: );
26592: END IF;
26593: END IF;
26594:
26595: OKS_SETUP_UTIL_PUB.copy_hdr_attr
26596: (p_chr_id => p_from_chr_id --Source Contract Header ID
26597: ,p_new_chr_id => l_to_chr_id --Target Contract Header ID
26598: ,p_duration_match => NULL
26599: ,p_renew_ref_YN => 'N'

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

26600: ,x_return_status => l_return_status);
26601: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
26602: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
26603: FND_LOG.string(FND_LOG.level_statement
26604: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
26605: ,'After call to oks_setup_util_pub.copy_hdr_attr: x_return_status:'||l_return_status
26606: ||' '||SQLERRM
26607: );
26608: END IF;

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

26601: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
26602: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
26603: FND_LOG.string(FND_LOG.level_statement
26604: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'
26605: ,'After call to oks_setup_util_pub.copy_hdr_attr: x_return_status:'||l_return_status
26606: ||' '||SQLERRM
26607: );
26608: END IF;
26609: END IF;