2: /* $Header: pvxvpams.pls 120.1 2005/08/10 14:37:20 appldev ship $ */
3:
4: TYPE Location_Rec_Type IS RECORD
5: (
6: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
7: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
10: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
3:
4: TYPE Location_Rec_Type IS RECORD
5: (
6: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
7: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
10: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
11: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
4: TYPE Location_Rec_Type IS RECORD
5: (
6: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
7: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
10: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
11: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
12: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
5: (
6: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
7: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
10: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
11: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
12: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
6: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
7: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
10: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
11: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
12: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
7: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
10: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
11: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
12: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
8: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
10: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
11: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
12: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
9: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
10: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
11: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
12: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
10: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
11: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
12: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
18: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
11: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
12: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
18: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
19:
12: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
18: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
19:
20: );
13: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
18: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
19:
20: );
21: G_MISS_Location_Rec Location_Rec_Type;
14: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
18: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
19:
20: );
21: G_MISS_Location_Rec Location_Rec_Type;
22:
22:
23:
24: TYPE Party_Site_Rec_Type IS RECORD
25: (
26: party_site_use_id NUMBER := FND_API.G_MISS_NUM,
27: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
28: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
29: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
23:
24: TYPE Party_Site_Rec_Type IS RECORD
25: (
26: party_site_use_id NUMBER := FND_API.G_MISS_NUM,
27: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
28: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
29: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: LOCATION Location_Rec_Type := G_MISS_Location_Rec,
24: TYPE Party_Site_Rec_Type IS RECORD
25: (
26: party_site_use_id NUMBER := FND_API.G_MISS_NUM,
27: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
28: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
29: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: LOCATION Location_Rec_Type := G_MISS_Location_Rec,
32: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
25: (
26: party_site_use_id NUMBER := FND_API.G_MISS_NUM,
27: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
28: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
29: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: LOCATION Location_Rec_Type := G_MISS_Location_Rec,
32: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
33: party_site_last_update_Date DATE := FND_API.G_MISS_DATE
26: party_site_use_id NUMBER := FND_API.G_MISS_NUM,
27: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
28: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
29: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: LOCATION Location_Rec_Type := G_MISS_Location_Rec,
32: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
33: party_site_last_update_Date DATE := FND_API.G_MISS_DATE
34:
28: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
29: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: LOCATION Location_Rec_Type := G_MISS_Location_Rec,
32: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
33: party_site_last_update_Date DATE := FND_API.G_MISS_DATE
34:
35: );
36: G_MISS_Party_Site_Rec Party_Site_Rec_Type;
29: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: LOCATION Location_Rec_Type := G_MISS_Location_Rec,
32: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
33: party_site_last_update_Date DATE := FND_API.G_MISS_DATE
34:
35: );
36: G_MISS_Party_Site_Rec Party_Site_Rec_Type;
37:
70: );
71:
72: PROCEDURE Create_Party_Site(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
75: p_commit IN VARCHAR2 := FND_API.g_false,
76: p_party_site_rec IN PARTY_SITE_REC_TYPE,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_party_site_id OUT NOCOPY NUMBER,
71:
72: PROCEDURE Create_Party_Site(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
75: p_commit IN VARCHAR2 := FND_API.g_false,
76: p_party_site_rec IN PARTY_SITE_REC_TYPE,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_party_site_id OUT NOCOPY NUMBER,
79: x_msg_count OUT NOCOPY NUMBER,