DBA Data[Home] [Help]

APPS.GMP_CALENDAR_PKG dependencies on DUAL

Line 3270: INTO l_aps_compatible FROM DUAL ;

3266: org_str := NULL ;
3267: in_position := -10 ;
3268:
3269: SELECT MSC_CL_GMP_UTILITY.is_aps_compatible
3270: INTO l_aps_compatible FROM DUAL ;
3271:
3272: IF l_aps_compatible = 1 THEN
3273:
3274: -- sql_stmt := 'SELECT MSC_CL_PULL.get_org_str(' || instance_id || ') FROM dual ' ;

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

3270: INTO l_aps_compatible FROM DUAL ;
3271:
3272: IF l_aps_compatible = 1 THEN
3273:
3274: -- sql_stmt := 'SELECT MSC_CL_PULL.get_org_str(' || instance_id || ') FROM dual ' ;
3275: -- OPEN c_str FOR sql_stmt ;
3276: --
3277: -- FETCH c_str INTO org_str ;
3278: -- log_message(' String From APS : ' || org_str);

Line 3327: INTO cur_time FROM sys.dual ;

3323: BEGIN
3324: cur_time := NULL ;
3325:
3326: SELECT to_char(sysdate,'DD-MON-RRRR HH24:MI:SS')
3327: INTO cur_time FROM sys.dual ;
3328:
3329: log_message(cur_time);
3330: EXCEPTION
3331: WHEN OTHERS THEN