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 1734: FROM gmd_recipe_process_parameters

1730: /* Parameters at the operation resource level */
1731: CURSOR Cur_get_rcp_rsrc (V_routingstep_id NUMBER, V_oprn_line_id NUMBER,
1732: V_resources VARCHAR2, V_parameter_id NUMBER) IS
1733: SELECT *
1734: FROM gmd_recipe_process_parameters
1735: WHERE recipe_id = p_recipe_id
1736: AND organization_id = p_organization_id
1737: AND routingstep_id = V_routingstep_id
1738: AND oprn_line_id = V_oprn_line_id

Line 1758: X_target_value gmd_recipe_process_parameters.target_value%type ;

1754:
1755: X_row NUMBER DEFAULT 0;
1756: X_found NUMBER(5) DEFAULT 0;
1757: X_override NUMBER(5) DEFAULT 0;
1758: X_target_value gmd_recipe_process_parameters.target_value%type ;
1759: X_minimum_value NUMBER ;
1760: X_maximum_value NUMBER ;
1761: X_created_by gmd_recipe_process_parameters.created_by%type ;
1762: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;

Line 1761: X_created_by gmd_recipe_process_parameters.created_by%type ;

1757: X_override NUMBER(5) DEFAULT 0;
1758: X_target_value gmd_recipe_process_parameters.target_value%type ;
1759: X_minimum_value NUMBER ;
1760: X_maximum_value NUMBER ;
1761: X_created_by gmd_recipe_process_parameters.created_by%type ;
1762: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;
1763: X_last_update_date gmd_recipe_process_parameters.last_update_date%type ;
1764: X_creation_date gmd_recipe_process_parameters.creation_date%type ;
1765: X_last_update_login gmd_recipe_process_parameters.last_update_login%type ;

Line 1762: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;

1758: X_target_value gmd_recipe_process_parameters.target_value%type ;
1759: X_minimum_value NUMBER ;
1760: X_maximum_value NUMBER ;
1761: X_created_by gmd_recipe_process_parameters.created_by%type ;
1762: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;
1763: X_last_update_date gmd_recipe_process_parameters.last_update_date%type ;
1764: X_creation_date gmd_recipe_process_parameters.creation_date%type ;
1765: X_last_update_login gmd_recipe_process_parameters.last_update_login%type ;
1766: BEGIN

Line 1763: X_last_update_date gmd_recipe_process_parameters.last_update_date%type ;

1759: X_minimum_value NUMBER ;
1760: X_maximum_value NUMBER ;
1761: X_created_by gmd_recipe_process_parameters.created_by%type ;
1762: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;
1763: X_last_update_date gmd_recipe_process_parameters.last_update_date%type ;
1764: X_creation_date gmd_recipe_process_parameters.creation_date%type ;
1765: X_last_update_login gmd_recipe_process_parameters.last_update_login%type ;
1766: BEGIN
1767: FOR l_rcp_res_rec IN Cur_get_recp_rsrc LOOP

Line 1764: X_creation_date gmd_recipe_process_parameters.creation_date%type ;

1760: X_maximum_value NUMBER ;
1761: X_created_by gmd_recipe_process_parameters.created_by%type ;
1762: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;
1763: X_last_update_date gmd_recipe_process_parameters.last_update_date%type ;
1764: X_creation_date gmd_recipe_process_parameters.creation_date%type ;
1765: X_last_update_login gmd_recipe_process_parameters.last_update_login%type ;
1766: BEGIN
1767: FOR l_rcp_res_rec IN Cur_get_recp_rsrc LOOP
1768: FOR l_rec IN Cur_get_gen_rsrc (l_rcp_res_rec.resources) LOOP

Line 1765: X_last_update_login gmd_recipe_process_parameters.last_update_login%type ;

1761: X_created_by gmd_recipe_process_parameters.created_by%type ;
1762: X_last_updated_by gmd_recipe_process_parameters.last_updated_by%type ;
1763: X_last_update_date gmd_recipe_process_parameters.last_update_date%type ;
1764: X_creation_date gmd_recipe_process_parameters.creation_date%type ;
1765: X_last_update_login gmd_recipe_process_parameters.last_update_login%type ;
1766: BEGIN
1767: FOR l_rcp_res_rec IN Cur_get_recp_rsrc LOOP
1768: FOR l_rec IN Cur_get_gen_rsrc (l_rcp_res_rec.resources) LOOP
1769: