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.ARP_CTL_PKG dependencies on STANDARD

Line 57: unit_standard_price DBMS_SQL.NUMBER_TABLE,

53: reason_code DBMS_SQL.VARCHAR2_TABLE,
54: previous_customer_trx_id DBMS_SQL.NUMBER_TABLE,
55: previous_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
56: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE,
57: unit_standard_price DBMS_SQL.NUMBER_TABLE,
58: unit_selling_price DBMS_SQL.NUMBER_TABLE,
59: gross_unit_selling_price DBMS_SQL.NUMBER_TABLE,-- Bug 7389126 KALYAN
60: gross_extended_amount DBMS_SQL.NUMBER_TABLE, -- 6882394
61: original_extended_amount DBMS_SQL.NUMBER_TABLE,-- 6882394

Line 363: dbms_sql.bind_variable(p_update_cursor, ':unit_standard_price',

359:
360: dbms_sql.bind_variable(p_update_cursor, ':unit_selling_price',
361: p_line_rec.unit_selling_price);
362:
363: dbms_sql.bind_variable(p_update_cursor, ':unit_standard_price',
364: p_line_rec.unit_standard_price);
365:
366: dbms_sql.bind_variable(p_update_cursor, ':revenue_amount',
367: p_line_rec.revenue_amount);

Line 364: p_line_rec.unit_standard_price);

360: dbms_sql.bind_variable(p_update_cursor, ':unit_selling_price',
361: p_line_rec.unit_selling_price);
362:
363: dbms_sql.bind_variable(p_update_cursor, ':unit_standard_price',
364: p_line_rec.unit_standard_price);
365:
366: dbms_sql.bind_variable(p_update_cursor, ':revenue_amount',
367: p_line_rec.revenue_amount);
368:

Line 836: unit_standard_price =

832: unit_selling_price =
833: DECODE(:unit_selling_price,
834: :ar_number_dummy, unit_selling_price,
835: :unit_selling_price),
836: unit_standard_price =
837: DECODE(:unit_standard_price,
838: :ar_number_dummy, unit_standard_price,
839: :unit_standard_price),
840: revenue_amount =

