153:
154: IS
155:
156: l_api_name CONSTANT varchar2(40) := 'first_wo_reservation_created';
157: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
158: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
159: v_activity_status_code varchar2(8);
160: return_value integer;
161:
154: IS
155:
156: l_api_name CONSTANT varchar2(40) := 'first_wo_reservation_created';
157: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
158: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
159: v_activity_status_code varchar2(8);
160: return_value integer;
161:
162:
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: select item_type_code, ato_line_id
168: into v_item_type_code, v_ato_line_id
169: from oe_order_lines_all
170: where line_id = order_line_id;
171:
172: if ((upper(v_item_type_code) = 'STANDARD' OR upper(v_item_type_code) = 'OPTION') --fix for bug#1874380
173: and v_ato_line_id = order_line_id)
283:
284:
285:
286: l_api_name CONSTANT VARCHAR2(40) := 'last_wo_reservation_deleted';
287: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
288: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
289: v_activity_status_code VARCHAR2(8);
290: v_counter INTEGER;
291: v_counter2 INTEGER;
284:
285:
286: l_api_name CONSTANT VARCHAR2(40) := 'last_wo_reservation_deleted';
287: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
288: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
289: v_activity_status_code VARCHAR2(8);
290: v_counter INTEGER;
291: v_counter2 INTEGER;
292: return_value INTEGER;
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299:
300: select item_type_code, ato_line_id
301: into v_item_type_code, v_ato_line_id
302: from oe_order_lines_all
303: where line_id = order_line_id;
304:
305: --bugfix 1799874 start
306: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => order_line_id );
448:
449: IS
450:
451: l_api_name CONSTANT VARCHAR2(40) := 'flow_creation';
452: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
453: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
454: v_activity_status_code VARCHAR2(8);
455: return_value INTEGER;
456:
449: IS
450:
451: l_api_name CONSTANT VARCHAR2(40) := 'flow_creation';
452: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
453: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
454: v_activity_status_code VARCHAR2(8);
455: return_value INTEGER;
456:
457:
460: x_return_status := FND_API.G_RET_STS_SUCCESS;
461:
462: select item_type_code, ato_line_id
463: into v_item_type_code, v_ato_line_id
464: from oe_order_lines_all
465: where line_id = order_line_id;
466:
467: if (((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))
468: and v_ato_line_id = order_line_id) -- fix for bug #1874380
571:
572:
573:
574: l_api_name CONSTANT VARCHAR2(40) := 'flow_deletion';
575: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
576: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
577: v_activity_status_code VARCHAR2(8);
578: v_counter INTEGER;
579: v_counter2 INTEGER;
572:
573:
574: l_api_name CONSTANT VARCHAR2(40) := 'flow_deletion';
575: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
576: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
577: v_activity_status_code VARCHAR2(8);
578: v_counter INTEGER;
579: v_counter2 INTEGER;
580: return_value INTEGER;
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:
588: select item_type_code, ato_line_id
589: into v_item_type_code, v_ato_line_id
590: from oe_order_lines_all
591: where line_id = order_line_id;
592:
593: --bugfix 1799874 start
594: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => order_line_id );