DBA Data[Home] [Help]

APPS.AS_COMPETITOR_PROD_PVT dependencies on FND_API

Line 24: -- Default = FND_API_G_FALSE

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

Line 26: -- Default = FND_API.G_FALSE

22: -- p_api_version_number IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional
24: -- Default = FND_API_G_FALSE
25: -- p_commit IN VARCHAR2 Optional
26: -- Default = FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Optional
28: -- Default = FND_API.G_VALID_LEVEL_FULL
29: -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
30: -- Required

Line 28: -- Default = FND_API.G_VALID_LEVEL_FULL

24: -- Default = FND_API_G_FALSE
25: -- p_commit IN VARCHAR2 Optional
26: -- Default = FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Optional
28: -- Default = FND_API.G_VALID_LEVEL_FULL
29: -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
30: -- Required
31: --
32: -- OUT:

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

39: -- End of Comments
40: --
41: PROCEDURE Create_competitor_prods(
42: P_Api_Version_Number IN NUMBER,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Admin_Group_Id IN NUMBER,
47: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

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

40: --
41: PROCEDURE Create_competitor_prods(
42: P_Api_Version_Number IN NUMBER,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Admin_Group_Id IN NUMBER,
47: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
48: P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type :=

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

41: PROCEDURE Create_competitor_prods(
42: P_Api_Version_Number IN NUMBER,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Admin_Group_Id IN NUMBER,
47: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
48: P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type :=
49: AS_OPPORTUNITY_PUB.G_MISS_competitor_prod_Tbl,

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

47: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
48: P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type :=
49: AS_OPPORTUNITY_PUB.G_MISS_competitor_prod_Tbl,
50: X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
51: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
52: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
53: P_Identity_Salesforce_Id IN NUMBER := NULL,
54: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
55: X_Return_Status OUT NOCOPY VARCHAR2,

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

48: P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type :=
49: AS_OPPORTUNITY_PUB.G_MISS_competitor_prod_Tbl,
50: X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
51: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
52: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
53: P_Identity_Salesforce_Id IN NUMBER := NULL,
54: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
55: X_Return_Status OUT NOCOPY VARCHAR2,
56: X_Msg_Count OUT NOCOPY NUMBER,

Line 54: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

50: X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
51: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
52: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
53: P_Identity_Salesforce_Id IN NUMBER := NULL,
54: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
55: X_Return_Status OUT NOCOPY VARCHAR2,
56: X_Msg_Count OUT NOCOPY NUMBER,
57: X_Msg_Data OUT NOCOPY VARCHAR2
58: );

Line 70: -- Default = FND_API_G_FALSE

66: -- Parameters:
67: -- IN
68: -- p_api_version_number IN NUMBER Required
69: -- p_init_msg_list IN VARCHAR2 Optional
70: -- Default = FND_API_G_FALSE
71: -- p_commit IN VARCHAR2 Optional
72: -- Default = FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Optional
74: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 72: -- Default = FND_API.G_FALSE

68: -- p_api_version_number IN NUMBER Required
69: -- p_init_msg_list IN VARCHAR2 Optional
70: -- Default = FND_API_G_FALSE
71: -- p_commit IN VARCHAR2 Optional
72: -- Default = FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Optional
74: -- Default = FND_API.G_VALID_LEVEL_FULL
75: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
76: -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type

Line 74: -- Default = FND_API.G_VALID_LEVEL_FULL

70: -- Default = FND_API_G_FALSE
71: -- p_commit IN VARCHAR2 Optional
72: -- Default = FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Optional
74: -- Default = FND_API.G_VALID_LEVEL_FULL
75: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
76: -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
77: -- Required
78: --

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

86: -- End of Comments
87: --
88: PROCEDURE Update_competitor_prods(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
94: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

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

87: --
88: PROCEDURE Update_competitor_prods(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
94: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
95: P_Admin_Group_Id IN NUMBER,

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

88: PROCEDURE Update_competitor_prods(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
94: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
95: P_Admin_Group_Id IN NUMBER,
96: P_Identity_Salesforce_Id IN NUMBER,

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

89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
94: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
95: P_Admin_Group_Id IN NUMBER,
96: P_Identity_Salesforce_Id IN NUMBER,
97: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

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

90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
94: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
95: P_Admin_Group_Id IN NUMBER,
96: P_Identity_Salesforce_Id IN NUMBER,
97: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
98: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 98: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

94: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
95: P_Admin_Group_Id IN NUMBER,
96: P_Identity_Salesforce_Id IN NUMBER,
97: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
98: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
99: P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type,
100: X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
101: X_Return_Status OUT NOCOPY VARCHAR2,
102: X_Msg_Count OUT NOCOPY NUMBER,

Line 116: -- Default = FND_API_G_FALSE

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

Line 118: -- Default = FND_API.G_FALSE

114: -- p_api_version_number IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional
116: -- Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
122: -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type

Line 120: -- Default = FND_API.G_VALID_LEVEL_FULL

116: -- Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
122: -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
123: -- Required
124: --

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

132: -- End of Comments
133: --
134: PROCEDURE Delete_competitor_prods(
135: P_Api_Version_Number IN NUMBER,
136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
140: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

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

133: --
134: PROCEDURE Delete_competitor_prods(
135: P_Api_Version_Number IN NUMBER,
136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
140: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
141: P_Admin_Group_Id IN NUMBER,

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

134: PROCEDURE Delete_competitor_prods(
135: P_Api_Version_Number IN NUMBER,
136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
140: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
141: P_Admin_Group_Id IN NUMBER,
142: P_identity_salesforce_id IN NUMBER := NULL,

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

135: P_Api_Version_Number IN NUMBER,
136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
140: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
141: P_Admin_Group_Id IN NUMBER,
142: P_identity_salesforce_id IN NUMBER := NULL,
143: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

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

136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
140: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
141: P_Admin_Group_Id IN NUMBER,
142: P_identity_salesforce_id IN NUMBER := NULL,
143: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
144: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 144: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

140: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
141: P_Admin_Group_Id IN NUMBER,
142: P_identity_salesforce_id IN NUMBER := NULL,
143: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
144: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
145: P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type,
146: X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
147: X_Return_Status OUT NOCOPY VARCHAR2,
148: X_Msg_Count OUT NOCOPY NUMBER,

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

160: --
161: -- End of Comments
162:
163: PROCEDURE Validate_REQUEST_ID (
164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: P_Validation_mode IN VARCHAR2,
166: P_REQUEST_ID IN NUMBER,
167: X_Return_Status OUT NOCOPY VARCHAR2,
168: X_Msg_Count OUT NOCOPY NUMBER,

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

180: --
181: -- End of Comments
182:
183: PROCEDURE Validate_WIN_LOSS_STATUS (
184: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
185: P_Validation_mode IN VARCHAR2,
186: P_WIN_LOSS_STATUS IN VARCHAR2,
187: X_Return_Status OUT NOCOPY VARCHAR2,
188: X_Msg_Count OUT NOCOPY NUMBER,

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

190: );
191:
192:
193: PROCEDURE Validate_COMPETITOR_PRODUCT_ID (
194: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
195: P_Validation_mode IN VARCHAR2,
196: P_COMPETITOR_PRODUCT_ID IN NUMBER,
197: X_Return_Status OUT NOCOPY VARCHAR2,
198: X_Msg_Count OUT NOCOPY NUMBER,

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

210: --
211: -- End of Comments
212:
213: PROCEDURE Validate_LEAD_LINE_ID (
214: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
215: P_Validation_mode IN VARCHAR2,
216: P_LEAD_LINE_ID IN NUMBER,
217: X_Return_Status OUT NOCOPY VARCHAR2,
218: X_Msg_Count OUT NOCOPY NUMBER,

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

230: --
231: -- End of Comments
232:
233: PROCEDURE Validate_LEAD_ID (
234: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
235: P_Validation_mode IN VARCHAR2,
236: P_LEAD_ID IN NUMBER,
237: X_Return_Status OUT NOCOPY VARCHAR2,
238: X_Msg_Count OUT NOCOPY NUMBER,

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

250: --
251: -- End of Comments
252:
253: PROCEDURE Validate_L_COMPETITOR_PROD_ID (
254: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
255: P_Validation_mode IN VARCHAR2,
256: P_LEAD_COMPETITOR_PROD_ID IN NUMBER,
257: X_Return_Status OUT NOCOPY VARCHAR2,
258: X_Msg_Count OUT NOCOPY NUMBER,

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

270: -- 2. Developer can manually added inter-field level validation.
271: -- End of Comments
272:
273: PROCEDURE Validate_Competitor_Prod_rec(
274: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
275: P_Validation_mode IN VARCHAR2,
276: P_Competitor_Prod_Rec IN As_Opportunity_Pub.Competitor_Prod_Rec_Type,
277: X_Return_Status OUT NOCOPY VARCHAR2,
278: X_Msg_Count OUT NOCOPY NUMBER,

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

290: -- 2. We can also validate table instead of record. There will be an option for user to choose.
291: -- End of Comments
292:
293: PROCEDURE Validate_competitor_prod(
294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
296: P_Validation_mode IN VARCHAR2,
297: P_Competitor_Prod_Rec IN As_Opportunity_Pub.Competitor_Prod_Rec_Type,
298: X_Return_Status OUT NOCOPY VARCHAR2,

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

291: -- End of Comments
292:
293: PROCEDURE Validate_competitor_prod(
294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
296: P_Validation_mode IN VARCHAR2,
297: P_Competitor_Prod_Rec IN As_Opportunity_Pub.Competitor_Prod_Rec_Type,
298: X_Return_Status OUT NOCOPY VARCHAR2,
299: X_Msg_Count OUT NOCOPY NUMBER,