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 308: v_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_ID ;

304: ---------------------------------
305: /* Declarations for Copy Order */
306: ---------------------------------
307:
308: v_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_ID ;
309: v_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_LINE_ID ;
310: v_source_document_type_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_TYPE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_TYPE_ID ;
311: v_order_source_type VARCHAR2(240);
312:

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

305: /* Declarations for Copy Order */
306: ---------------------------------
307:
308: v_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_ID ;
309: v_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_LINE_ID ;
310: v_source_document_type_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_TYPE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_TYPE_ID ;
311: v_order_source_type VARCHAR2(240);
312:
313: --2001/10/01 Anuradha Parthasarathy

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

306: ---------------------------------
307:
308: v_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_ID ;
309: v_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_LINE_ID ;
310: v_source_document_type_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_TYPE_ID%TYPE; --File.Sql.35 Cbabu := pr_new.SOURCE_DOCUMENT_TYPE_ID ;
311: v_order_source_type VARCHAR2(240);
312:
313: --2001/10/01 Anuradha Parthasarathy
314: v_source_order_category_code VARCHAR2(30);

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

380: v_hook VARCHAR2(6) ;
381: v_tax_line_count NUMBER ; --ashish for bug # 2519043
382: -- warehouse_not_found EXCEPTION ;
383:
384: CURSOR cur_source_line_id_exists ( p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
385: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE
386: )
387: IS
388: SELECT

Line 385: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE

381: v_tax_line_count NUMBER ; --ashish for bug # 2519043
382: -- warehouse_not_found EXCEPTION ;
383:
384: CURSOR cur_source_line_id_exists ( p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
385: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE
386: )
387: IS
388: SELECT
389: 'X'

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

746: -- utl file dir not defined, log file cannot be generated.
747: v_debug := 'N';
748: ELSE
749: -- open the file in append mode.
750: v_myfilehandle := utl_file.fopen(v_utl_location, 'OE_ORDER_LINES_ALL_triggers_ja.LOG','A');
751: END IF;
752:
753: EXCEPTION
754: WHEN OTHERS THEN

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

761:
762: -- Added by Aparajita for writing onto the log file
763: IF v_debug = 'Y' THEN
764: -- log start of trigger
765: 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'));
766: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
767: END IF; -- v_debug
768:
769:

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

854: /* End of bug 5401180 */
855:
856: IF v_debug = 'Y' THEN
857: utl_file.put_line(v_myfilehandle,'Returning at STANDARD , RETURN, V_Source_Document_Type_Id' );
858: 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'));
859: utl_file.fclose(v_myfilehandle);
860: END IF; -- v_debug
861: RETURN;
862: END IF;

Line 1087: p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE ,

1083:
1084: DECLARE
1085: -- get the details from JAI_OM_WSH_LINES_ALL table
1086: CURSOR cur_get_picking_lines(
1087: p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE ,
1088: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE
1089: )
1090: IS
1091: /* Commented by Brathod for Bug#4244829

Line 1088: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE

1084: DECLARE
1085: -- get the details from JAI_OM_WSH_LINES_ALL table
1086: CURSOR cur_get_picking_lines(
1087: p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE ,
1088: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE
1089: )
1090: IS
1091: /* Commented by Brathod for Bug#4244829
1092: SELECT

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

1135: from JAI_OM_OE_SO_LINES
1136: where line_id=v_reference_line_id;
1137:
1138:
1139: CURSOR cur_rma_entry_line_exists ( p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
1140: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE
1141: )
1142: IS
1143: SELECT

Line 1140: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE

1136: where line_id=v_reference_line_id;
1137:
1138:
1139: CURSOR cur_rma_entry_line_exists ( p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
1140: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE
1141: )
1142: IS
1143: SELECT
1144: 'X'

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

1254: regime_code = jai_constants.vat_regime
1255: AND tax_type = cp_tax_type;
1256:
1257: /*Added by Bgowrava for Bug#6126581 */
1258: 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
1259: select delivery_detail_id from JAI_OM_OE_RMA_LINES
1260: where rma_header_id = p_source_document_id AND
1261: rma_line_id = p_source_document_line_id;
1262:

Line 2030: p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE ,

2026: WHERE header_id = cp_rma_header_id;
2027:
2028: -- get the details from JAI_OM_WSH_LINES_ALL table
2029: CURSOR cur_get_picking_lines(
2030: p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE ,
2031: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE
2032: )
2033: IS
2034: SELECT

Line 2031: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE

2027:
2028: -- get the details from JAI_OM_WSH_LINES_ALL table
2029: CURSOR cur_get_picking_lines(
2030: p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE ,
2031: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE
2032: )
2033: IS
2034: SELECT
2035: pl.inventory_item_id inventory_item_id ,

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

