PACKAGE: APPS.ENG_ROUTING_PKG

Source

1 PACKAGE ENG_ROUTING_PKG AUTHID CURRENT_USER AS
2 /* $Header: ENGPRTRS.pls 115.2 2002/05/07 11:40:03 pkm ship     $ */
3 
4 -- +--------------------------- ROUTING_UPDATE -------------------------------+
5 -- NAME
6 -- ROUTING_UPDATE
7 
8 -- DESCRIPTION
9 -- Update Routings: Flip routing_type to 1 (manufacturing)
10 
11 -- REQUIRES
12 -- org_id: organization id
13 -- eng_item_id: routing that requires routing type to be set to 1
14 -- designator_option
15 --   1. all
16 --   2. primary only
17 --   3. specific only
18 -- alt_rtg_designator
19 
20 -- OUTPUT
21 
22 -- NOTES
23 
24 -- +--------------------------------------------------------------------------+
25 
26 PROCEDURE ROUTING_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_rtg_designator		IN VARCHAR2,
33 X_effectivity_date		IN DATE
34 );
35 
36 -- +--------------------------- ROUTING_TRANSFER -----------------------------+
37 -- NAME
38 -- ROUTING_TRANSFER
39 
40 -- DESCRIPTION
41 -- Transfer Routings
42 
43 -- REQUIRES
44 -- org_id: organization id
45 -- eng_item_id
46 -- mfg_item_id
47 -- designator_option
48 --   1. all
49 --   2. primary only
50 --   3. specific only
51 -- transfer option
52 --   1. all rows
53 --   2. current only
54 --   3. current and pending
55 -- alt_rtg_designator
56 -- effectivity_date
57 -- last_login_id
58 -- ecn_name
59 
60 -- OUTPUT
61 
62 -- NOTES
63 
64 -- +--------------------------------------------------------------------------+
65 
66 PROCEDURE ROUTING_TRANSFER
67 (
68 X_org_id			IN NUMBER,
69 X_eng_item_id			IN NUMBER,
70 X_mfg_item_id			IN NUMBER,
71 X_designator_option		IN NUMBER,
72 X_transfer_option		IN NUMBER,
73 X_alt_rtg_designator		IN VARCHAR2,
74 X_effectivity_date		IN DATE,
75 X_last_login_id			IN NUMBER,
76 X_ecn_name			IN VARCHAR2
77 );
78 
79 END ENG_ROUTING_PKG;