APPS.PSP_ER_AME dependencies on PSP_EFF_REPORT_APPROVALS

Line 801: insert into psp_eff_report_approvals

797: l_login_id number:= fnd_global.conc_login_id;
798:
799: begin
800: if p_custom_approvals = 'Y' then
801: insert into psp_eff_report_approvals
802: (effort_report_approval_id,
803: effort_report_detail_id,
804: wf_role_name,
805: wf_orig_system_id,

Line 816: values (psp_eff_report_approvals_s.nextval,

812: creation_date,
813: created_by,
814: wf_role_display_name,
815: object_version_number)
816: values (psp_eff_report_approvals_s.nextval,
817: p_effort_report_detail_id,
818: p_wf_role_name,
819: p_wf_orig_system_id,
820: p_wf_orig_system,

Line 832: insert into psp_eff_report_approvals

828: p_approver_display_name,
829: 1);
830: else --- seeded options
831: if p_approval_type in ( 'GPI', 'PMG', 'TMG') then
832: insert into psp_eff_report_approvals
833: (effort_report_approval_id,
834: effort_report_detail_id,
835: wf_role_name,
836: wf_orig_system,

Line 847: select psp_eff_report_approvals_s.nextval,

843: creation_date,
844: created_by,
845: wf_role_display_name,
846: object_version_number)
847: select psp_eff_report_approvals_s.nextval,
848: effort_report_detail_id,
849: p_wf_role_name,
850: p_wf_orig_system,
851: p_wf_orig_system_id,

Line 873: insert into psp_eff_report_approvals

869: --- Employee or Employee/Supervisor
870: elsif p_approval_type in ('EMP', 'ESU') then
871: hr_utility.trace('psperamb-->emp and esu insert');
872: hr_utility.trace('psperamb-->brk attrib ,rquest id,st person, end person==='||p_break_attribute||'='|| p_request_id||'='|| p_start_person||'='|| p_end_person);
873: insert into psp_eff_report_approvals
874: (effort_report_approval_id,
875: effort_report_detail_id,
876: wf_role_name,
877: wf_orig_system,

Line 888: select psp_eff_report_approvals_s.nextval,

884: creation_date,
885: created_by,
886: wf_role_display_name,
887: object_version_number)
888: select psp_eff_report_approvals_s.nextval,
889: effort_report_detail_id,
890: p_wf_role_name,
891: p_wf_orig_system,
892: p_wf_orig_system_id,

Line 913: insert into psp_eff_report_approvals

909:
910: hr_utility.trace('psperamb-->emp and esu insert -1');
911:
912: elsif p_approval_type in ('SUP') then
913: insert into psp_eff_report_approvals
914: (effort_report_approval_id,
915: effort_report_detail_id,
916: wf_role_name,
917: wf_orig_system,

Line 928: select psp_eff_report_approvals_s.nextval,

924: creation_date,
925: created_by,
926: wf_role_display_name,
927: object_version_number)
928: select psp_eff_report_approvals_s.nextval,
929: effort_report_detail_id,
930: p_wf_role_name,
931: p_wf_orig_system,
932: p_wf_orig_system_id,