DBA Data[Home] [Help]

APPS.GMP_CALENDAR_PKG dependencies on DUAL

Line 2820: INTO l_aps_compatible FROM DUAL ;

2816: org_str := NULL ;
2817: in_position := -10 ;
2818:
2819: SELECT MSC_CL_GMP_UTILITY.is_aps_compatible
2820: INTO l_aps_compatible FROM DUAL ;
2821:
2822: IF l_aps_compatible = 1 THEN
2823:
2824: -- sql_stmt := 'SELECT MSC_CL_PULL.get_org_str(' || instance_id || ') FROM dual ' ;

Line 2824: -- sql_stmt := 'SELECT MSC_CL_PULL.get_org_str(' || instance_id || ') FROM dual ' ;

2820: INTO l_aps_compatible FROM DUAL ;
2821:
2822: IF l_aps_compatible = 1 THEN
2823:
2824: -- sql_stmt := 'SELECT MSC_CL_PULL.get_org_str(' || instance_id || ') FROM dual ' ;
2825: -- OPEN c_str FOR sql_stmt ;
2826: --
2827: -- FETCH c_str INTO org_str ;
2828: -- log_message(' String From APS : ' || org_str);

Line 2877: INTO cur_time FROM sys.dual ;

2873: BEGIN
2874: cur_time := NULL ;
2875:
2876: SELECT to_char(sysdate,'DD-MON-RRRR HH24:MI:SS')
2877: INTO cur_time FROM sys.dual ;
2878:
2879: log_message(cur_time);
2880: EXCEPTION
2881: WHEN OTHERS THEN