DBA Data[Home] [Help]

APPS.OKI_BUT_PVT dependencies on JTFB_DCF

Line 46: l_object_refreshed := jtfb_dcf.get_parameter_value(p_name,'P_OBJECT_REFRESHED');

42: l_object_refreshed VARCHAR2(30) := NULL ;
43:
44: BEGIN
45: -- Get name of the object that that has been refreshed
46: l_object_refreshed := jtfb_dcf.get_parameter_value(p_name,'P_OBJECT_REFRESHED');
47:
48: OPEN rfh_csr( l_object_refreshed ) ;
49: FETCH rfh_csr INTO l_month, l_time ;
50: IF (rfh_csr%NOTFOUND) OR (l_month is NULL) THEN

Line 455: l_context := jtfb_dcf.get_parameter_value( p_param, 'pContext') ;

451: l_code VARCHAR2(30) ;
452: l_title_value VARCHAR2(60);
453:
454: BEGIN
455: l_context := jtfb_dcf.get_parameter_value( p_param, 'pContext') ;
456: l_code := substr(l_context, (instr(l_context, ':', 1, 1 ) + 1 ),
457: ((instr(l_context, ':', 1, 2 )) - (instr(l_context, ':', 1, 1 ) + 1 ))) ;
458: IF l_code = 'BACTK' THEN
459: l_title_value := 'Beginning active contracts by organization ' ;

Line 500: l_context := jtfb_dcf.get_parameter_value( p_param, 'pContext') ;

496: ;
497: rec_l_get_org_name_csr l_get_org_name_csr%ROWTYPE ;
498:
499: BEGIN
500: l_context := jtfb_dcf.get_parameter_value( p_param, 'pContext') ;
501:
502: l_code := substr(l_context, (instr(l_context, ':', 1, 1 ) + 1 ),
503: ((instr(l_context, ':', 1, 2 )) - (instr(l_context, ':', 1, 1 ) + 1 ))) ;
504: l_org_id := substr(l_context, (instr(l_context, ':', 1, 3 ) + 1 )) ;

Line 546: l_bin_name := jtfb_dcf.get_parameter_value(p_param, 'P_BIN_NAME') ;

542: l_title_suffix VARCHAR2(100) := NULL ;
543: l_title_var1 VARCHAR2(100) := NULL ;
544:
545: BEGIN
546: l_bin_name := jtfb_dcf.get_parameter_value(p_param, 'P_BIN_NAME') ;
547: l_param1 := jtfb_dcf.get_parameter_value(p_param, 'P_SCALING_FACTOR') ;
548: IF l_bin_name = 'OKI_EXPIRATION_GRAPH' THEN
549: -- set up for expiration graph title
550: l_title_prefix := 'Expiration to Renewal Graph' ;

Line 547: l_param1 := jtfb_dcf.get_parameter_value(p_param, 'P_SCALING_FACTOR') ;

543: l_title_var1 VARCHAR2(100) := NULL ;
544:
545: BEGIN
546: l_bin_name := jtfb_dcf.get_parameter_value(p_param, 'P_BIN_NAME') ;
547: l_param1 := jtfb_dcf.get_parameter_value(p_param, 'P_SCALING_FACTOR') ;
548: IF l_bin_name = 'OKI_EXPIRATION_GRAPH' THEN
549: -- set up for expiration graph title
550: l_title_prefix := 'Expiration to Renewal Graph' ;
551: IF l_param1 = 1000 THEN

Line 588: g_scaling_factor := jtfb_dcf.get_parameter_value(p_param, 'P_SCALING_FACTOR') ;

584: ( p_param IN VARCHAR2
585: ) IS
586: l_message VARCHAR2(50) := NULL ;
587: BEGIN
588: g_scaling_factor := jtfb_dcf.get_parameter_value(p_param, 'P_SCALING_FACTOR') ;
589: END set_scaling_factor ;
590: --------------------------------------------------------------------------------
591: -- Function to get the default value for the build summary date.
592: