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_HEADERS

Line 104: l_order_number oe_order_headers.order_number%type;

100: l_err_num VARCHAR2(30) := '';
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:

Line 107: l_org_id oe_order_headers.org_id%type;

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:
110: CURSOR C_ORDER
111: IS

Line 116: FROM OE_ORDER_HEADERS_ALL OH,

112: SELECT OH.ORDER_NUMBER ,
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:

Line 346: l_order_number oe_order_headers.order_number%type;

342: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_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;

Line 348: l_sold_to_org_id oe_order_headers.sold_to_org_id%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;
352: l_currency_code VARCHAR2(15);

Line 349: l_sold_to_contact_id oe_order_headers.sold_to_contact_id%type;

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;
352: l_currency_code VARCHAR2(15);
353: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;

Line 350: l_order_type_id oe_order_headers.order_type_id%type;

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;
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;

Line 362: l_ship_to_org_id oe_order_headers.ship_to_org_id%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;
366: l_ship_from_org_id oe_order_headers.ship_from_org_id%type;

Line 364: l_salesrep_id oe_order_headers.salesrep_id%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:
368: /*Bug 2360833 */

Line 365: l_sold_from_org_id oe_order_headers.sold_from_org_id%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:
368: /*Bug 2360833 */
369: l_invoice_to_org_id oe_order_headers.invoice_to_org_id%type;

Line 366: l_ship_from_org_id oe_order_headers.ship_from_org_id%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:
368: /*Bug 2360833 */
369: l_invoice_to_org_id oe_order_headers.invoice_to_org_id%type;
370: --l_ship_to_org_id oe_order_headers.ship_to_org_id%type;

Line 369: l_invoice_to_org_id oe_order_headers.invoice_to_org_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:
368: /*Bug 2360833 */
369: l_invoice_to_org_id oe_order_headers.invoice_to_org_id%type;
370: --l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
371: l_agreement_id oe_order_headers.agreement_id%type;
372: --l_ship_to_contact_id oe_order_headers.ship_to_contact_id%type;
373: l_invoice_to_contact_id oe_order_headers.invoice_to_contact_id%type;

Line 370: --l_ship_to_org_id oe_order_headers.ship_to_org_id%type;

366: l_ship_from_org_id oe_order_headers.ship_from_org_id%type;
367:
368: /*Bug 2360833 */
369: l_invoice_to_org_id oe_order_headers.invoice_to_org_id%type;
370: --l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
371: l_agreement_id oe_order_headers.agreement_id%type;
372: --l_ship_to_contact_id oe_order_headers.ship_to_contact_id%type;
373: l_invoice_to_contact_id oe_order_headers.invoice_to_contact_id%type;
374: l_payment_type_code oe_order_headers.payment_type_code%type;

Line 371: l_agreement_id oe_order_headers.agreement_id%type;

367:
368: /*Bug 2360833 */
369: l_invoice_to_org_id oe_order_headers.invoice_to_org_id%type;
370: --l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
371: l_agreement_id oe_order_headers.agreement_id%type;
372: --l_ship_to_contact_id oe_order_headers.ship_to_contact_id%type;
373: l_invoice_to_contact_id oe_order_headers.invoice_to_contact_id%type;
374: l_payment_type_code oe_order_headers.payment_type_code%type;
375: l_credit_card_code oe_order_headers.credit_card_code%type;

Line 372: --l_ship_to_contact_id oe_order_headers.ship_to_contact_id%type;

368: /*Bug 2360833 */
369: l_invoice_to_org_id oe_order_headers.invoice_to_org_id%type;
370: --l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
371: l_agreement_id oe_order_headers.agreement_id%type;
372: --l_ship_to_contact_id oe_order_headers.ship_to_contact_id%type;
373: l_invoice_to_contact_id oe_order_headers.invoice_to_contact_id%type;
374: l_payment_type_code oe_order_headers.payment_type_code%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;

Line 373: l_invoice_to_contact_id oe_order_headers.invoice_to_contact_id%type;

369: l_invoice_to_org_id oe_order_headers.invoice_to_org_id%type;
370: --l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
371: l_agreement_id oe_order_headers.agreement_id%type;
372: --l_ship_to_contact_id oe_order_headers.ship_to_contact_id%type;
373: l_invoice_to_contact_id oe_order_headers.invoice_to_contact_id%type;
374: l_payment_type_code oe_order_headers.payment_type_code%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;

