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.PO_CHORD_WF6 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 93


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** In Procedure: standard_po_reapproval ***');

Line: 130


             PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   				'l_is_complex_work_po - Yes');

Line: 133


             PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   				'l_is_complex_work_po - No');

Line: 174


   			PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'$$$$$$$ Document requires full approval =  N $$$$$$');

Line: 225


   			PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   				'########## header_require_reapproval result: Y');

Line: 231


   			PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   				'########## header_require_reapproval result: N');

Line: 273


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## lines_require_reapproval result: Y');

Line: 279


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## lines_require_reapproval result: N');

Line: 318


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## shipments_require_reapproval result: Y');

Line: 324


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## shipments_require_reapproval result: N');

Line: 351


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## dist_require_reapproval result: Y');

Line: 357


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## dist_require_reapproval result: N');

Line: 374


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'$$$$$$$ Document requires full approval =  Y $$$$$$');

Line: 380


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'$$$$$$$ Document requires full approval =  N $$$$$$');

Line: 387


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** Finish: standard_po_reapproval ***');

Line: 422


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** In Procedure: planned_po_reapproval ***');

Line: 462


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## header_require_reapproval result: Y');

Line: 468


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## header_require_reapproval result: N');

Line: 495


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## lines_require_reapproval result: Y');

Line: 501


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## lines_require_reapproval result: N');

Line: 525


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## shipments_require_reapproval result: Y');

Line: 531


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## shipments_require_reapproval result: N');

Line: 556


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## dist_require_reapproval result: Y');

Line: 562


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## dist_require_reapproval result: N');

Line: 571


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'$$$$$$$ Document requires full approval =  Y $$$$$$');

Line: 577


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'$$$$$$$ Document requires full approval =  N $$$$$$');

Line: 585


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** Finish: planned_po_reapproval ***');

Line: 620


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** In Procedure: blanket_po_reapproval ***');

Line: 667


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## header_require_reapproval result: Y');

Line: 673


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## header_require_reapproval result: N');

Line: 706


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## lines_require_reapproval result: Y');

Line: 712


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## lines_require_reapproval result: N');

Line: 737


                   PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                           '########## shipments_require_reapproval result: Y');

Line: 743


                   PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                           '########## shipments_require_reapproval result: N');

Line: 758


                   PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                           '########## GA org assignments require reapproval result: Y');

Line: 764


                   PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                           '########## GA org assignments require reapproval result: N');

Line: 781


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'$$$$$$$ Document requires full approval =  Y $$$$$$');

Line: 787


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'$$$$$$$ Document requires full approval =  N $$$$$$');

Line: 795


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** Finish: blanket_po_reapproval ***');

Line: 818


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** In Procedure: contract_po_reapproval ***');

Line: 859


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## header_require_reapproval result: Y');

Line: 865


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## header_require_reapproval result: N');

Line: 881


         		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
         			'$$$$$$$ Document requires full approval =  Y $$$$$$');

Line: 884


         		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
         			'$$$$$$$ Document requires full approval =  N $$$$$$');

Line: 892


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** Finish: contract_po_reapproval ***');

Line: 928


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** In Procedure: blanket_release_reapproval ***');

Line: 969


   			PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   				'$$$$$$$ Document requires full approval =  N $$$$$$');

Line: 994


   			PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			 '########## blanket_release_require_reapproval result: Y');

Line: 1000


   			PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			 '########## blanket_release_require_reapproval result: N');

Line: 1028


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## shipments_require_reapproval result: Y');

Line: 1034


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## shipments_require_reapproval result: N');

Line: 1061


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## dist_require_reapproval result: Y');

Line: 1067


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## dist_require_reapproval result: N');

Line: 1076


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'$$$$$$$ Document requires full approval =  Y $$$$$$');

Line: 1082


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'$$$$$$$ Document requires full approval =  N $$$$$$');

Line: 1090


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** Finish: blanket_release_reapproval ***');

Line: 1123


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** In Procedure: scheduled_release_reapproval ***');

Line: 1146


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		 '########## scheduled_release_require_reapproval result: Y');

Line: 1152


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		 '########## scheduled_release_require_reapproval result: N');

Line: 1174


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## shipments_require_reapproval result: Y');

Line: 1180


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## shipments_require_reapproval result: N');

Line: 1206


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## dist_require_reapproval result: Y');

Line: 1212


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'########## dist_require_reapproval result: N');

Line: 1221


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'$$$$$$$ Document requires full approval =  Y $$$$$$');

Line: 1227


   		PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   			'$$$$$$$ Document requires full approval =  N $$$$$$');

Line: 1235


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** Finish: scheduled_release_reapproval ***');

Line: 1270


      PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** In Procedure: get_default_tolerance ***');

Line: 1298


       PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** FINISH: get_default_tolerance ***');

Line: 1328


      PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
        	'*** In Procedure: get_tolerances_from_wf ***');

Line: 1453


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** FINISH: get_tolerances_from_wf ***');

Line: 1496


     PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** In Procedure: Set_Wf_Order_Tol ***');

Line: 1685


    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
		'*** FINISH: get_Default_Order_Tol ***');

Line: 1730


     PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** In Procedure: Set_Wf_Agreement_Tol ***');

Line: 1856


     PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
		'*** FINISH: get_Default_Agreement_Tol ***');

Line: 1901


     PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** In Procedure: Set_Wf_Release_Tol ***');

Line: 2005


     PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
		'*** FINISH: Set_Wf_Release_Tol ***');

Line: 2027


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** In Procedure: debug_default_tolerance ***');

Line: 2033


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - h_blanket_total_t        : '||
   		x_tolerance_control.h_blanket_total_t );

Line: 2036


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - h_amount_limit_t         : '||
   		x_tolerance_control.h_amount_limit_t );

Line: 2039


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - h_po_total_t         : '||
   		x_tolerance_control.h_po_total_t );

Line: 2044


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - l_start_date_t         : '||
   		x_tolerance_control.l_start_date_t );

Line: 2047


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - l_end_date_t         : '||
   		x_tolerance_control.l_end_date_t );

Line: 2055


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - l_quantity_t             : '||
   		x_tolerance_control.l_quantity_t );

Line: 2058


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - l_unit_price_t           : '||
   		x_tolerance_control.l_unit_price_t );

Line: 2061


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - l_quantity_committed_t   : '||
   		x_tolerance_control.l_quantity_committed_t );

Line: 2064


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - l_committed_amount_t     : '||
   		x_tolerance_control.l_committed_amount_t );

Line: 2067


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - l_price_limit_t          : '||
   		x_tolerance_control.l_price_limit_t );

Line: 2070


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - l_price_limit_t          : '||
   		x_tolerance_control.l_price_limit_t );

Line: 2074


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - l_amount_t          : '||
   		x_tolerance_control.l_amount_t );

Line: 2082


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - s_quantity_t             : '||
   		x_tolerance_control.s_quantity_t );

Line: 2085


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - s_price_override_t       : '||
   		x_tolerance_control.s_price_override_t );

Line: 2090


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - s_amount_t         : '||
   		x_tolerance_control.s_amount_t );

Line: 2093


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - s_need_by_date_t         : '||
   		x_tolerance_control.s_need_by_date_t );

Line: 2096


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - s_promised_date_t         : '||
   		x_tolerance_control.s_promised_date_t );

Line: 2105


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - d_quantity_ordered_t     : '||
   		x_tolerance_control.d_quantity_ordered_t );

Line: 2109


           PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
                   'Tolerance - d_amount_ordered_t       : '||
   		x_tolerance_control.d_amount_ordered_t );

Line: 2116


   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** FINISH: debug_default_tolerance ***');