APPS.CSP_RESOURCE_PUB dependencies on CSP_RESOURCE_PVT

Line 26: -- klou 01/12/00 Add CSP_Resource_PVT.CSP_Rec_Type record parameters and p_action_code.

22: -- UserID Date Comments
23: -- ----------- -------- --------------------------
24: -- klou 01/20/00 Modify exception handlings and message libraries such that they are compliant with
25: -- CRM standard.
26: -- klou 01/12/00 Add CSP_Resource_PVT.CSP_Rec_Type record parameters and p_action_code.
27: -- p_action_code: 0 = insert, 1 = update, 2 = delete.
28: -- Add update and delete operations.
29: -- klou 01/11/99 Add validatoins on Resource_id and Resource_type.
30: -- klou 12/16/99 Include validation of subinventory_type against Part-in and Part-out default code.

Line 92: l_csp_rec CSP_RESOURCE_PVT.CSP_Rec_Type;

88:
89: IS
90: l_api_version_number CONSTANT NUMBER := 1.0;
91: l_api_name CONSTANT VARCHAR2(30) := 'Assign_Resource_Inv_Loc';
92: l_csp_rec CSP_RESOURCE_PVT.CSP_Rec_Type;
93: l_return_status VARCHAR2(1);
94: l_msg_count NUMBER := 0;
95: l_msg_data VARCHAR2(500);
96: l_check_existence NUMBER := 0;

Line 401: CSP_RESOURCE_PVT.Create_resource(

397: l_csp_rec.ATTRIBUTE13 := p_ATTRIBUTE13;
398: l_csp_rec.ATTRIBUTE14 := p_ATTRIBUTE14;
399: l_csp_rec.ATTRIBUTE15 := p_ATTRIBUTE15;
400:
401: CSP_RESOURCE_PVT.Create_resource(
402: P_Api_Version_Number => p_api_version_number,
403: P_Init_Msg_List => FND_API.G_TRUE,
404: P_Commit => FND_API.G_FALSE,
405: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

Line 482: l_csp_rec_update CSP_RESOURCE_PVT.CSP_Rec_Type;

478: IF p_action_code = 1 THEN
479: -- we have to make sure that by updating an existing a record. A
480: -- duplicate record will not be created.
481: DECLARE
482: l_csp_rec_update CSP_RESOURCE_PVT.CSP_Rec_Type;
483: l_result NUMBER;
484: CURSOR C_Get_Inv_Loc_Assignments IS
485: SELECT CSP_INV_LOC_ASSIGNMENT_ID ,
486: CREATED_BY ,

Line 662: CSP_RESOURCE_PVT.Update_resource(

658: FROM csp_inv_loc_assignments
659: WHERE csp_inv_loc_assignment_id = l_csp_rec.csp_inv_loc_assignment_id;
660: END;
661: END IF;
662: CSP_RESOURCE_PVT.Update_resource(
663: P_Api_Version_Number => p_api_version_number,
664: P_Init_Msg_List => FND_API.G_TRUE,
665: P_Commit => FND_API.G_FALSE,
666: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

Line 674: CSP_RESOURCE_PVT.Delete_resource(

670: X_Msg_Data => l_msg_data
671: );
672: ELSE
673: -- call the delete procedure
674: CSP_RESOURCE_PVT.Delete_resource(
675: P_Api_Version_Number => p_api_version_number,
676: P_Init_Msg_List => FND_API.G_TRUE,
677: P_Commit => FND_API.G_FALSE,
678: p_validation_level => FND_API.G_VALID_LEVEL_NONE,