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 187: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL

183: p_api_version IN NUMBER := 1.0
184: , p_init_msg_list IN VARCHAR2 := 'F'
185: , p_commit IN VARCHAR2
186: , p_estimate_id IN NUMBER
187: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
188: , x_return_status OUT NOCOPY VARCHAR2
189: , x_msg_count OUT NOCOPY NUMBER
190: , x_msg_data OUT NOCOPY VARCHAR2)
191: IS

Line 193: l_in_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;

189: , x_msg_count OUT NOCOPY NUMBER
190: , x_msg_data OUT NOCOPY VARCHAR2)
191: IS
192:
193: l_in_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
194: l_out_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
195: l_estimate_id NUMBER := p_estimate_id;
196: l_return_status VARCHAR2(1);
197:

Line 194: l_out_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;

190: , x_msg_data OUT NOCOPY VARCHAR2)
191: IS
192:
193: l_in_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
194: l_out_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
195: l_estimate_id NUMBER := p_estimate_id;
196: l_return_status VARCHAR2(1);
197:
198: BEGIN

Line 341: , p_parent_wo_line_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_PARENT_WO_REC

337: p_api_version IN NUMBER := 1.0
338: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
339: , p_commit IN VARCHAR2
340: , p_estimate_id IN NUMBER
341: , p_parent_wo_line_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_PARENT_WO_REC
342: , x_return_status OUT NOCOPY VARCHAR2
343: , x_msg_count OUT NOCOPY NUMBER
344: , x_msg_data OUT NOCOPY VARCHAR2
345: )

Line 349: l_estimate_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC;

345: )
346:
347: IS
348:
349: l_estimate_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC;
350: l_parent_ce_wo_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
351: l_creation_date DATE := SYSDATE;
352: l_created_by NUMBER := FND_GLOBAL.USER_ID;
353: l_last_updated_date DATE := SYSDATE;

Line 350: l_parent_ce_wo_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;

346:
347: IS
348:
349: l_estimate_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC;
350: l_parent_ce_wo_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
351: l_creation_date DATE := SYSDATE;
352: l_created_by NUMBER := FND_GLOBAL.USER_ID;
353: l_last_updated_date DATE := SYSDATE;
354: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

Line 999: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

995: p_api_version IN NUMBER := 1.0
996: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
997: , p_commit IN VARCHAR2
998: , p_estimate_id IN NUMBER
999: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1000: , x_return_status OUT NOCOPY VARCHAR2
1001: , x_msg_count OUT NOCOPY NUMBER
1002: , x_msg_data OUT NOCOPY VARCHAR2
1003: )

Line 1355: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

1351: END INSERT_ALL_WO_LINES;
1352:
1353: PROCEDURE EXPLODE_CE_ACTIVITIES(
1354: p_estimate_id IN NUMBER
1355: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1356: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1357: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
1358: , x_return_status OUT NOCOPY VARCHAR2
1359: )

Line 1356: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

1352:
1353: PROCEDURE EXPLODE_CE_ACTIVITIES(
1354: p_estimate_id IN NUMBER
1355: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1356: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1357: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
1358: , x_return_status OUT NOCOPY VARCHAR2
1359: )
1360: IS

Line 1357: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL

1353: PROCEDURE EXPLODE_CE_ACTIVITIES(
1354: p_estimate_id IN NUMBER
1355: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1356: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1357: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
1358: , x_return_status OUT NOCOPY VARCHAR2
1359: )
1360: IS
1361: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1380: l_ce_association_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;

1376: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1377: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1378:
1379: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1380: l_ce_association_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;
1381:
1382: l_return_status VARCHAR2(1);
1383: l_estimate_id NUMBER := p_estimate_id;
1384: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL := p_eam_ce_wo_lines_tbl;

Line 1384: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL := p_eam_ce_wo_lines_tbl;

