DBA Data[Home] [Help]

APPS.CSP_PC_FORM_PICKHEADERS dependencies on CSP_PICKLIST_HEADER_PVT

Line 6: -- CSP_picklist_header_PVT.

2: /*$Header: cspgtphb.pls 120.0 2005/05/25 11:31:02 appldev noship $*/
3: -- Start of Comments
4: -- Package name : CSP_PC_FORM_PICKHEADERS
5: -- Purpose : A wrapper to prepare data to call the update, delete and insert procedures of the
6: -- CSP_picklist_header_PVT.
7: -- MODIFICATION HISTORY
8: -- Person Date Comments
9: -- --------- ------ ------------------------------------------
10: -- klou 02/09/00 Add standrd messages.

Line 74: l_PICK_HEADER_Rec CSP_PICKLIST_HEADER_PVT.PICK_HEADER_Rec_Type;

70: -- because we do not want to call the core apps standard validations.
71: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
72: l_creation_date DATE := p_creation_date;
73: l_last_update_date DATE := p_last_update_date;
74: l_PICK_HEADER_Rec CSP_PICKLIST_HEADER_PVT.PICK_HEADER_Rec_Type;
75: EXCP_USER_DEFINED EXCEPTION;
76: l_created_by NUMBER := p_created_by;
77: l_last_update_login NUMBER := p_last_update_login;
78: l_last_updated_by NUMBER := p_last_updated_by;

Line 333: -- Construct the record to call the CSP_picklist_header_PVT insert, update and delete operation

329: END IF;
330:
331: END IF;
332:
333: -- Construct the record to call the CSP_picklist_header_PVT insert, update and delete operation
334: l_pick_header_rec.picklist_header_id := px_picklist_header_id;
335: l_pick_header_rec.CREATED_BY := nvl(l_CREATED_BY, fnd_api.g_miss_num);
336: l_pick_header_rec.CREATION_DATE := l_CREATION_DATE;
337: l_pick_header_rec.LAST_UPDATED_BY := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);

Line 365: CSP_PICKLIST_HEADER_PVT.Create_picklist_header(

361:
362: -- call different operations based on the p_action_code
363: IF p_action_code = 0 THEN
364: -- call create procedure
365: CSP_PICKLIST_HEADER_PVT.Create_picklist_header(
366: P_Api_Version_Number => P_Api_Version_Number,
367: P_Init_Msg_List => P_Init_Msg_List,
368: P_Commit => l_Commit,
369: p_validation_level => l_validation_level,

Line 379: CSP_PICKLIST_HEADER_PVT.Update_picklist_header(

375: );
376:
377: ELSIF p_action_code = 1 THEN
378: -- call update procedure
379: CSP_PICKLIST_HEADER_PVT.Update_picklist_header(
380: P_Api_Version_Number => P_Api_Version_Number,
381: P_Init_Msg_List => P_Init_Msg_List,
382: P_Commit => l_Commit,
383: p_validation_level => l_validation_level,

Line 392: CSP_PICKLIST_HEADER_PVT.Delete_picklist_header(

388: );
389:
390: ELSE
391: -- call delete procedure
392: CSP_PICKLIST_HEADER_PVT.Delete_picklist_header(
393: P_Api_Version_Number => P_Api_Version_Number,
394: P_Init_Msg_List => P_Init_Msg_List,
395: P_Commit => l_Commit,
396: p_validation_level => l_validation_level,