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: --Adding INCLUDED item type code for SUN ER#9793792
173: --if ((upper(v_item_type_code) = 'STANDARD' OR upper(v_item_type_code) = 'OPTION') --fix for bug#1874380

Line 292: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

288:
289:
290:
291: l_api_name CONSTANT VARCHAR2(40) := 'last_wo_reservation_deleted';
292: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
293: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
294: v_activity_status_code VARCHAR2(8);
295: v_counter INTEGER;
296: v_counter2 INTEGER;

Line 293: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

289:
290:
291: l_api_name CONSTANT VARCHAR2(40) := 'last_wo_reservation_deleted';
292: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
293: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
294: v_activity_status_code VARCHAR2(8);
295: v_counter INTEGER;
296: v_counter2 INTEGER;
297: return_value INTEGER;

Line 307: from oe_order_lines_all

303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304:
305: select item_type_code, ato_line_id
306: into v_item_type_code, v_ato_line_id
307: from oe_order_lines_all
308: where line_id = order_line_id;
309:
310: --bugfix 1799874 start
311: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => order_line_id );

Line 462: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

458:
459: IS
460:
461: l_api_name CONSTANT VARCHAR2(40) := 'flow_creation';
462: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
463: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
464: v_activity_status_code VARCHAR2(8);
465: return_value INTEGER;
466:

Line 463: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

459: IS
460:
461: l_api_name CONSTANT VARCHAR2(40) := 'flow_creation';
462: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
463: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
464: v_activity_status_code VARCHAR2(8);
465: return_value INTEGER;
466:
467:

Line 474: from oe_order_lines_all

470: x_return_status := FND_API.G_RET_STS_SUCCESS;
471:
472: select item_type_code, ato_line_id
473: into v_item_type_code, v_ato_line_id
474: from oe_order_lines_all
475: where line_id = order_line_id;
476:
477: --Adding INCLUDED item type code for SUN ER#9793792
478: --if (((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))

Line 590: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

586:
587:
588:
589: l_api_name CONSTANT VARCHAR2(40) := 'flow_deletion';
590: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
591: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
592: v_activity_status_code VARCHAR2(8);
593: v_counter INTEGER;
594: v_counter2 INTEGER;

Line 591: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

587:
588:
589: l_api_name CONSTANT VARCHAR2(40) := 'flow_deletion';
590: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
591: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
592: v_activity_status_code VARCHAR2(8);
593: v_counter INTEGER;
594: v_counter2 INTEGER;
595: return_value INTEGER;

Line 605: from oe_order_lines_all

601: x_return_status := FND_API.G_RET_STS_SUCCESS;
602:
603: select item_type_code, ato_line_id
604: into v_item_type_code, v_ato_line_id
605: from oe_order_lines_all
606: where line_id = order_line_id;
607:
608: --bugfix 1799874 start
609: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => order_line_id );