APPS.IGW_PROPOSAL_APPROVAL dependencies on IGW_PROP_APPROVAL_RUNS

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

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

Line 343: /* update igw_prop_approval_runs

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

Line 423: from igw_prop_approval_runs

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

Line 502: select igw_prop_approval_runs_s.nextval

498: elsif p_rule_type = 'R' then
499: l_map_seq_number := l_map_seq_number + 1;
500: p_rules_found := 'T';
501: if l_map_seq_number = 1 then
502: select igw_prop_approval_runs_s.nextval
503: into p_run_id
504: from dual;
505:
506: open next_run_number;

Line 510: -- insert into igw_prop_approval_runs

506: open next_run_number;
507: fetch next_run_number into l_run_number;
508: close next_run_number;
509:
510: -- insert into igw_prop_approval_runs
511: insert into igw_prop_approval_runs(run_id,proposal_id,
512: run_number,status_code,status_date) values (
513: p_run_id,g_proposal_id,l_run_number,'I',sysdate);
514: end if;

Line 511: insert into igw_prop_approval_runs(run_id,proposal_id,

507: fetch next_run_number into l_run_number;
508: close next_run_number;
509:
510: -- insert into igw_prop_approval_runs
511: insert into igw_prop_approval_runs(run_id,proposal_id,
512: run_number,status_code,status_date) values (
513: p_run_id,g_proposal_id,l_run_number,'I',sysdate);
514: end if;
515: end if;