DBA Data[Home] [Help]

APPS.IGW_CREATE_PROPOSAL_PVT dependencies on IGW_PROPOSALS_ALL

Line 25: p_proposal_number IN igw_proposals_all.proposal_number%TYPE,

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,

Line 27: p_proposal_title IN igw_proposals_all.proposal_title%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,

Line 28: p_proposal_status IN igw_proposals_all.proposal_status%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,

Line 30: p_proposal_start_date IN igw_proposals_all.proposal_start_date%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,

Line 31: p_proposal_end_date IN igw_proposals_all.proposal_end_date%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,

Line 32: p_proposal_type_code IN igw_proposals_all.proposal_type_code%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,

Line 34: p_activity_type_code IN igw_proposals_all.activity_type_code%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,
37: p_proposal_category_meaning IN fnd_lookups.meaning%TYPE,
38: p_proposal_purpose_code IN VARCHAR2,

Line 51: p_submitting_organization_id IN igw_proposals_all.submitting_organization_id%TYPE,

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,

Line 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,

Line 57: p_original_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,

Line 59: p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,

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,

Line 62: p_attribute_category IN igw_proposals_all.attribute_category%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,

Line 63: p_attribute1 IN igw_proposals_all.attribute1%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,

Line 64: p_attribute2 IN igw_proposals_all.attribute2%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,

Line 65: p_attribute3 IN igw_proposals_all.attribute3%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,

Line 66: p_attribute4 IN igw_proposals_all.attribute4%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,

Line 67: p_attribute5 IN igw_proposals_all.attribute5%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,

Line 68: p_attribute6 IN igw_proposals_all.attribute6%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,

Line 69: p_attribute7 IN igw_proposals_all.attribute7%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,

Line 70: p_attribute8 IN igw_proposals_all.attribute8%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,

Line 71: p_attribute9 IN igw_proposals_all.attribute9%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,

Line 72: p_attribute10 IN igw_proposals_all.attribute10%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,

Line 73: p_attribute11 IN igw_proposals_all.attribute11%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,

Line 74: p_attribute12 IN igw_proposals_all.attribute12%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,

Line 75: p_attribute13 IN igw_proposals_all.attribute13%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,
79: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,

Line 76: p_attribute14 IN igw_proposals_all.attribute14%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,

Line 77: p_attribute15 IN igw_proposals_all.attribute15%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,

Line 79: x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%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,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2

Line 80: x_proposal_number OUT NOCOPY igw_proposals_all.proposal_number%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
84: );