DBA Data[Home] [Help]

APPS.AS_OPP_OBSTACLE_PVT dependencies on FND_API

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

18: -- Pre-Req :
19: -- Parameters:
20: -- IN
21: -- p_api_version_number IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25: -- P_Obstacle_Rec IN Obstacle_Rec_Type Required
26: --

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

19: -- Parameters:
20: -- IN
21: -- p_api_version_number IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25: -- P_Obstacle_Rec IN Obstacle_Rec_Type Required
26: --
27: -- OUT:

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

20: -- IN
21: -- p_api_version_number IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25: -- P_Obstacle_Rec IN Obstacle_Rec_Type Required
26: --
27: -- OUT:
28: -- x_return_status OUT VARCHAR2

Line 39: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

35: -- End of Comments
36: --
37: PROCEDURE Create_obstacles(
38: P_Api_Version_Number IN NUMBER,
39: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
40: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
43: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

Line 40: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

36: --
37: PROCEDURE Create_obstacles(
38: P_Api_Version_Number IN NUMBER,
39: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
40: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
43: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
44: P_Admin_Group_Id IN NUMBER,

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

37: PROCEDURE Create_obstacles(
38: P_Api_Version_Number IN NUMBER,
39: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
40: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
43: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
44: P_Admin_Group_Id IN NUMBER,
45: P_Identity_Salesforce_Id IN VARCHAR2 := FND_API.G_FALSE,

Line 42: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

38: P_Api_Version_Number IN NUMBER,
39: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
40: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
43: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
44: P_Admin_Group_Id IN NUMBER,
45: P_Identity_Salesforce_Id IN VARCHAR2 := FND_API.G_FALSE,
46: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

Line 43: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

39: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
40: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
43: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
44: P_Admin_Group_Id IN NUMBER,
45: P_Identity_Salesforce_Id IN VARCHAR2 := FND_API.G_FALSE,
46: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
47: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 45: P_Identity_Salesforce_Id IN VARCHAR2 := FND_API.G_FALSE,

41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
43: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
44: P_Admin_Group_Id IN NUMBER,
45: P_Identity_Salesforce_Id IN VARCHAR2 := FND_API.G_FALSE,
46: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
47: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
48: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type := AS_OPPORTUNITY_PUB.G_MISS_Obstacle_tbl,
49: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 47: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,

43: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
44: P_Admin_Group_Id IN NUMBER,
45: P_Identity_Salesforce_Id IN VARCHAR2 := FND_API.G_FALSE,
46: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
47: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
48: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type := AS_OPPORTUNITY_PUB.G_MISS_Obstacle_tbl,
49: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
50: X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,
51: X_Return_Status OUT NOCOPY VARCHAR2,

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

61: -- Pre-Req :
62: -- Parameters:
63: -- IN
64: -- p_api_version_number IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
66: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
68: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
69: -- P_Obstacle_Rec IN Obstacle_Rec_Type Required

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

62: -- Parameters:
63: -- IN
64: -- p_api_version_number IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
66: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
68: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
69: -- P_Obstacle_Rec IN Obstacle_Rec_Type Required
70: --

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

63: -- IN
64: -- p_api_version_number IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
66: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
68: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
69: -- P_Obstacle_Rec IN Obstacle_Rec_Type Required
70: --
71: -- OUT:

Line 84: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

80: --
81: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
82: PROCEDURE Update_obstacles(
83: P_Api_Version_Number IN NUMBER,
84: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
85: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
88: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

Line 85: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

81: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
82: PROCEDURE Update_obstacles(
83: P_Api_Version_Number IN NUMBER,
84: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
85: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
88: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
89: P_Admin_Group_Id IN NUMBER,

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

82: PROCEDURE Update_obstacles(
83: P_Api_Version_Number IN NUMBER,
84: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
85: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
88: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
89: P_Admin_Group_Id IN NUMBER,
90: P_Identity_Salesforce_Id IN NUMBER,

Line 87: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

83: P_Api_Version_Number IN NUMBER,
84: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
85: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
88: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
89: P_Admin_Group_Id IN NUMBER,
90: P_Identity_Salesforce_Id IN NUMBER,
91: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

Line 88: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

84: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
85: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
88: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
89: P_Admin_Group_Id IN NUMBER,
90: P_Identity_Salesforce_Id IN NUMBER,
91: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
92: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 92: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,

88: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
89: P_Admin_Group_Id IN NUMBER,
90: P_Identity_Salesforce_Id IN NUMBER,
91: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
92: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
93: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_type,
94: X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,
95: X_Return_Status OUT NOCOPY VARCHAR2,
96: X_Msg_Count OUT NOCOPY NUMBER,

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

105: -- Pre-Req :
106: -- Parameters:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
113: -- P_Obstacle_Rec IN Obstacle_Rec_Type Required

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

106: -- Parameters:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
113: -- P_Obstacle_Rec IN Obstacle_Rec_Type Required
114: --

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

107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
113: -- P_Obstacle_Rec IN Obstacle_Rec_Type Required
114: --
115: -- OUT:

Line 129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

125: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
126: -- The Master delete procedure may not be needed depends on different business requirements.
127: PROCEDURE Delete_obstacles(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
133: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

Line 130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

126: -- The Master delete procedure may not be needed depends on different business requirements.
127: PROCEDURE Delete_obstacles(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
133: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
134: P_Admin_Group_Id IN NUMBER,

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

127: PROCEDURE Delete_obstacles(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
133: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
134: P_Admin_Group_Id IN NUMBER,
135: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

Line 132: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
133: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
134: P_Admin_Group_Id IN NUMBER,
135: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
136: P_identity_salesforce_id IN NUMBER := NULL,

Line 133: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
133: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
134: P_Admin_Group_Id IN NUMBER,
135: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
136: P_identity_salesforce_id IN NUMBER := NULL,
137: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 137: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,

133: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
134: P_Admin_Group_Id IN NUMBER,
135: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
136: P_identity_salesforce_id IN NUMBER := NULL,
137: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
138: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
139: X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,
140: X_Return_Status OUT NOCOPY VARCHAR2,
141: X_Msg_Count OUT NOCOPY NUMBER,

Line 158: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

154: --
155: -- End of Comments
156:
157: PROCEDURE Validate_LEAD_OBSTACLE_ID (
158: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159: P_Validation_mode IN VARCHAR2,
160: P_LEAD_OBSTACLE_ID IN NUMBER,
161: -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
162: X_Return_Status OUT NOCOPY VARCHAR2,

Line 179: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

175: --
176: -- End of Comments
177:
178: PROCEDURE Validate_LEAD_ID (
179: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
180: P_Validation_mode IN VARCHAR2,
181: P_LEAD_ID IN NUMBER,
182: -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
183: X_Return_Status OUT NOCOPY VARCHAR2,

Line 200: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

196: --
197: -- End of Comments
198:
199: PROCEDURE Validate_OBSTACLE_CODE (
200: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
201: P_Validation_mode IN VARCHAR2,
202: P_OBSTACLE_CODE IN VARCHAR2,
203: -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
204: X_Return_Status OUT NOCOPY VARCHAR2,

Line 222: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

218: -- 2. Developer can manually added inter-field level validation.
219: -- End of Comments
220:
221: PROCEDURE Validate_Obstacle_rec(
222: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
223: P_Validation_mode IN VARCHAR2,
224: P_Obstacle_Rec IN AS_OPPORTUNITY_PUB.Obstacle_Rec_Type,
225: X_Return_Status OUT NOCOPY VARCHAR2,
226: X_Msg_Count OUT NOCOPY NUMBER,

Line 242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

238: -- 2. We can also validate table instead of record. There will be an option for user to choose.
239: -- End of Comments
240:
241: PROCEDURE Validate_obstacle(
242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Validation_mode IN VARCHAR2,
245: P_Obstacle_Rec IN AS_OPPORTUNITY_PUB.Obstacle_Rec_Type,
246: X_Return_Status OUT NOCOPY VARCHAR2,

Line 243: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

239: -- End of Comments
240:
241: PROCEDURE Validate_obstacle(
242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Validation_mode IN VARCHAR2,
245: P_Obstacle_Rec IN AS_OPPORTUNITY_PUB.Obstacle_Rec_Type,
246: X_Return_Status OUT NOCOPY VARCHAR2,
247: X_Msg_Count OUT NOCOPY NUMBER,