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.OTA_OM_UPD_API dependencies on OE_ORDER_LINES

Line 39: l_Line_id oe_order_lines.Line_Id%type;

35: p_org_id IN NUMBER)
36:
37: IS
38:
39: l_Line_id oe_order_lines.Line_Id%type;
40: l_header_id oe_order_lines.header_id%type;
41: l_control_rec OE_GLOBALS.Control_Rec_Type:=
42: OE_GLOBALS.G_MISS_CONTROL_REC;
43:

Line 40: l_header_id oe_order_lines.header_id%type;

36:
37: IS
38:
39: l_Line_id oe_order_lines.Line_Id%type;
40: l_header_id oe_order_lines.header_id%type;
41: l_control_rec OE_GLOBALS.Control_Rec_Type:=
42: OE_GLOBALS.G_MISS_CONTROL_REC;
43:
44: --Declare all local variable.

Line 105: l_ordered_quantity oe_order_lines.ordered_quantity%type;

101: l_err_msg VARCHAR2(1000) := '';
102: l_order_exception exception; -- added for bug #1657510
103:
104: l_order_number oe_order_headers.order_number%type;
105: l_ordered_quantity oe_order_lines.ordered_quantity%type;
106: l_caller_source varchar2(30); -- Bug 2707198
107: l_org_id oe_order_headers.org_id%type;
108:
109:

Line 117: OE_ORDER_LINES_ALL OL

113: OH.HEADER_ID,
114: OH.ORG_ID,
115: OL.ordered_quantity
116: FROM OE_ORDER_HEADERS_ALL OH,
117: OE_ORDER_LINES_ALL OL
118: WHERE OH.HEADER_ID = OL.HEADER_ID AND
119: OL.LINE_ID = p_line_id;
120:
121:

Line 286: l_Line_id oe_order_lines.Line_Id%type;

282: IS
283:
284: l_proc varchar2(72) := g_package||'create_rma';
285:
286: l_Line_id oe_order_lines.Line_Id%type;
287: l_header_id oe_order_lines.header_id%type;
288: l_control_rec OE_GLOBALS.Control_Rec_Type ;
289:
290: --Declare all local variable.

Line 287: l_header_id oe_order_lines.header_id%type;

283:
284: l_proc varchar2(72) := g_package||'create_rma';
285:
286: l_Line_id oe_order_lines.Line_Id%type;
287: l_header_id oe_order_lines.header_id%type;
288: l_control_rec OE_GLOBALS.Control_Rec_Type ;
289:
290: --Declare all local variable.
291: l_api_version_number CONSTANT NUMBER := 1.0;

Line 347: l_ordered_quantity oe_order_lines.ordered_quantity%type;

343: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
344:
345: l_message_data varchar2(2000);
346: l_order_number oe_order_headers.order_number%type;
347: l_ordered_quantity oe_order_lines.ordered_quantity%type;
348: l_sold_to_org_id oe_order_headers.sold_to_org_id%type;
349: l_sold_to_contact_id oe_order_headers.sold_to_contact_id%type;
350: l_order_type_id oe_order_headers.order_type_id%type;
351: l_invoicing_rule_id oe_order_lines.invoicing_rule_id%type;

Line 351: l_invoicing_rule_id oe_order_lines.invoicing_rule_id%type;

347: l_ordered_quantity oe_order_lines.ordered_quantity%type;
348: l_sold_to_org_id oe_order_headers.sold_to_org_id%type;
349: l_sold_to_contact_id oe_order_headers.sold_to_contact_id%type;
350: l_order_type_id oe_order_headers.order_type_id%type;
351: l_invoicing_rule_id oe_order_lines.invoicing_rule_id%type;
352: l_currency_code VARCHAR2(15);
353: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;
354: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
355: l_price_list_id oe_order_lines.price_list_id%type;

Line 353: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;

349: l_sold_to_contact_id oe_order_headers.sold_to_contact_id%type;
350: l_order_type_id oe_order_headers.order_type_id%type;
351: l_invoicing_rule_id oe_order_lines.invoicing_rule_id%type;
352: l_currency_code VARCHAR2(15);
353: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;
354: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
355: l_price_list_id oe_order_lines.price_list_id%type;
356: l_ordered_item_id oe_order_lines.ordered_item_id%type;
357: l_ordered_item oe_order_lines.ordered_item%type;

