APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_STATUS

Line 360: l_status_type GMD_STATUS_B.status_type%TYPE;

356: l_mesg_count NUMBER;
357: l_mesg_data VARCHAR2(2000);
358: l_return_status VARCHAR2(1);
359: l_action_flag VARCHAR2(1) := 'U';
360: l_status_type GMD_STATUS_B.status_type%TYPE;
361:
362: l_item_no VARCHAR2(2000);
363: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
364: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;

Line 459: FROM gmd_status_b

455: concurrent_id = pConcurrent_id;
456:
457: CURSOR Check_version_enabled(vStatus VARCHAR2) IS
458: SELECT version_enabled
459: FROM gmd_status_b
460: WHERE status_type = vStatus;
461:
462: -- Cursor to get formula_id when recipe_id is passed
463: CURSOR get_formula_id(v_recp_id NUMBER) IS

Line 600: FROM gmd_status

596:
597: FUNCTION get_status_meaning(P_status_code IN VARCHAR2) RETURN VARCHAR2 IS
598: CURSOR Cur_get IS
599: SELECT meaning
600: FROM gmd_status
601: WHERE status_code = P_status_code;
602:
603: l_meaning gmd_status.meaning%TYPE;
604: BEGIN

Line 603: l_meaning gmd_status.meaning%TYPE;

599: SELECT meaning
600: FROM gmd_status
601: WHERE status_code = P_status_code;
602:
603: l_meaning gmd_status.meaning%TYPE;
604: BEGIN
605: OPEN Cur_get;
606: FETCH Cur_get INTO l_meaning;
607: CLOSE Cur_get;

Line 711: GMD_STATUS_PUB.modify_status

707: -- If so then call the Change status API
708: IF get_object_rec.replace_type = 'STATUS' THEN
709:
710: -- Call the change status API
711: GMD_STATUS_PUB.modify_status
712: ( p_entity_name => get_object_rec.object_type
713: , p_entity_id => get_object_rec.object_id
714: , p_to_status => get_object_rec.new_name
715: , p_ignore_flag => TRUE

Line 1801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);

1797: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1798: END IF;
1799: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1800: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1802: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1803: get_status_meaning(
1804: GMD_API_GRP.get_object_status_type
1805: (get_object_rec.object_type

Line 1900: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);

1896: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1897: END IF;
1898: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1899: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1900: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1901: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1902: get_status_meaning(get_object_rec.new_name) );
1903: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1904: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);

Line 1971: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);

1967: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1968: END IF;
1969: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1970: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1971: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1972: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1973: get_status_meaning(get_object_rec.new_name) );
1974: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1975: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);