DBA Data[Home] [Help]

APPS.AMS_CNT_POINT_PVT dependencies on FND_API

Line 68: contact_point_id NUMBER := FND_API.G_MISS_NUM,

64:
65: --===================================================================
66: TYPE cnt_point_rec_type IS RECORD
67: (
68: contact_point_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,

Line 69: last_update_date DATE := FND_API.G_MISS_DATE,

65: --===================================================================
66: TYPE cnt_point_rec_type IS RECORD
67: (
68: contact_point_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 70: last_updated_by NUMBER := FND_API.G_MISS_NUM,

66: TYPE cnt_point_rec_type IS RECORD
67: (
68: contact_point_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 71: creation_date DATE := FND_API.G_MISS_DATE,

67: (
68: contact_point_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 72: created_by NUMBER := FND_API.G_MISS_NUM,

68: contact_point_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,

Line 73: last_update_login NUMBER := FND_API.G_MISS_NUM,

69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 74: object_version_number NUMBER := FND_API.G_MISS_NUM,

70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,

Line 75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,

71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,

Line 76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,

72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,

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

73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,

Line 78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,

74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,

75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 80: country NUMBER := FND_API.G_MISS_NUM,

76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,

77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,

78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: contact_point_value_id NUMBER := FND_API.G_MISS_NUM

Line 95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: contact_point_value_id NUMBER := FND_API.G_MISS_NUM
99: );

Line 96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: contact_point_value_id NUMBER := FND_API.G_MISS_NUM
99: );
100:

Line 97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: contact_point_value_id NUMBER := FND_API.G_MISS_NUM
99: );
100:
101: g_miss_cnt_point_rec cnt_point_rec_type;

Line 98: contact_point_value_id NUMBER := FND_API.G_MISS_NUM

94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: contact_point_value_id NUMBER := FND_API.G_MISS_NUM
99: );
100:
101: g_miss_cnt_point_rec cnt_point_rec_type;
102: TYPE cnt_point_tbl_type IS TABLE OF cnt_point_rec_type INDEX BY BINARY_INTEGER;

Line 118: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

114: -- Parameters
115: --
116: -- IN
117: -- p_api_version_number IN NUMBER Required
118: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
119: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
120: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_cnt_point_rec IN cnt_point_rec_type Required
122: --

Line 119: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

115: --
116: -- IN
117: -- p_api_version_number IN NUMBER Required
118: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
119: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
120: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_cnt_point_rec IN cnt_point_rec_type Required
122: --
123: -- OUT

Line 120: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

116: -- IN
117: -- p_api_version_number IN NUMBER Required
118: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
119: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
120: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_cnt_point_rec IN cnt_point_rec_type Required
122: --
123: -- OUT
124: -- x_return_status OUT VARCHAR2

Line 137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

133: --
134:
135: PROCEDURE Create_Cnt_Point(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140:
141: x_return_status OUT NOCOPY VARCHAR2,

Line 138: p_commit IN VARCHAR2 := FND_API.G_FALSE,

134:
135: PROCEDURE Create_Cnt_Point(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140:
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,

Line 139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

135: PROCEDURE Create_Cnt_Point(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140:
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,

Line 162: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

158: -- Parameters
159: --
160: -- IN
161: -- p_api_version_number IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
163: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
164: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
165: -- p_cnt_point_rec IN cnt_point_rec_type Required
166: --

Line 163: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

159: --
160: -- IN
161: -- p_api_version_number IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
163: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
164: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
165: -- p_cnt_point_rec IN cnt_point_rec_type Required
166: --
167: -- OUT

Line 164: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

160: -- IN
161: -- p_api_version_number IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
163: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
164: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
165: -- p_cnt_point_rec IN cnt_point_rec_type Required
166: --
167: -- OUT
168: -- x_return_status OUT VARCHAR2

Line 181: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

177: --
178:
179: PROCEDURE Update_Cnt_Point(
180: p_api_version_number IN NUMBER,
181: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182: p_commit IN VARCHAR2 := FND_API.G_FALSE,
183: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184:
185: x_return_status OUT NOCOPY VARCHAR2,

Line 182: p_commit IN VARCHAR2 := FND_API.G_FALSE,

178:
179: PROCEDURE Update_Cnt_Point(
180: p_api_version_number IN NUMBER,
181: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182: p_commit IN VARCHAR2 := FND_API.G_FALSE,
183: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184:
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,

Line 183: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

179: PROCEDURE Update_Cnt_Point(
180: p_api_version_number IN NUMBER,
181: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182: p_commit IN VARCHAR2 := FND_API.G_FALSE,
183: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184:
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,

Line 206: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

202: -- Parameters
203: --
204: -- IN
205: -- p_api_version_number IN NUMBER Required
206: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
207: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
209: -- p_CONTACT_POINT_ID IN NUMBER
210: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 207: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

203: --
204: -- IN
205: -- p_api_version_number IN NUMBER Required
206: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
207: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
209: -- p_CONTACT_POINT_ID IN NUMBER
210: -- p_object_version_number IN NUMBER Optional Default = NULL
211: --

Line 208: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

204: -- IN
205: -- p_api_version_number IN NUMBER Required
206: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
207: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
209: -- p_CONTACT_POINT_ID IN NUMBER
210: -- p_object_version_number IN NUMBER Optional Default = NULL
211: --
212: -- OUT

Line 226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

222: --
223:
224: PROCEDURE Delete_Cnt_Point(
225: p_api_version_number IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,

Line 227: p_commit IN VARCHAR2 := FND_API.G_FALSE,

223:
224: PROCEDURE Delete_Cnt_Point(
225: p_api_version_number IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,

Line 228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

224: PROCEDURE Delete_Cnt_Point(
225: p_api_version_number IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: p_contact_point_id IN NUMBER,

Line 249: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

245: -- Parameters
246: --
247: -- IN
248: -- p_api_version_number IN NUMBER Required
249: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
250: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
251: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
252: -- p_cnt_point_rec IN cnt_point_rec_type Required
253: --

Line 250: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

246: --
247: -- IN
248: -- p_api_version_number IN NUMBER Required
249: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
250: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
251: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
252: -- p_cnt_point_rec IN cnt_point_rec_type Required
253: --
254: -- OUT

Line 251: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

247: -- IN
248: -- p_api_version_number IN NUMBER Required
249: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
250: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
251: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
252: -- p_cnt_point_rec IN cnt_point_rec_type Required
253: --
254: -- OUT
255: -- x_return_status OUT VARCHAR2

Line 268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

264: --
265:
266: PROCEDURE Lock_Cnt_Point(
267: p_api_version_number IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269:
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,

Line 292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

288: -- End of Comments
289:
290: PROCEDURE Validate_cnt_point(
291: p_api_version_number IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
294: p_validation_mode IN VARCHAR2,
295: p_cnt_point_rec IN cnt_point_rec_type,
296: x_return_status OUT NOCOPY VARCHAR2,

Line 293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

289:
290: PROCEDURE Validate_cnt_point(
291: p_api_version_number IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
294: p_validation_mode IN VARCHAR2,
295: p_cnt_point_rec IN cnt_point_rec_type,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,

Line 332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

328:
329: PROCEDURE Validate_cnt_point_rec(
330: p_api_version_number IN NUMBER,
331: p_validation_mode IN VARCHAR2,
332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_msg_count OUT NOCOPY NUMBER,
335: x_msg_data OUT NOCOPY VARCHAR2,
336: p_cnt_point_rec IN cnt_point_rec_type