1 PACKAGE Igw_Create_Proposal_Pvt AS
2 --$Header: igwvcprs.pls 120.5 2005/09/12 21:04:57 vmedikon ship $
3
4 ---------------------------------------------------------------------------
5
6 PROCEDURE Get_Proposal_Numbering_Method
7 (x_proposal_numbering_method OUT NOCOPY VARCHAR2);
8
9 ---------------------------------------------------------------------------
10
11 FUNCTION Is_Positive_Integer(p_value VARCHAR2) RETURN BOOLEAN;
12
13 ---------------------------------------------------------------------------
14
15 FUNCTION Get_Party_Id(p_party_type VARCHAR2,p_party_id NUMBER,p_party_name VARCHAR2)
16 RETURN NUMBER;
17
18 ---------------------------------------------------------------------------
19
20 PROCEDURE Create_Proposal
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,
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,
39 p_proposal_purpose_meaning IN fnd_lookups.meaning%TYPE,
40 p_cross_cut_type_code IN VARCHAR2,
41 p_cross_cut_type_meaning IN fnd_lookups.meaning%TYPE,
42 p_proposal_url IN VARCHAR2,
43 p_grantor_id IN NUMBER,
44 p_grantor_name IN VARCHAR2,
45 p_proposal_manager_id IN NUMBER,
46 p_proposal_manager_name IN hz_parties.party_name%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,
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,
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,
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,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2
84 );
85
86 ---------------------------------------------------------------------------
87
88 END Igw_Create_Proposal_Pvt;