106: l_form_id NUMBER;
107: l_org_id NUMBER;
108: l_prod_exec_enabled VARCHAR2(1);
109:
110: l_from_status gmd_status_b.status_code%TYPE;
111: l_from_status_type gmd_status_b.status_type%TYPE;
112: l_from_status_desc gmd_status.description%TYPE;
113: l_to_status_type gmd_status_b.status_type%TYPE;
114: l_to_status_desc gmd_status.description%TYPE;
107: l_org_id NUMBER;
108: l_prod_exec_enabled VARCHAR2(1);
109:
110: l_from_status gmd_status_b.status_code%TYPE;
111: l_from_status_type gmd_status_b.status_type%TYPE;
112: l_from_status_desc gmd_status.description%TYPE;
113: l_to_status_type gmd_status_b.status_type%TYPE;
114: l_to_status_desc gmd_status.description%TYPE;
115:
109:
110: l_from_status gmd_status_b.status_code%TYPE;
111: l_from_status_type gmd_status_b.status_type%TYPE;
112: l_from_status_desc gmd_status.description%TYPE;
113: l_to_status_type gmd_status_b.status_type%TYPE;
114: l_to_status_desc gmd_status.description%TYPE;
115:
116: l_target_status gmd_status_next.target_status%TYPE;
117: l_rework_status gmd_status_next.rework_status%TYPE;