Line 837: DECODE(:unit_standard_price,

833: DECODE(:unit_selling_price,
834: :ar_number_dummy, unit_selling_price,
835: :unit_selling_price),
836: unit_standard_price =
837: DECODE(:unit_standard_price,
838: :ar_number_dummy, unit_standard_price,
839: :unit_standard_price),
840: revenue_amount =
841: DECODE(:revenue_amount,

Line 838: :ar_number_dummy, unit_standard_price,

834: :ar_number_dummy, unit_selling_price,
835: :unit_selling_price),
836: unit_standard_price =
837: DECODE(:unit_standard_price,
838: :ar_number_dummy, unit_standard_price,
839: :unit_standard_price),
840: revenue_amount =
841: DECODE(:revenue_amount,
842: :ar_number_dummy,

Line 839: :unit_standard_price),

835: :unit_selling_price),
836: unit_standard_price =
837: DECODE(:unit_standard_price,
838: :ar_number_dummy, unit_standard_price,
839: :unit_standard_price),
840: revenue_amount =
841: DECODE(:revenue_amount,
842: :ar_number_dummy,
843: /* IF the line type is LINE

Line 1589: p_line_rec.unit_standard_price := AR_NUMBER_DUMMY;

1585: p_line_rec.quantity_credited := AR_NUMBER_DUMMY;
1586: p_line_rec.quantity_invoiced := AR_NUMBER_DUMMY;
1587: p_line_rec.quantity_ordered := AR_NUMBER_DUMMY;
1588: p_line_rec.unit_selling_price := AR_NUMBER_DUMMY;
1589: p_line_rec.unit_standard_price := AR_NUMBER_DUMMY;
1590: p_line_rec.revenue_amount := AR_NUMBER_DUMMY;
1591: p_line_rec.extended_amount := AR_NUMBER_DUMMY;
1592: p_line_rec.memo_line_id := AR_NUMBER_DUMMY;
1593: p_line_rec.inventory_item_id := AR_NUMBER_DUMMY;

Line 2121: NVL(ctl.unit_standard_price, AR_NUMBER_DUMMY) =

2117: p_line_rec.unit_selling_price),
2118: AR_NUMBER_DUMMY
2119: )
2120: AND
2121: NVL(ctl.unit_standard_price, AR_NUMBER_DUMMY) =
2122: NVL(
2123: DECODE(p_line_rec.unit_standard_price,
2124: AR_NUMBER_DUMMY, ctl.unit_standard_price,
2125: p_line_rec.unit_standard_price),

Line 2123: DECODE(p_line_rec.unit_standard_price,

2119: )
2120: AND
2121: NVL(ctl.unit_standard_price, AR_NUMBER_DUMMY) =
2122: NVL(
2123: DECODE(p_line_rec.unit_standard_price,
2124: AR_NUMBER_DUMMY, ctl.unit_standard_price,
2125: p_line_rec.unit_standard_price),
2126: AR_NUMBER_DUMMY
2127: )

Line 2124: AR_NUMBER_DUMMY, ctl.unit_standard_price,

2120: AND
2121: NVL(ctl.unit_standard_price, AR_NUMBER_DUMMY) =
2122: NVL(
2123: DECODE(p_line_rec.unit_standard_price,
2124: AR_NUMBER_DUMMY, ctl.unit_standard_price,
2125: p_line_rec.unit_standard_price),
2126: AR_NUMBER_DUMMY
2127: )
2128: AND

Line 2125: p_line_rec.unit_standard_price),

2121: NVL(ctl.unit_standard_price, AR_NUMBER_DUMMY) =
2122: NVL(
2123: DECODE(p_line_rec.unit_standard_price,
2124: AR_NUMBER_DUMMY, ctl.unit_standard_price,
2125: p_line_rec.unit_standard_price),
2126: AR_NUMBER_DUMMY
2127: )
2128: AND
2129: NVL(ctl.revenue_amount, AR_NUMBER_DUMMY) =

Line 4036: unit_standard_price,

4032: quantity_credited,
4033: quantity_invoiced,
4034: quantity_ordered,
4035: unit_selling_price,
4036: unit_standard_price,
4037: revenue_amount,
4038: extended_amount,
4039: memo_line_id,
4040: inventory_item_id,

Line 4169: p_line_rec.unit_standard_price,

4165: p_line_rec.quantity_credited,
4166: p_line_rec.quantity_invoiced,
4167: p_line_rec.quantity_ordered,
4168: p_line_rec.unit_selling_price,
4169: p_line_rec.unit_standard_price,
4170: l_revenue_amount,
4171: p_line_rec.extended_amount,
4172: p_line_rec.memo_line_id,
4173: p_line_rec.inventory_item_id,

Line 4285: arp_standard.sysparm.org_id, /* SSA changes */

4281: p_line_rec.br_ref_payment_schedule_id,
4282: p_line_rec.br_adjustment_id,
4283: p_line_rec.wh_update_date,
4284: p_line_rec.payment_set_id,
4285: arp_standard.sysparm.org_id, /* SSA changes */
4286: p_line_rec.ship_to_customer_id,
4287: p_line_rec.ship_to_site_use_id,
4288: p_line_rec.ship_to_contact_id,
4289: p_line_rec.tax_classification_code,

Line 4618: IF (p_new_line_rec.unit_standard_price = AR_NUMBER_DUMMY)

4614: ELSE p_out_line_rec.unit_selling_price :=
4615: p_new_line_rec.unit_selling_price;
4616: END IF;
4617:
4618: IF (p_new_line_rec.unit_standard_price = AR_NUMBER_DUMMY)
4619: THEN p_out_line_rec.unit_standard_price :=
4620: p_old_line_rec.unit_standard_price;
4621: ELSE p_out_line_rec.unit_standard_price :=
4622: p_new_line_rec.unit_standard_price;

Line 4619: THEN p_out_line_rec.unit_standard_price :=

4615: p_new_line_rec.unit_selling_price;
4616: END IF;
4617:
4618: IF (p_new_line_rec.unit_standard_price = AR_NUMBER_DUMMY)
4619: THEN p_out_line_rec.unit_standard_price :=
4620: p_old_line_rec.unit_standard_price;
4621: ELSE p_out_line_rec.unit_standard_price :=
4622: p_new_line_rec.unit_standard_price;
4623: END IF;

Line 4620: p_old_line_rec.unit_standard_price;

4616: END IF;
4617:
4618: IF (p_new_line_rec.unit_standard_price = AR_NUMBER_DUMMY)
4619: THEN p_out_line_rec.unit_standard_price :=
4620: p_old_line_rec.unit_standard_price;
4621: ELSE p_out_line_rec.unit_standard_price :=
4622: p_new_line_rec.unit_standard_price;
4623: END IF;
4624:

Line 4621: ELSE p_out_line_rec.unit_standard_price :=

4617:
4618: IF (p_new_line_rec.unit_standard_price = AR_NUMBER_DUMMY)
4619: THEN p_out_line_rec.unit_standard_price :=
4620: p_old_line_rec.unit_standard_price;
4621: ELSE p_out_line_rec.unit_standard_price :=
4622: p_new_line_rec.unit_standard_price;
4623: END IF;
4624:
4625: IF (p_new_line_rec.revenue_amount = AR_NUMBER_DUMMY)

Line 4622: p_new_line_rec.unit_standard_price;

4618: IF (p_new_line_rec.unit_standard_price = AR_NUMBER_DUMMY)
4619: THEN p_out_line_rec.unit_standard_price :=
4620: p_old_line_rec.unit_standard_price;
4621: ELSE p_out_line_rec.unit_standard_price :=
4622: p_new_line_rec.unit_standard_price;
4623: END IF;
4624:
4625: IF (p_new_line_rec.revenue_amount = AR_NUMBER_DUMMY)
4626: THEN p_out_line_rec.revenue_amount := p_old_line_rec.revenue_amount;

Line 5486: a.unit_standard_price,

5482: a.reason_code,
5483: a.previous_customer_trx_id,
5484: a.previous_customer_trx_line_id,
5485: a.link_to_cust_trx_line_id,
5486: a.unit_standard_price,
5487: a.unit_selling_price,
5488: a.gross_unit_selling_price, -- Bug 7389126 KALYAN
5489: a.gross_extended_amount, -- 6882394
5490: a.original_extended_amount, -- 6882394 (original)

Line 5545: l_trx_line_array.unit_standard_price,

5541: l_trx_line_array.reason_code,
5542: l_trx_line_array.previous_customer_trx_id,
5543: l_trx_line_array.previous_customer_trx_line_id,
5544: l_trx_line_array.link_to_cust_trx_line_id,
5545: l_trx_line_array.unit_standard_price,
5546: l_trx_line_array.unit_selling_price,
5547: l_trx_line_array.gross_unit_selling_price, -- Bug 7389126 KALYAN
5548: l_trx_line_array.gross_extended_amount, -- 6882394
5549: l_trx_line_array.original_extended_amount, -- 6882394

Line 5610: inv_ctl.unit_standard_price,

5606: cm_ct.reason_code,
5607: inv_ctl.customer_trx_id previous_customer_trx_id,
5608: inv_ctl.customer_trx_line_id previous_customer_trx_line_id,
5609: cm_ctl.customer_trx_line_id link_to_cust_trx_line_id,
5610: inv_ctl.unit_standard_price,
5611: inv_ctl.unit_selling_price,
5612: inv_ctl.gross_unit_selling_price, -- Bug 7389126 KALYAN
5613: inv_ctl.gross_extended_amount, -- 6882394
5614: inv_ctl.extended_amount original_extended_amount, -- 6882394 (original)

Line 5940: unit_standard_price,

5936: reason_code,
5937: previous_customer_trx_id,
5938: previous_customer_trx_line_id,
5939: link_to_cust_trx_line_id,
5940: unit_standard_price,
5941: unit_selling_price,
5942: gross_unit_selling_price, -- Bug 7389126 KALYAN
5943: quantity_credited,
5944: extended_amount,

Line 5994: l_trx_line_array.unit_standard_price(indx),

5990: l_trx_line_array.reason_code(indx),
5991: l_trx_line_array.previous_customer_trx_id(indx),
5992: l_trx_line_array.previous_customer_trx_line_id(indx),
5993: l_trx_line_array.link_to_cust_trx_line_id(indx),
5994: l_trx_line_array.unit_standard_price(indx),
5995: l_trx_line_array.unit_selling_price(indx),
5996: l_trx_line_array.gross_unit_selling_price(indx), -- Bug 7389126 KALYAN
5997: l_trx_line_array.quantity_credited(indx),
5998: l_trx_line_array.extended_amount(indx),