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.JAI_OE_OLA_TRIGGER_PKG dependencies on OE_ORDER_LINES_ALL

Line 289: v_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_ID ;

285: ---------------------------------
286: /* Declarations for Copy Order */
287: ---------------------------------
288:
289: v_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_ID ;
290: v_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_LINE_ID ;
291: v_source_document_type_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_TYPE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_TYPE_ID ;
292: v_order_source_type VARCHAR2(240);
293:

Line 290: v_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_LINE_ID ;

286: /* Declarations for Copy Order */
287: ---------------------------------
288:
289: v_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_ID ;
290: v_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_LINE_ID ;
291: v_source_document_type_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_TYPE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_TYPE_ID ;
292: v_order_source_type VARCHAR2(240);
293:
294: --2001/10/01 Anuradha Parthasarathy

Line 291: v_source_document_type_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_TYPE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_TYPE_ID ;

287: ---------------------------------
288:
289: v_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_ID ;
290: v_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_LINE_ID ;
291: v_source_document_type_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_TYPE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_TYPE_ID ;
292: v_order_source_type VARCHAR2(240);
293:
294: --2001/10/01 Anuradha Parthasarathy
295: v_source_order_category_code VARCHAR2(30);

Line 364: CURSOR cur_source_line_id_exists ( p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE ,

360: v_hook VARCHAR2(6) ;
361: v_tax_line_count NUMBER ; --ashish for bug # 2519043
362: -- warehouse_not_found EXCEPTION ;
363:
364: CURSOR cur_source_line_id_exists ( p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
365: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE
366: )
367: IS
368: SELECT

Line 365: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE

361: v_tax_line_count NUMBER ; --ashish for bug # 2519043
362: -- warehouse_not_found EXCEPTION ;
363:
364: CURSOR cur_source_line_id_exists ( p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
365: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE
366: )
367: IS
368: SELECT
369: 'X'

Line 617: v_myfilehandle := utl_file.fopen(v_utl_location, 'OE_ORDER_LINES_ALL_triggers_ja.LOG','A');

613: -- utl file dir not defined, log file cannot be generated.
614: v_debug := 'N';
615: ELSE
616: -- open the file in append mode.
617: v_myfilehandle := utl_file.fopen(v_utl_location, 'OE_ORDER_LINES_ALL_triggers_ja.LOG','A');
618: END IF;
619:
620: EXCEPTION
621: WHEN OTHERS THEN

Line 632: utl_file.put_line(v_myfilehandle,'** START OF TRIGGER JA_IN_OE_ORDER_LINES_AIU_TRG AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'dd/mm/rrrr hh24:mi:ss'));

628:
629: -- Added by Aparajita for writing onto the log file
630: IF v_debug = 'Y' THEN
631: -- log start of trigger
632: utl_file.put_line(v_myfilehandle,'** START OF TRIGGER JA_IN_OE_ORDER_LINES_AIU_TRG AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'dd/mm/rrrr hh24:mi:ss'));
633: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
634: END IF; -- v_debug
635:
636:

Line 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'));

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;
729: END IF;

Line 906: p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE ,

902:
903: DECLARE
904: -- get the details from JAI_OM_WSH_LINES_ALL table
905: CURSOR cur_get_picking_lines(
906: p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE ,
907: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE
908: )
909: IS
910: /* Commented by Brathod for Bug#4244829

Line 907: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE

903: DECLARE
904: -- get the details from JAI_OM_WSH_LINES_ALL table
905: CURSOR cur_get_picking_lines(
906: p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE ,
907: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE
908: )
909: IS
910: /* Commented by Brathod for Bug#4244829
911: SELECT

Line 958: CURSOR cur_rma_entry_line_exists ( p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE ,

954: from JAI_OM_OE_SO_LINES
955: where line_id=v_reference_line_id;
956:
957:
958: CURSOR cur_rma_entry_line_exists ( p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
959: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE
960: )
961: IS
962: SELECT

Line 959: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE

955: where line_id=v_reference_line_id;
956:
957:
958: CURSOR cur_rma_entry_line_exists ( p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
959: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE
960: )
961: IS
962: SELECT
963: 'X'

Line 1077: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE , p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is

1073: regime_code = jai_constants.vat_regime
1074: AND tax_type = cp_tax_type;
1075:
1076: /*Added by Bgowrava for Bug#6126581 */
1077: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE , p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is
1078: select delivery_detail_id from JAI_OM_OE_RMA_LINES
1079: where rma_header_id = p_source_document_id AND
1080: rma_line_id = p_source_document_line_id;
1081:

Line 1755: CURSOR cur_get_JAI_OM_OE_RMA_TAXES (p_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE)

1751: /*
1752: Added by aiyer for the bug # #2798930.
1753: Get the rma trax lines detail from the table JAI_OM_OE_RMA_TAXES
1754: */
1755: CURSOR cur_get_JAI_OM_OE_RMA_TAXES (p_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE)
1756: IS
1757: SELECT
1758: tax_line_no ,
1759: tax_id ,

Line 1787: CURSOR cur_chk_tax_lines_exists ( p_line_id1 OE_ORDER_LINES_ALL.LINE_ID%TYPE ,

1783: /*
1784: Added by aiyer for the bug # #2798930.
1785: code to check whether a record exists in the table JAI_OM_OE_SO_TAXES for a given line_id and tax_id.
1786: */
1787: CURSOR cur_chk_tax_lines_exists ( p_line_id1 OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
1788: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE
1789: )
1790: IS
1791: SELECT

Line 2968: utl_file.put_line(v_myfilehandle,'** SUCCESSFUL 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'));

2964:
2965: -- Added by Aparajita for writing onto the log file
2966: IF v_debug = 'Y' THEN
2967: -- log start of trigger
2968: utl_file.put_line(v_myfilehandle,'** SUCCESSFUL 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'));
2969: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
2970: utl_file.fclose(v_myfilehandle);
2971: END IF; -- v_debug
2972:

Line 2981: utl_file.put_line(v_myfilehandle,'** Error 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'));

2977: IF v_debug = 'Y' THEN
2978: -- log start of trigger
2979: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
2980: utl_file.put_line(v_myfilehandle,'Error :' || SQLERRM );
2981: utl_file.put_line(v_myfilehandle,'** Error 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'));
2982: utl_file.fclose(v_myfilehandle);
2983: END IF; -- v_debug
2984:
2985: --RAISE_APPLICATION_ERROR(-20002, 'ERROR - TRIGGER JA_IN_OE_ORDER_LINES_AIU_TRG : ' || SQLERRM);

Line 3579: Before inserting a record in the oe_order_lines_all table for a return order, check if the delivery detail_id i.e pr_new.attribute2 is null.

3575:
3576:
3577: /*
3578: This code has been added by aiyer for the fix of the bug #2855855
3579: Before inserting a record in the oe_order_lines_all table for a return order, check if the delivery detail_id i.e pr_new.attribute2 is null.
3580: IF yes then
3581: 1. pick up the delivery_detail_id from the wsh_delivery_details table for records corresponding to the reference_header_id and
3582: reference_line_id in this table and populate the pr_new.attibute2 dff field
3583: 2.Set the pr_new.attribute3 = 'Y' and pr_new.attribute4 = 'Y'