APPS.CTO_CONFIG_ITEM_PK dependencies on CTO_CHANGE_ORDER_PK

Line 817: pchgtype CTO_CHANGE_ORDER_PK.change_table_type;

813:
814: -- The following flag is added by Renga Kannan on 03/13/2001
815:
816: l_resv_flag varchar2(1) := 'N';
817: pchgtype CTO_CHANGE_ORDER_PK.change_table_type;
818: l_order_number OE_ORDER_HEADERS_ALL.order_number%TYPE;
819: l_ml_mo_flag varchar2(1) := 'N';
820:
821: pAutoUnreserve varchar2(1);

Line 1253: cto_change_order_pk.delete_from_req_interface(

1249:
1250: -- rkaza. ireq project. 05/13/2005.
1251: -- Delete any records in req interface for this config line.
1252:
1253: cto_change_order_pk.delete_from_req_interface(
1254: p_line_id => lConfigLineId,
1255: p_item_id => pConfigId,
1256: x_return_status => l_return_status ) ;
1257:

Line 1547: -- from CTO_CHANGE_ORDER_PK the package variable CHANGE_ORDER_PK_STATE is set to 1. Otherwise

1543: -- Planner if Reservation exists for this item. But this de-link code
1544: -- Can be get called from the change_order package itself. In this case the
1545: -- Change order pkg will send the notification. This procedure need not do anything.
1546: -- This will be accomplished by the following logic. Whenever Delink_function is called
1547: -- from CTO_CHANGE_ORDER_PK the package variable CHANGE_ORDER_PK_STATE is set to 1. Otherwise
1548: -- it is defaulted to 0. So in this function we will call the notification only if this
1549: -- Pkg variable value is zero and l_resv_flag is set to 'Y'. This flag is set to 'Y' in the
1550: -- Begining part of this function.
1551:

Line 1557: IF ( CTO_CHANGE_ORDER_PK.change_order_pk_state = 0

1553:
1554: /* BUG#2234858 Sushant Modified this code for Drop Ship Project
1555: ** No notifications should be sent for drop shipped items
1556: */
1557: IF ( CTO_CHANGE_ORDER_PK.change_order_pk_state = 0
1558: and ( l_resv_flag = 'Y' or l_ml_mo_flag = 'Y')
1559: and v_source_type_code = 'INTERNAL' )
1560: THEN
1561:

Line 1581: pchgtype(1).change_type := CTO_CHANGE_ORDER_PK.DELINK_ACTION;

1577:
1578: oe_debug_pub.add('delink_item: ' || 'Line id = '||to_char(pModelLineId),3);
1579: END IF;
1580:
1581: pchgtype(1).change_type := CTO_CHANGE_ORDER_PK.DELINK_ACTION;
1582: pchgtype(1).old_value := null;
1583: pchgtype(1).new_value := null;
1584:
1585: lStmtNumber := 610;

Line 1586: CTO_CHANGE_ORDER_PK.Start_work_flow(

1582: pchgtype(1).old_value := null;
1583: pchgtype(1).new_value := null;
1584:
1585: lStmtNumber := 610;
1586: CTO_CHANGE_ORDER_PK.Start_work_flow(
1587: porder_no => l_order_number,
1588: pline_no => pModelLineId,
1589: pchgtype => pchgtype,
1590: pmlmo_flag => l_ml_mo_flag,