APPS.IGW_PROP_APPROVALS_PVT dependencies on IGW_PROP_APPROVAL_RUNS

Line 338: -- update the status to I (Approval In-Progress) in igw_prop_approval_runs

334: end if;
335:
336: p_return_status := 'S';
337:
338: -- update the status to I (Approval In-Progress) in igw_prop_approval_runs
339: -- and igw_proposals_all
340:
341: /* update igw_prop_approval_runs
342: set status_code = 'I',

Line 341: /* update igw_prop_approval_runs

337:
338: -- update the status to I (Approval In-Progress) in igw_prop_approval_runs
339: -- and igw_proposals_all
340:
341: /* update igw_prop_approval_runs
342: set status_code = 'I',
343: status_date = sysdate
344: where run_id = l_run_id;
345:

Line 419: from igw_prop_approval_runs

415: and pom.map_id = l_map_id;
416:
417: cursor next_run_number is
418: select nvl(max(run_number),0) + 1
419: from igw_prop_approval_runs
420: where proposal_id = g_proposal_id;
421:
422:
423: cursor user_exists is

Line 495: select igw_prop_approval_runs_s.nextval

491: elsif p_rule_type = 'R' then
492: l_map_seq_number := l_map_seq_number + 1;
493: p_rules_found := 'T';
494: if l_map_seq_number = 1 then
495: select igw_prop_approval_runs_s.nextval
496: into p_run_id
497: from dual;
498:
499: open next_run_number;

Line 503: -- insert into igw_prop_approval_runs

499: open next_run_number;
500: fetch next_run_number into l_run_number;
501: close next_run_number;
502:
503: -- insert into igw_prop_approval_runs
504: insert into igw_prop_approval_runs(run_id,proposal_id,
505: run_number,status_code,status_date) values (
506: p_run_id,g_proposal_id,l_run_number,'I',sysdate);
507: end if;

Line 504: insert into igw_prop_approval_runs(run_id,proposal_id,

500: fetch next_run_number into l_run_number;
501: close next_run_number;
502:
503: -- insert into igw_prop_approval_runs
504: insert into igw_prop_approval_runs(run_id,proposal_id,
505: run_number,status_code,status_date) values (
506: p_run_id,g_proposal_id,l_run_number,'I',sysdate);
507: end if;
508: end if;