APPS.AST_CAMP_RESULT_PVT dependencies on FND_API

Line 28: result_id NUMBER := FND_API.G_MISS_NUM,

24: -- End of Comments
25:
26: TYPE camp_result_Rec_Type IS RECORD
27: (
28: result_id NUMBER := FND_API.G_MISS_NUM,
29: object_id NUMBER := FND_API.G_MISS_NUM,
30: object_version_number NUMBER := FND_API.G_MISS_NUM,
31: created_by NUMBER := FND_API.G_MISS_NUM,
32: creation_date DATE := FND_API.G_MISS_DATE,

Line 29: object_id NUMBER := FND_API.G_MISS_NUM,

25:
26: TYPE camp_result_Rec_Type IS RECORD
27: (
28: result_id NUMBER := FND_API.G_MISS_NUM,
29: object_id NUMBER := FND_API.G_MISS_NUM,
30: object_version_number NUMBER := FND_API.G_MISS_NUM,
31: created_by NUMBER := FND_API.G_MISS_NUM,
32: creation_date DATE := FND_API.G_MISS_DATE,
33: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 30: object_version_number NUMBER := FND_API.G_MISS_NUM,

26: TYPE camp_result_Rec_Type IS RECORD
27: (
28: result_id NUMBER := FND_API.G_MISS_NUM,
29: object_id NUMBER := FND_API.G_MISS_NUM,
30: object_version_number NUMBER := FND_API.G_MISS_NUM,
31: created_by NUMBER := FND_API.G_MISS_NUM,
32: creation_date DATE := FND_API.G_MISS_DATE,
33: last_updated_by NUMBER := FND_API.G_MISS_NUM,
34: last_update_date DATE := FND_API.G_MISS_DATE,

Line 31: created_by NUMBER := FND_API.G_MISS_NUM,

27: (
28: result_id NUMBER := FND_API.G_MISS_NUM,
29: object_id NUMBER := FND_API.G_MISS_NUM,
30: object_version_number NUMBER := FND_API.G_MISS_NUM,
31: created_by NUMBER := FND_API.G_MISS_NUM,
32: creation_date DATE := FND_API.G_MISS_DATE,
33: last_updated_by NUMBER := FND_API.G_MISS_NUM,
34: last_update_date DATE := FND_API.G_MISS_DATE,
35: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 32: creation_date DATE := FND_API.G_MISS_DATE,

28: result_id NUMBER := FND_API.G_MISS_NUM,
29: object_id NUMBER := FND_API.G_MISS_NUM,
30: object_version_number NUMBER := FND_API.G_MISS_NUM,
31: created_by NUMBER := FND_API.G_MISS_NUM,
32: creation_date DATE := FND_API.G_MISS_DATE,
33: last_updated_by NUMBER := FND_API.G_MISS_NUM,
34: last_update_date DATE := FND_API.G_MISS_DATE,
35: last_update_login NUMBER := FND_API.G_MISS_NUM,
36: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 33: last_updated_by NUMBER := FND_API.G_MISS_NUM,

29: object_id NUMBER := FND_API.G_MISS_NUM,
30: object_version_number NUMBER := FND_API.G_MISS_NUM,
31: created_by NUMBER := FND_API.G_MISS_NUM,
32: creation_date DATE := FND_API.G_MISS_DATE,
33: last_updated_by NUMBER := FND_API.G_MISS_NUM,
34: last_update_date DATE := FND_API.G_MISS_DATE,
35: last_update_login NUMBER := FND_API.G_MISS_NUM,
36: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: source_code_id NUMBER := FND_API.G_MISS_NUM,

Line 34: last_update_date DATE := FND_API.G_MISS_DATE,

30: object_version_number NUMBER := FND_API.G_MISS_NUM,
31: created_by NUMBER := FND_API.G_MISS_NUM,
32: creation_date DATE := FND_API.G_MISS_DATE,
33: last_updated_by NUMBER := FND_API.G_MISS_NUM,
34: last_update_date DATE := FND_API.G_MISS_DATE,
35: last_update_login NUMBER := FND_API.G_MISS_NUM,
36: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: source_code_id NUMBER := FND_API.G_MISS_NUM,
38: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 35: last_update_login NUMBER := FND_API.G_MISS_NUM,

31: created_by NUMBER := FND_API.G_MISS_NUM,
32: creation_date DATE := FND_API.G_MISS_DATE,
33: last_updated_by NUMBER := FND_API.G_MISS_NUM,
34: last_update_date DATE := FND_API.G_MISS_DATE,
35: last_update_login NUMBER := FND_API.G_MISS_NUM,
36: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: source_code_id NUMBER := FND_API.G_MISS_NUM,
38: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39: );

Line 36: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

32: creation_date DATE := FND_API.G_MISS_DATE,
33: last_updated_by NUMBER := FND_API.G_MISS_NUM,
34: last_update_date DATE := FND_API.G_MISS_DATE,
35: last_update_login NUMBER := FND_API.G_MISS_NUM,
36: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: source_code_id NUMBER := FND_API.G_MISS_NUM,
38: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39: );
40:

Line 37: source_code_id NUMBER := FND_API.G_MISS_NUM,

33: last_updated_by NUMBER := FND_API.G_MISS_NUM,
34: last_update_date DATE := FND_API.G_MISS_DATE,
35: last_update_login NUMBER := FND_API.G_MISS_NUM,
36: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: source_code_id NUMBER := FND_API.G_MISS_NUM,
38: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39: );
40:
41: G_MISS_camp_result_REC camp_result_Rec_Type;

Line 38: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR

34: last_update_date DATE := FND_API.G_MISS_DATE,
35: last_update_login NUMBER := FND_API.G_MISS_NUM,
36: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: source_code_id NUMBER := FND_API.G_MISS_NUM,
38: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39: );
40:
41: G_MISS_camp_result_REC camp_result_Rec_Type;
42: TYPE camp_result_Tbl_Type IS TABLE OF camp_result_Rec_Type

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