Line 354: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;

350: l_order_type_id oe_order_headers.order_type_id%type;
351: l_invoicing_rule_id oe_order_lines.invoicing_rule_id%type;
352: l_currency_code VARCHAR2(15);
353: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;
354: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
355: l_price_list_id oe_order_lines.price_list_id%type;
356: l_ordered_item_id oe_order_lines.ordered_item_id%type;
357: l_ordered_item oe_order_lines.ordered_item%type;
358: l_inventory_item_id oe_order_lines.inventory_item_id%type;

Line 355: l_price_list_id oe_order_lines.price_list_id%type;

351: l_invoicing_rule_id oe_order_lines.invoicing_rule_id%type;
352: l_currency_code VARCHAR2(15);
353: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;
354: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
355: l_price_list_id oe_order_lines.price_list_id%type;
356: l_ordered_item_id oe_order_lines.ordered_item_id%type;
357: l_ordered_item oe_order_lines.ordered_item%type;
358: l_inventory_item_id oe_order_lines.inventory_item_id%type;
359: l_item_identifier_type oe_order_lines.item_identifier_type%type;

Line 356: l_ordered_item_id oe_order_lines.ordered_item_id%type;

352: l_currency_code VARCHAR2(15);
353: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;
354: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
355: l_price_list_id oe_order_lines.price_list_id%type;
356: l_ordered_item_id oe_order_lines.ordered_item_id%type;
357: l_ordered_item oe_order_lines.ordered_item%type;
358: l_inventory_item_id oe_order_lines.inventory_item_id%type;
359: l_item_identifier_type oe_order_lines.item_identifier_type%type;
360: l_unit_list_price oe_order_lines.unit_list_price%type;

Line 357: l_ordered_item oe_order_lines.ordered_item%type;

353: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;
354: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
355: l_price_list_id oe_order_lines.price_list_id%type;
356: l_ordered_item_id oe_order_lines.ordered_item_id%type;
357: l_ordered_item oe_order_lines.ordered_item%type;
358: l_inventory_item_id oe_order_lines.inventory_item_id%type;
359: l_item_identifier_type oe_order_lines.item_identifier_type%type;
360: l_unit_list_price oe_order_lines.unit_list_price%type;
361: l_unit_selling_price oe_order_lines.unit_selling_price%type;

Line 358: l_inventory_item_id oe_order_lines.inventory_item_id%type;

354: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
355: l_price_list_id oe_order_lines.price_list_id%type;
356: l_ordered_item_id oe_order_lines.ordered_item_id%type;
357: l_ordered_item oe_order_lines.ordered_item%type;
358: l_inventory_item_id oe_order_lines.inventory_item_id%type;
359: l_item_identifier_type oe_order_lines.item_identifier_type%type;
360: l_unit_list_price oe_order_lines.unit_list_price%type;
361: l_unit_selling_price oe_order_lines.unit_selling_price%type;
362: l_ship_to_org_id oe_order_headers.ship_to_org_id%type;

Line 359: l_item_identifier_type oe_order_lines.item_identifier_type%type;

355: l_price_list_id oe_order_lines.price_list_id%type;
356: l_ordered_item_id oe_order_lines.ordered_item_id%type;
357: l_ordered_item oe_order_lines.ordered_item%type;
358: l_inventory_item_id oe_order_lines.inventory_item_id%type;
359: l_item_identifier_type oe_order_lines.item_identifier_type%type;
360: l_unit_list_price oe_order_lines.unit_list_price%type;
361: l_unit_selling_price oe_order_lines.unit_selling_price%type;
362: l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
363: l_ship_to_contact_id oe_order_lines.ship_to_contact_id%type;

Line 360: l_unit_list_price oe_order_lines.unit_list_price%type;

356: l_ordered_item_id oe_order_lines.ordered_item_id%type;
357: l_ordered_item oe_order_lines.ordered_item%type;
358: l_inventory_item_id oe_order_lines.inventory_item_id%type;
359: l_item_identifier_type oe_order_lines.item_identifier_type%type;
360: l_unit_list_price oe_order_lines.unit_list_price%type;
361: l_unit_selling_price oe_order_lines.unit_selling_price%type;
362: l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
363: l_ship_to_contact_id oe_order_lines.ship_to_contact_id%type;
364: l_salesrep_id oe_order_headers.salesrep_id%type;

