APPS.GMD_ROUTINGS_PKG dependencies on GMD_ROUTINGS_B

Line 65: CURSOR C IS SELECT ROWID FROM GMD_ROUTINGS_B

61: X_LAST_UPDATE_LOGIN IN NUMBER,
62: X_FIXED_PROCESS_LOSS IN NUMBER, /* B6811759 */
63: X_FIXED_PROCESS_LOSS_UOM IN VARCHAR2
64: ) IS
65: CURSOR C IS SELECT ROWID FROM GMD_ROUTINGS_B
66: WHERE ROUTING_ID = X_ROUTING_ID
67: ;
68: BEGIN
69: INSERT INTO GMD_ROUTINGS_B (

Line 69: INSERT INTO GMD_ROUTINGS_B (

65: CURSOR C IS SELECT ROWID FROM GMD_ROUTINGS_B
66: WHERE ROUTING_ID = X_ROUTING_ID
67: ;
68: BEGIN
69: INSERT INTO GMD_ROUTINGS_B (
70: OWNER_ORGANIZATION_ID,
71: ROUTING_ID,
72: ROUTING_NO,
73: ROUTING_VERS,

Line 332: FROM GMD_ROUTINGS_B

328: PROCESS_LOSS,
329: ROUTING_STATUS,
330: FIXED_PROCESS_LOSS, /* B6811759 */
331: FIXED_PROCESS_LOSS_UOM
332: FROM GMD_ROUTINGS_B
333: WHERE ROUTING_ID = X_ROUTING_ID
334: FOR UPDATE OF ROUTING_ID NOWAIT;
335: RECINFO C%ROWTYPE;
336:

Line 526: UPDATE GMD_ROUTINGS_B SET

522: X_FIXED_PROCESS_LOSS IN NUMBER, /* B6811759 */
523: X_FIXED_PROCESS_LOSS_UOM IN VARCHAR2
524: ) IS
525: BEGIN
526: UPDATE GMD_ROUTINGS_B SET
527: OWNER_ORGANIZATION_ID = X_OWNER_ORGANIZATION_ID,
528: ROUTING_NO = X_ROUTING_NO,
529: ROUTING_VERS = X_ROUTING_VERS,
530: ROUTING_CLASS = X_ROUTING_CLASS,

Line 606: UPDATE GMD_ROUTINGS_B SET

602: X_ROUTING_ID IN NUMBER
603: ) IS
604: BEGIN
605:
606: UPDATE GMD_ROUTINGS_B SET
607: DELETE_MARK = 1
608: WHERE ROUTING_ID = X_ROUTING_ID;
609:
610: IF (SQL%NOTFOUND) THEN

Line 621: FROM GMD_ROUTINGS_B B

617: BEGIN
618: DELETE FROM GMD_ROUTINGS_TL T
619: WHERE NOT EXISTS
620: (SELECT NULL
621: FROM GMD_ROUTINGS_B B
622: WHERE B.ROUTING_ID = T.ROUTING_ID
623: );
624:
625: UPDATE GMD_ROUTINGS_TL T SET (