eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.CSI_EXT_CONTACTS_PKG

Source


1 PACKAGE CSI_Ext_Contacts_PKG AUTHID CURRENT_USER AS
2 /*$Header: CSIEXCTS.pls 115.4 2003/02/07 23:46:53 rmamidip noship $*/
3 TYPE CP_Contact_Rec_Type IS RECORD(
4         Customer_Product_Id NUMBER :=FND_API.G_Miss_Num,
5         Cs_Contact_Id         NUMBER :=FND_API.G_Miss_NUM,
6         Contact_Category    VARCHAR2(30) :=FND_API.G_Miss_Num,
7         Contact_Type        NUMBER := FND_API.G_Miss_Num,
8         Contact_Id          NUMBER := FND_API.G_Miss_Num,
9 	primary_flag	      VARCHAR2(1):= FND_API.G_Miss_CHAR,
10 	preferred_flag      VARCHAR2(1):= FND_API.G_Miss_Char,
11 	svc_provider_flag   VARCHAR2(1):= FND_API.G_Miss_Char,
12 	start_date_active   DATE:= FND_API.G_Miss_Date,
13 	end_date_active     DATE:= FND_API.G_Miss_Date,
14 	context	      VARCHAR2(150):= FND_API.G_Miss_CHAR,
15 	attribute1	      VARCHAR2(150):= FND_API.G_Miss_CHAR,
16 	attribute2	      VARCHAR2(150):= FND_API.G_Miss_CHAR,
17 	attribute3 VARCHAR2(150):= FND_API.G_Miss_CHAR,
18 	attribute4 VARCHAR2(150):= FND_API.G_Miss_CHAR,
19 	attribute5 VARCHAR2(150):= FND_API.G_Miss_CHAR,
20 	attribute6 VARCHAR2(150):= FND_API.G_Miss_CHAR,
21 	attribute7 VARCHAR2(150):= FND_API.G_Miss_CHAR,
22 	attribute8 VARCHAR2(150):= FND_API.G_Miss_CHAR,
23 	attribute9 VARCHAR2(150):= FND_API.G_Miss_CHAR,
24 	attribute10 VARCHAR2(150):= FND_API.G_Miss_CHAR,
25 	attribute11 VARCHAR2(150):= FND_API.G_Miss_CHAR,
26 	attribute12 VARCHAR2(150):= FND_API.G_Miss_CHAR,
27 	attribute13 VARCHAR2(150):= FND_API.G_Miss_CHAR,
28 	attribute14 VARCHAR2(150):= FND_API.G_Miss_CHAR,
29 	attribute15 VARCHAR2(150):= FND_API.G_Miss_CHAR);
30 
31 PROCEDURE Insert_Row(
32 	p_customer_Product_id		IN NUMBER,
33 	p_contact_category              IN VARCHAR2,
34 	p_contact_type			IN VARCHAR2,
35 	p_contact_id			IN NUMBER,
36 	p_primary_flag			IN VARCHAR2,
37 	p_preferred_flag		IN VARCHAR2,
38 	p_svc_provider_flag		IN VARCHAR2,
39 	p_start_date_active		IN DATE,
40 	p_end_date_active		IN DATE,
41 	p_context				IN VARCHAR2,
42 	p_attribute1			IN VARCHAR2,
43 	p_attribute2			IN VARCHAR2,
44 	p_attribute3			IN VARCHAR2,
45 	p_attribute4			IN VARCHAR2,
46 	p_attribute5			IN VARCHAR2,
47 	p_attribute6			IN VARCHAR2,
48 	p_attribute7			IN VARCHAR2,
49 	p_attribute8			IN VARCHAR2,
50 	p_attribute9			IN VARCHAR2,
51 	p_attribute10			IN VARCHAR2,
52 	p_attribute11			IN VARCHAR2,
53 	p_attribute12			IN VARCHAR2,
54 	p_attribute13			IN VARCHAR2,
55 	p_attribute14			IN VARCHAR2,
56 	p_attribute15			IN VARCHAR2,
57 	x_cs_contact_id	 OUT NOCOPY NUMBER,
58 	x_return_status	 OUT NOCOPY VARCHAR,
59 	x_msg_count		 OUT NOCOPY NUMBER,
60 	x_msg_data		 OUT NOCOPY VARCHAR,
61 	x_object_version_number OUT NOCOPY NUMBER
62 	);
63 
64 
65 PROCEDURE Lock_Row(
66 --	p_rowid				IN OUT VARCHAR2,
67 	p_cs_contact_id		        IN NUMBER,
68 	p_Customer_Product_id		IN NUMBER,
69 	p_Customer_Id	                IN NUMBER,
70 	p_contact_category              IN VARCHAR2,
71 	p_contact_type			IN VARCHAR2,
72 	p_contact_id			IN NUMBER,
73 	p_primary_flag			IN VARCHAR2,
74 	p_preferred_flag		IN VARCHAR2,
75 	p_svc_provider_flag		IN VARCHAR2,
76 	p_start_date_active		IN DATE,
77 	p_end_date_active		IN DATE,
78 	p_context			IN VARCHAR2,
79 	p_attribute1			IN VARCHAR2,
80 	p_attribute2			IN VARCHAR2,
81 	p_attribute3			IN VARCHAR2,
82 	p_attribute4			IN VARCHAR2,
83 	p_attribute5			IN VARCHAR2,
84 	p_attribute6			IN VARCHAR2,
85 	p_attribute7			IN VARCHAR2,
86 	p_attribute8			IN VARCHAR2,
87 	p_attribute9			IN VARCHAR2,
88 	p_attribute10			IN VARCHAR2,
89 	p_attribute11			IN VARCHAR2,
90 	p_attribute12			IN VARCHAR2,
91 	p_attribute13			IN VARCHAR2,
92 	p_attribute14			IN VARCHAR2,
93 	p_attribute15			IN VARCHAR2,
94 	p_object_version_number	IN NUMBER
95 	);
96 
97 PROCEDURE Update_Row(
98 	p_cs_contact_id		        IN NUMBER,
99 	p_customer_Product_id		IN NUMBER,
100 	p_contact_category              IN VARCHAR2,
101 	p_contact_type			IN VARCHAR2,
102 	p_contact_id			IN NUMBER,
103 	p_primary_flag			IN VARCHAR2,
104 	p_preferred_flag		IN VARCHAR2,
105 	p_svc_provider_flag		IN VARCHAR2,
106 	p_start_date_active		IN DATE,
107 	p_end_date_active		IN DATE,
108 	p_context			IN VARCHAR2,
109 	p_attribute1			IN VARCHAR2,
110 	p_attribute2			IN VARCHAR2,
111 	p_attribute3			IN VARCHAR2,
112 	p_attribute4			IN VARCHAR2,
113 	p_attribute5			IN VARCHAR2,
114 	p_attribute6			IN VARCHAR2,
115 	p_attribute7			IN VARCHAR2,
116 	p_attribute8			IN VARCHAR2,
117 	p_attribute9			IN VARCHAR2,
118 	p_attribute10			IN VARCHAR2,
119 	p_attribute11			IN VARCHAR2,
120 	p_attribute12			IN VARCHAR2,
121 	p_attribute13			IN VARCHAR2,
122 	p_attribute14			IN VARCHAR2,
123 	p_attribute15			IN VARCHAR2,
124 	p_object_version_number	        IN NUMBER,
125 	x_return_status		        OUT NOCOPY VARCHAR,
126 	x_msg_count		 OUT NOCOPY NUMBER,
127 	x_msg_data		 OUT NOCOPY VARCHAR,
128 	x_object_version_number         OUT NOCOPY NUMBER
129 	);
130 
131 PROCEDURE Delete_Row(
132 	x_return_status	 OUT NOCOPY VARCHAR,
133 	x_msg_count	 OUT NOCOPY NUMBER,
134 	x_msg_data	 OUT NOCOPY VARCHAR,
135 	p_cs_contact_id		IN NUMBER,
136         P_Object_Version_Number IN NUMBER
137 	);
138 end csi_ext_contacts_pkg;