1380: l_ce_association_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;
1381:
1382: l_return_status VARCHAR2(1);
1383: l_estimate_id NUMBER := p_estimate_id;
1384: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL := p_eam_ce_wo_lines_tbl;
1385: x_upd_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
1386:
1387: l_debug_filename VARCHAR(50) := G_DEBUG_FILENAME;
1388: l_debug VARCHAR2(1) := 'N';

Line 1385: x_upd_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;

1381:
1382: l_return_status VARCHAR2(1);
1383: l_estimate_id NUMBER := p_estimate_id;
1384: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL := p_eam_ce_wo_lines_tbl;
1385: x_upd_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
1386:
1387: l_debug_filename VARCHAR(50) := G_DEBUG_FILENAME;
1388: l_debug VARCHAR2(1) := 'N';
1389:

Line 1559: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC

1555: END EXPLODE_CE_ACTIVITIES;
1556:
1557: PROCEDURE POPULATE_CE_WORK_ORDER_LINES(
1558: p_estimate_id IN NUMBER
1559: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
1560: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1561: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1562: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1563: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type

Line 1560: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

1556:
1557: PROCEDURE POPULATE_CE_WORK_ORDER_LINES(
1558: p_estimate_id IN NUMBER
1559: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
1560: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1561: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1562: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1563: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1564: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type

Line 1568: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

1564: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1565: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1566: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1567: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1568: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1569: , x_return_status OUT NOCOPY VARCHAR2)
1570: IS
1571:
1572: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;

Line 1572: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;

1568: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1569: , x_return_status OUT NOCOPY VARCHAR2)
1570: IS
1571:
1572: l_eam_ce_wo_lines_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
1573: l_wo_lines_count NUMBER := p_eam_ce_wo_lines_tbl.COUNT;
1574: l_op_tbl_count NUMBER := p_eam_op_tbl.COUNT;
1575: l_res_tbl_count NUMBER := p_eam_res_tbl.COUNT;
1576: l_mat_tbl_count NUMBER := p_eam_mat_req_tbl.COUNT;

Line 1940: px_cu_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_UNITS_TBL,

1936: p_commit IN VARCHAR2,
1937: p_init_msg_list IN VARCHAR2,
1938: p_validation_level IN NUMBER,
1939: p_org_id IN NUMBER,
1940: px_cu_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_UNITS_TBL,
1941: x_return_status OUT NOCOPY VARCHAR2,
1942: x_msg_count OUT NOCOPY NUMBER,
1943: x_msg_data OUT NOCOPY VARCHAR2
1944: )

Line 2050: x_activities_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,

2046: p_commit IN VARCHAR2,
2047: p_init_msg_list IN VARCHAR2,
2048: p_validation_level IN NUMBER,
2049: p_cu_id IN NUMBER,
2050: x_activities_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,
2051: x_return_status OUT NOCOPY VARCHAR2,
2052: x_msg_count OUT NOCOPY NUMBER,
2053: x_msg_data OUT NOCOPY VARCHAR2
2054: )

Line 2075: l_activities_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;

2071: l_api_version CONSTANT NUMBER := 1.0;
2072: l_debug_filename VARCHAR(50) := G_DEBUG_FILENAME;
2073: l_debug VARCHAR2(1) := 'N';
2074: l_activity_count NUMBER := 0;
2075: l_activities_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;
2076: BEGIN
2077: SAVEPOINT GET_CU_ACTIVITIES;
2078:
2079: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2198: px_estimate_rec IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,

2194: p_api_version IN NUMBER,
2195: p_commit IN VARCHAR2,
2196: p_init_msg_list IN VARCHAR2,
2197: p_validation_level IN NUMBER,
2198: px_estimate_rec IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
2199: x_return_status OUT NOCOPY VARCHAR2,
2200: x_msg_count OUT NOCOPY NUMBER,
2201: x_msg_data OUT NOCOPY VARCHAR2
2202: )

Line 2359: p_estimate_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,

