APPS.IGW_PROP_APPROVALS_PVT dependencies on IGW_PROPOSALS_ALL

Line 88: update igw_proposals_all set proposal_status = 'I' where proposal_id = p_proposal_id;

84: fnd_message.set_name('l_short_name', l_message_name);
85: fnd_msg_pub.add;
86: raise fnd_api.g_exc_unexpected_error;
87: elsif (l_return_status = 'S') then
88: update igw_proposals_all set proposal_status = 'I' where proposal_id = p_proposal_id;
89: end if;
90:
91:
92: -- standard check of p_commit

Line 243: from igw_proposals_all ipa

239: ipa.admin_official_id
240: into l_proposal_status,
241: l_signing_official_id,
242: l_admin_official_id
243: from igw_proposals_all ipa
244: where ipa.proposal_id = g_proposal_id;
245:
246: -- do not rout the proposal if budget is incomplete
247: select complete,

Line 339: -- and igw_proposals_all

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',
343: status_date = sysdate

Line 442: from igw_proposals_all

438:
439: -- get the starting organization_id
440: select lead_organization_id
441: into l_org_id
442: from igw_proposals_all
443: where proposal_id = g_proposal_id;
444: --dbms_output.put_line('Lead Org = '||to_char(l_org_id));
445:
446:

Line 721: from igw_proposals_all

717:
718:
719: cursor get_deadline_date is
720: select to_char(deadline_date,'YYYYMMDD')
721: from igw_proposals_all
722: where proposal_id = g_proposal_id;
723:
724:
725: cursor get_expenditure_cat_type(exp_cat_flag in varchar2) is

Line 742: from igw_proposals_all

738:
739:
740: cursor get_lead_org is
741: select 'x'
742: from igw_proposals_all
743: where proposal_id = g_proposal_id
744: and lead_organization_id = p_rvalue_id;
745:
746: