APPS.OKE_APPLY_REMOVE_HOLDS_PKG dependencies on OKE_K_HOLDS

Line 53: from OKE_K_HOLDS

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;

Line 152: x_prev_hold_status_code OKE_K_HOLDS.hold_status_code%TYPE;

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:

Line 153: x_k_Deliverable_ID OKE_K_HOLDS.Deliverable_ID%TYPE;

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

Line 154: x_hold_type_code OKE_K_HOLDS.hold_type_code%TYPE;

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

Line 155: x_hold_reason_code OKE_K_HOLDS.hold_reason_code%TYPE;

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

Line 162: from OKE_K_HOLDS

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:

Line 174: update OKE_K_HOLDS

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,

Line 254: from OKE_K_HOLDS

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:

Line 259: insert into OKE_K_HOLDS(

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,