[Home] [Help]
PACKAGE: APPS.CSC_UTILS
Source
1 PACKAGE CSC_UTILS AUTHID CURRENT_USER AS
2 /* $Header: cscutils.pls 120.4.12010000.2 2009/04/07 16:27:16 mpathani ship $ */
3
4 TYPE Party_Ref_Cur_Type IS REF CURSOR;
5
6 TYPE Prof_Rec_Type IS RECORD(
7 Group_Id NUMBER
8 );
9
10 TYPE Dashboard_Rec_Type IS RECORD (
11 Group_Id NUMBER,
12 Cust_Party_Id NUMBER,
13 Cust_Party_Type VARCHAR2(2000),
14 Cust_Party_Number NUMBER,
15 Cust_Account_Number VARCHAR2(30), -- added for 7679121 by mpathani
16 Cust_Account_Id NUMBER,
17 Cust_Phn_Country_Code VARCHAR2(100),
18 Cust_Phn_Area_Code VARCHAR2(100),
19 Cust_Phone_Number VARCHAR2(40),
20 Cust_Email VARCHAR2(1000),
21 Cust_URL VARCHAR2(2000),
22 Cust_Address_1 VARCHAR2(2000),
23 Cust_City VARCHAR2(60),
24 Cust_State VARCHAR2(60),
25 Cust_Postal_Code VARCHAR2(60),
26 Cust_Country_Code VARCHAR2(100),
27 Cust_Province VARCHAR2(60),
28 Cust_County VARCHAR2(60),
29 Cust_Location_Id NUMBER,
30 Cust_class_code VARCHAR2(80),
31 Cust_tax_ident VARCHAR2(60),
32 Cust_DOB DATE,
33 Cust_person_iden_type VARCHAR2(80),
34 Cust_pers_identifier VARCHAR2(60),
35 Cont_Party_Id NUMBER,
36 Cont_Party_Type VARCHAR2(2000),
37 Cont_Party_Number NUMBER,
38 Cont_Relationship_Code VARCHAR2(2000),
39 Cont_Phn_Country_Code VARCHAR2(100),
40 Cont_Phn_Area_Code VARCHAR2(100),
41 Cont_Phn_Number VARCHAR2(40),
42 Cont_Email VARCHAR2(1000),
43 Cont_Address_1 VARCHAR2(2000),
44 Cont_City VARCHAR2(60),
45 Cont_State VARCHAR2(60),
46 Cont_Postal_Code VARCHAR2(60),
47 Cont_Country_Code VARCHAR2(100),
48 Cont_Province VARCHAR2(60),
49 Cont_County VARCHAR2(60),
50 Cont_Location_Id NUMBER,
51 Skey_Name VARCHAR2(2000), /* VERIFY */
52 Skey_Value NUMBER,
53 --Cust_Attribute0 VARCHAR2(150),
54 Cust_Attribute1 VARCHAR2(150),
55 Cust_Attribute2 VARCHAR2(150),
56 Cust_Attribute3 VARCHAR2(150),
57 Cust_Attribute4 VARCHAR2(150),
58 Cust_Attribute5 VARCHAR2(150),
59 Cust_Attribute6 VARCHAR2(150),
60 Cust_Attribute7 VARCHAR2(150),
61 Cust_Attribute8 VARCHAR2(150),
62 Cust_Attribute9 VARCHAR2(150),
63 Cust_Attribute10 VARCHAR2(150),
64 Cust_Attribute11 VARCHAR2(150),
65 Cust_Attribute12 VARCHAR2(150),
66 Cust_Attribute13 VARCHAR2(150),
67 Cust_Attribute14 VARCHAR2(150),
68 Cust_Attribute15 VARCHAR2(150),
69 Cust_Attribute16 VARCHAR2(150),
70 Cust_Attribute17 VARCHAR2(150),
71 Cust_Attribute18 VARCHAR2(150),
72 Cust_Attribute19 VARCHAR2(150),
73 Cust_Attribute20 VARCHAR2(150),
74 Cust_Attribute21 VARCHAR2(150),
75 Cust_Attribute22 VARCHAR2(150),
76 Cust_Attribute23 VARCHAR2(150),
77 Cust_Attribute_Category VARCHAR2(150),
78 --Cont_Attribute0 VARCHAR2(150),
79 Cont_Attribute1 VARCHAR2(150),
80 Cont_Attribute2 VARCHAR2(150),
81 Cont_Attribute3 VARCHAR2(150),
82 Cont_Attribute4 VARCHAR2(150),
83 Cont_Attribute5 VARCHAR2(150),
84 Cont_Attribute6 VARCHAR2(150),
85 Cont_Attribute7 VARCHAR2(150),
86 Cont_Attribute8 VARCHAR2(150),
87 Cont_Attribute9 VARCHAR2(150),
88 Cont_Attribute10 VARCHAR2(150),
89 Cont_Attribute11 VARCHAR2(150),
90 Cont_Attribute12 VARCHAR2(150),
91 Cont_Attribute13 VARCHAR2(150),
92 Cont_Attribute14 VARCHAR2(150),
93 Cont_Attribute15 VARCHAR2(150),
94 Cont_Attribute16 VARCHAR2(150),
95 Cont_Attribute17 VARCHAR2(150),
96 Cont_Attribute18 VARCHAR2(150),
97 Cont_Attribute19 VARCHAR2(150),
98 Cont_Attribute20 VARCHAR2(150),
99 Cont_Attribute21 VARCHAR2(150),
100 Cont_Attribute22 VARCHAR2(150),
101 Cont_Attribute23 VARCHAR2(150),
102 Cont_Attribute_Category VARCHAR2(150)
103 );
104
105 /* FUNCTION
106 -- Isvalid_dashboard_group_id
107 -- PURPOSE
108 -- This function checks if a given group_id is
109 -- a dashborad group. If it is a dashboard group
110 -- then the function returns 'Y'. If not, then the
111 -- function returns 'N'.
112 */
113 function Isvalid_dashboard_group_id(p_group_id in csc_prof_groups_b.group_id%TYPE) return boolean;
114
115 END CSC_UTILS;