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