[Home] [Help]
PACKAGE: APPS.IGW_REPORT_PROCESSING
Source
1 PACKAGE IGW_REPORT_PROCESSING AUTHID CURRENT_USER as
2 -- $Header: igwburps.pls 115.22 2002/11/15 00:28:39 ashkumar ship $
3 G_START_PERIOD NUMBER(10):=1;
4 G_PROPOSAL_ID NUMBER(15):=0;
5 G_VERSION_ID NUMBER(15):=0;
6 G_PROPOSAL_FORM_NUMBER VARCHAR2(30);
7
8
9 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGW_REPORT_PROCESSING';
10
11 PROCEDURE create_reporting_data( p_proposal_id NUMBER
12 ,p_proposal_form_number VARCHAR2
13 ,x_return_status OUT NOCOPY VARCHAR2
14 ,x_msg_data OUT NOCOPY VARCHAR2
15 ,x_msg_count OUT NOCOPY NUMBER);
16
17 PROCEDURE create_itemized_budget( p_proposal_id NUMBER
18 ,p_proposal_form_number VARCHAR2
19 ,x_return_status OUT NOCOPY VARCHAR2
20 ,x_msg_data OUT NOCOPY VARCHAR2
21 ,x_msg_count OUT NOCOPY NUMBER);
22
23 PROCEDURE create_base_rate (p_proposal_id NUMBER
24 ,p_proposal_form_number VARCHAR2
25 ,x_return_status OUT NOCOPY VARCHAR2
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ,x_msg_count OUT NOCOPY NUMBER);
28
29 PROCEDURE create_budget_justification (p_proposal_id NUMBER
30 ,p_proposal_form_number VARCHAR2
31 ,x_return_status OUT NOCOPY VARCHAR2
32 ,x_msg_data OUT NOCOPY VARCHAR2);
33
34 PROCEDURE dump_justification (p_proposal_id NUMBER
35 ,p_proposal_form_number VARCHAR2
36 ,x_return_status OUT NOCOPY VARCHAR2
37 ,x_msg_data OUT NOCOPY VARCHAR2);
38
39
40 PROCEDURE create_q_explanation (p_proposal_form_number VARCHAR2
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_msg_data OUT NOCOPY VARCHAR2);
43
44 FUNCTION get_final_version(p_proposal_id NUMBER) RETURN NUMBER;
45
46
47 FUNCTION get_period_total(p_budget_category_code VARCHAR2
48 , p_period_id NUMBER) RETURN NUMBER;
49
50 Function get_period_id RETURN NUMBER;
51 pragma restrict_references(get_period_id, wnds, wnps);
52
53 Function get_proposal_id RETURN NUMBER;
54 pragma restrict_references(get_proposal_id, wnds, wnps);
55
56 Function get_version_id RETURN NUMBER;
57 pragma restrict_references(get_version_id, wnds, wnps);
58
59 Function get_proposal_role(p_role_code VARCHAR2) RETURN VARCHAR2;
60 --pragma restrict_references(get_proposal_role, wnds, wnps);
61 --pragma restrict_references(get_proposal_role, wnps);
62
63 --used in setup budget category hierarchy form
64 Function get_category(p_category_code VARCHAR2
65 , p_proposal_form_number VARCHAR2) RETURN VARCHAR2;
66
67 Function get_abstract(p_proposal_id in INTEGER,
68 p_abstract_type_code in INTEGER) RETURN VARCHAR2;
69 pragma restrict_references(get_abstract, wnds, wnps);
70
71
72 PROCEDURE get_answer(p_proposal_id in INTEGER,
73 P_question_no in VARCHAR2,
74 p_person_id in INTEGER,
75 p_party_id in INTEGER,
76 p_organization_id in INTEGER,
77 p_response1 out NOCOPY VARCHAR2,
78 p_response2 out NOCOPY VARCHAR2);
79
80 FUNCTION get_response(p_proposal_id in INTEGER,
81 P_question_no in VARCHAR2,
82 p_person_id in INTEGER default null,
83 p_party_id in INTEGER,
84 p_organization_id in INTEGER default null) RETURN VARCHAR2;
85 pragma restrict_references(get_response, wnds, wnps);
86
87 FUNCTION get_explanation(p_proposal_id in INTEGER,
88 P_question_no in VARCHAR2,
89 p_person_id in INTEGER default null,
90 p_party_id in INTEGER,
91 p_organization_id in INTEGER default null) RETURN VARCHAR2;
92 pragma restrict_references(get_explanation, wnds, wnps);
93
94
95 FUNCTION get_subjects(p_proposal_id in INTEGER,
96 p_study_title_id INTEGER,
97 p_subject_race in VARCHAR2,
98 p_subject_gender in VARCHAR2) RETURN INTEGER;
99 pragma restrict_references(get_subjects, wnds, wnps);
100
101 FUNCTION get_job_name(person_id_v in NUMBER) RETURN VARCHAR2;
102 pragma restrict_references(get_job_name, wnds);
103
104
105 FUNCTION get_phone_number(v_person_id in NUMBER,
106 v_phone_type in VARCHAR2) RETURN VARCHAR2;
107 pragma restrict_references(get_phone_number, wnds, wnps);
108
109
110 FUNCTION get_person_Degrees(person_id_p in number,
111 party_id_p in number,
112 proposal_id_p in number) RETURN VARCHAR2;
113 pragma restrict_references(get_person_degrees, wnds, wnps);
114
115
116 FUNCTION get_org_type(p_org_id in integer,
117 p_org_type1 in varchar2,
118 p_org_type2 in varchar2 default null,
119 p_org_type3 in varchar2 default null) RETURN VARCHAR2;
120 pragma restrict_references(get_org_type, wnds, wnps);
121
122 FUNCTION get_org_party_name(p_party_id in number, p_org_id in number) RETURN VARCHAR2;
123 pragma restrict_references(get_org_party_name, wnds, wnps);
124
125
126 END IGW_REPORT_PROCESSING;