2355: p_api_version IN NUMBER,
2356: p_commit IN VARCHAR2,
2357: p_init_msg_list IN VARCHAR2,
2358: p_validation_level IN NUMBER,
2359: p_estimate_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
2360: x_return_status OUT NOCOPY VARCHAR2,
2361: x_msg_count OUT NOCOPY NUMBER,
2362: x_msg_data OUT NOCOPY VARCHAR2
2363: )

Line 2581: px_activities_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,

2577: p_commit IN VARCHAR2,
2578: p_init_msg_list IN VARCHAR2,
2579: p_validation_level IN NUMBER,
2580: p_ce_id IN NUMBER,
2581: px_activities_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,
2582: x_return_status OUT NOCOPY VARCHAR2,
2583: x_msg_count OUT NOCOPY NUMBER,
2584: x_msg_data OUT NOCOPY VARCHAR2
2585: )

Line 2813: x_ce_wo_ln_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL)

2809: --from this procedure.
2810: PROCEDURE GET_CE_WO_LNS_BY_GROUP_OPT(
2811: p_ce_id IN NUMBER,
2812: p_group_option IN VARCHAR2,
2813: x_ce_wo_ln_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL)
2814: IS
2815: --The group by 'None' option gets the lines in the order they are stored in the table.
2816: CURSOR none_cur IS
2817: SELECT *

Line 2875: l_ce_wo_ln_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;

2871: ECWOL.RES_SEQ_NUM,
2872: ECWOL.MAT_COMPONENT_SEQ_NUM,
2873: ECWOL.DI_DESCRIPTION;
2874:
2875: l_ce_wo_ln_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
2876: l_wo_ln_index NUMBER := 0;
2877: BEGIN
2878: IF p_group_option = 'None' THEN
2879: --Populate x_ce_wo_ln_tbl

Line 3133: p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,

3129: --This procedure does not do any error handling, but it may throw error, thus
3130: --the calling procedure should have logic in place to catch possible error thrown
3131: --from this procedure.
3132: PROCEDURE SET_WO_LNS_FROM_WO_DEFAULTS(
3133: p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,
3134: p_group_option IN VARCHAR2,
3135: px_ce_wo_ln_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
3136: )
3137: IS

Line 3135: px_ce_wo_ln_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

3131: --from this procedure.
3132: PROCEDURE SET_WO_LNS_FROM_WO_DEFAULTS(
3133: p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,
3134: p_group_option IN VARCHAR2,
3135: px_ce_wo_ln_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
3136: )
3137: IS
3138: BEGIN
3139: IF px_ce_wo_ln_tbl.COUNT > 0 THEN

Line 3198: px_ce_wo_ln_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

3194: --the calling procedure should have logic in place to catch possible error thrown
3195: --from this procedure.
3196: PROCEDURE RESOLVE_SORT_CONTENTION(
3197: p_group_option IN VARCHAR2,
3198: px_ce_wo_ln_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
3199: )
3200: IS
3201: l_new_wo_seq_num NUMBER;
3202: l_new_op_seq_num NUMBER;

Line 3419: p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,

3415: p_api_version IN NUMBER,
3416: p_commit IN VARCHAR2,
3417: p_init_msg_list IN VARCHAR2,
3418: p_validation_level IN NUMBER,
3419: p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,
3420: x_return_status OUT NOCOPY VARCHAR2,
3421: x_msg_count OUT NOCOPY NUMBER,
3422: x_msg_data OUT NOCOPY VARCHAR2
3423: )

Line 3433: l_ce_wo_ln_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;

3429: l_api_version CONSTANT NUMBER := 1.0;
3430: l_debug_filename VARCHAR(50) := G_DEBUG_FILENAME;
3431: l_debug VARCHAR2(1) := 'N';
3432: l_group_option VARCHAR2(80);
3433: l_ce_wo_ln_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
3434: BEGIN
3435: SAVEPOINT UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3436:
3437: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 4970: l_est_workorder_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;

4966:
4967: IS
4968:
4969:
4970: l_est_workorder_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
4971: l_creation_date DATE := SYSDATE;
4972: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4973: l_last_updated_date DATE := SYSDATE;
4974: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;