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
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
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
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
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: --
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,
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,
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,
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
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
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
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
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
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,
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,
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
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
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
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
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
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
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,
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,
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