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.OKI_DBI_LOAD_CLEB_PVT dependencies on FND_PROFILE

Line 547: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');

543: rlog ('Secondary Global Currency is - '||NVL(l_sglobal_curr,'Not Defined'),1);
544: rlog ('Annualized Global Currency is - '||l_annu_curr_code,1);
545:
546:
547: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');
548: IF l_salesperson_code IN ('YES', 'DRT') THEN /* Added 'DRT' filter condition, Please refer Bug#5978601 */
549: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');
550: ELSE
551: l_salesperson_code := 'SALESPERSON';

Line 549: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');

545:
546:
547: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');
548: IF l_salesperson_code IN ('YES', 'DRT') THEN /* Added 'DRT' filter condition, Please refer Bug#5978601 */
549: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');
550: ELSE
551: l_salesperson_code := 'SALESPERSON';
552: END IF ;
553:

Line 1101: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');

1097: THEN l_sglobal_curr := BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code;
1098: END IF;
1099: END IF;
1100:
1101: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');
1102: IF l_salesperson_code IN ('YES', 'DRT') THEN /* Added 'DRT' filter condition, Please refer Bug#5978601 */
1103: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');
1104: ELSE
1105: l_salesperson_code := 'SALESPERSON';

Line 1103: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');

1099: END IF;
1100:
1101: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');
1102: IF l_salesperson_code IN ('YES', 'DRT') THEN /* Added 'DRT' filter condition, Please refer Bug#5978601 */
1103: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');
1104: ELSE
1105: l_salesperson_code := 'SALESPERSON';
1106: END IF ;
1107:

Line 2226: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');

2222: -- l_balance_logic:='EVENTDATE';
2223: -- l_balance_logic:=nvl(l_balance_logic,'CONTRDATE');
2224:
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:

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 4574: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');

4570: l_end_date := OKI_DBI_LOAD_CLEB_PVT.g_end_date ;
4571: l_run_date := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
4572: l_dop := 1 ;
4573:
4574: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');
4575: IF l_salesperson_code IN ('YES', 'DRT') THEN /* Added 'DRT' filter condition, Please refer Bug#5978601 */
4576: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');
4577: ELSE
4578: l_salesperson_code := 'SALESPERSON';

Line 4576: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');

4572: l_dop := 1 ;
4573:
4574: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');
4575: IF l_salesperson_code IN ('YES', 'DRT') THEN /* Added 'DRT' filter condition, Please refer Bug#5978601 */
4576: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');
4577: ELSE
4578: l_salesperson_code := 'SALESPERSON';
4579: END IF ;
4580:

Line 4589: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');

4585: EXECUTE IMMEDIATE 'alter session force parallel query';
4586:
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 );

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 5825: fnd_profile.put('CONC_SINGLE_THREAD','N');

5821:
5822: --rlog('Start of the procedure launch_worker for worker ' ||p_worker_no||' at : ' ||
5823: -- fnd_date.date_to_displayDT(SYSDATE),2);
5824:
5825: fnd_profile.put('CONC_SINGLE_THREAD','N');
5826:
5827: DECLARE
5828: l_oki_schema VARCHAR2(30);
5829: l_status VARCHAR2(30);