[Home] [Help]
PACKAGE: APPS.ENG_BOM_RTG_TRANSFER_PKG
Source
1 PACKAGE ENG_BOM_RTG_TRANSFER_PKG AUTHID CURRENT_USER AS
2 /* $Header: ENGPTRFS.pls 115.6 2003/10/28 09:26:32 kxhunt ship $ */
3
4 -- Variables intoduced to share data when logging electronic records
5 -- =================================================================
6 G_PARENT_ERECORD_ID NUMBER; -- ERES
7 G_ORG_CODE VARCHAR2(3); -- ERES
8 G_ITEM_NAME VARCHAR2(800); -- ERES
9
10 -- +--------------------------- RAISE_ERROR ----------------------------------+
11
12 -- NAME
13 -- RAISE_ERROR
14
15 -- DESCRIPTION
16 -- Raise generic error message. For sql error failures, places the SQLERRM
17 -- error on the message stack
18
19 -- REQUIRES
20 -- func_name: function name
21 -- stmt_num : statement number
22
23 -- OUTPUT
24
25 -- NOTES
26
27 -- +--------------------------------------------------------------------------+
28
29 PROCEDURE RAISE_ERROR (
30 func_name VARCHAR2,
31 stmt_num NUMBER,
32 message_name VARCHAR2,
33 token VARCHAR2
34 );
35
36 -- +-------------------------- ENG_BOM_RTG_TRANSFER --------------------------+
37
38 -- NAME
39 -- ENG_BOM_RTG_TRANSFER
40
41 -- DESCRIPTION
42 -- Transfer engineering data from engineering to manufacturing
43
44 -- REQUIRES
45 -- org_id: organization id
46 -- eng_item_id
47 -- mfg_item_id
48 -- transfer_option:
49 -- "1" - all rows
50 -- "2" - current only
51 -- "3" - current and pending
52 -- designator_option
53 -- "1" - all
54 -- "2" - primary only
55 -- "3" - specific only
56 -- alt_bom_designator
57 -- alt_rtg_designator
58 -- effectivity_date
59 -- last_login_id
60 -- bom_rev_starting
61 -- rtg_rev_starting
62 -- ecn_name
63 -- item_code
64 -- "1" - transfer yes
65 -- "2" - transfer no
66 -- bom_code
67 -- "1" - transfer yes
68 -- "2" - transfer no
69 -- rtg_code
70 -- "1" - transfer yes
71 -- "2" - transfer no
72 -- mfg_description
73 -- segment1
74 -- segment2
75 -- segment3
76 -- segment4
77 -- segment5
78 -- segment6
79 -- segment7
80 -- segment8
81 -- segment9
82 -- segment10
83 -- segment11
84 -- segment12
85 -- segment13
86 -- segment14
87 -- segment15
88 -- segment16
89 -- segment17
90 -- segment18
91 -- segment19
92 -- segment20
93 -- implemented_only
94 -- "1" - yes
95 -- "2" - no
96 -- commit Introduced for BUG 3196478 OCT 2003
97 -- TRUE or FALSE
98
99 -- OUTPUT
100
101 -- RETURNS
102
103 -- NOTES
104
105 -- +--------------------------------------------------------------------------+
106
107 -- BUG 3196478
108 -- Introduce parameter X_commit to give added control over commit handling
109 PROCEDURE ENG_BOM_RTG_TRANSFER
110 (
111 X_org_id IN NUMBER,
112 X_eng_item_id IN NUMBER,
113 X_mfg_item_id IN NUMBER,
114 X_transfer_option IN NUMBER DEFAULT 2,
115 X_designator_option IN NUMBER DEFAULT 1,
116 X_alt_bom_designator IN VARCHAR2,
117 X_alt_rtg_designator IN VARCHAR2,
118 X_effectivity_date IN DATE,
119 X_last_login_id IN NUMBER DEFAULT -1,
120 X_bom_rev_starting IN VARCHAR2,
121 X_rtg_rev_starting IN VARCHAR2,
122 X_ecn_name IN VARCHAR2,
123 X_item_code IN NUMBER DEFAULT 1,
124 X_bom_code IN NUMBER DEFAULT 1,
125 X_rtg_code IN NUMBER DEFAULT 1,
126 X_mfg_description IN VARCHAR2,
127 X_segment1 IN VARCHAR2,
128 X_segment2 IN VARCHAR2,
129 X_segment3 IN VARCHAR2,
130 X_segment4 IN VARCHAR2,
131 X_segment5 IN VARCHAR2,
132 X_segment6 IN VARCHAR2,
133 X_segment7 IN VARCHAR2,
134 X_segment8 IN VARCHAR2,
135 X_segment9 IN VARCHAR2,
136 X_segment10 IN VARCHAR2,
137 X_segment11 IN VARCHAR2,
138 X_segment12 IN VARCHAR2,
139 X_segment13 IN VARCHAR2,
140 X_segment14 IN VARCHAR2,
141 X_segment15 IN VARCHAR2,
142 X_segment16 IN VARCHAR2,
143 X_segment17 IN VARCHAR2,
144 X_segment18 IN VARCHAR2,
145 X_segment19 IN VARCHAR2,
146 X_segment20 IN VARCHAR2,
147 X_implemented_only IN NUMBER DEFAULT 2,
148 X_unit_number IN VARCHAR2 DEFAULT NULL,
149 X_commit IN BOOLEAN DEFAULT TRUE);
150
151 -- Introduced for ERES September 2003
152 PROCEDURE PROCESS_ERECORD
153 (
154 p_event_name IN VARCHAR2,
155 p_event_key IN VARCHAR2,
156 p_user_key IN VARCHAR2,
157 p_parent_event_key IN VARCHAR2);
158
159 END ENG_BOM_RTG_TRANSFER_PKG;