DBA Data[Home] [Help]

APPS.CSI_EXT_CONTACTS_PKG dependencies on FND_API

Line 4: Customer_Product_Id NUMBER :=FND_API.G_Miss_Num,

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,

Line 5: Cs_Contact_Id NUMBER :=FND_API.G_Miss_NUM,

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,

Line 6: Contact_Category VARCHAR2(30) :=FND_API.G_Miss_Num,

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,

Line 7: Contact_Type NUMBER := FND_API.G_Miss_Num,

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,

Line 8: Contact_Id NUMBER := FND_API.G_Miss_Num,

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,

Line 9: primary_flag VARCHAR2(1):= FND_API.G_Miss_CHAR,

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,

Line 10: preferred_flag VARCHAR2(1):= FND_API.G_Miss_Char,

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,

Line 11: svc_provider_flag VARCHAR2(1):= FND_API.G_Miss_Char,

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,

Line 12: start_date_active DATE:= FND_API.G_Miss_Date,

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,

Line 13: end_date_active DATE:= FND_API.G_Miss_Date,

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,

Line 14: context VARCHAR2(150):= 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,

Line 15: attribute1 VARCHAR2(150):= 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,

Line 16: attribute2 VARCHAR2(150):= 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,

Line 17: attribute3 VARCHAR2(150):= FND_API.G_Miss_CHAR,

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,

Line 18: attribute4 VARCHAR2(150):= FND_API.G_Miss_CHAR,

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,

Line 19: attribute5 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,

Line 20: attribute6 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,

Line 21: attribute7 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,

Line 22: attribute8 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,

Line 23: attribute9 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,

Line 24: attribute10 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,

Line 25: attribute11 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);

Line 26: attribute12 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:

Line 27: attribute13 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(

Line 28: attribute14 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,

Line 29: attribute15 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,