Line 374: l_payment_type_code oe_order_headers.payment_type_code%type;

370: --l_ship_to_org_id oe_order_headers.ship_to_org_id%type;
371: l_agreement_id oe_order_headers.agreement_id%type;
372: --l_ship_to_contact_id oe_order_headers.ship_to_contact_id%type;
373: l_invoice_to_contact_id oe_order_headers.invoice_to_contact_id%type;
374: l_payment_type_code oe_order_headers.payment_type_code%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;

Line 375: l_credit_card_code oe_order_headers.credit_card_code%type;

371: l_agreement_id oe_order_headers.agreement_id%type;
372: --l_ship_to_contact_id oe_order_headers.ship_to_contact_id%type;
373: l_invoice_to_contact_id oe_order_headers.invoice_to_contact_id%type;
374: l_payment_type_code oe_order_headers.payment_type_code%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;

Line 376: l_cc_holder_name oe_order_headers.credit_card_holder_name%type;

372: --l_ship_to_contact_id oe_order_headers.ship_to_contact_id%type;
373: l_invoice_to_contact_id oe_order_headers.invoice_to_contact_id%type;
374: l_payment_type_code oe_order_headers.payment_type_code%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;

Line 377: l_cc_number oe_order_headers.credit_card_number%type;

373: l_invoice_to_contact_id oe_order_headers.invoice_to_contact_id%type;
374: l_payment_type_code oe_order_headers.payment_type_code%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;

Line 378: l_cc_expiration_date oe_order_headers.credit_card_expiration_date%type;

374: l_payment_type_code oe_order_headers.payment_type_code%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 */

Line 380: l_check_number oe_order_headers.check_number%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:
384: l_line_type_id oe_order_lines.line_type_id%type;

Line 381: l_payment_amount oe_order_headers.payment_amount%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:
384: l_line_type_id oe_order_lines.line_type_id%type;
385: l_err_num VARCHAR2(30) := '';

Line 391: l_org_id oe_order_headers.org_id%type;

387: l_order_exception EXCEPTION; -- added for bug #1657510
388: l_count number;
389:
390: v Varchar2(30);
391: l_org_id oe_order_headers.org_id%type;
392:
393: CURSOR C_ORDER
394: IS
395: SELECT OH.ORDER_NUMBER ,

Line 433: FROM OE_ORDER_HEADERS_ALL OH,

429: oh.ship_to_contact_id ,
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:

Line 767: l_order_number oe_order_headers.order_number%type;

763: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_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

Line 769: l_sold_to_org_id oe_order_headers.sold_to_org_id%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;
773: l_currency_code VARCHAR2(15);

Line 770: l_sold_to_contact_id oe_order_headers.sold_to_contact_id%type;

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;
773: l_currency_code VARCHAR2(15);
774: l_accounting_rule_id oe_order_lines.accounting_rule_id%type;

Line 771: l_order_type_id oe_order_headers.order_type_id%type := 1193; --revisit later

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;
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;

Line 783: l_ship_to_org_id oe_order_headers.ship_to_org_id%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;
787: l_ship_from_org_id oe_order_headers.ship_from_org_id%type;

Line 785: l_salesrep_id oe_order_headers.salesrep_id%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;
789: l_err_num VARCHAR2(30) := '';

Line 786: l_sold_from_org_id oe_order_headers.sold_from_org_id%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;
789: l_err_num VARCHAR2(30) := '';
790: l_err_msg VARCHAR2(1000) := '';

Line 787: l_ship_from_org_id oe_order_headers.ship_from_org_id%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;
789: l_err_num VARCHAR2(30) := '';
790: l_err_msg VARCHAR2(1000) := '';
791:

Line 794: l_org_id oe_order_headers.org_id%type;

790: l_err_msg VARCHAR2(1000) := '';
791:
792: v Varchar2(30);
793: l_order_exception EXCEPTION;
794: l_org_id oe_order_headers.org_id%type;
795:
796: BEGIN
797: hr_utility.set_location('Entering:'||l_proc, 5);
798: hr_utility.set_location('Entering:'||l_proc, 10);