APPS.CTO_CONFIG_ITEM_PK dependencies on CTO_CHANGE_ORDER_PK

Line 892: pchgtype CTO_CHANGE_ORDER_PK.change_table_type;

888:
889: -- The following flag is added by Renga Kannan on 03/13/2001
890:
891: l_resv_flag varchar2(1) := 'N';
892: pchgtype CTO_CHANGE_ORDER_PK.change_table_type;
893: l_order_number OE_ORDER_HEADERS_ALL.order_number%TYPE;
894: l_ml_mo_flag varchar2(1) := 'N';
895:
896: pAutoUnreserve varchar2(1);

Line 1332: cto_change_order_pk.delete_from_req_interface(

1328:
1329: -- rkaza. ireq project. 05/13/2005.
1330: -- Delete any records in req interface for this config line.
1331:
1332: cto_change_order_pk.delete_from_req_interface(
1333: p_line_id => lConfigLineId,
1334: p_item_id => pConfigId,
1335: x_return_status => l_return_status ) ;
1336:

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

1635: -- Planner if Reservation exists for this item. But this de-link code
1636: -- Can be get called from the change_order package itself. In this case the
1637: -- Change order pkg will send the notification. This procedure need not do anything.
1638: -- This will be accomplished by the following logic. Whenever Delink_function is called
1639: -- from CTO_CHANGE_ORDER_PK the package variable CHANGE_ORDER_PK_STATE is set to 1. Otherwise
1640: -- it is defaulted to 0. So in this function we will call the notification only if this
1641: -- Pkg variable value is zero and l_resv_flag is set to 'Y'. This flag is set to 'Y' in the
1642: -- Begining part of this function.
1643:

Line 1649: IF ( CTO_CHANGE_ORDER_PK.change_order_pk_state = 0

1645:
1646: /* BUG#2234858 Sushant Modified this code for Drop Ship Project
1647: ** No notifications should be sent for drop shipped items
1648: */
1649: IF ( CTO_CHANGE_ORDER_PK.change_order_pk_state = 0
1650: and ( l_resv_flag = 'Y' or l_ml_mo_flag = 'Y')
1651: and v_source_type_code = 'INTERNAL' )
1652: THEN
1653:

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

1669:
1670: oe_debug_pub.add('delink_item: ' || 'Line id = '||to_char(pModelLineId),3);
1671: END IF;
1672:
1673: pchgtype(1).change_type := CTO_CHANGE_ORDER_PK.DELINK_ACTION;
1674: pchgtype(1).old_value := null;
1675: pchgtype(1).new_value := null;
1676:
1677: lStmtNumber := 610;

Line 1678: CTO_CHANGE_ORDER_PK.Start_work_flow(

1674: pchgtype(1).old_value := null;
1675: pchgtype(1).new_value := null;
1676:
1677: lStmtNumber := 610;
1678: CTO_CHANGE_ORDER_PK.Start_work_flow(
1679: porder_no => l_order_number,
1680: pline_no => pModelLineId,
1681: pchgtype => pchgtype,
1682: pmlmo_flag => l_ml_mo_flag,