APPS.AMS_CONTCAMPAIGN_PVT dependencies on DUAL

Line 686: FROM dual ;

682: x_return_status OUT NOCOPY VARCHAR2)
683: IS
684: CURSOR c_result_seq IS
685: SELECT ams_trigger_results_s.NEXTVAL
686: FROM dual ;
687:
688: CURSOR c_act_det IS
689: SELECT COUNT(1)
690: FROM ams_trigger_results

Line 1393: l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '

1389: /* Change for SQL Bind Project. this code is commented and replaced
1390: -- No proper indentation in this code!!!!!!!!!!!!!!
1391: -- dbms_OUTPUT.Put_Line('chk2_type = Static val');
1392: IF l_trigger_checks.chk1_to_chk2_operator_type = 'BETWEEN' THEN
1393: l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '
1394: ||l_final_val||' '||l_trigger_checks.chk1_to_chk2_operator_type
1395: ||' '||l_trigger_checks.chk2_low_value||' AND '
1396: ||l_trigger_checks.chk2_high_value ;
1397:

Line 1400: l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '

1396: ||l_trigger_checks.chk2_high_value ;
1397:
1398: ELSE
1399: l_rhs_val := l_trigger_checks.chk2_value ;
1400: l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '
1401: ||l_final_val||' '||l_trigger_checks.chk1_to_chk2_operator_type
1402: ||' '||l_trigger_checks.chk2_value ;
1403: END IF;
1404:

Line 1406: l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '

1402: ||' '||l_trigger_checks.chk2_value ;
1403: END IF;
1404:
1405: ELSE
1406: l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '
1407: ||l_lhs_val||' '||l_trigger_checks.chk1_to_chk2_operator_type
1408: ||' '||l_rhs_val ;
1409: END IF;
1410: -- dbms_output.put_line('SQl STMT : '||l_sql_stmt);

Line 1416: l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '

1412: EXECUTE IMMEDIATE l_sql_stmt INTO l_chk_success ;
1413: */
1414: -- New Replacement code for SQL Bind Project
1415: IF l_trigger_checks.chk1_to_chk2_operator_type = 'BETWEEN' THEN
1416: l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '
1417: ||' :b1 ' || ' BETWEEN '
1418: ||' :b2 AND :b3';
1419: EXECUTE IMMEDIATE l_sql_stmt INTO l_chk_success USING l_final_val, l_trigger_checks.chk2_low_value,
1420: l_trigger_checks.chk2_high_value;

Line 1424: l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '

1420: l_trigger_checks.chk2_high_value;
1421:
1422: ELSE
1423: l_rhs_val := l_trigger_checks.chk2_value;
1424: l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '
1425: ||' :b1 '||l_trigger_checks.chk1_to_chk2_operator_type
1426: ||' :b2' ;
1427: EXECUTE IMMEDIATE l_sql_stmt INTO l_chk_success USING l_final_val, l_rhs_val;
1428: --insert_log_mesg ('Anirban , inside 1st ELSE part of IF l_trigger_checks.chk1_to_chk2_operator_type = BETWEEN THEN : the value of variable l_rhs_val :: '||l_rhs_val);

Line 1435: l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '

1431: END IF;
1432:
1433: ELSE
1434:
1435: l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '
1436: ||' :b1 '||l_trigger_checks.chk1_to_chk2_operator_type
1437: ||' :b2 ' ;
1438:
1439: EXECUTE IMMEDIATE l_sql_stmt INTO l_chk_success USING l_lhs_val, l_rhs_val;