DBA Data[Home] [Help]

APPS.WIP_EAM_PROCESS_WO_PUB dependencies on EAM_PROCESS_WO_PUB

Line 1: PACKAGE BODY WIP_EAM_PROCESS_WO_PUB AS

1: PACKAGE BODY WIP_EAM_PROCESS_WO_PUB AS
2: /* $Header: WIPPWOPB.pls 120.1 2005/06/29 03:52:35 mmaduska noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='WIP_EAM_PROCESS_WO_PUB';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='WIP_EAM_PROCESS_WO_PUB';

1: PACKAGE BODY WIP_EAM_PROCESS_WO_PUB AS
2: /* $Header: WIPPWOPB.pls 120.1 2005/06/29 03:52:35 mmaduska noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='WIP_EAM_PROCESS_WO_PUB';
5:
6:
7:
8:

Line 25: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;

21: p_organization_id IN NUMBER,
22: p_firm_planned_flag IN NUMBER
23: ) IS
24:
25: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
26: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
27: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
28: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
29: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 26: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

22: p_firm_planned_flag IN NUMBER
23: ) IS
24:
25: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
26: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
27: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
28: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
29: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
30: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 27: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

23: ) IS
24:
25: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
26: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
27: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
28: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
29: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
30: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
31: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 28: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

24:
25: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
26: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
27: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
28: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
29: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
30: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
31: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
32: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 29: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

25: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
26: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
27: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
28: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
29: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
30: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
31: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
32: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
33: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 30: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

26: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
27: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
28: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
29: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
30: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
31: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
32: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
33: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
34:

Line 31: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

27: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
28: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
29: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
30: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
31: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
32: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
33: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
34:
35: l_out_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;

Line 32: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

28: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
29: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
30: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
31: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
32: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
33: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
34:
35: l_out_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
36: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 33: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

29: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
30: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
31: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
32: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
33: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
34:
35: l_out_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
36: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
37: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 35: l_out_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;

31: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
32: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
33: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
34:
35: l_out_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
36: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
37: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
38: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
39: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 36: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

32: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
33: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
34:
35: l_out_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
36: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
37: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
38: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
39: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
40: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 37: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

33: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
34:
35: l_out_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
36: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
37: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
38: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
39: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
40: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
41: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 38: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

34:
35: l_out_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
36: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
37: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
38: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
39: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
40: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
41: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
42: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 39: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

35: l_out_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
36: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
37: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
38: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
39: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
40: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
41: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
42: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
43: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 40: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

36: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
37: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
38: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
39: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
40: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
41: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
42: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
43: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
44:

Line 41: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

37: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
38: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
39: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
40: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
41: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
42: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
43: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
44:
45: l_return_status VARCHAR2(1);

Line 42: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

38: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
39: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
40: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
41: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
42: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
43: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
44:
45: l_return_status VARCHAR2(1);
46: l_msg_count NUMBER;

Line 43: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

39: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
40: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
41: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
42: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
43: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
44:
45: l_return_status VARCHAR2(1);
46: l_msg_count NUMBER;
47: l_error_message VARCHAR2(512);

Line 74: eam_process_wo_pub.PROCESS_WO

70: l_init := TRUE;
71: end if;
72:
73:
74: eam_process_wo_pub.PROCESS_WO
75: ( p_bo_identifier => 'EAM'
76: , p_api_version_number => l_api_version
77: , p_init_msg_list => l_init
78: , p_commit => l_commit

Line 249: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;

245: l_return_status VARCHAR2(10);
246: l_msg_count NUMBER;
247: l_msg_data VARCHAR2(512);
248: l_error_message VARCHAR2(512);
249: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;
250:
251: BEGIN
252:
253: l_api_version := p_api_version;

Line 437: END WIP_EAM_PROCESS_WO_PUB;

433:
434:
435:
436:
437: END WIP_EAM_PROCESS_WO_PUB;