DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_HEADERS_PUB dependencies on CSP_REQUIREMENT_HEADERS_PVT

Line 36: x_pvt_RQH_rec OUT NOCOPY CSP_requirement_headers_PVT.Requirement_Header_Rec_Type

32: --
33: -- End of Comments
34: PROCEDURE Convert_RQH_Values_To_Ids(
35: P_RQH_Rec IN CSP_requirement_headers_PUB.RQH_Rec_Type,
36: x_pvt_RQH_rec OUT NOCOPY CSP_requirement_headers_PVT.Requirement_Header_Rec_Type
37: )
38: IS
39: -- Hint: Declare cursor and local variables
40: CURSOR C_Get_Task_Id(X_Task_Number VARCHAR2) IS

Line 120: PROCEDURE Validate_Requirement_Header(l_pvt_RQH_rec CSP_REQUIREMENT_HEADERS_PVT.Requirement_Header_Rec_Type) IS

116: END IF;
117:
118: END Convert_RQH_Values_To_Ids;
119:
120: PROCEDURE Validate_Requirement_Header(l_pvt_RQH_rec CSP_REQUIREMENT_HEADERS_PVT.Requirement_Header_Rec_Type) IS
121: l_count NUMBER;
122: EXCP_USER_DEFINED EXCEPTION;
123: BEGIN
124: IF (l_pvt_RQH_rec.address_type IS NOT NULL

Line 288: l_pvt_RQH_rec CSP_Requirement_Headers_PVT.Requirement_Header_Rec_Type;

284:
285: IS
286: l_api_name CONSTANT VARCHAR2(30) := 'Create_requirement_headers';
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;

Line 336: CSP_requirement_headers_PVT.Create_requirement_headers(

332: Validate_Requirement_Header(l_pvt_RQH_rec);
333:
334: -- Calling Private package: Create_Packlist_Headers
335: -- Hint: Primary key needs to be returned
336: CSP_requirement_headers_PVT.Create_requirement_headers(
337: P_Api_Version_Number => 1.0,
338: P_Init_Msg_List => FND_API.G_FALSE,
339: P_Commit => FND_API.G_FALSE,
340: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 423: l_pvt_RQH_rec CSP_Requirement_Headers_PVT.Requirement_Header_Rec_Type;

419:
420: IS
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:

Line 460: CSP_requirement_headers_PVT.Update_requirement_headers(

456: );
457:
458: Validate_Requirement_Header(l_pvt_RQH_rec);
459:
460: CSP_requirement_headers_PVT.Update_requirement_headers(
461: P_Api_Version_Number => 1.0,
462: P_Init_Msg_List => FND_API.G_FALSE,
463: P_Commit => p_commit,
464: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 548: l_pvt_RQH_rec CSP_Requirement_Headers_PVT.Requirement_Header_Rec_Type;

544:
545: IS
546: l_api_name CONSTANT VARCHAR2(30) := 'Delete_requirement_headers';
547: l_api_version_number CONSTANT NUMBER := 1.0;
548: l_pvt_RQH_rec CSP_Requirement_Headers_PVT.Requirement_Header_Rec_Type;
549: I NUMBER;
550: CURSOR rqmt_lines_cur(p_rqmt_header_id NUMBER) IS
551: SELECT REQUIREMENT_LINE_ID
552: /* CREATED_BY,

Line 668: CSP_requirement_headers_PVT.Delete_requirement_headers(

664: raise FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;
666: END IF;
667:
668: CSP_requirement_headers_PVT.Delete_requirement_headers(
669: P_Api_Version_Number => 1.0,
670: P_Init_Msg_List => FND_API.G_FALSE,
671: P_Commit => p_commit,
672: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,