124: x_status := 1;
125:
126: SELECT process_type
127: INTO l_process_type
128: FROM qp_interface_list_headers
129: WHERE process_id = p_process_id;
130:
131:
132: IF (l_process_type = 'XML') THEN
151: gpr_modifier_list_rec.start_date_active,
152: gpr_modifier_list_rec.end_date_active,
153: gpr_modifier_list_rec.automatic_flag
154: FROM
155: qp_interface_list_headers lhdr
156: WHERE
157: lhdr.process_id = p_process_id
158: AND
159: rownum < 2;
185: gpr_modifier_list_rec.pte_code,
186: gpr_modifier_list_rec.automatic_flag,
187: gpr_modifier_list_rec.attribute1
188: FROM
189: qp_interface_list_headers lhdr
190: WHERE
191: lhdr.process_id = p_process_id
192: AND
193: rownum < 2;