21: (
22: p_init_msg_list IN VARCHAR2,
23: p_commit IN VARCHAR2,
24: p_validate_only IN VARCHAR2,
25: p_proposal_number IN igw_proposals_all.proposal_number%TYPE,
26: p_proposal_short_title IN VARCHAR2,
27: p_proposal_title IN igw_proposals_all.proposal_title%TYPE,
28: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
29: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
23: p_commit IN VARCHAR2,
24: p_validate_only IN VARCHAR2,
25: p_proposal_number IN igw_proposals_all.proposal_number%TYPE,
26: p_proposal_short_title IN VARCHAR2,
27: p_proposal_title IN igw_proposals_all.proposal_title%TYPE,
28: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
29: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
30: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
31: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
24: p_validate_only IN VARCHAR2,
25: p_proposal_number IN igw_proposals_all.proposal_number%TYPE,
26: p_proposal_short_title IN VARCHAR2,
27: p_proposal_title IN igw_proposals_all.proposal_title%TYPE,
28: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
29: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
30: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
31: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
32: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
26: p_proposal_short_title IN VARCHAR2,
27: p_proposal_title IN igw_proposals_all.proposal_title%TYPE,
28: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
29: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
30: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
31: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
32: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
33: p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
34: p_activity_type_code IN igw_proposals_all.activity_type_code%type,
27: p_proposal_title IN igw_proposals_all.proposal_title%TYPE,
28: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
29: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
30: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
31: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
32: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
33: p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
34: p_activity_type_code IN igw_proposals_all.activity_type_code%type,
35: p_activity_type_meaning IN fnd_lookups.meaning%TYPE,
28: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
29: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
30: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
31: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
32: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
33: p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
34: p_activity_type_code IN igw_proposals_all.activity_type_code%type,
35: p_activity_type_meaning IN fnd_lookups.meaning%TYPE,
36: p_proposal_category_code IN VARCHAR2,
30: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
31: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
32: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
33: p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
34: p_activity_type_code IN igw_proposals_all.activity_type_code%type,
35: p_activity_type_meaning IN fnd_lookups.meaning%TYPE,
36: p_proposal_category_code IN VARCHAR2,
37: p_proposal_category_meaning IN fnd_lookups.meaning%TYPE,
38: p_proposal_purpose_code IN VARCHAR2,
47: p_signing_official_party_id IN NUMBER,
48: p_signing_official_name IN hz_parties.party_name%TYPE,
49: p_admin_official_party_id IN NUMBER,
50: p_admin_official_name IN hz_parties.party_name%TYPE,
51: p_submitting_organization_id IN igw_proposals_all.submitting_organization_id%TYPE,
52: p_submitting_party_id IN NUMBER,
53: p_lead_organization_id IN NUMBER,
54: p_applicant_unit_name IN VARCHAR2,
55: p_org_id IN igw_proposals_all.org_id%TYPE,
51: p_submitting_organization_id IN igw_proposals_all.submitting_organization_id%TYPE,
52: p_submitting_party_id IN NUMBER,
53: p_lead_organization_id IN NUMBER,
54: p_applicant_unit_name IN VARCHAR2,
55: p_org_id IN igw_proposals_all.org_id%TYPE,
56: p_original_proposal_id IN NUMBER,
57: p_original_proposal_number IN igw_proposals_all.proposal_number%TYPE,
58: p_parent_proposal_id IN NUMBER,
59: p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,
53: p_lead_organization_id IN NUMBER,
54: p_applicant_unit_name IN VARCHAR2,
55: p_org_id IN igw_proposals_all.org_id%TYPE,
56: p_original_proposal_id IN NUMBER,
57: p_original_proposal_number IN igw_proposals_all.proposal_number%TYPE,
58: p_parent_proposal_id IN NUMBER,
59: p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,
60: p_sponsor_application_number IN VARCHAR2,
61: p_external_applicant_unit_id IN NUMBER,
55: p_org_id IN igw_proposals_all.org_id%TYPE,
56: p_original_proposal_id IN NUMBER,
57: p_original_proposal_number IN igw_proposals_all.proposal_number%TYPE,
58: p_parent_proposal_id IN NUMBER,
59: p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,
60: p_sponsor_application_number IN VARCHAR2,
61: p_external_applicant_unit_id IN NUMBER,
62: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
63: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
58: p_parent_proposal_id IN NUMBER,
59: p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,
60: p_sponsor_application_number IN VARCHAR2,
61: p_external_applicant_unit_id IN NUMBER,
62: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
63: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
64: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
65: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
66: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
59: p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,
60: p_sponsor_application_number IN VARCHAR2,
61: p_external_applicant_unit_id IN NUMBER,
62: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
63: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
64: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
65: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
66: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
67: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
60: p_sponsor_application_number IN VARCHAR2,
61: p_external_applicant_unit_id IN NUMBER,
62: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
63: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
64: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
65: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
66: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
67: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
68: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
61: p_external_applicant_unit_id IN NUMBER,
62: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
63: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
64: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
65: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
66: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
67: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
68: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
69: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
62: p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
63: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
64: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
65: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
66: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
67: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
68: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
69: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
70: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
63: p_attribute1 IN igw_proposals_all.attribute1%TYPE,
64: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
65: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
66: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
67: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
68: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
69: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
70: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
71: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
64: p_attribute2 IN igw_proposals_all.attribute2%TYPE,
65: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
66: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
67: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
68: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
69: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
70: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
71: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
72: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
65: p_attribute3 IN igw_proposals_all.attribute3%TYPE,
66: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
67: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
68: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
69: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
70: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
71: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
72: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
73: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
66: p_attribute4 IN igw_proposals_all.attribute4%TYPE,
67: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
68: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
69: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
70: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
71: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
72: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
73: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
74: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
67: p_attribute5 IN igw_proposals_all.attribute5%TYPE,
68: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
69: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
70: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
71: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
72: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
73: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
74: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
75: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
68: p_attribute6 IN igw_proposals_all.attribute6%TYPE,
69: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
70: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
71: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
72: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
73: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
74: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
75: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
76: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
69: p_attribute7 IN igw_proposals_all.attribute7%TYPE,
70: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
71: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
72: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
73: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
74: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
75: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
76: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
77: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
70: p_attribute8 IN igw_proposals_all.attribute8%TYPE,
71: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
72: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
73: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
74: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
75: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
76: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
77: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
78: p_igw_mode IN VARCHAR2,
71: p_attribute9 IN igw_proposals_all.attribute9%TYPE,
72: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
73: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
74: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
75: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
76: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
77: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
78: p_igw_mode IN VARCHAR2,
79: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,
72: p_attribute10 IN igw_proposals_all.attribute10%TYPE,
73: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
74: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
75: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
76: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
77: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
78: p_igw_mode IN VARCHAR2,
79: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,
80: x_proposal_number OUT NOCOPY igw_proposals_all.proposal_number%TYPE,
73: p_attribute11 IN igw_proposals_all.attribute11%TYPE,
74: p_attribute12 IN igw_proposals_all.attribute12%TYPE,
75: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
76: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
77: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
78: p_igw_mode IN VARCHAR2,
79: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,
80: x_proposal_number OUT NOCOPY igw_proposals_all.proposal_number%TYPE,
81: x_return_status OUT NOCOPY VARCHAR2,
75: p_attribute13 IN igw_proposals_all.attribute13%TYPE,
76: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
77: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
78: p_igw_mode IN VARCHAR2,
79: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,
80: x_proposal_number OUT NOCOPY igw_proposals_all.proposal_number%TYPE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2
76: p_attribute14 IN igw_proposals_all.attribute14%TYPE,
77: p_attribute15 IN igw_proposals_all.attribute15%TYPE,
78: p_igw_mode IN VARCHAR2,
79: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,
80: x_proposal_number OUT NOCOPY igw_proposals_all.proposal_number%TYPE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2
84: );