APPS.ASO_PARTY_INT dependencies on FND_API

Line 32: PARTY_ID NUMBER := FND_API.G_MISS_NUM,

28:
29:
30: TYPE Party_Rec_Type IS RECORD
31: (
32: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
33: PARTY_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
35: CURR_FY_POTENTIAL_REVENUE NUMBER := FND_API.G_MISS_NUM,
36: NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,

Line 33: PARTY_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

29:
30: TYPE Party_Rec_Type IS RECORD
31: (
32: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
33: PARTY_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
35: CURR_FY_POTENTIAL_REVENUE NUMBER := FND_API.G_MISS_NUM,
36: NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
37: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 34: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,

30: TYPE Party_Rec_Type IS RECORD
31: (
32: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
33: PARTY_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
35: CURR_FY_POTENTIAL_REVENUE NUMBER := FND_API.G_MISS_NUM,
36: NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
37: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: PERSON_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 35: CURR_FY_POTENTIAL_REVENUE NUMBER := FND_API.G_MISS_NUM,

31: (
32: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
33: PARTY_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
35: CURR_FY_POTENTIAL_REVENUE NUMBER := FND_API.G_MISS_NUM,
36: NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
37: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: PERSON_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 36: NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,

32: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
33: PARTY_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
35: CURR_FY_POTENTIAL_REVENUE NUMBER := FND_API.G_MISS_NUM,
36: NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
37: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: PERSON_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
40: PERSON_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 37: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,

33: PARTY_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
35: CURR_FY_POTENTIAL_REVENUE NUMBER := FND_API.G_MISS_NUM,
36: NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
37: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: PERSON_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
40: PERSON_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: PERSON_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 38: PERSON_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,

34: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
35: CURR_FY_POTENTIAL_REVENUE NUMBER := FND_API.G_MISS_NUM,
36: NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
37: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: PERSON_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
40: PERSON_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: PERSON_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
42: DATE_OF_BIRTH DATE := FND_API.G_MISS_DATE,

Line 39: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,

35: CURR_FY_POTENTIAL_REVENUE NUMBER := FND_API.G_MISS_NUM,
36: NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
37: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: PERSON_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
40: PERSON_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: PERSON_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
42: DATE_OF_BIRTH DATE := FND_API.G_MISS_DATE,
43: PERSONAL_INCOME NUMBER := FND_API.G_MISS_NUM,

Line 40: PERSON_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,

36: NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
37: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: PERSON_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
40: PERSON_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: PERSON_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
42: DATE_OF_BIRTH DATE := FND_API.G_MISS_DATE,
43: PERSONAL_INCOME NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 41: PERSON_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,

37: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: PERSON_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
40: PERSON_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: PERSON_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
42: DATE_OF_BIRTH DATE := FND_API.G_MISS_DATE,
43: PERSONAL_INCOME NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: TOTAL_NUM_OF_ORDERS NUMBER := FND_API.G_MISS_NUM

Line 42: DATE_OF_BIRTH DATE := FND_API.G_MISS_DATE,

38: PERSON_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
40: PERSON_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: PERSON_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
42: DATE_OF_BIRTH DATE := FND_API.G_MISS_DATE,
43: PERSONAL_INCOME NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: TOTAL_NUM_OF_ORDERS NUMBER := FND_API.G_MISS_NUM
46: );

Line 43: PERSONAL_INCOME NUMBER := FND_API.G_MISS_NUM,

39: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
40: PERSON_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: PERSON_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
42: DATE_OF_BIRTH DATE := FND_API.G_MISS_DATE,
43: PERSONAL_INCOME NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: TOTAL_NUM_OF_ORDERS NUMBER := FND_API.G_MISS_NUM
46: );
47: G_Miss_Party_Rec Party_Rec_Type;

Line 44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

40: PERSON_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: PERSON_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
42: DATE_OF_BIRTH DATE := FND_API.G_MISS_DATE,
43: PERSONAL_INCOME NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: TOTAL_NUM_OF_ORDERS NUMBER := FND_API.G_MISS_NUM
46: );
47: G_Miss_Party_Rec Party_Rec_Type;
48:

Line 45: TOTAL_NUM_OF_ORDERS NUMBER := FND_API.G_MISS_NUM

41: PERSON_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
42: DATE_OF_BIRTH DATE := FND_API.G_MISS_DATE,
43: PERSONAL_INCOME NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: TOTAL_NUM_OF_ORDERS NUMBER := FND_API.G_MISS_NUM
46: );
47: G_Miss_Party_Rec Party_Rec_Type;
48:
49:

