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.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_EST_DATASTRUCTURES_PUB

Line 182: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL

178: p_api_version IN NUMBER := 1.0
179: , p_init_msg_list IN VARCHAR2 := 'F'
180: , p_commit IN VARCHAR2
181: , p_estimate_id IN NUMBER
182: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
183: , x_return_status OUT NOCOPY VARCHAR2
184: , x_msg_count OUT NOCOPY NUMBER
185: , x_msg_data OUT NOCOPY VARCHAR2)
186: IS

Line 188: l_in_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;

184: , x_msg_count OUT NOCOPY NUMBER
185: , x_msg_data OUT NOCOPY VARCHAR2)
186: IS
187:
188: l_in_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
189: l_out_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
190: l_estimate_id NUMBER := p_estimate_id;
191: l_return_status VARCHAR2(1);
192:

Line 189: l_out_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;

185: , x_msg_data OUT NOCOPY VARCHAR2)
186: IS
187:
188: l_in_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
189: l_out_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
190: l_estimate_id NUMBER := p_estimate_id;
191: l_return_status VARCHAR2(1);
192:
193: BEGIN

Line 322: , p_parent_wo_line_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_PARENT_WO_REC

318: p_api_version IN NUMBER := 1.0
319: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
320: , p_commit IN VARCHAR2
321: , p_estimate_id IN NUMBER
322: , p_parent_wo_line_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_PARENT_WO_REC
323: , x_return_status OUT NOCOPY VARCHAR2
324: , x_msg_count OUT NOCOPY NUMBER
325: , x_msg_data OUT NOCOPY VARCHAR2
326: )

Line 330: l_estimate_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC;

326: )
327:
328: IS
329:
330: l_estimate_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC;
331: l_parent_ce_wo_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
332: l_creation_date DATE := SYSDATE;
333: l_created_by NUMBER := FND_GLOBAL.USER_ID;
334: l_last_updated_date DATE := SYSDATE;

Line 331: l_parent_ce_wo_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;

327:
328: IS
329:
330: l_estimate_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC;
331: l_parent_ce_wo_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
332: l_creation_date DATE := SYSDATE;
333: l_created_by NUMBER := FND_GLOBAL.USER_ID;
334: l_last_updated_date DATE := SYSDATE;
335: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

Line 927: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

923: p_api_version IN NUMBER := 1.0
924: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
925: , p_commit IN VARCHAR2
926: , p_estimate_id IN NUMBER
927: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
928: , x_return_status OUT NOCOPY VARCHAR2
929: , x_msg_count OUT NOCOPY NUMBER
930: , x_msg_data OUT NOCOPY VARCHAR2
931: )

Line 1269: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

1265: END INSERT_ALL_WO_LINES;
1266:
1267: PROCEDURE EXPLODE_CE_ACTIVITIES(
1268: p_estimate_id IN NUMBER
1269: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1270: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1271: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
1272: , x_return_status OUT NOCOPY VARCHAR2
1273: )

Line 1270: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

1266:
1267: PROCEDURE EXPLODE_CE_ACTIVITIES(
1268: p_estimate_id IN NUMBER
1269: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1270: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1271: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
1272: , x_return_status OUT NOCOPY VARCHAR2
1273: )
1274: IS

Line 1271: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL

1267: PROCEDURE EXPLODE_CE_ACTIVITIES(
1268: p_estimate_id IN NUMBER
1269: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1270: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1271: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
1272: , x_return_status OUT NOCOPY VARCHAR2
1273: )
1274: IS
1275: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1294: l_ce_association_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;

1290: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1291: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1292:
1293: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1294: l_ce_association_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;
1295:
1296: l_return_status VARCHAR2(1);
1297: l_estimate_id NUMBER := p_estimate_id;
1298: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL := p_eam_ce_wo_lines_tbl;

Line 1298: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL := p_eam_ce_wo_lines_tbl;

