[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;