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_ROUTING_STEPS_PUB dependencies on FM_ROUT_DEP

Line 1051: /* step dependency (fm_rout_dep table) is success. */

1047: /* */
1048: /* DESCRIPTION: */
1049: /* */
1050: /* API returns (x_return_code) = 'S' if the update into routing */
1051: /* step dependency (fm_rout_dep table) is success. */
1052: /* */
1053: /* History : */
1054: /* Shyam 07/29/2002 Initial implementation */
1055: /* =============================================================== */

Line 1060: , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL

1056: PROCEDURE update_step_dependencies
1057: ( p_api_version IN NUMBER := 1
1058: , p_init_msg_list IN BOOLEAN := TRUE
1059: , p_commit IN BOOLEAN := FALSE
1060: , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
1061: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
1062: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
1063: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
1064: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL

Line 1062: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE

1058: , p_init_msg_list IN BOOLEAN := TRUE
1059: , p_commit IN BOOLEAN := FALSE
1060: , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
1061: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
1062: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
1063: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
1064: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
1065: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
1066: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type

Line 1063: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL

1059: , p_commit IN BOOLEAN := FALSE
1060: , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
1061: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
1062: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
1063: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
1064: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
1065: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
1066: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
1067: , x_message_count OUT NOCOPY NUMBER

Line 1078: l_routing_id fm_rout_dep.routing_id%TYPE;

1074: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1075:
1076: l_routingstep_no fm_rout_dtl.routingStep_no%TYPE;
1077: l_routingstep_id fm_rout_dtl.routingStep_id%TYPE;
1078: l_routing_id fm_rout_dep.routing_id%TYPE;
1079: l_transfer_pct NUMBER;
1080: l_dep_type NUMBER;
1081: l_std_delay NUMBER;
1082:

Line 1084: l_old_stepDep_rec fm_rout_dep%ROWTYPE;

1080: l_dep_type NUMBER;
1081: l_std_delay NUMBER;
1082:
1083: /* Define record type that hold the routing data */
1084: l_old_stepDep_rec fm_rout_dep%ROWTYPE;
1085:
1086: /* Define Exceptions */
1087: routing_update_dep_failure EXCEPTION;
1088: invalid_version EXCEPTION;

Line 1341: /* step dependency (fm_rout_dep table) is success. */

1337: /* */
1338: /* DESCRIPTION: */
1339: /* */
1340: /* API returns (x_return_code) = 'S' if the delete into routing */
1341: /* step dependency (fm_rout_dep table) is success. */
1342: /* */
1343: /* History : */
1344: /* Shyam 07/29/2002 Initial implementation */
1345: /* =============================================================== */

Line 1364: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;

1360: /* Local variable section */
1361: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ROUTING_STEP';
1362: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1363: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1364: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;
1365: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
1366: l_routing_id gmd_routings.routing_id%TYPE;
1367: l_dep_routingstep_no fm_rout_dep.dep_routingStep_no%TYPE;
1368:

Line 1367: l_dep_routingstep_no fm_rout_dep.dep_routingStep_no%TYPE;

1363: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1364: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;
1365: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
1366: l_routing_id gmd_routings.routing_id%TYPE;
1367: l_dep_routingstep_no fm_rout_dep.dep_routingStep_no%TYPE;
1368:
1369: /* Define Cursors */
1370: /* Cursor that check if there any row in the step dependency table that
1371: needs to be deleted */

Line 1372: Cursor Check_Step_dep_rec(vRoutingstep_no fm_rout_dep.routingStep_no%TYPE

1368:
1369: /* Define Cursors */
1370: /* Cursor that check if there any row in the step dependency table that
1371: needs to be deleted */
1372: Cursor Check_Step_dep_rec(vRoutingstep_no fm_rout_dep.routingStep_no%TYPE
1373: ,vRouting_id gmd_routings.Routing_id%TYPE) IS
1374: Select dep_routingstep_no
1375: From fm_rout_dep
1376: Where routingStep_no = vRoutingStep_no

Line 1375: From fm_rout_dep

1371: needs to be deleted */
1372: Cursor Check_Step_dep_rec(vRoutingstep_no fm_rout_dep.routingStep_no%TYPE
1373: ,vRouting_id gmd_routings.Routing_id%TYPE) IS
1374: Select dep_routingstep_no
1375: From fm_rout_dep
1376: Where routingStep_no = vRoutingStep_no
1377: And routing_id = vrouting_id;
1378:
1379: /* Define Exceptions */

Line 1612: /* step dependency (fm_rout_dep table) is success. */

1608: /* */
1609: /* DESCRIPTION: */
1610: /* */
1611: /* API returns (x_return_code) = 'S' if the delete in routing */
1612: /* step dependency (fm_rout_dep table) is success. */
1613: /* */
1614: /* History : */
1615: /* Shyam 07/29/2002 Initial implementation */
1616: /* =============================================================== */

Line 1621: , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE

1617: PROCEDURE delete_step_dependencies
1618: ( p_api_version IN NUMBER := 1
1619: , p_init_msg_list IN BOOLEAN := TRUE
1620: , p_commit IN BOOLEAN := FALSE
1621: , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
1622: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
1623: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
1624: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
1625: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL

Line 1622: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL

1618: ( p_api_version IN NUMBER := 1
1619: , p_init_msg_list IN BOOLEAN := TRUE
1620: , p_commit IN BOOLEAN := FALSE
1621: , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
1622: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
1623: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
1624: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
1625: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
1626: , x_message_count OUT NOCOPY NUMBER

Line 1623: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL

1619: , p_init_msg_list IN BOOLEAN := TRUE
1620: , p_commit IN BOOLEAN := FALSE
1621: , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
1622: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
1623: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
1624: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
1625: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
1626: , x_message_count OUT NOCOPY NUMBER
1627: , x_message_list OUT NOCOPY VARCHAR2

Line 1635: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;

1631: /* Local variable section */
1632: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STEP_DEPENDENCIES';
1633: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1634:
1635: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;
1636: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
1637: l_dep_routingstep_no fm_rout_dep.dep_routingStep_no%TYPE;
1638: l_routing_id fm_rout_dep.routing_id%TYPE;
1639:

Line 1637: l_dep_routingstep_no fm_rout_dep.dep_routingStep_no%TYPE;

1633: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1634:
1635: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;
1636: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
1637: l_dep_routingstep_no fm_rout_dep.dep_routingStep_no%TYPE;
1638: l_routing_id fm_rout_dep.routing_id%TYPE;
1639:
1640: /* Define Exceptions */
1641: routing_delete_dep_failure EXCEPTION;

Line 1638: l_routing_id fm_rout_dep.routing_id%TYPE;

1634:
1635: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;
1636: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
1637: l_dep_routingstep_no fm_rout_dep.dep_routingStep_no%TYPE;
1638: l_routing_id fm_rout_dep.routing_id%TYPE;
1639:
1640: /* Define Exceptions */
1641: routing_delete_dep_failure EXCEPTION;
1642: invalid_version EXCEPTION;

Line 1767: /* Actual delete in fm_rout_dep table */

1763: FND_MSG_PUB.ADD;
1764: RAISE routing_delete_dep_failure;
1765: END IF;
1766:
1767: /* Actual delete in fm_rout_dep table */
1768: /* This delete can be specific to a dep_routingstep_no or a
1769: Routingstep_no */
1770: IF (l_debug = 'Y') THEN
1771: gmd_Debug.put_line('About to delete from step dep table - the routingstep no = '