APPS.PSP_EFFORTS_PKG dependencies on PSP_EFFORT_ERRORS

Line 393: INSERT INTO PSP_EFFORT_ERRORS(template_id,person_id,message,prev_effort_report_id,

389: effort_report_id1 IN NUMBER, version_num1 IN NUMBER)
390: --- Error Logging Procedure
391: IS
392: BEGIN
393: INSERT INTO PSP_EFFORT_ERRORS(template_id,person_id,message,prev_effort_report_id,
394: prev_version_num) values (template_id1,person_id1,errmsg,effort_report_id1,version_num1);
395: -- enumerated the INSERT list for bug fix 2307100
396: ---
397: UPDATE PSP_EFFORT_REPORT_TEMPLATES

Line 788: FROM PSP_EFFORT_ERRORS

784: WHERE template_id = a_template_id;
785: ---
786: CURSOR t_errors IS
787: SELECT message
788: FROM PSP_EFFORT_ERRORS
789: WHERE template_id = a_template_id AND
790: person_id = 0
791: UNION
792: SELECT message

Line 793: FROM PSP_EFFORT_ERRORS

789: WHERE template_id = a_template_id AND
790: person_id = 0
791: UNION
792: SELECT message
793: FROM PSP_EFFORT_ERRORS
794: WHERE template_id = a_template_id AND
795: message not like 'Effort Rep%' AND
796: message not like 'Status Code%';
797: ---

Line 976: FROM PSP_EFFORT_ERRORS

972: ---
973: BEGIN
974: SELECT 'x'
975: INTO t_dummy
976: FROM PSP_EFFORT_ERRORS
977: WHERE template_id = a_template_id AND
978: person_id = t_PERS_rec.person_id AND
979: ROWNUM = 1;
980: EXCEPTION