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