APPS.OE_PC_CONSTRAINTS_ADMIN_PVT dependencies on DUAL

Line 92: FROM DUAL;

88: -- Padding for single quotes
89: WHILE TRUE LOOP
90: SELECT INSTR(l_value_string,'''',1,from_char)
91: INTO found_char
92: FROM DUAL;
93: EXIT WHEN (found_char=0);
94: l_value_string := substr(l_value_string,1,found_char)||
95: ''''||substr(l_value_string,found_char+1,
96: length(l_value_string));

Line 373: FROM sys.dual

369:
370:
371: CURSOR C_DFK
372: IS SELECT 'Y'
373: FROM sys.dual
374: WHERE EXISTS (SELECT 'EXISTS'
375: FROM oe_pc_rentities_v re
376: WHERE entity_id = p_entity_id
377: AND related_entity_id = p_validation_entity_id);

Line 629: -- FROM sys.dual

625: -- l_valid_count := 0;
626: --
627: -- SELECT count(*)
628: -- INTO x_valid_count
629: -- FROM sys.dual
630: -- WHERE '||p_global_record_name||'.prorated_price = 'YES'
631: --
632: -- x_result := l_valid_count;
633: -- return;

Line 670: -- on this validation template, hence select FROM SYS.DUAL

666: l_vc_sql := l_vc_sql || ' AND a.' || val_rec.column_name ||
667: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
668:
669: -- If first attribute NOT state attribute THEN there are no state attributes
670: -- on this validation template, hence select FROM SYS.DUAL
671: ELSE
672: l_condn_logic_only := TRUE;
673: l_vc_sql := ' IF '||p_global_record_name||'.' || val_rec.column_name ||
674: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;

Line 676: l_vc_sql := ' FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;

672: l_condn_logic_only := TRUE;
673: l_vc_sql := ' IF '||p_global_record_name||'.' || val_rec.column_name ||
674: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
675: /*
676: l_vc_sql := ' FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
677: l_vc_sql := l_vc_sql || ' WHERE '||p_global_record_name||'.' || val_rec.column_name ||
678: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
679: */
680: END IF;

Line 1295: l_sql := l_sql || 'FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;

1291: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1292: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1293: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1294: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1295: l_sql := l_sql || 'FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
1296: l_sql := l_sql || 'WHERE EXISTS (SELECT ''EXISTS'''|| OE_PC_GLOBALS.NEWLINE;
1297: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1298: l_sql := l_sql || ' WHERE u.OBJECT_NAME = :b5 '|| OE_PC_GLOBALS.NEWLINE;
1299: l_sql := l_sql || ' AND u.OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;