eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.GMP_BOM_ROUTING_PKG

Source


1 PACKAGE GMP_BOM_ROUTING_PKG AS
2 /* $Header: GMPBMRTS.pls 120.4.12010000.2 2008/11/01 21:53:02 rpatangy ship $ */
3 
4   PROCEDURE extract_effectivities
5             (
6 			  at_apps_link   IN VARCHAR2,
7 			  delimiter_char IN VARCHAR2,
8 			  instance       IN INTEGER,
9 			  run_date       IN DATE,
10                           return_status  IN OUT NOCOPY BOOLEAN
11             );
12 
13   PROCEDURE time_stamp ;
14 
15   PROCEDURE LOG_MESSAGE(pBUFF  IN  VARCHAR2) ;
16 
17   FUNCTION check_formula (
18                            porganization_id IN PLS_INTEGER,
19                            pformula_id IN PLS_INTEGER) return BOOLEAN ;
20 
21   FUNCTION check_formula_for_organization (
22                            porganization_id IN PLS_INTEGER,
23                            pformula_id IN PLS_INTEGER) return BOOLEAN ;
24 
25   PROCEDURE validate_formula_for_orgn ;
26 
27   PROCEDURE validate_formula ;
28 
29   PROCEDURE invalidate_rtg_all_org (p_routing_id IN PLS_INTEGER) ;
30 
31   PROCEDURE validate_routing (prouting_id IN PLS_INTEGER ,
32                              porganization_id   IN PLS_INTEGER,
33                              pheader_loc  IN  PLS_INTEGER,
34                              prout_valid  OUT NOCOPY BOOLEAN) ;
35 
36   PROCEDURE link_routing ;
37 
38   PROCEDURE link_override_routing ;
39 
40   PROCEDURE export_effectivities
41   (
42     return_status            OUT NOCOPY BOOLEAN
43   ) ;
44 
45   FUNCTION bsearch_routing (p_routing_id IN PLS_INTEGER ,
46                             p_organization_id IN PLS_INTEGER)
47                           RETURN INTEGER ;
48 
49   /* Added New Function for Sequence Dependencies - SGIDUGU  */
50   FUNCTION bsearch_setupid (p_oprn_id      IN PLS_INTEGER ,
51                             p_category_id  IN PLS_INTEGER)
52                           RETURN INTEGER ;
53 
54   PROCEDURE write_process_effectivity
55   (
56     p_x_aps_fmeff_id   IN PLS_INTEGER,
57     p_aps_fmeff_id     IN PLS_INTEGER,
58     return_status      OUT NOCOPY BOOLEAN
59   ) ;
60 
61   PROCEDURE write_bom_components
62   (
63     p_x_aps_fmeff_id   IN PLS_INTEGER,
64     return_status      OUT NOCOPY BOOLEAN
65   ) ;
66 
67   PROCEDURE write_routing
68   (
69     p_x_aps_fmeff_id   IN PLS_INTEGER,
70     return_status      OUT NOCOPY BOOLEAN
71   ) ;
72 
73   PROCEDURE write_routing_operations
74   (
75     p_x_aps_fmeff_id   IN PLS_INTEGER,
76     return_status      OUT NOCOPY BOOLEAN
77   ) ;
78 
79   PROCEDURE retrieve_effectivities
80   (
81     return_status  OUT NOCOPY BOOLEAN
82   ) ;
83 
84   PROCEDURE write_operation_components
85   (
86     p_x_aps_fmeff_id   IN PLS_INTEGER,
87     precipe_id         IN PLS_INTEGER,
88     return_status      OUT NOCOPY BOOLEAN
89   ) ;
90 
91   PROCEDURE setup
92   (
93     apps_link_name IN VARCHAR2,
94     delimiter_char IN VARCHAR2,
95     instance       IN INTEGER,
96     run_date       IN DATE,
97     return_status  OUT NOCOPY BOOLEAN
98   ) ;
99 
100    PROCEDURE gmp_putline (
101        v_text                    IN       VARCHAR2,
102        v_mode                    IN       VARCHAR2 ) ;
103 
104    FUNCTION find_routing_header ( prouting_id   IN PLS_INTEGER,
105                                   porganization_id   IN PLS_INTEGER)
106                                   RETURN BOOLEAN ;
107    FUNCTION find_routing_offsets (p_formula_id       IN PLS_INTEGER,
108                                   p_organization_id   IN PLS_INTEGER)
109                                RETURN NUMBER ;
110    FUNCTION get_offsets( p_formula_id                IN PLS_INTEGER,
111 			p_organization_id	IN PLS_INTEGER,
112                         p_formulaline_id        IN PLS_INTEGER )
113                         RETURN NUMBER ;
114 
115    PROCEDURE msc_inserts
116    (
117      return_status  OUT NOCOPY BOOLEAN
118    ) ;
119 
120   /* Added new procedure to write the Resource Setups and Transitions - SGIDUGU  */
121   /* bug: 6710684 Vpedarla added an IN parameter at_apps_link to the procedure write_setups_and_transitions */
122   PROCEDURE write_setups_and_transitions
123   (
124     at_apps_link    IN VARCHAR2,
125     return_status   OUT NOCOPY BOOLEAN
126   ) ;
127 
128 PROCEDURE Report_Error
129 (
130   i_error_id       IN VARCHAR2,
131   i_error_code     IN VARCHAR2,
132   i_param_1        IN VARCHAR2,
133   i_param_2        IN VARCHAR2,
134   i_param_3        IN VARCHAR2,
135   i_param_4        IN VARCHAR2
136 );
137 
138 PROCEDURE write_step_dependency(
139   p_x_aps_fmeff_id   IN PLS_INTEGER
140 );
141 
142 FUNCTION enh_bsearch_stpno ( l_formula_id       IN PLS_INTEGER,
143                              l_recipe_id        IN PLS_INTEGER,
144                              l_item_id          IN PLS_INTEGER
145                            ) RETURN INTEGER ;
146 
147 PROCEDURE bsearch_unique (p_resource_id   IN PLS_INTEGER ,
148                           p_category_id   IN PLS_INTEGER ,
149                           p_setup_id      OUT NOCOPY PLS_INTEGER
150                          ) ;
151 
152 PROCEDURE extract_items
153 (
154   at_apps_link  IN VARCHAR2,
155   instance      IN INTEGER,
156   run_date      IN DATE,
157   return_status IN OUT NOCOPY BOOLEAN
158 );
159 
160 /* bug: 6710684 vpedarla - added new function */
161 FUNCTION get_profile_value(
162       profile_name IN VARCHAR2,
163       pdblink      IN VARCHAR2 DEFAULT NULL ) return VARCHAR2 ;
164 
165 
166 END GMP_BOM_ROUTING_PKG;