DBA Data[Home] [Help]

APPS.CSP_REQ_LINE_DETAILS_PVT dependencies on FND_API

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

58: -- Pre-Req :
59: -- Parameters:
60: -- IN
61: -- p_api_version_number IN NUMBER Required
62: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
63: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
66: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

59: -- Parameters:
60: -- IN
61: -- p_api_version_number IN NUMBER Required
62: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
63: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
66: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
67: -- p_admin_group_id IN NUMBER Required

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

60: -- IN
61: -- p_api_version_number IN NUMBER Required
62: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
63: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
66: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
67: -- p_admin_group_id IN NUMBER Required
68: -- P_Req_Line_Details_Rec IN Req_Line_Details_Rec_Type Required

Line 65: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

61: -- p_api_version_number IN NUMBER Required
62: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
63: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
66: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
67: -- p_admin_group_id IN NUMBER Required
68: -- P_Req_Line_Details_Rec IN Req_Line_Details_Rec_Type Required
69: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

62: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
63: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
66: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
67: -- p_admin_group_id IN NUMBER Required
68: -- P_Req_Line_Details_Rec IN Req_Line_Details_Rec_Type Required
69: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
70: --

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

79: -- End of Comments
80: --
81: PROCEDURE Create_req_line_details(
82: P_Api_Version_Number IN NUMBER,
83: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
84: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: P_Req_Line_Details_Tbl IN Req_Line_Details_Tbl_Type := G_MISS_Req_Line_Details_Tbl,
87: x_Req_Line_Details_tbl OUT NOCOPY Req_Line_Details_Tbl_Type,

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

80: --
81: PROCEDURE Create_req_line_details(
82: P_Api_Version_Number IN NUMBER,
83: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
84: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: P_Req_Line_Details_Tbl IN Req_Line_Details_Tbl_Type := G_MISS_Req_Line_Details_Tbl,
87: x_Req_Line_Details_tbl OUT NOCOPY Req_Line_Details_Tbl_Type,
88: X_Return_Status OUT NOCOPY VARCHAR2,

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

81: PROCEDURE Create_req_line_details(
82: P_Api_Version_Number IN NUMBER,
83: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
84: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: P_Req_Line_Details_Tbl IN Req_Line_Details_Tbl_Type := G_MISS_Req_Line_Details_Tbl,
87: x_Req_Line_Details_tbl OUT NOCOPY Req_Line_Details_Tbl_Type,
88: X_Return_Status OUT NOCOPY VARCHAR2,
89: X_Msg_Count OUT NOCOPY NUMBER,

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

98: -- Pre-Req :
99: -- Parameters:
100: -- IN
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

99: -- Parameters:
100: -- IN
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_admin_group_id IN NUMBER Required

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

100: -- IN
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_admin_group_id IN NUMBER Required
108: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

Line 105: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_admin_group_id IN NUMBER Required
108: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
109: -- P_Req_Line_Details_Rec IN Req_Line_Details_Rec_Type Required

Line 106: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_admin_group_id IN NUMBER Required
108: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
109: -- P_Req_Line_Details_Rec IN Req_Line_Details_Rec_Type Required
110: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

121: --
122: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
123: PROCEDURE Update_req_line_details(
124: P_Api_Version_Number IN NUMBER,
125: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
126: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128: P_Req_Line_Details_Tbl IN Req_Line_Details_Tbl_Type,
129: X_Return_Status OUT NOCOPY VARCHAR2,

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

122: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
123: PROCEDURE Update_req_line_details(
124: P_Api_Version_Number IN NUMBER,
125: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
126: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128: P_Req_Line_Details_Tbl IN Req_Line_Details_Tbl_Type,
129: X_Return_Status OUT NOCOPY VARCHAR2,
130: X_Msg_Count OUT NOCOPY NUMBER,

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

123: PROCEDURE Update_req_line_details(
124: P_Api_Version_Number IN NUMBER,
125: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
126: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128: P_Req_Line_Details_Tbl IN Req_Line_Details_Tbl_Type,
129: X_Return_Status OUT NOCOPY VARCHAR2,
130: X_Msg_Count OUT NOCOPY NUMBER,
131: X_Msg_Data OUT NOCOPY VARCHAR2

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

139: -- Pre-Req :
140: -- Parameters:
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
147: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

140: -- Parameters:
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
147: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_admin_group_id IN NUMBER Required

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

141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
147: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_admin_group_id IN NUMBER Required
149: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

Line 146: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
147: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_admin_group_id IN NUMBER Required
149: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
150: -- P_Req_Line_Details_Rec IN Requirement_Line_details_Rec_Type Required

Line 147: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
147: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_admin_group_id IN NUMBER Required
149: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
150: -- P_Req_Line_Details_Rec IN Requirement_Line_details_Rec_Type Required
151: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

163: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
164: -- The Master delete procedure may not be needed depends on different business requirements.
165: PROCEDURE Delete_req_line_details(
166: P_Api_Version_Number IN NUMBER,
167: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
168: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: P_Req_Line_Details_Tbl IN Req_Line_Details_Tbl_Type,
171: X_Return_Status OUT NOCOPY VARCHAR2,

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

164: -- The Master delete procedure may not be needed depends on different business requirements.
165: PROCEDURE Delete_req_line_details(
166: P_Api_Version_Number IN NUMBER,
167: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
168: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: P_Req_Line_Details_Tbl IN Req_Line_Details_Tbl_Type,
171: X_Return_Status OUT NOCOPY VARCHAR2,
172: X_Msg_Count OUT NOCOPY NUMBER,

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

165: PROCEDURE Delete_req_line_details(
166: P_Api_Version_Number IN NUMBER,
167: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
168: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: P_Req_Line_Details_Tbl IN Req_Line_Details_Tbl_Type,
171: X_Return_Status OUT NOCOPY VARCHAR2,
172: X_Msg_Count OUT NOCOPY NUMBER,
173: X_Msg_Data OUT NOCOPY VARCHAR2