[Home] [Help]
287: l_api_version_number CONSTANT NUMBER := 1.0;
288: l_pvt_RQH_rec CSP_Requirement_Headers_PVT.Requirement_Header_Rec_Type;
289: l_requirement_header_id NUMBER;
290: BEGIN
291: -- Standard Start of API savepoint
292: SAVEPOINT CREATE_Requirement_Headers_PUB;
293:
294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
290: BEGIN
291: -- Standard Start of API savepoint
292: SAVEPOINT CREATE_Requirement_Headers_PUB;
293:
294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
296: p_api_version_number,
297: l_api_name,
298: G_PKG_NAME)
355: x_requirement_header_id := l_requirement_header_id;
356: --
357: -- End of API body.
358: --
359: -- Standard check for p_commit
360: IF FND_API.to_Boolean( p_commit )
361: THEN
362: COMMIT WORK;
363: END IF;
366: -- Debug Message
367: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
368:
369:
370: -- Standard call to get message count and if count is 1, get message info.
371: FND_MSG_PUB.Count_And_Get
372: ( p_count => x_msg_count,
373: p_data => x_msg_data
374: );
421: l_api_name CONSTANT VARCHAR2(30) := 'Update_requirement_headers';
422: l_api_version_number CONSTANT NUMBER := 1.0;
423: l_pvt_RQH_rec CSP_Requirement_Headers_PVT.Requirement_Header_Rec_Type;
424: BEGIN
425: -- Standard Start of API savepoint
426: SAVEPOINT UPDATE_Packlist_Headers_PUB;
427:
428: -- Standard call to check for call compatibility.
429: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
424: BEGIN
425: -- Standard Start of API savepoint
426: SAVEPOINT UPDATE_Packlist_Headers_PUB;
427:
428: -- Standard call to check for call compatibility.
429: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
430: p_api_version_number,
431: l_api_name,
432: G_PKG_NAME)
479: --
480: -- End of API body
481: --
482:
483: -- Standard check for p_commit
484: IF FND_API.to_Boolean( p_commit )
485: THEN
486: COMMIT WORK;
487: END IF;
490: -- Debug Message
491: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
492:
493:
494: -- Standard call to get message count and if count is 1, get message info.
495: FND_MSG_PUB.Count_And_Get
496: ( p_count => x_msg_count,
497: p_data => x_msg_data
498: );
594: WHERE requirement_header_id = p_rqmt_header_id;
595: l_RQL_TBL CSP_Requirement_lines_PUB.RQL_Tbl_Type;
596: l_RQL_Rec CSP_Requirement_lines_PUB.RQL_Rec_Type;
597: BEGIN
598: -- Standard Start of API savepoint
599: SAVEPOINT DELETE_Requirement_Headers_PUB;
600:
601: -- Standard call to check for call compatibility.
602: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
597: BEGIN
598: -- Standard Start of API savepoint
599: SAVEPOINT DELETE_Requirement_Headers_PUB;
600:
601: -- Standard call to check for call compatibility.
602: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
603: p_api_version_number,
604: l_api_name,
605: G_PKG_NAME)
685: --
686: -- End of API body
687: --
688:
689: -- Standard check for p_commit
690: IF FND_API.to_Boolean( p_commit )
691: THEN
692: COMMIT WORK;
693: END IF;
694:
695: -- Debug Message
696: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
697:
698: -- Standard call to get message count and if count is 1, get message info.
699: FND_MSG_PUB.Count_And_Get
700: ( p_count => x_msg_count,
701: p_data => x_msg_data
702: );