PACKAGE: APPS.PV_SQL_UTILITY

Source

1 package PV_SQL_UTILITY as
2 /* $Header: pvsqluts.pls 120.3 2005/12/19 16:19:01 pklin ship $*/
3 
4 
5 -- ----------------------------------------------------------------------------
6 -- Public Procedures
7 -- ----------------------------------------------------------------------------
8 
9 FUNCTION pv_lookup (
10    p_lookup_code IN  VARCHAR2,
11    p_lookup_type IN  VARCHAR2
12 )
13 RETURN VARCHAR2;
14 
15 FUNCTION as_lookup (
16    p_lookup_code IN  VARCHAR2,
17    p_lookup_type IN  VARCHAR2
18 )
19 RETURN VARCHAR2;
20 
21 FUNCTION ar_lookup (
22    p_lookup_code IN  VARCHAR2,
23    p_lookup_type IN  VARCHAR2
24 )
25 RETURN VARCHAR2;
26 
27 FUNCTION fnd_lookup_values (
28    p_lookup_code IN  VARCHAR2,
29    p_lookup_type IN  VARCHAR2
30 )
31 RETURN VARCHAR2;
32 
33 FUNCTION as_status (
34    p_status_code IN  VARCHAR2
35 )
36 RETURN VARCHAR2;
37 
38 FUNCTION aso_i_sales_channels (
39    p_sales_channel_code IN  VARCHAR2
40 )
41 RETURN VARCHAR2;
42 
43 FUNCTION as_sales_methodology (
44    p_sales_methodology_id IN  NUMBER
45 )
46 RETURN VARCHAR2;
47 
48 FUNCTION as_sales_stages_all (
49    p_sales_stage_id IN  NUMBER
50 )
51 RETURN VARCHAR2;
52 
53 FUNCTION as_sales_lead_ranks (
54    p_rank_id IN  NUMBER
55 )
56 RETURN VARCHAR2;
57 
58 FUNCTION fnd_territories (
59    p_territory_code IN  VARCHAR2
60 )
61 RETURN VARCHAR2;
62 
63 FUNCTION hz_location_country (
64    p_party_site_id IN  NUMBER
65 )
66 RETURN VARCHAR2;
67 
68 FUNCTION customer_contact_name (
69    p_party_id IN  NUMBER
70 )
71 RETURN VARCHAR2;
72 
73 FUNCTION customer_contact_email (
74    p_party_id IN  NUMBER
75 )
76 RETURN VARCHAR2;
77 
78 FUNCTION customer_contact_phone (
79    p_party_id IN  NUMBER
80 )
81 RETURN VARCHAR2;
82 
83 
84 FUNCTION customer_contact_name2 (
85    p_lead_id IN  NUMBER
86 )
87 RETURN VARCHAR2;
88 
89 FUNCTION customer_contact_email2 (
90    p_lead_id IN  NUMBER
91 )
92 RETURN VARCHAR2;
93 
94 FUNCTION customer_contact_phone2 (
95    p_lead_id IN  NUMBER
96 )
97 RETURN VARCHAR2;
98 
99 
100 FUNCTION referral_customer_address (
101    p_referral_id IN  NUMBER
102 )
103 RETURN VARCHAR2;
104 
105 FUNCTION jtf_resource (
106    p_resource_id IN  NUMBER
107 )
108 RETURN VARCHAR2;
109 
110 FUNCTION party_address (
111    p_party_site_id IN  NUMBER
112 )
113 RETURN VARCHAR2;
114 
115 FUNCTION party_address2 (
116    p_location_id IN  NUMBER
117 )
118 RETURN VARCHAR2;
119 
120 FUNCTION user_has_permission(p_contact_rel_party_id number, p_permission varchar2)
121 RETURN NUMBER;
122 
123 end PV_SQL_UTILITY;