[Home] [Help]
36: | to support ATO item under a PTO |
37: | item_type_code for an ato item under PTO |
38: | is 'OPTION' and top_model_line_id will NOT be |
39: | null, UNLIKE an ato item order, where |
40: | item_type_code = 'Standard' and |
41: | top_model_lined_id is null |
42: | This fix has actually been provided in |
43: | branched code 115.15.115.3 |
44: | |
133: /**************************************************************************
134:
135: Procedure: first_wo_reservation_created
136: Parameters: order_line_id - order_line_id
137: x_return_status - standard API output parameter
138: x_msg_count - "
139: x_msg_data - "
140: Description: This callback is used to inform the order line workflow that
141: the first reservation has been created for this sales order
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)
174: or
175: upper(v_item_type_code) = 'CONFIG'
176: then
263: /**************************************************************************
264:
265: Procedure: last_wo_reservation_deleted
266: Parameters: order_line_id - order_line_id
267: x_return_status - standard API output parameter
268: x_msg_count - "
269: x_msg_data - "
270: Description: This callback is used to inform the order line workflow that
271: the last reservation has been deleted for this sales order
305: --bugfix 1799874 start
306: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => order_line_id );
307: --bugfix 1799874 end
308:
309: if(((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))
310: and v_ato_line_id = order_line_id ) -- fix for bug# 1874380
311: or upper(v_item_type_code) = 'CONFIG'
312: then
313:
429: /**************************************************************************
430:
431: Procedure: flow_creation
432: Parameters: order_line_id - order_line_id
433: x_return_status - standard API output parameter
434: x_msg_count - "
435: x_msg_data - "
436: Description: This callback is used to inform the order line workflow that
437: the first flow schedule has been created for this sales order
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
469: or upper(v_item_type_code) = 'CONFIG' then
470:
471: -- an ATO item line or CONFIG line
551: /**************************************************************************
552:
553: Procedure: flow_deletion
554: Parameters: order_line_id - order_line_id
555: x_return_status - standard API output parameter
556: x_msg_count - "
557: x_msg_data - "
558: Description: This callback is used to inform the order line workflow that
559: the last flow schedule has been deleted for this sales order
593: --bugfix 1799874 start
594: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => order_line_id );
595: --bugfix 1799874 end
596:
597: if (((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))
598: and v_ato_line_id = order_line_id ) -- fix for bug#1874380
599: or upper(v_item_type_code) = 'CONFIG'
600: then
601: