APPS.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_ESTIMATE_ASSOCIATIONS

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 1315: FROM EAM_ESTIMATE_ASSOCIATIONS

1311: ACTIVITY_QTY,
1312: RESOURCE_MULTIPLIER,
1313: DIFFICULTY_ID,
1314: CU_QTY
1315: FROM EAM_ESTIMATE_ASSOCIATIONS
1316: WHERE ESTIMATE_ID = p_estimate_id;
1317:
1318: BEGIN
1319: INIT_DEBUG(

Line 1442: DELETE FROM EAM_ESTIMATE_ASSOCIATIONS WHERE ESTIMATE_ID = p_estimate_id;

1438: x_eam_ce_wo_lines_tbl := x_upd_eam_ce_wo_lines_tbl;
1439: x_return_status := 'S';
1440:
1441: -- Delete all the association entry
1442: DELETE FROM EAM_ESTIMATE_ASSOCIATIONS WHERE ESTIMATE_ID = p_estimate_id;
1443:
1444: IF (l_debug = 'Y') THEN
1445: DEBUG('End EXPLODE_CE_ACTIVITIES');
1446: END IF;

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 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 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 2568: EAM_ESTIMATE_ASSOCIATIONS_PKG.INSERT_ROW(

2564: END IF;
2565: l_resource_multiplier := px_activities_tbl(l_index).RESOURCE_MULTIPLIER;
2566: l_est_association_id := NULL;
2567:
2568: EAM_ESTIMATE_ASSOCIATIONS_PKG.INSERT_ROW(
2569: px_ESTIMATE_ASSOCIATION_ID => l_est_association_id,
2570: p_ORGANIZATION_ID => l_organization_id,
2571: p_ESTIMATE_ID => l_ce_id,
2572: p_CU_ID => l_cu_id,