API To Create And Update An ESTIMATE in Oracle EAM

Following API procedure help us to create and update an ESTIMATE.

Here are the details of the specifications  for the create and update procedures:-
PACKAGE EAM_CONSTRUCTION_EST_PUB
File name: EAMPCESS.pls/EAMPCESB.pls

/*
* These procedures are used to create and update construction estimate records
* p_api_version Version of the API
* p_commit Flag to indicate whether API should commit changes
* p_init_msg_list Flag to indicate initialization of message list
* p_validation_level Validation Level of the API
* px_estimate_rec Record for estimation details of type EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC
* x_return_status Return status of the procedure call
* x_msg_count Count of the return messages that API returns
* x_msg_data The collection of the messages
*/

PROCEDURE CREATE_ESTIMATE(
p_api_version IN NUMBER,
p_commit IN VARCHAR2,
p_init_msg_list IN VARCHAR2,
p_validation_level IN NUMBER,
px_estimate_rec IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
);

PROCEDURE UPDATE_ESTIMATE(
p_api_version IN NUMBER,
p_commit IN VARCHAR2,

p_init_msg_list IN VARCHAR2,
p_validation_level IN NUMBER,
p_estimate_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
);


--------------------
Additional information:

1. EAM_CONSTRUCTION_EST_PUB.INSERT_ALL_WO_LINES => Use this to create estimate
    lines
2. EAM_CONSTRUCTION_EST_PUB.INSERT_PARENT_WO_LINE => Call this if you need to
    attach/create parents WO for these estimate lines

EAM_CONSTRUCTION_EST_PUB.INSERT_ALL_WO_LINES => If you wish to update the EAM_CE_WORK_ORDER_LINES table pass the p_eam_ce_wo_lines_tbl.ESTIMATE_WORK_ORDER_LINE_ID as NOT NULL. The API will find the existing estimate line which is equal to ESTIMATE_WORK_ORDER_LINE_ID and update the corresponding attributes