Line 361: l_unit_selling_price oe_order_lines.unit_selling_price%type;

357: l_ordered_item oe_order_lines.ordered_item%type;
358: l_inventory_item_id oe_order_lines.inventory_item_id%type;
359: l_item_identifier_type oe_order_lines.item_identifier_type%type;
360: l_unit_list_price oe_order_lines.unit_list_price%type;
361: l_unit_selling_price oe_order_lines.unit_selling_price%type;
362: l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
363: l_ship_to_contact_id oe_order_lines.ship_to_contact_id%type;
364: l_salesrep_id oe_order_headers.salesrep_id%type;
365: l_sold_from_org_id oe_order_headers.sold_from_org_id%type;

Line 363: l_ship_to_contact_id oe_order_lines.ship_to_contact_id%type;

359: l_item_identifier_type oe_order_lines.item_identifier_type%type;
360: l_unit_list_price oe_order_lines.unit_list_price%type;
361: l_unit_selling_price oe_order_lines.unit_selling_price%type;
362: l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
363: l_ship_to_contact_id oe_order_lines.ship_to_contact_id%type;
364: l_salesrep_id oe_order_headers.salesrep_id%type;
365: l_sold_from_org_id oe_order_headers.sold_from_org_id%type;
366: l_ship_from_org_id oe_order_headers.ship_from_org_id%type;
367:

Line 379: l_commitment_id oe_order_lines.commitment_id%type;

375: l_credit_card_code oe_order_headers.credit_card_code%type;
376: l_cc_holder_name oe_order_headers.credit_card_holder_name%type;
377: l_cc_number oe_order_headers.credit_card_number%type;
378: l_cc_expiration_date oe_order_headers.credit_card_expiration_date%type;
379: l_commitment_id oe_order_lines.commitment_id%type;
380: l_check_number oe_order_headers.check_number%type;
381: l_payment_amount oe_order_headers.payment_amount%type;
382: /*Bug 2360833 */
383:

Line 384: l_line_type_id oe_order_lines.line_type_id%type;

380: l_check_number oe_order_headers.check_number%type;
381: l_payment_amount oe_order_headers.payment_amount%type;
382: /*Bug 2360833 */
383:
384: l_line_type_id oe_order_lines.line_type_id%type;
385: l_err_num VARCHAR2(30) := '';
386: l_err_msg VARCHAR2(1000) := '';
387: l_order_exception EXCEPTION; -- added for bug #1657510
388: l_count number;

Line 434: OE_ORDER_LINES_ALL OL

430: ol.line_type_id,
431: ol.commitment_id,
432: oh.org_id
433: FROM OE_ORDER_HEADERS_ALL OH,
434: OE_ORDER_LINES_ALL OL
435: WHERE OH.HEADER_ID = OL.HEADER_ID AND
436: OL.LINE_ID = p_line_id;
437:
438:

Line 442: Select count(*)into l_count from oe_order_lines_all

438:
439: BEGIN
440: hr_utility.set_location('Entering:'||l_proc, 5);
441:
442: Select count(*)into l_count from oe_order_lines_all
443: where reference_line_id = p_line_id;
444: if l_count = 0 then
445:
446: OPEN C_ORDER;

Line 707: l_Line_id oe_order_lines.Line_Id%type;

703: IS
704:
705: l_proc varchar2(72) := g_package||'create_order';
706:
707: l_Line_id oe_order_lines.Line_Id%type;
708: l_header_id oe_order_lines.header_id%type;
709: l_control_rec OE_GLOBALS.Control_Rec_Type ;
710:
711: --Declare all local variable.

Line 708: l_header_id oe_order_lines.header_id%type;

704:
705: l_proc varchar2(72) := g_package||'create_order';
706:
707: l_Line_id oe_order_lines.Line_Id%type;
708: l_header_id oe_order_lines.header_id%type;
709: l_control_rec OE_GLOBALS.Control_Rec_Type ;
710:
711: --Declare all local variable.
712: l_api_version_number CONSTANT NUMBER := 1.0;

