DBA Data[Home] [Help]

PACKAGE: APPS.ENG_BOM_PKG

Source


1 PACKAGE ENG_BOM_PKG AUTHID CURRENT_USER AS
2 /* $Header: ENGPBTRS.pls 115.3 2002/04/12 14:02:43 pkm ship      $ */
3 
4 -- +------------------------------ BOM_UPDATE --------------------------------+
5 -- NAME
6 -- BOM_UPDATE
7 
8 -- DESCRIPTION
9 -- Update Bills: Flip assembly_type to 1 (manufacturing)
10 
11 -- REQUIRES
12 -- org_id: organization id
13 -- eng_item_id: bill that requires assembly_type to bee set to 1
14 -- designator_option
15 --   1. all
16 --   2. primary only
17 --   3. specific only
18 -- alt_bom_designator
19 
20 -- OUTPUT
21 
22 -- NOTES
23 
24 -- +--------------------------------------------------------------------------+
25 
26 PROCEDURE BOM_UPDATE
27 (
28 X_org_id			IN NUMBER,
29 X_eng_item_id			IN NUMBER,
30 X_designator_option		IN NUMBER,
31 X_transfer_option		IN NUMBER,
32 X_alt_bom_designator		IN VARCHAR2,
33 X_effectivity_date		IN DATE,
34 X_implemented_only		IN NUMBER,
35 X_unit_number			IN VARCHAR2 DEFAULT NULL
36 );
37 
38 -- +--------------------------- BOM_TRANSFER -----------------------------+
39 -- NAME
40 -- BOM_TRANSFER
41 
42 -- DESCRIPTION
43 -- Transfer Bills
44 
45 -- REQUIRES
46 -- org_id: organization id
47 -- eng_item_id
48 -- mfg_item_id
49 -- designator_option
50 --   1. all
51 --   2. primary only
52 --   3. specific only
53 -- transfer option
54 --   1. all rows
55 --   2. current only
56 --   3. current and pending
57 -- alt_bom_designator
58 -- effectivity_date
59 -- last_login_id
60 -- ecn_name
61 
62 -- OUTPUT
63 
64 -- NOTES
65 
66 -- +--------------------------------------------------------------------------+
67 
68 PROCEDURE BOM_TRANSFER
69 (
70 X_org_id			IN NUMBER,
71 X_eng_item_id			IN NUMBER,
72 X_mfg_item_id			IN NUMBER,
73 X_designator_option		IN NUMBER,
74 X_transfer_option		IN NUMBER,
75 X_alt_bom_designator		IN VARCHAR2,
76 X_effectivity_date		IN DATE,
77 X_last_login_id			IN NUMBER,
78 X_ecn_name			IN VARCHAR2,
79 X_unit_number			IN VARCHAR2 DEFAULT NULL
80 );
81 
82 END ENG_BOM_PKG;