Line 52: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

48:
49:
50: TYPE Location_Rec_Type IS RECORD
51: (
52: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
53: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
54: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
55: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 53: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

49:
50: TYPE Location_Rec_Type IS RECORD
51: (
52: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
53: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
54: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
55: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 54: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

50: TYPE Location_Rec_Type IS RECORD
51: (
52: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
53: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
54: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
55: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 55: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

51: (
52: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
53: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
54: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
55: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
59: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 56: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

52: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
53: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
54: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
55: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
59: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
60: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 57: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

53: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
54: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
55: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
59: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
60: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
61: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 58: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,

54: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
55: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
59: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
60: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
61: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
62: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 59: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,

55: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
59: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
60: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
61: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
62: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
63: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 60: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,

56: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
59: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
60: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
61: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
62: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
63: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE

Line 61: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,

57: COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
59: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
60: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
61: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
62: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
63: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
65:

Line 62: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,

58: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
59: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
60: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
61: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
62: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
63: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
65:
66: );

Line 63: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,

59: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
60: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
61: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
62: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
63: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
65:
66: );
67: G_MISS_Location_Rec Location_Rec_Type;

Line 64: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE

60: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
61: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
62: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
63: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
65:
66: );
67: G_MISS_Location_Rec Location_Rec_Type;
68:

Line 72: party_site_use_id NUMBER := FND_API.G_MISS_NUM,

68:
69:
70: TYPE Party_Site_Rec_Type IS RECORD
71: (
72: party_site_use_id NUMBER := FND_API.G_MISS_NUM,
73: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
76: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 73: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,

69:
70: TYPE Party_Site_Rec_Type IS RECORD
71: (
72: party_site_use_id NUMBER := FND_API.G_MISS_NUM,
73: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
76: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: LOCATION Location_Rec_Type := G_MISS_Location_Rec,

Line 74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,

70: TYPE Party_Site_Rec_Type IS RECORD
71: (
72: party_site_use_id NUMBER := FND_API.G_MISS_NUM,
73: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
76: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: LOCATION Location_Rec_Type := G_MISS_Location_Rec,
78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 75: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,

71: (
72: party_site_use_id NUMBER := FND_API.G_MISS_NUM,
73: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
76: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: LOCATION Location_Rec_Type := G_MISS_Location_Rec,
78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79: party_site_last_update_Date DATE := FND_API.G_MISS_DATE

Line 76: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

72: party_site_use_id NUMBER := FND_API.G_MISS_NUM,
73: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
76: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: LOCATION Location_Rec_Type := G_MISS_Location_Rec,
78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79: party_site_last_update_Date DATE := FND_API.G_MISS_DATE
80:

Line 78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
76: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: LOCATION Location_Rec_Type := G_MISS_Location_Rec,
78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79: party_site_last_update_Date DATE := FND_API.G_MISS_DATE
80:
81: );
82: G_MISS_Party_Site_Rec Party_Site_Rec_Type;

Line 79: party_site_last_update_Date DATE := FND_API.G_MISS_DATE

75: PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
76: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: LOCATION Location_Rec_Type := G_MISS_Location_Rec,
78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79: party_site_last_update_Date DATE := FND_API.G_MISS_DATE
80:
81: );
82: G_MISS_Party_Site_Rec Party_Site_Rec_Type;
83:

Line 86: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,

82: G_MISS_Party_Site_Rec Party_Site_Rec_Type;
83:
84: TYPE Org_Contact_Rec_Type IS RECORD
85: (
86: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
87: CONTACT_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
88: CONTACT_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: CONTACT_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
90: CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 87: CONTACT_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,

83:
84: TYPE Org_Contact_Rec_Type IS RECORD
85: (
86: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
87: CONTACT_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
88: CONTACT_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: CONTACT_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
90: CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: CONTACT_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 88: CONTACT_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,

84: TYPE Org_Contact_Rec_Type IS RECORD
85: (
86: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
87: CONTACT_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
88: CONTACT_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: CONTACT_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
90: CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: CONTACT_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
92: CONTACT_ROLE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 89: CONTACT_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,

85: (
86: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
87: CONTACT_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
88: CONTACT_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: CONTACT_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
90: CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: CONTACT_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
92: CONTACT_ROLE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: job_title VARCHAR2(100) :=FND_API.G_MISS_CHAR,

Line 90: CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,

86: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
87: CONTACT_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
88: CONTACT_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: CONTACT_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
90: CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: CONTACT_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
92: CONTACT_ROLE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: job_title VARCHAR2(100) :=FND_API.G_MISS_CHAR,
94: job_title_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 91: CONTACT_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,

87: CONTACT_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
88: CONTACT_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: CONTACT_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
90: CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: CONTACT_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
92: CONTACT_ROLE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: job_title VARCHAR2(100) :=FND_API.G_MISS_CHAR,
94: job_title_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,

Line 92: CONTACT_ROLE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,

88: CONTACT_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: CONTACT_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
90: CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: CONTACT_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
92: CONTACT_ROLE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: job_title VARCHAR2(100) :=FND_API.G_MISS_CHAR,
94: job_title_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,

Line 93: job_title VARCHAR2(100) :=FND_API.G_MISS_CHAR,

89: CONTACT_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
90: CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: CONTACT_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
92: CONTACT_ROLE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: job_title VARCHAR2(100) :=FND_API.G_MISS_CHAR,
94: job_title_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
97: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

Line 94: job_title_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

90: CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: CONTACT_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
92: CONTACT_ROLE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: job_title VARCHAR2(100) :=FND_API.G_MISS_CHAR,
94: job_title_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
97: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
98: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 95: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,

91: CONTACT_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
92: CONTACT_ROLE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: job_title VARCHAR2(100) :=FND_API.G_MISS_CHAR,
94: job_title_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
97: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
98: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
99: rel_last_update_Date date := FND_API.G_MISS_DATE,

Line 96: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,

92: CONTACT_ROLE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: job_title VARCHAR2(100) :=FND_API.G_MISS_CHAR,
94: job_title_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
97: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
98: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
99: rel_last_update_Date date := FND_API.G_MISS_DATE,
100: org_cont_last_update_Date DATE := FND_API.G_MISS_DATE

Line 97: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

93: job_title VARCHAR2(100) :=FND_API.G_MISS_CHAR,
94: job_title_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
97: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
98: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
99: rel_last_update_Date date := FND_API.G_MISS_DATE,
100: org_cont_last_update_Date DATE := FND_API.G_MISS_DATE
101:

Line 98: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

94: job_title_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
97: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
98: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
99: rel_last_update_Date date := FND_API.G_MISS_DATE,
100: org_cont_last_update_Date DATE := FND_API.G_MISS_DATE
101:
102: );

Line 99: rel_last_update_Date date := FND_API.G_MISS_DATE,

95: PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
97: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
98: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
99: rel_last_update_Date date := FND_API.G_MISS_DATE,
100: org_cont_last_update_Date DATE := FND_API.G_MISS_DATE
101:
102: );
103:

Line 100: org_cont_last_update_Date DATE := FND_API.G_MISS_DATE

96: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
97: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
98: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
99: rel_last_update_Date date := FND_API.G_MISS_DATE,
100: org_cont_last_update_Date DATE := FND_API.G_MISS_DATE
101:
102: );
103:
104: TYPE Contact_Point_Rec_Type IS RECORD

Line 106: contact_point_id NUMBER := FND_API.G_MISS_NUM,

102: );
103:
104: TYPE Contact_Point_Rec_Type IS RECORD
105: (
106: contact_point_id NUMBER := FND_API.G_MISS_NUM,
107: telephone_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: status VARCHAR2(10) := FND_API.G_MISS_CHAR,
110: owner_table_name VARCHAR2(200):= FND_API.G_MISS_CHAR,

Line 107: telephone_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

103:
104: TYPE Contact_Point_Rec_Type IS RECORD
105: (
106: contact_point_id NUMBER := FND_API.G_MISS_NUM,
107: telephone_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: status VARCHAR2(10) := FND_API.G_MISS_CHAR,
110: owner_table_name VARCHAR2(200):= FND_API.G_MISS_CHAR,
111: owner_table_id NUMBER := FND_API.G_MISS_NUM,

Line 108: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

104: TYPE Contact_Point_Rec_Type IS RECORD
105: (
106: contact_point_id NUMBER := FND_API.G_MISS_NUM,
107: telephone_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: status VARCHAR2(10) := FND_API.G_MISS_CHAR,
110: owner_table_name VARCHAR2(200):= FND_API.G_MISS_CHAR,
111: owner_table_id NUMBER := FND_API.G_MISS_NUM,
112: email_format VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 109: status VARCHAR2(10) := FND_API.G_MISS_CHAR,

105: (
106: contact_point_id NUMBER := FND_API.G_MISS_NUM,
107: telephone_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: status VARCHAR2(10) := FND_API.G_MISS_CHAR,
110: owner_table_name VARCHAR2(200):= FND_API.G_MISS_CHAR,
111: owner_table_id NUMBER := FND_API.G_MISS_NUM,
112: email_format VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 110: owner_table_name VARCHAR2(200):= FND_API.G_MISS_CHAR,

106: contact_point_id NUMBER := FND_API.G_MISS_NUM,
107: telephone_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: status VARCHAR2(10) := FND_API.G_MISS_CHAR,
110: owner_table_name VARCHAR2(200):= FND_API.G_MISS_CHAR,
111: owner_table_id NUMBER := FND_API.G_MISS_NUM,
112: email_format VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
114: phone_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 111: owner_table_id NUMBER := FND_API.G_MISS_NUM,

107: telephone_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: status VARCHAR2(10) := FND_API.G_MISS_CHAR,
110: owner_table_name VARCHAR2(200):= FND_API.G_MISS_CHAR,
111: owner_table_id NUMBER := FND_API.G_MISS_NUM,
112: email_format VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
114: phone_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
115: phone_country_code VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 112: email_format VARCHAR2(30) := FND_API.G_MISS_CHAR,

108: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: status VARCHAR2(10) := FND_API.G_MISS_CHAR,
110: owner_table_name VARCHAR2(200):= FND_API.G_MISS_CHAR,
111: owner_table_id NUMBER := FND_API.G_MISS_NUM,
112: email_format VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
114: phone_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
115: phone_country_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
116: phone_number VARCHAR2(40) := FND_API.G_MISS_CHAR,

Line 113: email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,

109: status VARCHAR2(10) := FND_API.G_MISS_CHAR,
110: owner_table_name VARCHAR2(200):= FND_API.G_MISS_CHAR,
111: owner_table_id NUMBER := FND_API.G_MISS_NUM,
112: email_format VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
114: phone_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
115: phone_country_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
116: phone_number VARCHAR2(40) := FND_API.G_MISS_CHAR,
117: phone_extension VARCHAR2(20) := FND_API.G_MISS_CHAR,

Line 114: phone_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR,

110: owner_table_name VARCHAR2(200):= FND_API.G_MISS_CHAR,
111: owner_table_id NUMBER := FND_API.G_MISS_NUM,
112: email_format VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
114: phone_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
115: phone_country_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
116: phone_number VARCHAR2(40) := FND_API.G_MISS_CHAR,
117: phone_extension VARCHAR2(20) := FND_API.G_MISS_CHAR,
118: phone_line_type VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 115: phone_country_code VARCHAR2(10) := FND_API.G_MISS_CHAR,

111: owner_table_id NUMBER := FND_API.G_MISS_NUM,
112: email_format VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
114: phone_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
115: phone_country_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
116: phone_number VARCHAR2(40) := FND_API.G_MISS_CHAR,
117: phone_extension VARCHAR2(20) := FND_API.G_MISS_CHAR,
118: phone_line_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
119: telex_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 116: phone_number VARCHAR2(40) := FND_API.G_MISS_CHAR,

112: email_format VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
114: phone_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
115: phone_country_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
116: phone_number VARCHAR2(40) := FND_API.G_MISS_CHAR,
117: phone_extension VARCHAR2(20) := FND_API.G_MISS_CHAR,
118: phone_line_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
119: telex_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
120: url VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 117: phone_extension VARCHAR2(20) := FND_API.G_MISS_CHAR,

113: email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
114: phone_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
115: phone_country_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
116: phone_number VARCHAR2(40) := FND_API.G_MISS_CHAR,
117: phone_extension VARCHAR2(20) := FND_API.G_MISS_CHAR,
118: phone_line_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
119: telex_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
120: url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
121: primary_flag VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 118: phone_line_type VARCHAR2(80) := FND_API.G_MISS_CHAR,

114: phone_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
115: phone_country_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
116: phone_number VARCHAR2(40) := FND_API.G_MISS_CHAR,
117: phone_extension VARCHAR2(20) := FND_API.G_MISS_CHAR,
118: phone_line_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
119: telex_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
120: url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
121: primary_flag VARCHAR2(10) := FND_API.G_MISS_CHAR,
122: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE

Line 119: telex_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

115: phone_country_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
116: phone_number VARCHAR2(40) := FND_API.G_MISS_CHAR,
117: phone_extension VARCHAR2(20) := FND_API.G_MISS_CHAR,
118: phone_line_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
119: telex_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
120: url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
121: primary_flag VARCHAR2(10) := FND_API.G_MISS_CHAR,
122: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
123:

Line 120: url VARCHAR2(2000) := FND_API.G_MISS_CHAR,

116: phone_number VARCHAR2(40) := FND_API.G_MISS_CHAR,
117: phone_extension VARCHAR2(20) := FND_API.G_MISS_CHAR,
118: phone_line_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
119: telex_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
120: url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
121: primary_flag VARCHAR2(10) := FND_API.G_MISS_CHAR,
122: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
123:
124: );

Line 121: primary_flag VARCHAR2(10) := FND_API.G_MISS_CHAR,

117: phone_extension VARCHAR2(20) := FND_API.G_MISS_CHAR,
118: phone_line_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
119: telex_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
120: url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
121: primary_flag VARCHAR2(10) := FND_API.G_MISS_CHAR,
122: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
123:
124: );
125:

Line 122: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE

118: phone_line_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
119: telex_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
120: url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
121: primary_flag VARCHAR2(10) := FND_API.G_MISS_CHAR,
122: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
123:
124: );
125:
126: TYPE Out_Contact_Point_Rec_Type IS RECORD

Line 143: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE

139: Restriction_End_Date DATE,
140: Contact_Type VARCHAR2(30),
141: Subject_Table VARCHAR2(30),
142: Subject_ID NUMBER,
143: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
144:
145: );
146:
147: PROCEDURE Create_Party(

Line 182: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

178: -- also uses the marketing source code id if passed.
179:
180: PROCEDURE Create_Customer_Account(
181: p_api_version IN NUMBER
182: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
183: ,p_commit IN VARCHAR2 := FND_API.g_false
184: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
185: ,P_Qte_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
186: ,P_Account_number IN NUMBER := FND_API.G_MISS_NUM

Line 183: ,p_commit IN VARCHAR2 := FND_API.g_false

179:
180: PROCEDURE Create_Customer_Account(
181: p_api_version IN NUMBER
182: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
183: ,p_commit IN VARCHAR2 := FND_API.g_false
184: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
185: ,P_Qte_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
186: ,P_Account_number IN NUMBER := FND_API.G_MISS_NUM
187: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 184: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

180: PROCEDURE Create_Customer_Account(
181: p_api_version IN NUMBER
182: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
183: ,p_commit IN VARCHAR2 := FND_API.g_false
184: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
185: ,P_Qte_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
186: ,P_Account_number IN NUMBER := FND_API.G_MISS_NUM
187: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
188: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 186: ,P_Account_number IN NUMBER := FND_API.G_MISS_NUM

182: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
183: ,p_commit IN VARCHAR2 := FND_API.g_false
184: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
185: ,P_Qte_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
186: ,P_Account_number IN NUMBER := FND_API.G_MISS_NUM
187: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
188: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
189: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
190: ,x_acct_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 197: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

193:
194: -- creates an account site
195: PROCEDURE Create_ACCT_SITE (
196: p_api_version IN NUMBER
197: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
198: ,p_commit IN VARCHAR2 := FND_API.g_false
199: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
200: ,p_Cust_Account_Id NUMBER
201: ,p_Party_Site_Id NUMBER

Line 198: ,p_commit IN VARCHAR2 := FND_API.g_false

194: -- creates an account site
195: PROCEDURE Create_ACCT_SITE (
196: p_api_version IN NUMBER
197: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
198: ,p_commit IN VARCHAR2 := FND_API.g_false
199: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
200: ,p_Cust_Account_Id NUMBER
201: ,p_Party_Site_Id NUMBER
202: ,p_Acct_site VARCHAR2 := 'NONE'

Line 199: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

195: PROCEDURE Create_ACCT_SITE (
196: p_api_version IN NUMBER
197: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
198: ,p_commit IN VARCHAR2 := FND_API.g_false
199: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
200: ,p_Cust_Account_Id NUMBER
201: ,p_Party_Site_Id NUMBER
202: ,p_Acct_site VARCHAR2 := 'NONE'
203: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 212: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

208:
209:
210: PROCEDURE Create_ACCT_SITE_USES (
211: p_api_version IN NUMBER
212: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
213: ,p_commit IN VARCHAR2 := FND_API.g_false
214: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
215: ,P_Cust_Account_Id IN NUMBER
216: ,P_Party_Site_Id IN NUMBER

Line 213: ,p_commit IN VARCHAR2 := FND_API.g_false

209:
210: PROCEDURE Create_ACCT_SITE_USES (
211: p_api_version IN NUMBER
212: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
213: ,p_commit IN VARCHAR2 := FND_API.g_false
214: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
215: ,P_Cust_Account_Id IN NUMBER
216: ,P_Party_Site_Id IN NUMBER
217: ,P_cust_acct_site_id IN NUMBER := NULL

Line 214: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

210: PROCEDURE Create_ACCT_SITE_USES (
211: p_api_version IN NUMBER
212: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
213: ,p_commit IN VARCHAR2 := FND_API.g_false
214: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
215: ,P_Cust_Account_Id IN NUMBER
216: ,P_Party_Site_Id IN NUMBER
217: ,P_cust_acct_site_id IN NUMBER := NULL
218: ,P_Acct_Site_type IN VARCHAR2 := 'NONE'

Line 229: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

225:
226:
227: PROCEDURE Create_Contact (
228: p_api_version IN NUMBER
229: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
230: ,p_commit IN VARCHAR2 := FND_API.g_false
231: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
232: ,p_party_id IN NUMBER := NULL -- this is the party id of the corresponding org contact
233: ,p_Org_Contact_Id IN NUMBER

Line 230: ,p_commit IN VARCHAR2 := FND_API.g_false

226:
227: PROCEDURE Create_Contact (
228: p_api_version IN NUMBER
229: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
230: ,p_commit IN VARCHAR2 := FND_API.g_false
231: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
232: ,p_party_id IN NUMBER := NULL -- this is the party id of the corresponding org contact
233: ,p_Org_Contact_Id IN NUMBER
234: ,p_Cust_account_id IN NUMBER

Line 231: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

227: PROCEDURE Create_Contact (
228: p_api_version IN NUMBER
229: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
230: ,p_commit IN VARCHAR2 := FND_API.g_false
231: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
232: ,p_party_id IN NUMBER := NULL -- this is the party id of the corresponding org contact
233: ,p_Org_Contact_Id IN NUMBER
234: ,p_Cust_account_id IN NUMBER
235: ,p_Role_type IN VARCHAR2 := 'CONTACT'

Line 245: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

241: );
242:
243: PROCEDURE Create_ORG_CONTACT_ord (
244: p_api_version IN NUMBER
245: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
246: ,p_commit IN VARCHAR2 := FND_API.g_false
247: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
248: ,p_party_id NUMBER
249: ,p_header_Party_Id NUMBER := NULL

Line 246: ,p_commit IN VARCHAR2 := FND_API.g_false

242:
243: PROCEDURE Create_ORG_CONTACT_ord (
244: p_api_version IN NUMBER
245: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
246: ,p_commit IN VARCHAR2 := FND_API.g_false
247: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
248: ,p_party_id NUMBER
249: ,p_header_Party_Id NUMBER := NULL
250: ,p_acct_id NUMBER := NULL

Line 247: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

243: PROCEDURE Create_ORG_CONTACT_ord (
244: p_api_version IN NUMBER
245: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
246: ,p_commit IN VARCHAR2 := FND_API.g_false
247: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
248: ,p_party_id NUMBER
249: ,p_header_Party_Id NUMBER := NULL
250: ,p_acct_id NUMBER := NULL
251: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 258: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

254: ,x_org_contact_id OUT NOCOPY /* file.sql.39 change */ NUMBER
255: ,x_party_id OUT NOCOPY /* file.sql.39 change */ NUMBER
256: ) ;
257: PROCEDURE Create_Contact_Role ( p_api_version IN NUMBER
258: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
259: ,p_commit IN VARCHAR2 := FND_API.g_false
260: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
261: ,p_Cust_account_id IN NUMBER
262: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM

Line 259: ,p_commit IN VARCHAR2 := FND_API.g_false

255: ,x_party_id OUT NOCOPY /* file.sql.39 change */ NUMBER
256: ) ;
257: PROCEDURE Create_Contact_Role ( p_api_version IN NUMBER
258: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
259: ,p_commit IN VARCHAR2 := FND_API.g_false
260: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
261: ,p_Cust_account_id IN NUMBER
262: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
263: ,p_Role_type IN VARCHAR2 := 'CONTACT'

Line 260: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

256: ) ;
257: PROCEDURE Create_Contact_Role ( p_api_version IN NUMBER
258: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
259: ,p_commit IN VARCHAR2 := FND_API.g_false
260: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
261: ,p_Cust_account_id IN NUMBER
262: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
263: ,p_Role_type IN VARCHAR2 := 'CONTACT'
264: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 262: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM

258: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
259: ,p_commit IN VARCHAR2 := FND_API.g_false
260: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
261: ,p_Cust_account_id IN NUMBER
262: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
263: ,p_Role_type IN VARCHAR2 := 'CONTACT'
264: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR
265: ,p_Begin_date IN DATE := sysdate
266: ,p_role_id IN NUMBER := FND_API.G_MISS_NUM

Line 264: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR

260: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
261: ,p_Cust_account_id IN NUMBER
262: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
263: ,p_Role_type IN VARCHAR2 := 'CONTACT'
264: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR
265: ,p_Begin_date IN DATE := sysdate
266: ,p_role_id IN NUMBER := FND_API.G_MISS_NUM
267: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
268: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 266: ,p_role_id IN NUMBER := FND_API.G_MISS_NUM

262: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
263: ,p_Role_type IN VARCHAR2 := 'CONTACT'
264: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR
265: ,p_Begin_date IN DATE := sysdate
266: ,p_role_id IN NUMBER := FND_API.G_MISS_NUM
267: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
268: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
269: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
270: ,x_cust_account_role_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 275: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

271: );
272:
273: Procedure GET_ACCT_SITE_USES(
274: p_api_version IN NUMBER
275: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
276: ,p_commit IN VARCHAR2 := FND_API.g_false
277: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
278: ,P_Cust_Account_Id IN NUMBER
279: ,P_Party_Site_Id IN NUMBER

Line 276: ,p_commit IN VARCHAR2 := FND_API.g_false

272:
273: Procedure GET_ACCT_SITE_USES(
274: p_api_version IN NUMBER
275: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
276: ,p_commit IN VARCHAR2 := FND_API.g_false
277: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
278: ,P_Cust_Account_Id IN NUMBER
279: ,P_Party_Site_Id IN NUMBER
280: ,P_Acct_Site_type IN VARCHAR2 := 'NONE'

Line 277: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

273: Procedure GET_ACCT_SITE_USES(
274: p_api_version IN NUMBER
275: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
276: ,p_commit IN VARCHAR2 := FND_API.g_false
277: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
278: ,P_Cust_Account_Id IN NUMBER
279: ,P_Party_Site_Id IN NUMBER
280: ,P_Acct_Site_type IN VARCHAR2 := 'NONE'
281: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 290: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

286:
287:
288: PROCEDURE Create_Cust_Acct_Relationship(
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
291: p_commit IN VARCHAR2 := FND_API.g_false,
292: p_sold_to_cust_account IN NUMBER,
293: p_related_cust_account IN NUMBER,
294: p_relationship_type IN VARCHAR2,

Line 291: p_commit IN VARCHAR2 := FND_API.g_false,

287:
288: PROCEDURE Create_Cust_Acct_Relationship(
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
291: p_commit IN VARCHAR2 := FND_API.g_false,
292: p_sold_to_cust_account IN NUMBER,
293: p_related_cust_account IN NUMBER,
294: p_relationship_type IN VARCHAR2,
295: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 300: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

296: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
297: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
298: PROCEDURE update_Cust_Acct_Relationship(
299: p_api_version IN NUMBER,
300: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
301: p_commit IN VARCHAR2 := FND_API.g_false,
302: p_sold_to_cust_account IN NUMBER,
303: p_related_cust_account IN NUMBER,
304: p_relationship_type IN VARCHAR2,

Line 301: p_commit IN VARCHAR2 := FND_API.g_false,

297: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
298: PROCEDURE update_Cust_Acct_Relationship(
299: p_api_version IN NUMBER,
300: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
301: p_commit IN VARCHAR2 := FND_API.g_false,
302: p_sold_to_cust_account IN NUMBER,
303: p_related_cust_account IN NUMBER,
304: p_relationship_type IN VARCHAR2,
305: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 312: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

308:
309:
310: PROCEDURE Create_Customer_Account(
311: p_api_version IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
313: p_commit IN VARCHAR2 := FND_API.g_false,
314: P_Party_id IN NUMBER,
315: P_Account_number IN NUMBER := FND_API.G_MISS_NUM,
316: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 313: p_commit IN VARCHAR2 := FND_API.g_false,

309:
310: PROCEDURE Create_Customer_Account(
311: p_api_version IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
313: p_commit IN VARCHAR2 := FND_API.g_false,
314: P_Party_id IN NUMBER,
315: P_Account_number IN NUMBER := FND_API.G_MISS_NUM,
316: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
317: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 315: P_Account_number IN NUMBER := FND_API.G_MISS_NUM,

311: p_api_version IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
313: p_commit IN VARCHAR2 := FND_API.g_false,
314: P_Party_id IN NUMBER,
315: P_Account_number IN NUMBER := FND_API.G_MISS_NUM,
316: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
317: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
318: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
319: x_cust_acct_id OUT NOCOPY /* file.sql.39 change */ NUMBER);

Line 324: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

320:
321:
322: PROCEDURE Create_Party_Site_Use(
323: p_api_version IN NUMBER,
324: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
325: p_commit IN VARCHAR2 := FND_API.g_false,
326: p_party_site_id IN NUMBER,
327: p_party_site_use_type IN VARCHAR2,
328: x_party_site_use_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 325: p_commit IN VARCHAR2 := FND_API.g_false,

321:
322: PROCEDURE Create_Party_Site_Use(
323: p_api_version IN NUMBER,
324: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
325: p_commit IN VARCHAR2 := FND_API.g_false,
326: p_party_site_id IN NUMBER,
327: p_party_site_use_type IN VARCHAR2,
328: x_party_site_use_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
329: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,