DBA Data[Home] [Help]

PACKAGE: APPS.EAM_EXPLODE_ACTIVITY_PVT

Source


1 PACKAGE EAM_EXPLODE_ACTIVITY_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVEXAS.pls 115.3 2004/01/06 08:54:48 samjain ship $ */
3 /***************************************************************************
4 --
5 --  Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 --  All rights reserved.
7 --
8 --  FILENAME
9 --
10 --      EAMVEXAS.pls
11 --
12 --  DESCRIPTION
13 --
14 --      Spec of package EAM_EXPLODE_ACTIVITY_PVT
15 --
16 --  NOTES
17 --
18 --  HISTORY
19 --
20 --  12-JUN-2002    Kenichi Nagumo     Initial Creation
21 ***************************************************************************/
22 
23 
24       PROCEDURE EXPLODE_ACTIVITY
25          ( p_validation_level        IN  NUMBER
26          , p_eam_wo_rec              IN  EAM_PROCESS_WO_PUB.eam_wo_rec_type
27          , p_eam_op_tbl              IN  EAM_PROCESS_WO_PUB.eam_op_tbl_type
28          , p_eam_op_network_tbl      IN  EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
29          , p_eam_res_tbl             IN  EAM_PROCESS_WO_PUB.eam_res_tbl_type
30          , p_eam_res_inst_tbl        IN  EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
31          , p_eam_sub_res_tbl         IN  EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
32          , p_eam_res_usage_tbl       IN  EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
33          , p_eam_mat_req_tbl         IN  EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
34          , x_eam_wo_rec              OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
35          , x_eam_op_tbl              OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
36          , x_eam_op_network_tbl      OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
37          , x_eam_res_tbl             OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
38          , x_eam_res_inst_tbl        OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
39          , x_eam_sub_res_tbl         OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
40          , x_eam_res_usage_tbl       OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
41          , x_eam_mat_req_tbl         OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
42          , x_mesg_token_tbl          OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
43          , x_return_status           OUT NOCOPY VARCHAR2
44          );
45 
46 --Bug#3342391 : Modified the function definition to pass 2 new parameters and default it to null
47 --    for backward compatibility.The parameters contain the operation_sequence_id and operations_sequence_number
48 --    and common_routing_sequence_id
49       PROCEDURE COPY_ATTACHMENT
50          ( p_organization_id         IN  NUMBER
51          , p_asset_activity_id       IN  NUMBER
52          , p_wip_entity_id           IN  NUMBER
53          , p_bill_sequence_id        IN  NUMBER
54          , x_error_message           OUT NOCOPY VARCHAR2
55          , x_return_status           OUT NOCOPY VARCHAR2
56          , p_common_routing_sequence_id IN NUMBER := NULL
57          , p_operation_sequence_id  IN NUMBER := NULL
58          , p_operation_sequence_num IN NUMBER := NULL
59          );
60 
61 END EAM_EXPLODE_ACTIVITY_PVT;