2055: from JAI_OM_OE_SO_LINES
2056: where line_id=v_reference_line_id;
2057:
2058:
2059: CURSOR cur_rma_entry_line_exists ( p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
2060: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE
2061: )
2062: IS
2063: SELECT

Line 2060: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE

2056: where line_id=v_reference_line_id;
2057:
2058:
2059: CURSOR cur_rma_entry_line_exists ( p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
2060: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE
2061: )
2062: IS
2063: SELECT
2064: 'X'

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

2171: regime_code = jai_constants.vat_regime
2172: AND tax_type = cp_tax_type;
2173:
2174: /*Added by Bgowrava for Bug#6126581 */
2175: 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
2176: select delivery_detail_id from JAI_OM_OE_RMA_LINES
2177: where rma_header_id = p_source_document_id AND
2178: rma_line_id = p_source_document_line_id;
2179:

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

2871: /*
2872: Added by aiyer for the bug # #2798930.
2873: Get the rma trax lines detail from the table JAI_OM_OE_RMA_TAXES
2874: */
2875: CURSOR cur_get_JAI_OM_OE_RMA_TAXES (p_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE)
2876: IS
2877: SELECT
2878: tax_line_no ,
2879: tax_id ,

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

2903: /*
2904: Added by aiyer for the bug # #2798930.
2905: code to check whether a record exists in the table JAI_OM_OE_SO_TAXES for a given line_id and tax_id.
2906: */
2907: CURSOR cur_chk_tax_lines_exists ( p_line_id1 OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
2908: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE
2909: )
2910: IS
2911: SELECT

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

4183:
4184: -- Added by Aparajita for writing onto the log file
4185: IF v_debug = 'Y' THEN
4186: -- log start of trigger
4187: 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'));
4188: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
4189: utl_file.fclose(v_myfilehandle);
4190: END IF; -- v_debug
4191:

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

4196: IF v_debug = 'Y' THEN
4197: -- log start of trigger
4198: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
4199: utl_file.put_line(v_myfilehandle,'Error :' || SQLERRM );
4200: 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'));
4201: utl_file.fclose(v_myfilehandle);
4202: END IF; -- v_debug
4203:
4204: --RAISE_APPLICATION_ERROR(-20002, 'ERROR - TRIGGER JA_IN_OE_ORDER_LINES_AIU_TRG : ' || SQLERRM);

Line 5119: oe_order_lines_all

5115: CURSOR cur_get_line_id IS
5116: SELECT
5117: line_id, inventory_item_id
5118: FROM
5119: oe_order_lines_all
5120: WHERE
5121: header_id = pr_new.Header_id
5122: and top_model_line_id = pr_new.top_model_line_id
5123: and item_type_code = 'CONFIG';

Line 5555: OE_ORDER_LINES_ALL

5551: IS
5552: SELECT
5553: ship_from_org_id, inventory_item_id
5554: FROM
5555: OE_ORDER_LINES_ALL
5556: WHERE header_id = pn_header_id
5557: AND line_id = pn_line_id;
5558: BEGIN
5559: OPEN Get_model_line_dtls_cur;

Line 5658: FROM OE_ORDER_LINES_ALL

5654: CURSOR cur_get_model_line_dtls (cp_header_id IN NUMBER,
5655: cp_line_id IN NUMBER)
5656: IS
5657: SELECT ship_from_org_id, inventory_item_id
5658: FROM OE_ORDER_LINES_ALL
5659: WHERE header_id = cp_header_id
5660: AND line_id = cp_line_id;
5661: */
5662:

Line 5712: * The firing table is on OE_ORDER_LINES_ALL. The firing table accessing in the

5708: CLOSE cur_chk_item_dtls;
5709:
5710: IF nvl(ln_item_exists,0) <> 1 THEN
5711: /* Commented out the below section of code by Eric Ma for bug 9768133 on Jun-02
5712: * The firing table is on OE_ORDER_LINES_ALL. The firing table accessing in the
5713: * trigger in the enven of UPDATING will cause table mutating error. So use an
5714: * AUTONOMOUS transaction to resolve the issue.
5715: */
5716:

Line 5758: 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.

5754:
5755:
5756: /*
5757: This code has been added by aiyer for the fix of the bug #2855855
5758: 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.
5759: IF yes then
5760: 1. pick up the delivery_detail_id from the wsh_delivery_details table for records corresponding to the reference_header_id and
5761: reference_line_id in this table and populate the pr_new.attibute2 dff field
5762: 2.Set the pr_new.attribute3 = 'Y' and pr_new.attribute4 = 'Y'