eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AST_RS_CAMP_PVT dependencies on FND_API

Line 40: RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,

36: -- End of Comments
37:
38: TYPE rs_camp_Rec_Type IS RECORD
39: (
40: RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,

Line 41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

37:
38: TYPE rs_camp_Rec_Type IS RECORD
39: (
40: RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,

38: TYPE rs_camp_Rec_Type IS RECORD
39: (
40: RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 43: START_DATE DATE := FND_API.G_MISS_DATE,

39: (
40: RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 44: END_DATE DATE := FND_API.G_MISS_DATE,

40: RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,

41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 48: CREATION_DATE DATE := FND_API.G_MISS_DATE,

44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR
52: );

Line 49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR
52: );
53:

Line 50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR
52: );
53:
54: G_MISS_rs_camp_REC rs_camp_Rec_Type;

Line 51: LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR

47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR
52: );
53:
54: G_MISS_rs_camp_REC rs_camp_Rec_Type;
55: TYPE rs_camp_Tbl_Type IS TABLE OF rs_camp_Rec_Type

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

64: -- Pre-Req :
65: -- Parameters:
66: -- IN
67: -- p_api_version_number IN NUMBER Required
68: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
69: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
70: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
71: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
72: --

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

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

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

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

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

84: FUNCTION get_CAMPAIGN_REC RETURN AST_RS_CAMP_PVT.rs_camp_rec_type;
85:
86: PROCEDURE Create_rs_camp(
87: P_Api_Version_Number IN NUMBER,
88: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: P_rs_camp_Rec IN rs_camp_Rec_Type := G_MISS_rs_camp_REC,
92: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

85:
86: PROCEDURE Create_rs_camp(
87: P_Api_Version_Number IN NUMBER,
88: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: P_rs_camp_Rec IN rs_camp_Rec_Type := G_MISS_rs_camp_REC,
92: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
93: X_RS_CAMPAIGN_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

86: PROCEDURE Create_rs_camp(
87: P_Api_Version_Number IN NUMBER,
88: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: P_rs_camp_Rec IN rs_camp_Rec_Type := G_MISS_rs_camp_REC,
92: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
93: X_RS_CAMPAIGN_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
94: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

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

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

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

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

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

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

124: --
125: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
126: PROCEDURE Update_rs_camp(
127: P_Api_Version_Number IN NUMBER,
128: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
129: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
130: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
131: P_Identity_Salesforce_Id IN NUMBER := NULL,
132: P_rs_camp_Rec IN rs_camp_Rec_Type,

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

125: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
126: PROCEDURE Update_rs_camp(
127: P_Api_Version_Number IN NUMBER,
128: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
129: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
130: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
131: P_Identity_Salesforce_Id IN NUMBER := NULL,
132: P_rs_camp_Rec IN rs_camp_Rec_Type,
133: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

126: PROCEDURE Update_rs_camp(
127: P_Api_Version_Number IN NUMBER,
128: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
129: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
130: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
131: P_Identity_Salesforce_Id IN NUMBER := NULL,
132: P_rs_camp_Rec IN rs_camp_Rec_Type,
133: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
134: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

143: -- Pre-Req :
144: -- Parameters:
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
151: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required

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

144: -- Parameters:
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
151: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
152: --

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

145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
151: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
152: --
153: -- OUT:

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

164: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
165: -- The Master delete procedure may not be needed depends on different business requirements.
166: PROCEDURE Delete_rs_camp(
167: P_Api_Version_Number IN NUMBER,
168: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
169: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: P_identity_salesforce_id IN NUMBER := NULL,
172: P_rs_camp_Rec IN rs_camp_Rec_Type,

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

165: -- The Master delete procedure may not be needed depends on different business requirements.
166: PROCEDURE Delete_rs_camp(
167: P_Api_Version_Number IN NUMBER,
168: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
169: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: P_identity_salesforce_id IN NUMBER := NULL,
172: P_rs_camp_Rec IN rs_camp_Rec_Type,
173: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

166: PROCEDURE Delete_rs_camp(
167: P_Api_Version_Number IN NUMBER,
168: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
169: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: P_identity_salesforce_id IN NUMBER := NULL,
172: P_rs_camp_Rec IN rs_camp_Rec_Type,
173: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
174: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

183: -- Pre-Req :
184: -- Parameters:
185: -- IN
186: -- p_api_version_number IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
188: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
189: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
190: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
191: -- Hint: Add List of bind variables here

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

184: -- Parameters:
185: -- IN
186: -- p_api_version_number IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
188: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
189: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
190: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
191: -- Hint: Add List of bind variables here
192: -- p_rec_requested IN NUMBER Optional Default = 30

Line 198: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE

194: --
195: -- Return Total Records Count Flag. This flag controls whether the total record count
196: -- and total record amount is returned.
197: --
198: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
199: -- Hint: User defined record type
200: -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
201: --
202: -- OUT:

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

217: -- End of Comments
218: --
219: PROCEDURE Get_rs_camp(
220: P_Api_Version_Number IN NUMBER,
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: P_identity_salesforce_id IN NUMBER := NULL,
224: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,
225: -- Hint: Add list of bind variables here

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

218: --
219: PROCEDURE Get_rs_camp(
220: P_Api_Version_Number IN NUMBER,
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: P_identity_salesforce_id IN NUMBER := NULL,
224: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,
225: -- Hint: Add list of bind variables here
226: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

Line 228: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

224: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,
225: -- Hint: Add list of bind variables here
226: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
227: p_start_rec_prt IN NUMBER := 1,
228: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
229: -- Hint: user defined record type
230: p_order_by_rec IN AST_rs_camp_PUB.rs_camp_sort_rec_type,
231: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
232: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

250: --
251: -- End of Comments
252:
253: PROCEDURE Validate_RS_CAMPAIGN_ID (
254: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
255: P_Validation_mode IN VARCHAR2,
256: P_RS_CAMPAIGN_ID IN NUMBER,
257: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
258:

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

272: --
273: -- End of Comments
274:
275: PROCEDURE Validate_RESOURCE_ID (
276: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
277: P_Validation_mode IN VARCHAR2,
278: P_RESOURCE_ID IN NUMBER,
279: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
280:

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

294: --
295: -- End of Comments
296:
297: PROCEDURE Validate_CAMPAIGN_ID (
298: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
299: P_Validation_mode IN VARCHAR2,
300: P_CAMPAIGN_ID IN NUMBER,
301: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
302:

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

316: --
317: -- End of Comments
318:
319: PROCEDURE Validate_START_DATE (
320: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
321: P_Validation_mode IN VARCHAR2,
322: P_START_DATE IN DATE,
323: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
324:

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

338: --
339: -- End of Comments
340:
341: PROCEDURE Validate_END_DATE (
342: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
343: P_Validation_mode IN VARCHAR2,
344: P_END_DATE IN DATE,
345: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
346:

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

360: --
361: -- End of Comments
362:
363: PROCEDURE Validate_STATUS (
364: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
365: P_Validation_mode IN VARCHAR2,
366: P_STATUS IN VARCHAR2,
367: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
368:

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

382: --
383: -- End of Comments
384:
385: PROCEDURE Validate_ENABLED_FLAG (
386: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
387: P_Validation_mode IN VARCHAR2,
388: P_ENABLED_FLAG IN VARCHAR2,
389: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
390:

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

404: -- 2. Developer can manually added inter-field level validation.
405: -- End of Comments
406:
407: PROCEDURE Validate_rs_camp_rec(
408: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
409: P_Validation_mode IN VARCHAR2,
410: P_rs_camp_Rec IN rs_camp_Rec_Type,
411: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
412: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

425:
426: -- End of Comments
427:
428: PROCEDURE Validate_rs_camp(
429: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
430: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
431: P_Validation_mode IN VARCHAR2,
432: P_rs_camp_Rec IN rs_camp_Rec_Type,
433: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

426: -- End of Comments
427:
428: PROCEDURE Validate_rs_camp(
429: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
430: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
431: P_Validation_mode IN VARCHAR2,
432: P_rs_camp_Rec IN rs_camp_Rec_Type,
433: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
434: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,