APPS.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_ESTIMATE_ASSOCIATIONS

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

1397: ACTIVITY_QTY,
1398: RESOURCE_MULTIPLIER,
1399: DIFFICULTY_ID,
1400: CU_QTY
1401: FROM EAM_ESTIMATE_ASSOCIATIONS
1402: WHERE ESTIMATE_ID = p_estimate_id;
1403:
1404: BEGIN
1405: INIT_DEBUG(

Line 1546: DELETE FROM EAM_ESTIMATE_ASSOCIATIONS WHERE ESTIMATE_ID = p_estimate_id;

1542: x_eam_ce_wo_lines_tbl := x_upd_eam_ce_wo_lines_tbl;
1543: x_return_status := 'S';
1544:
1545: -- Delete all the association entry
1546: DELETE FROM EAM_ESTIMATE_ASSOCIATIONS WHERE ESTIMATE_ID = p_estimate_id;
1547:
1548: --IF (l_debug = 'Y') THEN
1549: DEBUG('End of API - EXPLODE_CE_ACTIVITIES');
1550: --END IF;

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

2743: END IF;
2744: l_resource_multiplier := px_activities_tbl(l_index).RESOURCE_MULTIPLIER;
2745: l_est_association_id := NULL;
2746:
2747: EAM_ESTIMATE_ASSOCIATIONS_PKG.INSERT_ROW(
2748: px_ESTIMATE_ASSOCIATION_ID => l_est_association_id,
2749: p_ORGANIZATION_ID => l_organization_id,
2750: p_ESTIMATE_ID => l_ce_id,
2751: p_CU_ID => l_cu_id,