1 Package WIP_EAM_UTILS AUTHID CURRENT_USER as
2 /* $Header: wipeamus.pls 115.11 2003/11/21 01:19:20 baroy noship $
3 $Author: baroy $ */
4
5 -- Author : BAROY
6 -- Created : 11/13/02 12:48:31 PM
7 -- Purpose : API to default the WAC
8 -- Standard who
9
10
11 -- Procedure to find the default wip accounting class for a work order
12 -- based on pre-defined criteria
13 PROCEDURE DEFAULT_ACC_CLASS(
14 p_org_id IN NUMBER, -- Organization Id
15 p_job_type IN NUMBER DEFAULT 1, -- Standard/Rebuild
16 p_serial_number IN VARCHAR2 DEFAULT null, -- Asset Number
17 p_asset_group IN VARCHAR2 DEFAULT null, -- Asset Group
18 p_parent_wo_name IN VARCHAR2 DEFAULT null, -- Parent Wip Entity Id
19 p_asset_activity IN VARCHAR2 DEFAULT null, -- Asset Activity
20 p_project_number IN VARCHAR2 DEFAULT null, -- Project Number
21 p_task_number IN VARCHAR2 DEFAULT null, -- Task Number
22 x_class_code OUT NOCOPY VARCHAR2, -- WAC (return value)
23 x_return_status OUT NOCOPY VARCHAR2, -- Return Status
24 x_msg_data OUT NOCOPY VARCHAR2 -- Error messages
25 );
26
27
28 -- A copy of the default_acc_class procedure. The only difference is that in
29 -- this procedure, the input parameters are 'id's instead of names
30 -- Procedure to find the default wip accounting class for a work order
31 -- based on pre-defined criteria
32 PROCEDURE DEFAULT_ACC_CLASS(
33 p_org_id IN NUMBER, -- Organization Id
34 p_job_type IN NUMBER DEFAULT 1, -- Standard/Rebuild
35 p_serial_number IN VARCHAR2 DEFAULT null, -- Asset Number
36 p_asset_group_id IN NUMBER DEFAULT null, -- Asset Group
37 p_parent_wo_id IN NUMBER DEFAULT null, -- Parent Wip Entity Id
38 p_asset_activity_id IN number DEFAULT null,-- Asset Activity
39 p_project_id IN NUMBER DEFAULT null, -- Project Number
40 p_task_id IN NUMBER DEFAULT null, -- Task Number
41 x_class_code OUT NOCOPY VARCHAR2, -- WAC (return value)
42 x_return_status OUT NOCOPY VARCHAR2, -- Return Status
43 x_msg_data OUT NOCOPY VARCHAR2 -- Error messages
44 );
45
46
47 -- This procedure copies over the asset attachments,
48 -- asset activity attachments, activity bom attachments
49 -- and activity routing attachments to the work order
50 -- created by the WIP Mass Load.
51 PROCEDURE copy_attachments(
52 copy_asset_attachments IN VARCHAR2, -- Copy Asset Attachments (Y/N).
53 copy_activity_attachments IN VARCHAR2, -- Copy Activity Attachments (Y/N).
54 copy_activity_bom_attachments IN VARCHAR2, -- Copy Activity BOM Attachments (Y/N).
55 copy_activity_rtng_attachments IN VARCHAR2, -- Copy Activity Routing Attachments (Y/N).
56 p_organization_id IN NUMBER, -- Org Id of the Work Order
57 p_wip_entity_id IN NUMBER, -- Wip Ent Id of WO (created thru WML).
58 p_primary_item_id IN NUMBER, -- Asset Activity Id of the activity.
59 p_common_bom_sequence_id IN NUMBER, -- BOM Sequence Id for the activity
60 p_common_routing_sequence_id IN NUMBER -- Routing Sequence Id for the Activity
61 );
62
63
64 procedure create_default_operation
65 ( p_organization_id IN NUMBER
66 ,p_wip_entity_id IN NUMBER
67 );
68
69
70 END WIP_EAM_UTILS;