DBA Data[Home] [Help]

APPS.CTO_WORKFLOW_API_PK dependencies on OE_ORDER_LINES_ALL

Line 102: | from oe_order_lines_all This is added during Unit test

98: |
99: | 08/28/2003 Kiran Konada
100: | chnaging the procedure wf_update_after_inv_unresv
101: | getting inventory_item_id and oship from org_id
102: | from oe_order_lines_all This is added during Unit test
103: | for support to handle mutiple sources situations during supply
104: | creation
105: |
106: | 09/25/2003 Shashi Bhaskaran

Line 424: from oe_order_lines_all

420: -- line ou and reset after the worklfow node is completed.
421:
422: Select org_id
423: into l_line_org_id
424: from oe_order_lines_all
425: where line_id = p_itemkey;
426:
427: -- Modified by Renga Kannan on 04/28/06
428: -- CAlling Utility API to Switch to order line context

Line 467: context to the org_id on oe_order_lines_all. After

463: Fix for bug 1494878 :
464: The operating unit can be set differently for
465: OM and WIP reponsibilities. Hence, before calling OM's
466: function to update the line status, we set the org
467: context to the org_id on oe_order_lines_all. After
468: returning from the OM function, we reset the org
469: context to the WIP operating unit (profile MO:op unit)
470:
471: fix for bug 1895563 :

Line 489: l_ship_from_org_id Oe_order_lines_all.ship_from_org_id%type;

485: x_return_status VARCHAR2(1);
486: l_stmt_num number;
487: v_inv_item_id NUMBER;
488: l_message NUMBER;
489: l_ship_from_org_id Oe_order_lines_all.ship_from_org_id%type;
490: l_change_status Varchar2(100);
491: l_item_type_code Varchar2(100);
492: v_source_type_code Varchar2(100);
493: v_shipped_quantity oe_order_lines_all.shipped_quantity%type;

Line 493: v_shipped_quantity oe_order_lines_all.shipped_quantity%type;

489: l_ship_from_org_id Oe_order_lines_all.ship_from_org_id%type;
490: l_change_status Varchar2(100);
491: l_item_type_code Varchar2(100);
492: v_source_type_code Varchar2(100);
493: v_shipped_quantity oe_order_lines_all.shipped_quantity%type;
494: v_shipped_qty number; -- 2972186
495: l_msg_count NUMBER;
496: l_msg_data VARCHAR2(200);
497: l_ato_line_id NUMBER;

Line 548: from oe_order_lines_all oel,

544: v_shipped_qty,
545: l_ato_line_id,
546: l_top_model_line_id,
547: l_booked_flag
548: from oe_order_lines_all oel,
549: mtl_system_items msi
550: where line_id = p_order_line_id
551: and oel.inventory_item_id = msi.inventory_item_id
552: and oel.ship_from_org_id = msi.organization_id;

Line 738: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

734: )
735: IS
736:
737: l_api_name CONSTANT varchar2(40) := 'inventory_reservation_check';
738: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
739: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
740: v_activity_status_code varchar2(8);
741: v_source_type_code oe_order_lines.source_type_code%type ;
742:

Line 739: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

735: IS
736:
737: l_api_name CONSTANT varchar2(40) := 'inventory_reservation_check';
738: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
739: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
740: v_activity_status_code varchar2(8);
741: v_source_type_code oe_order_lines.source_type_code%type ;
742:
743: l_stmt_num number;

Line 745: v_header_id oe_order_lines_all.header_id%type ;

741: v_source_type_code oe_order_lines.source_type_code%type ;
742:
743: l_stmt_num number;
744:
745: v_header_id oe_order_lines_all.header_id%type ;
746: v_po_header_id po_headers_all.po_header_id%type ;
747: v_authorization_status po_headers_all.authorization_status%type ;
748:
749:

Line 770: from oe_order_lines_all

766: into v_item_type_code
767: , v_ato_line_id
768: , v_source_type_code
769: , v_header_id
770: from oe_order_lines_all
771: where line_id = p_order_line_id;
772:
773: -- here, we pass the Standard item line,
774: -- namely, it will return a success. */

Line 966: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

