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 STANDARD

Line 40: | item_type_code = 'Standard' and |

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: | |

Line 137: x_return_status - standard API output parameter

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

Line 173: --if ((upper(v_item_type_code) = 'STANDARD' OR upper(v_item_type_code) = 'OPTION') --fix for bug#1874380

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
174: IF ( (UPPER(v_item_type_code) = 'STANDARD'
175: OR UPPER(v_item_type_code) = 'OPTION'
176: OR UPPER(v_item_type_code) = 'INCLUDED'
177: )

Line 174: IF ( (UPPER(v_item_type_code) = 'STANDARD'

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
174: IF ( (UPPER(v_item_type_code) = 'STANDARD'
175: OR UPPER(v_item_type_code) = 'OPTION'
176: OR UPPER(v_item_type_code) = 'INCLUDED'
177: )
178: AND v_ato_line_id = order_line_id

Line 272: x_return_status - standard API output parameter

268: /**************************************************************************
269:
270: Procedure: last_wo_reservation_deleted
271: Parameters: order_line_id - order_line_id
272: x_return_status - standard API output parameter
273: x_msg_count - "
274: x_msg_data - "
275: Description: This callback is used to inform the order line workflow that
276: the last reservation has been deleted for this sales order

Line 315: --if(((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))

311: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => order_line_id );
312: --bugfix 1799874 end
313:
314: --Adding INCLUDED item type code for SUN ER#9793792
315: --if(((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))
316: if(( (upper(v_item_type_code) = 'STANDARD')
317: OR (upper(v_item_type_code) = 'OPTION')
318: OR (upper(v_item_type_code) = 'INCLUDED')
319: )

Line 316: if(( (upper(v_item_type_code) = 'STANDARD')

312: --bugfix 1799874 end
313:
314: --Adding INCLUDED item type code for SUN ER#9793792
315: --if(((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))
316: if(( (upper(v_item_type_code) = 'STANDARD')
317: OR (upper(v_item_type_code) = 'OPTION')
318: OR (upper(v_item_type_code) = 'INCLUDED')
319: )
320: and v_ato_line_id = order_line_id ) -- fix for bug# 1874380

Line 443: x_return_status - standard API output parameter

439: /**************************************************************************
440:
441: Procedure: flow_creation
442: Parameters: order_line_id - order_line_id
443: x_return_status - standard API output parameter
444: x_msg_count - "
445: x_msg_data - "
446: Description: This callback is used to inform the order line workflow that
447: the first flow schedule has been created for this sales order

Line 478: --if (((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))

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'))
479: if (( (upper(v_item_type_code) = 'STANDARD')
480: OR (upper(v_item_type_code) = 'OPTION')
481: OR (upper(v_item_type_code) = 'INCLUDED')
482: )

Line 479: if (( (upper(v_item_type_code) = 'STANDARD')

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'))
479: if (( (upper(v_item_type_code) = 'STANDARD')
480: OR (upper(v_item_type_code) = 'OPTION')
481: OR (upper(v_item_type_code) = 'INCLUDED')
482: )
483: and v_ato_line_id = order_line_id) -- fix for bug #1874380

Line 570: x_return_status - standard API output parameter

566: /**************************************************************************
567:
568: Procedure: flow_deletion
569: Parameters: order_line_id - order_line_id
570: x_return_status - standard API output parameter
571: x_msg_count - "
572: x_msg_data - "
573: Description: This callback is used to inform the order line workflow that
574: the last flow schedule has been deleted for this sales order

Line 613: --if (((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))

609: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => order_line_id );
610: --bugfix 1799874 end
611:
612: --Adding INCLUDED item type code for SUN ER#9793792
613: --if (((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))
614: if (( (upper(v_item_type_code) = 'STANDARD')
615: OR (upper(v_item_type_code) = 'OPTION')
616: OR (upper(v_item_type_code) = 'INCLUDED')
617: )

Line 614: if (( (upper(v_item_type_code) = 'STANDARD')

610: --bugfix 1799874 end
611:
612: --Adding INCLUDED item type code for SUN ER#9793792
613: --if (((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))
614: if (( (upper(v_item_type_code) = 'STANDARD')
615: OR (upper(v_item_type_code) = 'OPTION')
616: OR (upper(v_item_type_code) = 'INCLUDED')
617: )
618: and v_ato_line_id = order_line_id ) -- fix for bug#1874380