DBA Data[Home] [Help]

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on STANDARD

Line 703: || IF v_item_type_code = 'STANDARD'

699:
700: /*
701: || Added by aiyer for the bug 5401180,
702: || Modified the IF condition. Original Condition
703: || IF v_item_type_code = 'STANDARD'
704: || AND
705: || ( (v_reference_line_id IS NOT NULL OR v_order_category = 'RETURN')
706: || AND
707: || ( NVL(pr_new.RETURN_CONTEXT, 'XX') <> 'LEGACY') -- and legacy condition added by Aparajita for bug # 2504184

Line 713: IF v_item_type_code = 'STANDARD' AND

709: || AND
710: || NVL(V_Source_Document_Type_Id,0) <> 2
711: || has been replaced by the new condition.
712: */
713: IF v_item_type_code = 'STANDARD' AND
714: ( ( v_reference_line_id IS NOT NULL OR
715: pr_new.line_category_code = 'RETURN'
716: ) AND
717: pr_new.return_context IS NOT NULL

Line 724: utl_file.put_line(v_myfilehandle,'Returning at STANDARD , RETURN, V_Source_Document_Type_Id' );

720: THEN
721: /* End of bug 5401180 */
722:
723: IF v_debug = 'Y' THEN
724: utl_file.put_line(v_myfilehandle,'Returning at STANDARD , RETURN, V_Source_Document_Type_Id' );
725: utl_file.put_line(v_myfilehandle,'** END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'dd/mm/rrrr hh24:mi:ss'));
726: utl_file.fclose(v_myfilehandle);
727: END IF; -- v_debug
728: RETURN;