962: )
963: IS
964:
965: l_api_name CONSTANT varchar2(40) := 'wf_update_after_inv_reserv';
966: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
967: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
968: v_activity_status_code varchar2(8);
969: return_value integer :=1; --fix for bug#1895563
970: /*******************************************************

Line 967: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

963: IS
964:
965: l_api_name CONSTANT varchar2(40) := 'wf_update_after_inv_reserv';
966: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
967: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
968: v_activity_status_code varchar2(8);
969: return_value integer :=1; --fix for bug#1895563
970: /*******************************************************
971: return value is intialized to 1 in the begining,

Line 997: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'Before selecting info from oe_order_lines_all');

993: x_return_status := FND_API.G_RET_STS_SUCCESS;
994: l_stmt_num := 10;
995:
996: If PG_DEBUG <> 0 Then
997: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'Before selecting info from oe_order_lines_all');
998: End if;
999:
1000:
1001: select item_type_code,

Line 1005: from oe_order_lines_all

1001: select item_type_code,
1002: ato_line_id
1003: into v_item_type_code,
1004: v_ato_line_id
1005: from oe_order_lines_all
1006: where line_id = p_order_line_id;
1007: If PG_DEBUG <> 0 Then
1008: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'ato_line_id = '||v_ato_line_id);
1009: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'v_item_type_code = '||v_item_type_code);

Line 1400: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

1396: )
1397: IS
1398:
1399: l_api_name CONSTANT VARCHAR2(40) := 'inventory_unreservation_check';
1400: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
1401: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
1402: v_activity_status_code VARCHAR2(8);
1403: l_stmt_num number;
1404:

Line 1401: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

1397: IS
1398:
1399: l_api_name CONSTANT VARCHAR2(40) := 'inventory_unreservation_check';
1400: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
1401: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
1402: v_activity_status_code VARCHAR2(8);
1403: l_stmt_num number;
1404:
1405: BEGIN

Line 1416: from oe_order_lines_all

1412: l_stmt_num := 10;
1413:
1414: select item_type_code, ato_line_id
1415: into v_item_type_code, v_ato_line_id
1416: from oe_order_lines_all
1417: where line_id = p_order_line_id;
1418:
1419: --
1420: -- For CONFIG items, unreservation is allowed only when the workflow has moved to SHIP LINE.

Line 1568: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

1564: )
1565: IS
1566:
1567: l_api_name CONSTANT varchar2(40) := 'wf_update_after_inv_unreserv';
1568: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
1569: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
1570: v_activity_status_code varchar2(8);
1571: v_counter integer;
1572: v_counter2 integer;

Line 1569: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

1565: IS
1566:
1567: l_api_name CONSTANT varchar2(40) := 'wf_update_after_inv_unreserv';
1568: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
1569: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
1570: v_activity_status_code varchar2(8);
1571: v_counter integer;
1572: v_counter2 integer;
1573: return_value integer;

Line 1578: l_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;

1574: l_stmt_num number;
1575: l_source_document_type_id number; -- bugfix 1799874
1576: l_message varchar2(100);
1577: l_po_req_qty Number;
1578: l_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;
1579:
1580: l_dummy number;
1581:
1582:

Line 1661: from oe_order_lines_all

1657: l_inventory_item_id,
1658: l_ship_from_org_id,
1659: l_ship_xfaced_flag, -- Bug fix 4863275
1660: v_open_flag -- Bugfix 7214005
1661: from oe_order_lines_all
1662: where line_id = p_order_line_id;
1663:
1664: If PG_DEBUG <> 0 Then
1665: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'ATO Line Id = '||v_ato_line_id);

Line 2157: from oe_order_lines_all

2153:
2154: v_count := 0;
2155: l_stmt_num := 20;
2156: select count(*) into v_count
2157: from oe_order_lines_all
2158: where header_id = v_header_id
2159: and ato_line_id = v_model_id
2160: and item_type_code = 'CONFIG';
2161:

Line 2240: from oe_order_lines_all

2236:
2237: l_stmt_num := 5;
2238: select ato_line_id, header_id
2239: into l_ato_line_id, l_header_id
2240: from oe_order_lines_all
2241: where line_id = oe_line_security.g_record.line_id
2242: and item_type_code <> 'STANDARD'
2243: and ato_line_id is not null;
2244:

Line 2250: from oe_order_lines_all

2246: -- adding join to header_id for performance
2247: l_stmt_num := 10;
2248: select 1
2249: into l_config_exists
2250: from oe_order_lines_all
2251: where header_id = l_header_id
2252: and ato_line_id = l_ato_line_id
2253: and item_type_code = 'CONFIG';
2254:

Line 2422: from oe_order_lines_all

2418: l_stmt_num := 5;
2419:
2420: select 1
2421: into l_config_item
2422: from oe_order_lines_all
2423: where line_id = oe_line_security.g_record.line_id
2424: and item_type_code = 'CONFIG';
2425:
2426: IF PG_DEBUG <> 0 THEN

Line 2503: from oe_order_lines_all

2499: l_stmt_num NUMBER;
2500:
2501: CURSOR c_config_exists IS
2502: select ato_line_id
2503: from oe_order_lines_all
2504: where top_model_line_id = oe_line_security.g_record.top_model_line_id
2505: and item_type_code = 'CONFIG';
2506:
2507: BEGIN

Line 2536: from oe_order_lines_all

2532:
2533: l_stmt_num := 30;
2534: select 1
2535: into l_config_exists
2536: from oe_order_lines_all
2537: where top_model_line_id = oe_line_security.g_record.top_model_line_id
2538: and item_type_code = 'CONFIG'
2539: and rownum = 1;
2540:

Line 2564: from oe_order_lines_all

2560:
2561: l_stmt_num := 50;
2562: select link_to_line_id
2563: into l_current_model_line
2564: from oe_order_lines_all
2565: where line_id = l_current_model_line;
2566:
2567: IF l_current_model_line = l_pto_line THEN
2568: IF PG_DEBUG <> 0 THEN

Line 2654: from oe_order_lines_all

2650: l_stmt_num := 5;
2651:
2652: select 1
2653: into l_top_ato_model
2654: from oe_order_lines_all
2655: where line_id = oe_line_security.g_record.line_id
2656: and ato_line_id = line_id;
2657:
2658: x_result := 1; /* the condition is true */

