APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on STANDARD

Line 2229: l_renewal_logic := nvl(fnd_profile.value('OKI_REN_IDENT'),'STANDARD');

2225: /* Balance logic for OI */
2226: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');
2227:
2228: /*Renewal logic for OI */
2229: l_renewal_logic := nvl(fnd_profile.value('OKI_REN_IDENT'),'STANDARD');
2230:
2231: rlog( 'Profile value for balance logic is '|| l_balance_logic , 1 );
2232: rlog( 'Profile value for renewal logic is '|| l_renewal_logic , 1 );
2233:

Line 2646: , CASE l_renewal_logic when 'STANDARD' THEN ilv1.okc_renewal_flag

2642: , ilv1.sl_date_cancelled
2643: , ilv1.sl_date_terminated
2644: , ilv1.sl_creation_date
2645: , ilv1.sl_last_update_date
2646: , CASE l_renewal_logic when 'STANDARD' THEN ilv1.okc_renewal_flag
2647: else NVL2(ilv1.order_number,0,1) END renewal_flag
2648: , CASE WHEN l_renewal_logic= 'ORDERNO' AND ilv1.order_number IS NULL
2649: AND ilv1.okc_renewal_flag = 0 THEN 'Y'
2650: END falsernwlyn

Line 4591: l_renewal_logic := nvl(fnd_profile.value('OKI_REN_IDENT'),'STANDARD');

4587: rlog('Populating Staging Table OKI_DBI_CLE_B_OLD - ' ||fnd_date.date_to_displayDT(sysdate),1) ;
4588: /* Balance logic for OI */
4589: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');
4590: /* Renewal logic for OI */
4591: l_renewal_logic := nvl(fnd_profile.value('OKI_REN_IDENT'),'STANDARD');
4592:
4593: rlog( 'Profile value for balance logic is '|| l_balance_logic , 2 );
4594: rlog( 'Profile value for renewal logic is '|| l_renewal_logic , 2 );
4595:

Line 4914: , CASE when l_renewal_logic = 'STANDARD' THEN

4910: , ilv1.scs_code
4911: , ilv1.sts_code -- line level cancellation code
4912: , ilv1.trn_code
4913: , ilv1.root_lty_code
4914: , CASE when l_renewal_logic = 'STANDARD' THEN
4915: NVL (ilv1.renewal_flag, 0)
4916: ELSE
4917: DECODE(ilv1.order_number,NULL,1,0)
4918: END AS renewal_flag