DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_PROCESS_WO_PUB

Line 43: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type

39: PROCEDURE POPULATE_CE_WORK_ORDER_LINES(
40: p_estimate_id IN NUMBER
41: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
42: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
43: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
44: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
45: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
46: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
47: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type

Line 44: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type

40: p_estimate_id IN NUMBER
41: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
42: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
43: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
44: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
45: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
46: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
47: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
48: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type

Line 45: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type

41: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
42: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
43: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
44: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
45: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
46: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
47: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
48: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
49: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

Line 46: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type

42: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
43: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
44: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
45: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
46: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
47: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
48: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
49: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
50: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

Line 47: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type

43: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
44: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
45: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
46: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
47: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
48: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
49: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
50: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
51: , x_return_status OUT NOCOPY VARCHAR2);

Line 48: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type

44: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
45: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
46: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
47: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
48: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
49: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
50: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
51: , x_return_status OUT NOCOPY VARCHAR2);
52:

Line 49: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

45: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
46: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
47: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
48: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
49: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
50: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
51: , x_return_status OUT NOCOPY VARCHAR2);
52:
53: PROCEDURE INSERT_PARENT_WO_LINE(

Line 117: , x_eam_wo_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_WO_REC_TYPE

113: PROCEDURE POPULATE_WO(
114: p_parent_wo IN NUMBER
115: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
116: , p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
117: , x_eam_wo_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_WO_REC_TYPE
118: , x_return_status OUT NOCOPY VARCHAR2
119: , x_msg_count OUT NOCOPY NUMBER
120: , x_msg_data OUT NOCOPY VARCHAR2
121: );

Line 126: , x_eam_op_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_OP_REC_TYPE

122:
123: PROCEDURE POPULATE_OPERATION(
124: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
125: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
126: , x_eam_op_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_OP_REC_TYPE
127: , x_return_status OUT NOCOPY VARCHAR2
128: , x_msg_count OUT NOCOPY NUMBER
129: , x_msg_data OUT NOCOPY VARCHAR2
130: );

Line 135: , x_eam_res_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_RES_REC_TYPE

131:
132: PROCEDURE POPULATE_RESOURCE(
133: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
134: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
135: , x_eam_res_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_RES_REC_TYPE
136: , x_return_status OUT NOCOPY VARCHAR2
137: , x_msg_count OUT NOCOPY NUMBER
138: , x_msg_data OUT NOCOPY VARCHAR2
139: );

Line 144: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_MAT_REQ_REC_TYPE

140:
141: PROCEDURE POPULATE_MATERIAL(
142: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
143: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
144: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_MAT_REQ_REC_TYPE
145: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_REC_TYPE
146: , x_return_status OUT NOCOPY VARCHAR2
147: , x_msg_count OUT NOCOPY NUMBER
148: , x_msg_data OUT NOCOPY VARCHAR2

Line 145: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_REC_TYPE

141: PROCEDURE POPULATE_MATERIAL(
142: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
143: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
144: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_MAT_REQ_REC_TYPE
145: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_REC_TYPE
146: , x_return_status OUT NOCOPY VARCHAR2
147: , x_msg_count OUT NOCOPY NUMBER
148: , x_msg_data OUT NOCOPY VARCHAR2
149: );

Line 151: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type;

147: , x_msg_count OUT NOCOPY NUMBER
148: , x_msg_data OUT NOCOPY VARCHAR2
149: );
150:
151: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type;
152:
153: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
154:
155: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 153: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

149: );
150:
151: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type;
152:
153: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
154:
155: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type;
156:
157: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 155: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type;

151: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type;
152:
153: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
154:
155: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type;
156:
157: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
158:
159: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 157: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

153: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
154:
155: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type;
156:
157: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
158:
159: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
160:
161: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 159: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

155: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type;
156:
157: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
158:
159: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
160:
161: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
162:
163: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 161: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

157: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
158:
159: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
160:
161: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
162:
163: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
164:
165: PROCEDURE GET_CU_RECS(

Line 163: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

159: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
160:
161: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
162:
163: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
164:
165: PROCEDURE GET_CU_RECS(
166: p_api_version IN NUMBER,
167: p_commit IN VARCHAR2,