eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_REQUIREMENT_LINES_PUB dependencies on CSP_REQUIREMENT_LINES_PVT

Line 36: x_pvt_RQL_tbl OUT NOCOPY CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type

32: --
33: -- End of Comments
34: PROCEDURE Convert_RQL_Values_To_Ids(
35: P_RQL_Tbl IN CSP_REQUIREMENT_LINES_PUB.RQL_Tbl_Type,
36: x_pvt_RQL_tbl OUT NOCOPY CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type
37: )
38: IS
39: l_any_errors BOOLEAN := FALSE;
40: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;

Line 40: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;

36: x_pvt_RQL_tbl OUT NOCOPY CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type
37: )
38: IS
39: l_any_errors BOOLEAN := FALSE;
40: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;
41: l_RQL_rec CSP_REQUIREMENT_LINES_PUB.RQL_Rec_Type;
42: l_inventory_item_id Number;
43: -- Hint: Declare cursor and local variables
44: CURSOR C_Get_Item_Id IS

Line 162: PROCEDURE Validate_Requirement_Lines(l_pvt_RQL_Tbl IN CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type) IS

158: END IF;
159: */
160: END Convert_RQL_Values_To_Ids;
161:
162: PROCEDURE Validate_Requirement_Lines(l_pvt_RQL_Tbl IN CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type) IS
163: l_count NUMBER;
164: EXCP_USER_DEFINED EXCEPTION;
165: BEGIN
166: FOR I IN 1..l_pvt_RQL_TBL.COUNT LOOP

Line 278: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;

274:
275: IS
276: l_api_name CONSTANT VARCHAR2(30) := 'Create_REQUIREMENT_LINES';
277: l_api_version_number CONSTANT NUMBER := 1.0;
278: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;
279: l_pvt_RQL_tbl CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;
280: l_pvt_RQL_tbl1 CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;
281: BEGIN
282: -- Standard Start of API savepoint

Line 279: l_pvt_RQL_tbl CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;

275: IS
276: l_api_name CONSTANT VARCHAR2(30) := 'Create_REQUIREMENT_LINES';
277: l_api_version_number CONSTANT NUMBER := 1.0;
278: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;
279: l_pvt_RQL_tbl CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;
280: l_pvt_RQL_tbl1 CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;
281: BEGIN
282: -- Standard Start of API savepoint
283: SAVEPOINT CREATE_REQUIREMENT_LINES_PUB;

Line 280: l_pvt_RQL_tbl1 CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;

276: l_api_name CONSTANT VARCHAR2(30) := 'Create_REQUIREMENT_LINES';
277: l_api_version_number CONSTANT NUMBER := 1.0;
278: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;
279: l_pvt_RQL_tbl CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;
280: l_pvt_RQL_tbl1 CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;
281: BEGIN
282: -- Standard Start of API savepoint
283: SAVEPOINT CREATE_REQUIREMENT_LINES_PUB;
284:

Line 327: CSP_REQUIREMENT_LINES_PVT.Create_REQUIREMENT_LINES(

323: Validate_Requirement_Lines(l_pvt_RQL_Tbl);
324:
325: -- Calling Private package: Create_Requirement_Lines
326: -- Hint: Primary key needs to be returned
327: CSP_REQUIREMENT_LINES_PVT.Create_REQUIREMENT_LINES(
328: P_Api_Version_Number => 1.0,
329: P_Init_Msg_List => FND_API.G_FALSE,
330: P_Commit => FND_API.G_FALSE,
331: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 454: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;

450:
451: IS
452: l_api_name CONSTANT VARCHAR2(30) := 'Update_REQUIREMENT_LINES';
453: l_api_version_number CONSTANT NUMBER := 1.0;
454: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;
455: l_pvt_RQL_Tbl CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;
456: BEGIN
457: -- Standard Start of API savepoint
458: SAVEPOINT UPDATE_Packlist_Headers_PUB;

Line 455: l_pvt_RQL_Tbl CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;

451: IS
452: l_api_name CONSTANT VARCHAR2(30) := 'Update_REQUIREMENT_LINES';
453: l_api_version_number CONSTANT NUMBER := 1.0;
454: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;
455: l_pvt_RQL_Tbl CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;
456: BEGIN
457: -- Standard Start of API savepoint
458: SAVEPOINT UPDATE_Packlist_Headers_PUB;
459:

Line 500: CSP_REQUIREMENT_LINES_PVT.Update_REQUIREMENT_LINES(

496: );
497:
498: Validate_Requirement_Lines(l_pvt_RQL_Tbl);
499:
500: CSP_REQUIREMENT_LINES_PVT.Update_REQUIREMENT_LINES(
501: P_Api_Version_Number => 1.0,
502: P_Init_Msg_List => FND_API.G_FALSE,
503: P_Commit => p_commit,
504: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 588: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;

584:
585: IS
586: l_api_name CONSTANT VARCHAR2(30) := 'Delete_REQUIREMENT_LINES';
587: l_api_version_number CONSTANT NUMBER := 1.0;
588: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;
589: l_pvt_RQL_Tbl CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;
590: l_count NUMBER;
591: EXCP_USER_DEFINED EXCEPTION;
592: BEGIN

Line 589: l_pvt_RQL_Tbl CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;

585: IS
586: l_api_name CONSTANT VARCHAR2(30) := 'Delete_REQUIREMENT_LINES';
587: l_api_version_number CONSTANT NUMBER := 1.0;
588: l_pvt_RQL_rec CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Rec_Type;
589: l_pvt_RQL_Tbl CSP_REQUIREMENT_LINES_PVT.Requirement_Line_Tbl_Type;
590: l_count NUMBER;
591: EXCP_USER_DEFINED EXCEPTION;
592: BEGIN
593: -- Standard Start of API savepoint

Line 653: CSP_REQUIREMENT_LINES_PVT.Delete_REQUIREMENT_LINES(

649: null;
650: END;
651: END LOOP;
652:
653: CSP_REQUIREMENT_LINES_PVT.Delete_REQUIREMENT_LINES(
654: P_Api_Version_Number => 1.0,
655: P_Init_Msg_List => FND_API.G_FALSE,
656: P_Commit => p_commit,
657: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,