51: -- Pre-Req :
52: -- Parameters:
53: -- IN
54: -- p_api_version_number IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
56: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
57: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
58: -- P_camp_result_Rec IN camp_result_Rec_Type Required
59: --

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

52: -- Parameters:
53: -- IN
54: -- p_api_version_number IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
56: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
57: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
58: -- P_camp_result_Rec IN camp_result_Rec_Type Required
59: --
60: -- OUT:

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

53: -- IN
54: -- p_api_version_number IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
56: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
57: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
58: -- P_camp_result_Rec IN camp_result_Rec_Type Required
59: --
60: -- OUT:
61: -- x_return_status OUT VARCHAR2

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

71: FUNCTION get_camp_result_REC RETURN AST_camp_result_PVT.camp_result_rec_type;
72:
73: PROCEDURE Create_camp_result(
74: P_Api_Version_Number IN NUMBER,
75: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
76: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: P_camp_result_Rec IN camp_result_Rec_Type := G_MISS_camp_result_REC,
79: X_Return_Status OUT VARCHAR2,

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

72:
73: PROCEDURE Create_camp_result(
74: P_Api_Version_Number IN NUMBER,
75: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
76: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: P_camp_result_Rec IN camp_result_Rec_Type := G_MISS_camp_result_REC,
79: X_Return_Status OUT VARCHAR2,
80: X_Msg_Count OUT NUMBER,

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

73: PROCEDURE Create_camp_result(
74: P_Api_Version_Number IN NUMBER,
75: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
76: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: P_camp_result_Rec IN camp_result_Rec_Type := G_MISS_camp_result_REC,
79: X_Return_Status OUT VARCHAR2,
80: X_Msg_Count OUT NUMBER,
81: X_Msg_Data OUT VARCHAR2

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

89: -- Pre-Req :
90: -- Parameters:
91: -- IN
92: -- p_api_version_number IN NUMBER Required
93: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
94: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
95: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
96: -- P_camp_result_Rec IN camp_result_Rec_Type Required
97: --

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

90: -- Parameters:
91: -- IN
92: -- p_api_version_number IN NUMBER Required
93: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
94: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
95: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
96: -- P_camp_result_Rec IN camp_result_Rec_Type Required
97: --
98: -- OUT:

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

91: -- IN
92: -- p_api_version_number IN NUMBER Required
93: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
94: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
95: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
96: -- P_camp_result_Rec IN camp_result_Rec_Type Required
97: --
98: -- OUT:
99: -- x_return_status OUT VARCHAR2

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

109: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
110: -- The Master delete procedure may not be needed depends on different business requirements.
111: PROCEDURE Delete_camp_result(
112: P_Api_Version_Number IN NUMBER,
113: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
114: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: P_camp_result_Rec IN camp_result_Rec_Type,
117: X_Return_Status OUT VARCHAR2,

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

110: -- The Master delete procedure may not be needed depends on different business requirements.
111: PROCEDURE Delete_camp_result(
112: P_Api_Version_Number IN NUMBER,
113: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
114: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: P_camp_result_Rec IN camp_result_Rec_Type,
117: X_Return_Status OUT VARCHAR2,
118: X_Msg_Count OUT NUMBER,

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

111: PROCEDURE Delete_camp_result(
112: P_Api_Version_Number IN NUMBER,
113: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
114: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: P_camp_result_Rec IN camp_result_Rec_Type,
117: X_Return_Status OUT VARCHAR2,
118: X_Msg_Count OUT NUMBER,
119: X_Msg_Data OUT VARCHAR2