APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_STATUS

Line 225: l_status_type GMD_STATUS_B.status_type%TYPE;

221: l_mesg_count NUMBER;
222: l_mesg_data VARCHAR2(2000);
223: l_return_status VARCHAR2(1);
224: l_action_flag VARCHAR2(1) := 'U';
225: l_status_type GMD_STATUS_B.status_type%TYPE;
226:
227: l_item_no VARCHAR2(2000);
228: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
229: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;

Line 306: FROM gmd_status_b

302: concurrent_id = pConcurrent_id;
303:
304: CURSOR Check_version_enabled(vStatus VARCHAR2) IS
305: SELECT version_enabled
306: FROM gmd_status_b
307: WHERE status_type = vStatus;
308:
309: -- Cursor to get formula_id when recipe_id is passed
310: CURSOR get_formula_id(v_recp_id NUMBER) IS

Line 447: FROM gmd_status

443:
444: FUNCTION get_status_meaning(P_status_code IN VARCHAR2) RETURN VARCHAR2 IS
445: CURSOR Cur_get IS
446: SELECT meaning
447: FROM gmd_status
448: WHERE status_code = P_status_code;
449:
450: l_meaning gmd_status.meaning%TYPE;
451: BEGIN

Line 450: l_meaning gmd_status.meaning%TYPE;

446: SELECT meaning
447: FROM gmd_status
448: WHERE status_code = P_status_code;
449:
450: l_meaning gmd_status.meaning%TYPE;
451: BEGIN
452: OPEN Cur_get;
453: FETCH Cur_get INTO l_meaning;
454: CLOSE Cur_get;

Line 558: GMD_STATUS_PUB.modify_status

554: -- If so then call the Change status API
555: IF get_object_rec.replace_type = 'STATUS' THEN
556:
557: -- Call the change status API
558: GMD_STATUS_PUB.modify_status
559: ( p_entity_name => get_object_rec.object_type
560: , p_entity_id => get_object_rec.object_id
561: , p_to_status => get_object_rec.new_name
562: , p_ignore_flag => TRUE

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

1611: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1612: END IF;
1613: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1614: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1615: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1616: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1617: get_status_meaning(
1618: GMD_API_GRP.get_object_status_type
1619: (get_object_rec.object_type

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

1710: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1711: END IF;
1712: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1713: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1714: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1715: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1716: get_status_meaning(get_object_rec.new_name) );
1717: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1718: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);

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

1781: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1782: END IF;
1783: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1784: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1785: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1786: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1787: get_status_meaning(get_object_rec.new_name) );
1788: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1789: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);