1294: l_ce_association_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;
1295:
1296: l_return_status VARCHAR2(1);
1297: l_estimate_id NUMBER := p_estimate_id;
1298: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL := p_eam_ce_wo_lines_tbl;
1299: x_upd_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
1300:
1301: l_debug_filename VARCHAR(50) := G_DEBUG_FILENAME;
1302: l_debug VARCHAR2(1) := 'N';

Line 1299: x_upd_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;

1295:
1296: l_return_status VARCHAR2(1);
1297: l_estimate_id NUMBER := p_estimate_id;
1298: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL := p_eam_ce_wo_lines_tbl;
1299: x_upd_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
1300:
1301: l_debug_filename VARCHAR(50) := G_DEBUG_FILENAME;
1302: l_debug VARCHAR2(1) := 'N';
1303:

Line 1454: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC

1450: END EXPLODE_CE_ACTIVITIES;
1451:
1452: PROCEDURE POPULATE_CE_WORK_ORDER_LINES(
1453: p_estimate_id IN NUMBER
1454: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
1455: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1456: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1457: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1458: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type

Line 1455: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

1451:
1452: PROCEDURE POPULATE_CE_WORK_ORDER_LINES(
1453: p_estimate_id IN NUMBER
1454: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
1455: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1456: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1457: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1458: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1459: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type

Line 1463: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

1459: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1460: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1461: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1462: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1463: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1464: , x_return_status OUT NOCOPY VARCHAR2)
1465: IS
1466:
1467: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;

Line 1467: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;

1463: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1464: , x_return_status OUT NOCOPY VARCHAR2)
1465: IS
1466:
1467: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
1468: l_wo_lines_count NUMBER := p_eam_ce_wo_lines_tbl.COUNT;
1469: l_op_tbl_count NUMBER := p_eam_op_tbl.COUNT;
1470: l_res_tbl_count NUMBER := p_eam_res_tbl.COUNT;
1471: l_mat_tbl_count NUMBER := p_eam_mat_req_tbl.COUNT;

Line 1805: px_cu_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_UNITS_TBL,

1801: p_commit IN VARCHAR2,
1802: p_init_msg_list IN VARCHAR2,
1803: p_validation_level IN NUMBER,
1804: p_org_id IN NUMBER,
1805: px_cu_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_UNITS_TBL,
1806: x_return_status OUT NOCOPY VARCHAR2,
1807: x_msg_count OUT NOCOPY NUMBER,
1808: x_msg_data OUT NOCOPY VARCHAR2
1809: )

Line 1915: x_activities_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,

1911: p_commit IN VARCHAR2,
1912: p_init_msg_list IN VARCHAR2,
1913: p_validation_level IN NUMBER,
1914: p_cu_id IN NUMBER,
1915: x_activities_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,
1916: x_return_status OUT NOCOPY VARCHAR2,
1917: x_msg_count OUT NOCOPY NUMBER,
1918: x_msg_data OUT NOCOPY VARCHAR2
1919: )

Line 1940: l_activities_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;

1936: l_api_version CONSTANT NUMBER := 1.0;
1937: l_debug_filename VARCHAR(50) := G_DEBUG_FILENAME;
1938: l_debug VARCHAR2(1) := 'N';
1939: l_activity_count NUMBER := 0;
1940: l_activities_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;
1941: BEGIN
1942: SAVEPOINT GET_CU_ACTIVITIES;
1943:
1944: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2063: px_estimate_rec IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,

2059: p_api_version IN NUMBER,
2060: p_commit IN VARCHAR2,
2061: p_init_msg_list IN VARCHAR2,
2062: p_validation_level IN NUMBER,
2063: px_estimate_rec IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
2064: x_return_status OUT NOCOPY VARCHAR2,
2065: x_msg_count OUT NOCOPY NUMBER,
2066: x_msg_data OUT NOCOPY VARCHAR2
2067: )

Line 2220: p_estimate_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,

