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_RECIPE_VAL dependencies on GMD_RECIPE_VAL

Line 1: Package Body GMD_RECIPE_VAL AS

1: Package Body GMD_RECIPE_VAL AS
2: /* $Header: GMDRVALB.pls 120.0 2005/05/25 18:49:38 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_RECIPE_VAL';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_RECIPE_VAL';

1: Package Body GMD_RECIPE_VAL AS
2: /* $Header: GMDRVALB.pls 120.0 2005/05/25 18:49:38 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_RECIPE_VAL';
5:
6:
7: /* Purpose: Validate entities within a recipe */
8: /* */

Line 1030: l_std_qty gmd_recipe_validity_rules.std_qty%TYPE;

1026: l_recipe_theo_loss GMD_PROCESS_LOSS.process_loss%TYPE;
1027: x_msg_cnt NUMBER;
1028: x_msg_dat VARCHAR2(2000);
1029:
1030: l_std_qty gmd_recipe_validity_rules.std_qty%TYPE;
1031: l_detail_uom gmd_recipe_validity_rules.detail_uom%TYPE;
1032: l_inventory_item_id gmd_recipe_validity_rules.inventory_item_id%TYPE;
1033: l_organization_id gmd_recipe_validity_rules.organization_id%TYPE;
1034:

Line 1031: l_detail_uom gmd_recipe_validity_rules.detail_uom%TYPE;

1027: x_msg_cnt NUMBER;
1028: x_msg_dat VARCHAR2(2000);
1029:
1030: l_std_qty gmd_recipe_validity_rules.std_qty%TYPE;
1031: l_detail_uom gmd_recipe_validity_rules.detail_uom%TYPE;
1032: l_inventory_item_id gmd_recipe_validity_rules.inventory_item_id%TYPE;
1033: l_organization_id gmd_recipe_validity_rules.organization_id%TYPE;
1034:
1035: CURSOR get_other_vr_details(V_vr_id NUMBER) IS

Line 1032: l_inventory_item_id gmd_recipe_validity_rules.inventory_item_id%TYPE;

1028: x_msg_dat VARCHAR2(2000);
1029:
1030: l_std_qty gmd_recipe_validity_rules.std_qty%TYPE;
1031: l_detail_uom gmd_recipe_validity_rules.detail_uom%TYPE;
1032: l_inventory_item_id gmd_recipe_validity_rules.inventory_item_id%TYPE;
1033: l_organization_id gmd_recipe_validity_rules.organization_id%TYPE;
1034:
1035: CURSOR get_other_vr_details(V_vr_id NUMBER) IS
1036: SELECT std_qty, inventory_item_id, detail_uom, organization_id

Line 1033: l_organization_id gmd_recipe_validity_rules.organization_id%TYPE;

1029:
1030: l_std_qty gmd_recipe_validity_rules.std_qty%TYPE;
1031: l_detail_uom gmd_recipe_validity_rules.detail_uom%TYPE;
1032: l_inventory_item_id gmd_recipe_validity_rules.inventory_item_id%TYPE;
1033: l_organization_id gmd_recipe_validity_rules.organization_id%TYPE;
1034:
1035: CURSOR get_other_vr_details(V_vr_id NUMBER) IS
1036: SELECT std_qty, inventory_item_id, detail_uom, organization_id
1037: FROM gmd_recipe_validity_rules

Line 1037: FROM gmd_recipe_validity_rules

1033: l_organization_id gmd_recipe_validity_rules.organization_id%TYPE;
1034:
1035: CURSOR get_other_vr_details(V_vr_id NUMBER) IS
1036: SELECT std_qty, inventory_item_id, detail_uom, organization_id
1037: FROM gmd_recipe_validity_rules
1038: WHERE recipe_validity_rule_id = V_vr_id;
1039:
1040: l_api_name VARCHAR2(100) := 'calculate_process_loss' ;
1041:

Line 1105: FROM gmd_recipe_validity_rules

1101: ,x_return_status OUT NOCOPY VARCHAR2
1102: ) IS
1103: CURSOR Cur_check_dup_upd IS
1104: SELECT recipe_validity_rule_id
1105: FROM gmd_recipe_validity_rules
1106: WHERE recipe_id = pRecipe_id
1107: AND inventory_item_id = pitem_id
1108: AND ((organization_id = pOrgn_id) OR
1109: (organization_id IS NULL AND pOrgn_id is NULL))

Line 1139: END; /* Package Body GMD_RECIPE_VAL */

1135: x_return_status := FND_API.g_ret_sts_unexp_error;
1136: END check_for_duplicate;
1137:
1138:
1139: END; /* Package Body GMD_RECIPE_VAL */