APPS.AST_CAMP_REASON_PVT dependencies on FND_API

Line 29: reason_id NUMBER := FND_API.G_MISS_NUM,

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

Line 30: object_id NUMBER := FND_API.G_MISS_NUM,

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

Line 31: object_version_number NUMBER := FND_API.G_MISS_NUM,

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

Line 32: created_by NUMBER := FND_API.G_MISS_NUM,

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

Line 33: creation_date DATE := FND_API.G_MISS_DATE,

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

Line 34: last_updated_by NUMBER := FND_API.G_MISS_NUM,

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

Line 35: last_update_date DATE := FND_API.G_MISS_DATE,

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

Line 36: last_update_login NUMBER := FND_API.G_MISS_NUM,

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

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

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

Line 38: source_code_id NUMBER := FND_API.G_MISS_NUM,

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

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

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

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

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

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

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

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

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

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

72: FUNCTION get_camp_reason_REC RETURN AST_camp_reason_PVT.camp_reason_rec_type;
73:
74: PROCEDURE Create_camp_reason(
75: P_Api_Version_Number IN NUMBER,
76: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
77: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79: P_camp_reason_Rec IN camp_reason_Rec_Type := G_MISS_camp_reason_REC,
80: X_Return_Status OUT VARCHAR2,

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

73:
74: PROCEDURE Create_camp_reason(
75: P_Api_Version_Number IN NUMBER,
76: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
77: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79: P_camp_reason_Rec IN camp_reason_Rec_Type := G_MISS_camp_reason_REC,
80: X_Return_Status OUT VARCHAR2,
81: X_Msg_Count OUT NUMBER,

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

74: PROCEDURE Create_camp_reason(
75: P_Api_Version_Number IN NUMBER,
76: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
77: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79: P_camp_reason_Rec IN camp_reason_Rec_Type := G_MISS_camp_reason_REC,
80: X_Return_Status OUT VARCHAR2,
81: X_Msg_Count OUT NUMBER,
82: X_Msg_Data OUT VARCHAR2

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

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

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

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

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

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

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

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

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

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

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

112: PROCEDURE Delete_camp_reason(
113: P_Api_Version_Number IN NUMBER,
114: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
115: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: P_camp_reason_Rec IN camp_reason_Rec_Type,
118: X_Return_Status OUT VARCHAR2,
119: X_Msg_Count OUT NUMBER,
120: X_Msg_Data OUT VARCHAR2