2216: p_api_version IN NUMBER,
2217: p_commit IN VARCHAR2,
2218: p_init_msg_list IN VARCHAR2,
2219: p_validation_level IN NUMBER,
2220: p_estimate_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
2221: x_return_status OUT NOCOPY VARCHAR2,
2222: x_msg_count OUT NOCOPY NUMBER,
2223: x_msg_data OUT NOCOPY VARCHAR2
2224: )

Line 2402: px_activities_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,

2398: p_commit IN VARCHAR2,
2399: p_init_msg_list IN VARCHAR2,
2400: p_validation_level IN NUMBER,
2401: p_ce_id IN NUMBER,
2402: px_activities_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,
2403: x_return_status OUT NOCOPY VARCHAR2,
2404: x_msg_count OUT NOCOPY NUMBER,
2405: x_msg_data OUT NOCOPY VARCHAR2
2406: )

Line 2634: x_ce_wo_ln_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL)

2630: --from this procedure.
2631: PROCEDURE GET_CE_WO_LNS_BY_GROUP_OPT(
2632: p_ce_id IN NUMBER,
2633: p_group_option IN VARCHAR2,
2634: x_ce_wo_ln_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL)
2635: IS
2636: --The group by 'None' option gets the lines in the order they are stored in the table.
2637: CURSOR none_cur IS
2638: SELECT *

Line 2696: l_ce_wo_ln_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;

2692: ECWOL.RES_SEQ_NUM,
2693: ECWOL.MAT_COMPONENT_SEQ_NUM,
2694: ECWOL.DI_DESCRIPTION;
2695:
2696: l_ce_wo_ln_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
2697: l_wo_ln_index NUMBER := 0;
2698: BEGIN
2699: IF p_group_option = 'None' THEN
2700: --Populate x_ce_wo_ln_tbl

Line 2954: p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,

2950: --This procedure does not do any error handling, but it may throw error, thus
2951: --the calling procedure should have logic in place to catch possible error thrown
2952: --from this procedure.
2953: PROCEDURE SET_WO_LNS_FROM_WO_DEFAULTS(
2954: p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,
2955: p_group_option IN VARCHAR2,
2956: px_ce_wo_ln_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
2957: )
2958: IS

Line 2956: px_ce_wo_ln_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

2952: --from this procedure.
2953: PROCEDURE SET_WO_LNS_FROM_WO_DEFAULTS(
2954: p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,
2955: p_group_option IN VARCHAR2,
2956: px_ce_wo_ln_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
2957: )
2958: IS
2959: BEGIN
2960: IF px_ce_wo_ln_tbl.COUNT > 0 THEN

Line 3019: px_ce_wo_ln_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

3015: --the calling procedure should have logic in place to catch possible error thrown
3016: --from this procedure.
3017: PROCEDURE RESOLVE_SORT_CONTENTION(
3018: p_group_option IN VARCHAR2,
3019: px_ce_wo_ln_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
3020: )
3021: IS
3022: l_new_wo_seq_num NUMBER;
3023: l_new_op_seq_num NUMBER;

Line 3240: p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,

3236: p_api_version IN NUMBER,
3237: p_commit IN VARCHAR2,
3238: p_init_msg_list IN VARCHAR2,
3239: p_validation_level IN NUMBER,
3240: p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,
3241: x_return_status OUT NOCOPY VARCHAR2,
3242: x_msg_count OUT NOCOPY NUMBER,
3243: x_msg_data OUT NOCOPY VARCHAR2
3244: )

Line 3254: l_ce_wo_ln_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;

3250: l_api_version CONSTANT NUMBER := 1.0;
3251: l_debug_filename VARCHAR(50) := G_DEBUG_FILENAME;
3252: l_debug VARCHAR2(1) := 'N';
3253: l_group_option VARCHAR2(80);
3254: l_ce_wo_ln_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
3255: BEGIN
3256: SAVEPOINT UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3257:
3258: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 4781: l_est_workorder_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;

4777:
4778: IS
4779:
4780:
4781: l_est_workorder_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
4782: l_creation_date DATE := SYSDATE;
4783: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4784: l_last_updated_date DATE := SYSDATE;
4785: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;