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_FETCH_PUB dependencies on GMD_RECIPE_PROCESS_PARAMETERS

Line 1673: FROM gmd_recipe_process_parameters

1669: /* Parameters at the operation resource level */
1670: CURSOR Cur_get_rcp_rsrc (V_routingstep_id NUMBER, V_oprn_line_id NUMBER,
1671: V_resources VARCHAR2, V_parameter_id NUMBER) IS
1672: SELECT *
1673: FROM gmd_recipe_process_parameters
1674: WHERE recipe_id = p_recipe_id
1675: AND organization_id = p_organization_id
1676: AND routingstep_id = V_routingstep_id
1677: AND oprn_line_id = V_oprn_line_id

Line 1697: X_target_value gmd_recipe_process_parameters.target_value%type ;

1693:
1694: X_row NUMBER DEFAULT 0;
1695: X_found NUMBER(5) DEFAULT 0;
1696: X_override NUMBER(5) DEFAULT 0;
1697: X_target_value gmd_recipe_process_parameters.target_value%type ;
1698: X_minimum_value NUMBER ;
1699: X_maximum_value NUMBER ;
1700: X_created_by gmd_recipe_process_parameters.created_by%type ;
1701: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;

Line 1700: X_created_by gmd_recipe_process_parameters.created_by%type ;

1696: X_override NUMBER(5) DEFAULT 0;
1697: X_target_value gmd_recipe_process_parameters.target_value%type ;
1698: X_minimum_value NUMBER ;
1699: X_maximum_value NUMBER ;
1700: X_created_by gmd_recipe_process_parameters.created_by%type ;
1701: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;
1702: X_last_update_date gmd_recipe_process_parameters.last_update_date%type ;
1703: X_creation_date gmd_recipe_process_parameters.creation_date%type ;
1704: X_last_update_login gmd_recipe_process_parameters.last_update_login%type ;

Line 1701: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;

1697: X_target_value gmd_recipe_process_parameters.target_value%type ;
1698: X_minimum_value NUMBER ;
1699: X_maximum_value NUMBER ;
1700: X_created_by gmd_recipe_process_parameters.created_by%type ;
1701: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;
1702: X_last_update_date gmd_recipe_process_parameters.last_update_date%type ;
1703: X_creation_date gmd_recipe_process_parameters.creation_date%type ;
1704: X_last_update_login gmd_recipe_process_parameters.last_update_login%type ;
1705: BEGIN

Line 1702: X_last_update_date gmd_recipe_process_parameters.last_update_date%type ;

1698: X_minimum_value NUMBER ;
1699: X_maximum_value NUMBER ;
1700: X_created_by gmd_recipe_process_parameters.created_by%type ;
1701: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;
1702: X_last_update_date gmd_recipe_process_parameters.last_update_date%type ;
1703: X_creation_date gmd_recipe_process_parameters.creation_date%type ;
1704: X_last_update_login gmd_recipe_process_parameters.last_update_login%type ;
1705: BEGIN
1706: FOR l_rcp_res_rec IN Cur_get_recp_rsrc LOOP

Line 1703: X_creation_date gmd_recipe_process_parameters.creation_date%type ;

1699: X_maximum_value NUMBER ;
1700: X_created_by gmd_recipe_process_parameters.created_by%type ;
1701: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;
1702: X_last_update_date gmd_recipe_process_parameters.last_update_date%type ;
1703: X_creation_date gmd_recipe_process_parameters.creation_date%type ;
1704: X_last_update_login gmd_recipe_process_parameters.last_update_login%type ;
1705: BEGIN
1706: FOR l_rcp_res_rec IN Cur_get_recp_rsrc LOOP
1707: FOR l_rec IN Cur_get_gen_rsrc (l_rcp_res_rec.resources) LOOP

Line 1704: X_last_update_login gmd_recipe_process_parameters.last_update_login%type ;

1700: X_created_by gmd_recipe_process_parameters.created_by%type ;
1701: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;
1702: X_last_update_date gmd_recipe_process_parameters.last_update_date%type ;
1703: X_creation_date gmd_recipe_process_parameters.creation_date%type ;
1704: X_last_update_login gmd_recipe_process_parameters.last_update_login%type ;
1705: BEGIN
1706: FOR l_rcp_res_rec IN Cur_get_recp_rsrc LOOP
1707: FOR l_rec IN Cur_get_gen_rsrc (l_rcp_res_rec.resources) LOOP
1708: