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.

APPS.GMD_ROUTINGS_PVT dependencies on GMD_ROUTINGS

Line 1: PACKAGE BODY GMD_ROUTINGS_PVT AS

1: PACKAGE BODY GMD_ROUTINGS_PVT AS
2: /* $Header: GMDVROUB.pls 120.4.12010000.2 2008/11/12 18:12:46 rnalla ship $ */
3:
4:
5: --Bug 3222090, NSRIVAST 20-FEB-2004, BEGIN

Line 27: /* header (fm_rout_hdr or gmd_routings) table is successfully. */

23: /* */
24: /* DESCRIPTION: */
25: /* */
26: /* API returns (x_return_code) = 'S' if the insert into routing */
27: /* header (fm_rout_hdr or gmd_routings) table is successfully. */
28: /* */
29: /* History : */
30: /* Shyam 07/29/2002 Initial implementation */
31: /* =============================================================== */

Line 33: ( p_routings IN gmd_routings%ROWTYPE

29: /* History : */
30: /* Shyam 07/29/2002 Initial implementation */
31: /* =============================================================== */
32: PROCEDURE insert_routing
33: ( p_routings IN gmd_routings%ROWTYPE
34: , x_message_count OUT NOCOPY NUMBER
35: , x_message_list OUT NOCOPY VARCHAR2
36: , x_return_status OUT NOCOPY VARCHAR2
37: ) IS

Line 75: GMD_ROUTINGS_PKG.insert_row(

71: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
72: ||'Inserting the routing header with routing id '||l_routing_id);
73: END IF;
74:
75: GMD_ROUTINGS_PKG.insert_row(
76: x_rowid => l_row_id,
77: x_routing_id => p_routings.routing_id,
78: x_routing_no => p_routings.routing_no,
79: x_routing_vers => p_routings.routing_vers,

Line 180: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);

176: WHEN OTHERS THEN
177: IF (l_debug = 'Y') THEN
178: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
179: END IF;
180: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
181: x_return_status := FND_API.g_ret_sts_unexp_error;
182: fnd_msg_pub.count_and_get (
183: p_count => x_message_count
184: ,p_encoded => FND_API.g_false

Line 195: /* header (fm_rout_hdr or gmd_routings) table is successfully. */

191: /* */
192: /* DESCRIPTION: */
193: /* */
194: /* API returns (x_return_code) = 'S' if the update into routing */
195: /* header (fm_rout_hdr or gmd_routings) table is successfully. */
196: /* */
197: /* History : */
198: /* Shyam 07/29/2002 Initial implementation */
199: /* Kalyani 06/06/2006 BUG 5197863 Moved existing code to new */

Line 204: ( p_routing_id IN gmd_routings.routing_id%TYPE := NULL

200: /* function validate dates */
201: /* RLNAGARA 25-Apr-2008 B6997624 Added Fixed Process Loss and UOM */
202: /* =============================================================== */
203: PROCEDURE update_routing
204: ( p_routing_id IN gmd_routings.routing_id%TYPE := NULL
205: , p_update_table IN gmd_routings_pub.update_tbl_type
206: , x_message_count OUT NOCOPY NUMBER
207: , x_message_list OUT NOCOPY VARCHAR2
208: , x_return_status OUT NOCOPY VARCHAR2

Line 205: , p_update_table IN gmd_routings_pub.update_tbl_type

201: /* RLNAGARA 25-Apr-2008 B6997624 Added Fixed Process Loss and UOM */
202: /* =============================================================== */
203: PROCEDURE update_routing
204: ( p_routing_id IN gmd_routings.routing_id%TYPE := NULL
205: , p_update_table IN gmd_routings_pub.update_tbl_type
206: , x_message_count OUT NOCOPY NUMBER
207: , x_message_list OUT NOCOPY VARCHAR2
208: , x_return_status OUT NOCOPY VARCHAR2
209: ) IS

Line 223: l_old_routing_rec gmd_routings%ROWTYPE;

219: l_vr_start_date DATE;
220: l_vr_end_date DATE;
221:
222: /* Define record type that hold the routing data */
223: l_old_routing_rec gmd_routings%ROWTYPE;
224:
225: /* Table type defn */
226: l_stepupdate_table gmd_routings_pub.update_tbl_type;
227:

Line 226: l_stepupdate_table gmd_routings_pub.update_tbl_type;

222: /* Define record type that hold the routing data */
223: l_old_routing_rec gmd_routings%ROWTYPE;
224:
225: /* Table type defn */
226: l_stepupdate_table gmd_routings_pub.update_tbl_type;
227:
228: /* BUG 5197863 Added l_ret */
229: l_ret NUMBER;
230:

Line 238: CURSOR get_old_routing_rec(vRouting_id gmd_routings.routing_id%TYPE) IS

234: invalid_version EXCEPTION;
235: setup_failure EXCEPTION;
236:
237: /* Define cursor section */
238: CURSOR get_old_routing_rec(vRouting_id gmd_routings.routing_id%TYPE) IS
239: Select *
240: From gmd_routings
241: Where Routing_id = vRouting_id;
242:

Line 240: From gmd_routings

236:
237: /* Define cursor section */
238: CURSOR get_old_routing_rec(vRouting_id gmd_routings.routing_id%TYPE) IS
239: Select *
240: From gmd_routings
241: Where Routing_id = vRouting_id;
242:
243: CURSOR get_nonmanual_step_release(vRouting_id gmd_routings.routing_id%TYPE) IS
244: Select routingstep_id

Line 243: CURSOR get_nonmanual_step_release(vRouting_id gmd_routings.routing_id%TYPE) IS

239: Select *
240: From gmd_routings
241: Where Routing_id = vRouting_id;
242:
243: CURSOR get_nonmanual_step_release(vRouting_id gmd_routings.routing_id%TYPE) IS
244: Select routingstep_id
245: From fm_rout_dtl
246: Where Routing_id = vRouting_id
247: And steprelease_type <> 1;

Line 249: CURSOR Get_db_last_update_date(vRouting_id gmd_routings.routing_id%TYPE) IS

245: From fm_rout_dtl
246: Where Routing_id = vRouting_id
247: And steprelease_type <> 1;
248:
249: CURSOR Get_db_last_update_date(vRouting_id gmd_routings.routing_id%TYPE) IS
250: Select last_update_date
251: From gmd_routings_b
252: Where Routing_id = vRouting_id;
253:

Line 251: From gmd_routings_b

247: And steprelease_type <> 1;
248:
249: CURSOR Get_db_last_update_date(vRouting_id gmd_routings.routing_id%TYPE) IS
250: Select last_update_date
251: From gmd_routings_b
252: Where Routing_id = vRouting_id;
253:
254: CURSOR Get_oprn_start_end_dates(vRouting_id NUMBER) IS
255: SELECT max(effective_start_date) effective_start_date

Line 265: From gmd_routings_b rt, gmd_recipes_b rc,

261:
262: CURSOR Get_vr_start_end_dates(vRouting_id NUMBER) IS
263: Select min(vr.Start_Date) Start_Date ,
264: max(NVL(vr.End_Date, trunc(SYSDATE + 999999) ) ) End_Date
265: From gmd_routings_b rt, gmd_recipes_b rc,
266: gmd_recipe_validity_rules vr
267: Where vr.recipe_id = rc.recipe_id AND
268: ((rc.routing_id IS NOT NULL) AND (rc.routing_id = rt.routing_id)) AND
269: rt.routing_id = vRouting_id AND

Line 497: GMD_ROUTINGS_PKG.update_row(

493: END IF;
494: CLOSE Get_vr_start_end_dates;
495:
496: /* Number of times this routine is equal to number of rows in the p_update_table */
497: GMD_ROUTINGS_PKG.update_row(
498: x_routing_id => p_routing_id,
499: x_owner_organization_id => l_old_routing_rec.owner_organization_id,
500: x_routing_no => l_old_routing_rec.routing_no,
501: x_routing_vers => l_old_routing_rec.routing_vers,

Line 601: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);

597: WHEN OTHERS THEN
598: IF (l_debug = 'Y') THEN
599: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
600: END IF;
601: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
602: x_return_status := FND_API.g_ret_sts_unexp_error;
603: fnd_msg_pub.count_and_get (
604: p_count => x_message_count
605: ,p_encoded => FND_API.g_false

Line 621: p_routing_id IN gmd_routings.routing_id%TYPE

617: /* History : */
618: /* Kalyani 06/06/2006 BUG 5197863 Added */
619: /* =============================================================== */
620: FUNCTION Validate_dates(
621: p_routing_id IN gmd_routings.routing_id%TYPE
622: ,p_effective_start_date IN DATE
623: ,p_effective_end_date IN DATE ) RETURN NUMBER is
624:
625: l_api_name CONSTANT VARCHAR2(30) := 'Validate_dates';

Line 694: END GMD_ROUTINGS_PVT;

690: RETURN 1;
691: END validate_dates;
692:
693:
694: END GMD_ROUTINGS_PVT;