APPS.PA_TASK_MANAGER dependencies on DUAL

Line 1002: from dual;

998: where person_id = p_task_manager_person_id;
999:
1000: select length(p_message)
1001: into len_msg
1002: from dual;
1003:
1004: tm_log('len_msg:'||len_msg);
1005:
1006: if len_msg > 60 then

Line 1055: FROM DUAL;

1051: l_tmp_str := fnd_message.get_string('PA', 'PA_TM_DATE');
1052:
1053: SELECT ' '||rpad(l_sob_name,30,' ')||lpad(l_tmp_str,75,' ')||sysdate
1054: INTO l_tblock
1055: FROM DUAL;
1056: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1057: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
1058: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1059:

Line 1064: FROM DUAL;

1060: l_tmp_str := fnd_message.get_string('PA', 'PA_TM_RPT_HDR');
1061:
1062: SELECT lpad(l_tmp_str,66+length(l_tmp_str)/2,' ')
1063: INTO l_tblock
1064: FROM DUAL;
1065:
1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
1067: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1068:

Line 1084: FROM DUAL;

1080: l_tmp_str3 := rpad(l_tmp_str3, 60, ' ');
1081:
1082: SELECT l_tmp_str||' '||l_tmp_str2||' '||l_tmp_str3
1083: INTO l_tblock
1084: FROM DUAL;
1085:
1086: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tblock);
1087:
1088: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);