eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGW_CREATE_PROPOSAL_PVT dependencies on IGW_PROPOSALS_ALL

Line 83: l_proposal_id Igw_Proposals_All.Proposal_Id%TYPE;

79: RETURN NUMBER IS
80:
81: l_api_name CONSTANT VARCHAR2(30) := 'Get_Proposal_Id';
82:
83: l_proposal_id Igw_Proposals_All.Proposal_Id%TYPE;
84:
85: BEGIN
86:
87: null;

Line 98: p_proposal_number IN igw_proposals_all.proposal_number%TYPE,

94: (
95: p_init_msg_list IN VARCHAR2,
96: p_commit IN VARCHAR2,
97: p_validate_only IN VARCHAR2,
98: p_proposal_number IN igw_proposals_all.proposal_number%TYPE,
99: p_proposal_short_title IN VARCHAR2,
100: p_proposal_title IN igw_proposals_all.proposal_title%TYPE,
101: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
102: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,

Line 100: p_proposal_title IN igw_proposals_all.proposal_title%TYPE,

96: p_commit IN VARCHAR2,
97: p_validate_only IN VARCHAR2,
98: p_proposal_number IN igw_proposals_all.proposal_number%TYPE,
99: p_proposal_short_title IN VARCHAR2,
100: p_proposal_title IN igw_proposals_all.proposal_title%TYPE,
101: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
102: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
103: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
104: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,

Line 101: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,

97: p_validate_only IN VARCHAR2,
98: p_proposal_number IN igw_proposals_all.proposal_number%TYPE,
99: p_proposal_short_title IN VARCHAR2,
100: p_proposal_title IN igw_proposals_all.proposal_title%TYPE,
101: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
102: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
103: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
104: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
105: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,

Line 103: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,

99: p_proposal_short_title IN VARCHAR2,
100: p_proposal_title IN igw_proposals_all.proposal_title%TYPE,
101: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
102: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
103: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
104: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
105: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
106: p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
107: p_activity_type_code IN igw_proposals_all.activity_type_code%type,

Line 104: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,

100: p_proposal_title IN igw_proposals_all.proposal_title%TYPE,
101: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
102: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
103: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
104: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
105: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
106: p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
107: p_activity_type_code IN igw_proposals_all.activity_type_code%type,
108: p_activity_type_meaning IN fnd_lookups.meaning%TYPE,

Line 105: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,

101: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
102: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
103: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
104: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
105: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
106: p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
107: p_activity_type_code IN igw_proposals_all.activity_type_code%type,
108: p_activity_type_meaning IN fnd_lookups.meaning%TYPE,
109: p_proposal_category_code IN VARCHAR2,

Line 107: p_activity_type_code IN igw_proposals_all.activity_type_code%type,

103: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
104: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
105: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
106: p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
107: p_activity_type_code IN igw_proposals_all.activity_type_code%type,
108: p_activity_type_meaning IN fnd_lookups.meaning%TYPE,
109: p_proposal_category_code IN VARCHAR2,
110: p_proposal_category_meaning IN fnd_lookups.meaning%TYPE,
111: p_proposal_purpose_code IN VARCHAR2,

Line 124: p_submitting_organization_id IN igw_proposals_all.submitting_organization_id%TYPE,

120: p_signing_official_party_id IN NUMBER,
121: p_signing_official_name IN hz_parties.party_name%TYPE,
122: p_admin_official_party_id IN NUMBER,
123: p_admin_official_name IN hz_parties.party_name%TYPE,
124: p_submitting_organization_id IN igw_proposals_all.submitting_organization_id%TYPE,
125: p_submitting_party_id IN NUMBER,
126: p_lead_organization_id IN NUMBER,
127: p_applicant_unit_name IN VARCHAR2,
128: p_org_id IN igw_proposals_all.org_id%TYPE,

Line 128: p_org_id IN igw_proposals_all.org_id%TYPE,

124: p_submitting_organization_id IN igw_proposals_all.submitting_organization_id%TYPE,
125: p_submitting_party_id IN NUMBER,
126: p_lead_organization_id IN NUMBER,
127: p_applicant_unit_name IN VARCHAR2,
128: p_org_id IN igw_proposals_all.org_id%TYPE,
129: p_original_proposal_id IN NUMBER,
130: p_original_proposal_number IN igw_proposals_all.proposal_number%TYPE,
131: p_parent_proposal_id IN NUMBER,
132: p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,

Line 130: p_original_proposal_number IN igw_proposals_all.proposal_number%TYPE,

126: p_lead_organization_id IN NUMBER,
127: p_applicant_unit_name IN VARCHAR2,
128: p_org_id IN igw_proposals_all.org_id%TYPE,
129: p_original_proposal_id IN NUMBER,
130: p_original_proposal_number IN igw_proposals_all.proposal_number%TYPE,
131: p_parent_proposal_id IN NUMBER,
132: p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,
133: p_sponsor_application_number IN VARCHAR2,
134: p_external_applicant_unit_id IN NUMBER,

Line 132: p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,

128: p_org_id IN igw_proposals_all.org_id%TYPE,
129: p_original_proposal_id IN NUMBER,
130: p_original_proposal_number IN igw_proposals_all.proposal_number%TYPE,
131: p_parent_proposal_id IN NUMBER,
132: p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,
133: p_sponsor_application_number IN VARCHAR2,
134: p_external_applicant_unit_id IN NUMBER,
135: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
136: p_attribute1 IN igw_proposals_all.attribute1%TYPE,

Line 135: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,

131: p_parent_proposal_id IN NUMBER,
132: p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,
133: p_sponsor_application_number IN VARCHAR2,
134: p_external_applicant_unit_id IN NUMBER,
135: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
136: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
137: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
138: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
139: p_attribute4 IN igw_proposals_all.attribute4%TYPE,

Line 136: p_attribute1 IN igw_proposals_all.attribute1%TYPE,

132: p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,
133: p_sponsor_application_number IN VARCHAR2,
134: p_external_applicant_unit_id IN NUMBER,
135: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
136: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
137: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
138: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
139: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
140: p_attribute5 IN igw_proposals_all.attribute5%TYPE,

Line 137: p_attribute2 IN igw_proposals_all.attribute2%TYPE,

133: p_sponsor_application_number IN VARCHAR2,
134: p_external_applicant_unit_id IN NUMBER,
135: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
136: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
137: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
138: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
139: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
140: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
141: p_attribute6 IN igw_proposals_all.attribute6%TYPE,

Line 138: p_attribute3 IN igw_proposals_all.attribute3%TYPE,

134: p_external_applicant_unit_id IN NUMBER,
135: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
136: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
137: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
138: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
139: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
140: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
141: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
142: p_attribute7 IN igw_proposals_all.attribute7%TYPE,

Line 139: p_attribute4 IN igw_proposals_all.attribute4%TYPE,

135: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
136: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
137: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
138: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
139: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
140: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
141: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
142: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
143: p_attribute8 IN igw_proposals_all.attribute8%TYPE,

Line 140: p_attribute5 IN igw_proposals_all.attribute5%TYPE,

136: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
137: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
138: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
139: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
140: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
141: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
142: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
143: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
144: p_attribute9 IN igw_proposals_all.attribute9%TYPE,

Line 141: p_attribute6 IN igw_proposals_all.attribute6%TYPE,

137: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
138: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
139: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
140: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
141: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
142: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
143: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
144: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
145: p_attribute10 IN igw_proposals_all.attribute10%TYPE,

Line 142: p_attribute7 IN igw_proposals_all.attribute7%TYPE,

138: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
139: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
140: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
141: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
142: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
143: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
144: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
145: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
146: p_attribute11 IN igw_proposals_all.attribute11%TYPE,

Line 143: p_attribute8 IN igw_proposals_all.attribute8%TYPE,

139: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
140: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
141: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
142: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
143: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
144: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
145: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
146: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
147: p_attribute12 IN igw_proposals_all.attribute12%TYPE,

Line 144: p_attribute9 IN igw_proposals_all.attribute9%TYPE,

140: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
141: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
142: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
143: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
144: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
145: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
146: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
147: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
148: p_attribute13 IN igw_proposals_all.attribute13%TYPE,

Line 145: p_attribute10 IN igw_proposals_all.attribute10%TYPE,

141: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
142: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
143: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
144: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
145: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
146: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
147: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
148: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
149: p_attribute14 IN igw_proposals_all.attribute14%TYPE,

Line 146: p_attribute11 IN igw_proposals_all.attribute11%TYPE,

142: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
143: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
144: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
145: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
146: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
147: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
148: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
149: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
150: p_attribute15 IN igw_proposals_all.attribute15%TYPE,

Line 147: p_attribute12 IN igw_proposals_all.attribute12%TYPE,

143: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
144: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
145: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
146: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
147: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
148: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
149: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
150: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
151: p_igw_mode IN VARCHAR2,

Line 148: p_attribute13 IN igw_proposals_all.attribute13%TYPE,

144: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
145: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
146: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
147: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
148: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
149: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
150: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
151: p_igw_mode IN VARCHAR2,
152: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,

Line 149: p_attribute14 IN igw_proposals_all.attribute14%TYPE,

145: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
146: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
147: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
148: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
149: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
150: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
151: p_igw_mode IN VARCHAR2,
152: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,
153: x_proposal_number OUT NOCOPY igw_proposals_all.proposal_number%TYPE,

Line 150: p_attribute15 IN igw_proposals_all.attribute15%TYPE,

146: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
147: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
148: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
149: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
150: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
151: p_igw_mode IN VARCHAR2,
152: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,
153: x_proposal_number OUT NOCOPY igw_proposals_all.proposal_number%TYPE,
154: x_return_status OUT NOCOPY VARCHAR2,

Line 152: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,

148: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
149: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
150: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
151: p_igw_mode IN VARCHAR2,
152: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,
153: x_proposal_number OUT NOCOPY igw_proposals_all.proposal_number%TYPE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2

Line 153: x_proposal_number OUT NOCOPY igw_proposals_all.proposal_number%TYPE,

149: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
150: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
151: p_igw_mode IN VARCHAR2,
152: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,
153: x_proposal_number OUT NOCOPY igw_proposals_all.proposal_number%TYPE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2
157: ) IS