Line 2725: from oe_order_lines_all

2721: l_stmt_num := 5;
2722:
2723: select 1
2724: into l_config_item
2725: from oe_order_lines_all
2726: where line_id = oe_line_security.g_record.line_id
2727: and item_type_code = 'CONFIG';
2728:
2729: IF PG_DEBUG <> 0 THEN

Line 2775: lFlowStatusCode oe_order_lines_all.flow_status_code%type; --bugfix 2825486

2771:
2772: -- local parameters
2773: l_message VARCHAR2(100);
2774: l_stmt_num NUMBER;
2775: lFlowStatusCode oe_order_lines_all.flow_status_code%type; --bugfix 2825486
2776: l_current_mode varchar2(100);
2777: l_current_org Number;
2778: L_CHANGE_CONTEXT_BACK Varchar2(100);
2779:

Line 2793: from oe_order_lines_all

2789: -- bugfix 2825486: added select to get the current flow_status_code.
2790: l_stmt_num := 20;
2791: select nvl(flow_status_code,'N')
2792: into lFlowStatusCode
2793: from oe_order_lines_all
2794: where header_id = p_header_id
2795: and line_id = p_line_id;
2796:
2797:

Line 2942: p_new_order_quantity oe_order_lines_all.ordered_quantity%TYPE;

2938: p_organization_id VARCHAR2(100);
2939: p_offset_days NUMBER;
2940: x_return_status VARCHAR2(100);
2941: l_stmt_num NUMBER;
2942: p_new_order_quantity oe_order_lines_all.ordered_quantity%TYPE;
2943: v_x_error_msg_count NUMBER;
2944: v_x_hold_result_out VARCHAR2(1);
2945: v_x_hold_return_status VARCHAR2(1);
2946: v_x_error_msg VARCHAR2(150);

Line 2947: so_line oe_order_lines_all%ROWTYPE;

2943: v_x_error_msg_count NUMBER;
2944: v_x_hold_result_out VARCHAR2(1);
2945: v_x_hold_return_status VARCHAR2(1);
2946: v_x_error_msg VARCHAR2(150);
2947: so_line oe_order_lines_all%ROWTYPE;
2948: p_program_id NUMBER;
2949: l_res BOOLEAN;
2950: p_order_number VARCHAR2(100);
2951:

Line 2999: FROM oe_order_lines_all

2995: -- this cursor will fetch only one record from the table as the parameter passed in is the primary key.
2996: --
2997: SELECT *
2998: INTO so_line
2999: FROM oe_order_lines_all
3000: WHERE line_id = to_number(p_itemkey);
3001:
3002: SELECT order_number
3003: INTO p_order_number

Line 3004: FROM oe_order_lines_all a, oe_order_headers_all b

3000: WHERE line_id = to_number(p_itemkey);
3001:
3002: SELECT order_number
3003: INTO p_order_number
3004: FROM oe_order_lines_all a, oe_order_headers_all b
3005: WHERE a.header_id = b.header_id
3006: AND a.line_id = to_number(p_itemkey);
3007:
3008: -- get the line source document type ID

Line 3240: FROM OE_ORDER_LINES_ALL

3236: INTO l_item_type_code,
3237: l_ato_line_id,
3238: l_inv_item_id,
3239: l_ship_org
3240: FROM OE_ORDER_LINES_ALL
3241: WHERE line_id = oe_line_security.g_record.line_id;
3242:
3243:
3244: IF l_item_type_code in ('STANDARD','OPTION') AND

Line 3357: from oe_order_lines_all

3353: END IF;
3354: l_stmt_num := 5;
3355: select ato_line_id, header_id , inventory_item_id
3356: into l_ato_line_id, l_header_id , l_cfg_item_id
3357: from oe_order_lines_all
3358: where line_id = oe_line_security.g_record.line_id
3359: and item_type_code <> 'STANDARD'
3360: and ato_line_id is not null;
3361:

Line 3369: from oe_order_lines_all

3365: l_stmt_num := 10;
3366:
3367: select line_id
3368: into l_config_line_id
3369: from oe_order_lines_all
3370: where header_id = l_header_id
3371: and ato_line_id = l_ato_line_id
3372: and item_type_code = 'CONFIG';
3373:

Line 3397: from oe_order_lines_all oel,

3393: --this query catches the CIB contsraint when OM calls for model line
3394: --instead of waiting for a call for config line
3395: select nvl(msi.config_orgs,1)
3396: into l_config_orgs
3397: from oe_order_lines_all oel,
3398: mtl_system_items msi
3399: where oel.line_id = l_ato_line_id
3400: and msi.inventory_item_id = oel.inventory_item_id
3401: and msi.organization_id = oel.ship_from_org_id;