APPS.GR_WF_UTIL_PVT dependencies on MTL_PARAMETERS

Line 425: l_orgn_name MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

421: l_count NUMBER;
422: l_errname VARCHAR2(200);
423: l_errmsg VARCHAR2(200);
424: l_errstack VARCHAR2(200);
425: l_orgn_name MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
426: BEGIN
427: l_itemtype := 'GRDCRBLD';
428: l_itemkey := to_char(p_item_no)||'-'||to_char(sysdate,'dd-MON-yyyy HH24:mi:ss');
429: l_WorkflowProcess := 'GRDCRBLD_PROCESS';

Line 1037: FROM gr_prop_chng_temp a, mtl_system_items_kfv b, mtl_parameters c

1033: AND message_icn = p_message_icn;
1034:
1035: CURSOR gr_prop_chng_temp IS
1036: SELECT a.orgn_id, nvl(c.organization_code, ' ') orgn_code, a.item_code, b.description item_name, a.property_name
1037: FROM gr_prop_chng_temp a, mtl_system_items_kfv b, mtl_parameters c
1038: WHERE a.orgn_id = b.organization_id
1039: AND a.orgn_id = c.organization_id
1040: AND b.organization_id = c.organization_id
1041: AND a.item_code = b.concatenated_segments

Line 1307: l_orgn_name MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

1303: l_errmsg VARCHAR2(200);
1304: l_errstack VARCHAR2(200);
1305:
1306: l_orgn_id NUMBER;
1307: l_orgn_name MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
1308: l_from_item VARCHAR2(40);
1309: l_to_item VARCHAR2(40);
1310:
1311: CURSOR cur_get_details IS