eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_WIP_WORKFLOW_API_PK dependencies on OE_ORDER_LINES_ALL

Line 157: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

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:

Line 158: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

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:

Line 169: from oe_order_lines_all

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)

Line 287: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

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;

Line 288: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

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;

Line 302: from oe_order_lines_all

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 );

Line 452: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

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:

Line 453: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

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:

Line 464: from oe_order_lines_all

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

Line 575: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

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;

Line 576: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

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;

Line 590: from oe_order_lines_all

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 );