PACKAGE: APPS.IGW_PROP

Source

1 PACKAGE igw_prop AUTHID CURRENT_USER AS
2 --$Header: igwprcps.pls 115.22 2002/11/14 18:49:18 vmedikon ship $
3 
4 
5    PROCEDURE get_business_group(
6                 o_business_group_id   out NOCOPY number,
7                 o_business_group_name out NOCOPY varchar2 );
8 
9    PRAGMA restrict_references( get_business_group, WNDS, WNPS );
10 
11    PROCEDURE get_signing_official(
12                 i_organization_id       in  number,
13                 o_signing_official_id   out NOCOPY number,
14                 o_signing_official_name out NOCOPY varchar2 );
15 
16    PRAGMA restrict_references( get_signing_official, WNDS, WNPS );
17 
18    FUNCTION get_admin_official_id( i_organization_id number )
19    RETURN number;
20 
21    PRAGMA restrict_references( get_admin_official_id, WNDS, WNPS );
22 
23    FUNCTION get_user_name( p_person_id number )
24    RETURN varchar2;
25 
26    PRAGMA restrict_references( get_user_name, WNDS, WNPS );
27 
28    FUNCTION get_pi_full_name( p_proposal_id number )
29    RETURN varchar2;
30 
31   FUNCTION get_pi_formatted_name( p_proposal_id number )
32    RETURN varchar2;
33 
34    PRAGMA restrict_references( get_pi_full_name, WNDS, WNPS );
35 
36 
37    FUNCTION get_lookup_meaning( p_lookup_type varchar2, p_lookup_code varchar2 )
38    RETURN varchar2;
39 
40    PRAGMA restrict_references( get_lookup_meaning, WNDS );
41 
42 
43    FUNCTION get_narrative_status( p_proposal_id  number )
44    RETURN varchar2;
45 
46    PRAGMA restrict_references( get_narrative_status, WNDS, WNPS );
47 
48 
49    FUNCTION get_major_subdivision( p_organization_id  number )
50    RETURN varchar2;
51 
52    PRAGMA restrict_references( get_major_subdivision, WNDS );
53 
54    FUNCTION is_proposal_signing_official( p_proposal_id number, p_user_id number )
55    RETURN varchar2;
56 
57    PRAGMA restrict_references( is_proposal_signing_official, WNDS, WNPS );
58 
59    FUNCTION get_top_parent_org_name( p_organization_id  number )
60    RETURN varchar2;
61 
62 
63    PROCEDURE ins_prop_user_role( p_proposal_id number,
64                                  p_user_id     number,
65                                  p_role_id     number );
66 
67    PRAGMA restrict_references( ins_prop_user_role, WNPS );
68 
69    PROCEDURE del_prop_user_role( p_proposal_id number,
70                                  p_user_id     number,
71                                  p_role_id     number );
72 
73    PRAGMA restrict_references( del_prop_user_role, WNPS );
74 
75    PROCEDURE copy_proposal_all(
76                 i_old_proposal_id      IN  number,
77                 i_new_proposal_id      IN  number,
78                 i_new_proposal_number  IN  varchar2,
79                 i_budget_copy_flag     IN  varchar2,
80                 i_budget_version_id    IN  number,
81                 i_narrative_copy_flag  IN  varchar2,
82                 o_error_message        OUT NOCOPY varchar2,
83                 o_return_status        OUT NOCOPY varchar2 );
84 
85 
86    PROCEDURE set_component_status(
87                 i_component_name IN varchar2,
88                 i_proposal_id    IN number,
89                 i_value          IN varchar2 );
90 
91    PRAGMA restrict_references( set_component_status, WNPS );
92 
93 
94 END igw_prop;