Line 768: l_ordered_quantity oe_order_lines.ordered_quantity%type;

764: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
765:
766: l_message_data varchar2(2000);
767: l_order_number oe_order_headers.order_number%type;
768: l_ordered_quantity oe_order_lines.ordered_quantity%type;
769: l_sold_to_org_id oe_order_headers.sold_to_org_id%type;
770: l_sold_to_contact_id oe_order_headers.sold_to_contact_id%type;
771: l_order_type_id oe_order_headers.order_type_id%type := 1193; --revisit later
772: l_invoicing_rule_id oe_order_lines.invoicing_rule_id%type;

Line 772: l_invoicing_rule_id oe_order_lines.invoicing_rule_id%type;

768: l_ordered_quantity oe_order_lines.ordered_quantity%type;
769: l_sold_to_org_id oe_order_headers.sold_to_org_id%type;
770: l_sold_to_contact_id oe_order_headers.sold_to_contact_id%type;
771: l_order_type_id oe_order_headers.order_type_id%type := 1193; --revisit later
772: l_invoicing_rule_id oe_order_lines.invoicing_rule_id%type;
773: l_currency_code VARCHAR2(15);
774: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;
775: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
776: l_price_list_id oe_order_lines.price_list_id%type;

Line 774: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;

770: l_sold_to_contact_id oe_order_headers.sold_to_contact_id%type;
771: l_order_type_id oe_order_headers.order_type_id%type := 1193; --revisit later
772: l_invoicing_rule_id oe_order_lines.invoicing_rule_id%type;
773: l_currency_code VARCHAR2(15);
774: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;
775: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
776: l_price_list_id oe_order_lines.price_list_id%type;
777: l_ordered_item_id oe_order_lines.ordered_item_id%type;
778: l_ordered_item oe_order_lines.ordered_item%type;

Line 775: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;

771: l_order_type_id oe_order_headers.order_type_id%type := 1193; --revisit later
772: l_invoicing_rule_id oe_order_lines.invoicing_rule_id%type;
773: l_currency_code VARCHAR2(15);
774: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;
775: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
776: l_price_list_id oe_order_lines.price_list_id%type;
777: l_ordered_item_id oe_order_lines.ordered_item_id%type;
778: l_ordered_item oe_order_lines.ordered_item%type;
779: l_inventory_item_id oe_order_lines.inventory_item_id%type;

Line 776: l_price_list_id oe_order_lines.price_list_id%type;

772: l_invoicing_rule_id oe_order_lines.invoicing_rule_id%type;
773: l_currency_code VARCHAR2(15);
774: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;
775: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
776: l_price_list_id oe_order_lines.price_list_id%type;
777: l_ordered_item_id oe_order_lines.ordered_item_id%type;
778: l_ordered_item oe_order_lines.ordered_item%type;
779: l_inventory_item_id oe_order_lines.inventory_item_id%type;
780: l_item_identifier_type oe_order_lines.item_identifier_type%type;

Line 777: l_ordered_item_id oe_order_lines.ordered_item_id%type;

773: l_currency_code VARCHAR2(15);
774: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;
775: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
776: l_price_list_id oe_order_lines.price_list_id%type;
777: l_ordered_item_id oe_order_lines.ordered_item_id%type;
778: l_ordered_item oe_order_lines.ordered_item%type;
779: l_inventory_item_id oe_order_lines.inventory_item_id%type;
780: l_item_identifier_type oe_order_lines.item_identifier_type%type;
781: l_unit_list_price oe_order_lines.unit_list_price%type;

Line 778: l_ordered_item oe_order_lines.ordered_item%type;

774: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;
775: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
776: l_price_list_id oe_order_lines.price_list_id%type;
777: l_ordered_item_id oe_order_lines.ordered_item_id%type;
778: l_ordered_item oe_order_lines.ordered_item%type;
779: l_inventory_item_id oe_order_lines.inventory_item_id%type;
780: l_item_identifier_type oe_order_lines.item_identifier_type%type;
781: l_unit_list_price oe_order_lines.unit_list_price%type;
782: l_unit_selling_price oe_order_lines.unit_selling_price%type;

