APPS.IGW_PROPOSAL_APPROVAL dependencies on IGW_PROPOSALS_ALL

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

82: -- fnd_message.set_name('l_short_name', l_message_name);
83: -- fnd_msg_pub.add;
84: raise fnd_api.g_exc_unexpected_error;
85: elsif (l_return_status = 'S') then
86: update igw_proposals_all set proposal_status = 'I' where proposal_id = p_proposal_id;
87: end if;
88: */
89:
90: update igw_proposals_all set proposal_status = 'I' where proposal_id = p_proposal_id;

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

86: update igw_proposals_all set proposal_status = 'I' where proposal_id = p_proposal_id;
87: end if;
88: */
89:
90: update igw_proposals_all set proposal_status = 'I' where proposal_id = p_proposal_id;
91: -- standard check of p_commit
92: if fnd_api.to_boolean(p_commit) then
93: commit work;
94: end if;

Line 242: from igw_proposals_all ipa

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

Line 341: -- and igw_proposals_all

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

Line 446: from igw_proposals_all

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

Line 733: from igw_proposals_all

729:
730:
731: cursor get_deadline_date is
732: select to_char(deadline_date,'YYYYMMDD')
733: from igw_proposals_all
734: where proposal_id = g_proposal_id;
735:
736:
737: cursor get_expenditure_cat_type(exp_cat_flag in varchar2) is

Line 754: from igw_proposals_all

750:
751:
752: cursor get_lead_org is
753: select 'x'
754: from igw_proposals_all
755: where proposal_id = g_proposal_id
756: and lead_organization_id = p_rvalue_id;
757:
758: