49: attribute12,
50: attribute13,
51: attribute14,
52: attribute15
53: from OKE_K_HOLDS
54: where hold_id = X_hold_id
55: for update of hold_id nowait;
56:
57: recinfo c%rowtype;
148: X_Attribute15 VARCHAR2
149:
150: ) is
151:
152: x_prev_hold_status_code OKE_K_HOLDS.hold_status_code%TYPE;
153: x_k_Deliverable_ID OKE_K_HOLDS.Deliverable_ID%TYPE;
154: x_hold_type_code OKE_K_HOLDS.hold_type_code%TYPE;
155: x_hold_reason_code OKE_K_HOLDS.hold_reason_code%TYPE;
156:
149:
150: ) is
151:
152: x_prev_hold_status_code OKE_K_HOLDS.hold_status_code%TYPE;
153: x_k_Deliverable_ID OKE_K_HOLDS.Deliverable_ID%TYPE;
154: x_hold_type_code OKE_K_HOLDS.hold_type_code%TYPE;
155: x_hold_reason_code OKE_K_HOLDS.hold_reason_code%TYPE;
156:
157: cursor C_prev is
150: ) is
151:
152: x_prev_hold_status_code OKE_K_HOLDS.hold_status_code%TYPE;
153: x_k_Deliverable_ID OKE_K_HOLDS.Deliverable_ID%TYPE;
154: x_hold_type_code OKE_K_HOLDS.hold_type_code%TYPE;
155: x_hold_reason_code OKE_K_HOLDS.hold_reason_code%TYPE;
156:
157: cursor C_prev is
158: select hold_status_code
151:
152: x_prev_hold_status_code OKE_K_HOLDS.hold_status_code%TYPE;
153: x_k_Deliverable_ID OKE_K_HOLDS.Deliverable_ID%TYPE;
154: x_hold_type_code OKE_K_HOLDS.hold_type_code%TYPE;
155: x_hold_reason_code OKE_K_HOLDS.hold_reason_code%TYPE;
156:
157: cursor C_prev is
158: select hold_status_code
159: ,Deliverable_ID
158: select hold_status_code
159: ,Deliverable_ID
160: ,hold_type_code
161: ,hold_reason_code
162: from OKE_K_HOLDS
163: where hold_id = X_hold_id;
164:
165: begin
166:
170: ,x_hold_type_code
171: ,x_hold_reason_code;
172: close c_prev;
173:
174: update OKE_K_HOLDS
175: set
176: remove_date = X_remove_date,
177: remove_reason_code = X_remove_reason_code,
178: remove_comment = X_remove_comment,
250: ) is
251:
252: cursor C is
253: select rowid
254: from OKE_K_HOLDS
255: where hold_id = X_hold_id;
256:
257: begin
258:
255: where hold_id = X_hold_id;
256:
257: begin
258:
259: insert into OKE_K_HOLDS(
260: hold_id,
261: k_header_id,
262: k_line_id,
263: deliverable_id,