Line 779: l_inventory_item_id oe_order_lines.inventory_item_id%type;

775: l_ordered_quantity_uom oe_order_lines.order_quantity_uom%type;
776: l_price_list_id oe_order_lines.price_list_id%type;
777: l_ordered_item_id oe_order_lines.ordered_item_id%type;
778: l_ordered_item oe_order_lines.ordered_item%type;
779: l_inventory_item_id oe_order_lines.inventory_item_id%type;
780: l_item_identifier_type oe_order_lines.item_identifier_type%type;
781: l_unit_list_price oe_order_lines.unit_list_price%type;
782: l_unit_selling_price oe_order_lines.unit_selling_price%type;
783: l_ship_to_org_id oe_order_headers.ship_to_org_id%type;

Line 780: l_item_identifier_type oe_order_lines.item_identifier_type%type;

776: l_price_list_id oe_order_lines.price_list_id%type;
777: l_ordered_item_id oe_order_lines.ordered_item_id%type;
778: l_ordered_item oe_order_lines.ordered_item%type;
779: l_inventory_item_id oe_order_lines.inventory_item_id%type;
780: l_item_identifier_type oe_order_lines.item_identifier_type%type;
781: l_unit_list_price oe_order_lines.unit_list_price%type;
782: l_unit_selling_price oe_order_lines.unit_selling_price%type;
783: l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
784: l_ship_to_contact_id oe_order_lines.ship_to_contact_id%type;

Line 781: l_unit_list_price oe_order_lines.unit_list_price%type;

777: l_ordered_item_id oe_order_lines.ordered_item_id%type;
778: l_ordered_item oe_order_lines.ordered_item%type;
779: l_inventory_item_id oe_order_lines.inventory_item_id%type;
780: l_item_identifier_type oe_order_lines.item_identifier_type%type;
781: l_unit_list_price oe_order_lines.unit_list_price%type;
782: l_unit_selling_price oe_order_lines.unit_selling_price%type;
783: l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
784: l_ship_to_contact_id oe_order_lines.ship_to_contact_id%type;
785: l_salesrep_id oe_order_headers.salesrep_id%type;

Line 782: l_unit_selling_price oe_order_lines.unit_selling_price%type;

778: l_ordered_item oe_order_lines.ordered_item%type;
779: l_inventory_item_id oe_order_lines.inventory_item_id%type;
780: l_item_identifier_type oe_order_lines.item_identifier_type%type;
781: l_unit_list_price oe_order_lines.unit_list_price%type;
782: l_unit_selling_price oe_order_lines.unit_selling_price%type;
783: l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
784: l_ship_to_contact_id oe_order_lines.ship_to_contact_id%type;
785: l_salesrep_id oe_order_headers.salesrep_id%type;
786: l_sold_from_org_id oe_order_headers.sold_from_org_id%type;

Line 784: l_ship_to_contact_id oe_order_lines.ship_to_contact_id%type;

780: l_item_identifier_type oe_order_lines.item_identifier_type%type;
781: l_unit_list_price oe_order_lines.unit_list_price%type;
782: l_unit_selling_price oe_order_lines.unit_selling_price%type;
783: l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
784: l_ship_to_contact_id oe_order_lines.ship_to_contact_id%type;
785: l_salesrep_id oe_order_headers.salesrep_id%type;
786: l_sold_from_org_id oe_order_headers.sold_from_org_id%type;
787: l_ship_from_org_id oe_order_headers.ship_from_org_id%type;
788: l_line_type_id oe_order_lines.line_type_id%type;

Line 788: l_line_type_id oe_order_lines.line_type_id%type;

784: l_ship_to_contact_id oe_order_lines.ship_to_contact_id%type;
785: l_salesrep_id oe_order_headers.salesrep_id%type;
786: l_sold_from_org_id oe_order_headers.sold_from_org_id%type;
787: l_ship_from_org_id oe_order_headers.ship_from_org_id%type;
788: l_line_type_id oe_order_lines.line_type_id%type;
789: l_err_num VARCHAR2(30) := '';
790: l_err_msg VARCHAR2(1000) := '';
791:
792: v Varchar2(30);