PACKAGE: APPS.ENG_ITEM_PKG

Source

1 PACKAGE ENG_ITEM_PKG AUTHID CURRENT_USER AS
2 /* $Header: ENGPITRS.pls 115.2 2002/05/07 11:39:20 pkm ship     $ */
3 
4 -- +-------------------------- ITEM_TRANSFER ---------------------------------+
5 -- NAME
6 -- ITEM_TRANSFER
7 
8 -- DESCRIPTION
9 -- Transfer the Engineering Item to Manufacturing, and set revisions.
10 
11 -- REQUIRES
12 -- org_id: organization id
13 -- eng_item_id: original item id
14 -- mfg_item_id: new id for manufacturing item
15 -- last_login_id
16 -- mfg_description: new description for manufacturing item
17 -- ecn_name: associated change order
18 -- bom_rev_starting: new revision
19 -- segment1
20 -- segment2
21 -- segment3
22 -- segment4
23 -- segment5
24 -- segment6
25 -- segment7
26 -- segment8
27 -- segment9
28 -- segment10
29 -- segment11
30 -- segment12
31 -- segment13
32 -- segment14
33 -- segment15
34 -- segment16
35 -- segment17
36 -- segment18
37 -- segment19
38 -- segment20
39 
40 -- OUTPUT
41 
42 -- NOTES
43 
44 -- +--------------------------------------------------------------------------+
45 
46 PROCEDURE ITEM_TRANSFER
47 (
48 X_org_id			IN NUMBER,
49 X_eng_item_id			IN NUMBER,
50 X_mfg_item_id			IN NUMBER,
51 X_last_login_id			IN NUMBER,
52 X_mfg_description		IN VARCHAR2,
53 X_ecn_name			IN VARCHAR2,
54 X_bom_rev_starting		IN VARCHAR2,
55 X_segment1			IN VARCHAR2,
56 X_segment2			IN VARCHAR2,
57 X_segment3			IN VARCHAR2,
58 X_segment4			IN VARCHAR2,
59 X_segment5			IN VARCHAR2,
60 X_segment6			IN VARCHAR2,
61 X_segment7			IN VARCHAR2,
62 X_segment8			IN VARCHAR2,
63 X_segment9			IN VARCHAR2,
64 X_segment10			IN VARCHAR2,
65 X_segment11			IN VARCHAR2,
66 X_segment12			IN VARCHAR2,
67 X_segment13			IN VARCHAR2,
68 X_segment14			IN VARCHAR2,
69 X_segment15			IN VARCHAR2,
70 X_segment16			IN VARCHAR2,
71 X_segment17			IN VARCHAR2,
72 X_segment18			IN VARCHAR2,
73 X_segment19			IN VARCHAR2,
74 X_segment20			IN VARCHAR2
75 );
76 
77 -- +--------------------------- COMPONENT_TRANSFER ----------------------------+
78 -- NAME
79 -- COMPONENT_TRANSFER
80 
81 -- DESCRIPTION
82 -- Transfer Components: Flip the eng_item_flag to 'N' for each component of
83 --                      the bills.
84 
85 -- REQUIRES
86 -- org_id: organization id
87 -- eng_item_id
88 -- designator_option
89 --   1. all
90 --   2. primary only
91 --   3. specific only
92 -- alt_bom_designator
93 
94 -- OUTPUT
95 
96 -- NOTES
97 
98 -- +--------------------------------------------------------------------------+
99 
100 PROCEDURE COMPONENT_TRANSFER
101 (
102 X_org_id			IN NUMBER,
103 X_eng_item_id			IN NUMBER,
104 X_designator_option		IN NUMBER,
105 X_alt_bom_designator		IN VARCHAR2
106 );
107 
108 -- +--------------------------- SET_OP_SEQ -----------------------------------+
109 -- NAME
110 -- SET_OP_SEQ
111 
112 -- DESCRIPTION
113 -- Set Operation Sequence: Set operation_seq_num to 1 in table
114 --                         BOM_INVENTORY_COMPONENTS where there is no
115 --                         corresponding manufacturing routing.
116 
117 -- REQUIRES
118 -- org_id: organization id
119 -- item_id: item to be updated
120 -- designator_option
121 --   1. all
122 --   2. primary only
123 --   3. specific only
124 -- alt_bom_designator
125 
126 -- OUTPUT
127 
128 -- NOTES
129 
130 -- +--------------------------------------------------------------------------+
131 
132 PROCEDURE SET_OP_SEQ
133 (
134 X_org_id			IN NUMBER,
135 X_item_id			IN NUMBER,
136 X_designator_option		IN NUMBER,
137 X_alt_bom_designator		IN VARCHAR2
138 );
139 
140 END ENG_ITEM_PKG;