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 4058: unit_standard_price,

4054: quantity_credited,
4055: quantity_invoiced,
4056: quantity_ordered,
4057: unit_selling_price,
4058: unit_standard_price,
4059: revenue_amount,
4060: extended_amount,
4061: memo_line_id,
4062: inventory_item_id,

Line 4191: p_line_rec.unit_standard_price,

4187: p_line_rec.quantity_credited,
4188: p_line_rec.quantity_invoiced,
4189: p_line_rec.quantity_ordered,
4190: p_line_rec.unit_selling_price,
4191: p_line_rec.unit_standard_price,
4192: l_revenue_amount,
4193: p_line_rec.extended_amount,
4194: p_line_rec.memo_line_id,
4195: p_line_rec.inventory_item_id,

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

4303: p_line_rec.br_ref_payment_schedule_id,
4304: p_line_rec.br_adjustment_id,
4305: p_line_rec.wh_update_date,
4306: p_line_rec.payment_set_id,
4307: arp_standard.sysparm.org_id, /* SSA changes */
4308: p_line_rec.ship_to_customer_id,
4309: p_line_rec.ship_to_site_use_id,
4310: p_line_rec.ship_to_contact_id,
4311: p_line_rec.tax_classification_code,

Line 4640: IF (p_new_line_rec.unit_standard_price = AR_NUMBER_DUMMY)

4636: ELSE p_out_line_rec.unit_selling_price :=
4637: p_new_line_rec.unit_selling_price;
4638: END IF;
4639:
4640: IF (p_new_line_rec.unit_standard_price = AR_NUMBER_DUMMY)
4641: THEN p_out_line_rec.unit_standard_price :=
4642: p_old_line_rec.unit_standard_price;
4643: ELSE p_out_line_rec.unit_standard_price :=
4644: p_new_line_rec.unit_standard_price;

Line 4641: THEN p_out_line_rec.unit_standard_price :=

4637: p_new_line_rec.unit_selling_price;
4638: END IF;
4639:
4640: IF (p_new_line_rec.unit_standard_price = AR_NUMBER_DUMMY)
4641: THEN p_out_line_rec.unit_standard_price :=
4642: p_old_line_rec.unit_standard_price;
4643: ELSE p_out_line_rec.unit_standard_price :=
4644: p_new_line_rec.unit_standard_price;
4645: END IF;

Line 4642: p_old_line_rec.unit_standard_price;

4638: END IF;
4639:
4640: IF (p_new_line_rec.unit_standard_price = AR_NUMBER_DUMMY)
4641: THEN p_out_line_rec.unit_standard_price :=
4642: p_old_line_rec.unit_standard_price;
4643: ELSE p_out_line_rec.unit_standard_price :=
4644: p_new_line_rec.unit_standard_price;
4645: END IF;
4646:

Line 4643: ELSE p_out_line_rec.unit_standard_price :=

4639:
4640: IF (p_new_line_rec.unit_standard_price = AR_NUMBER_DUMMY)
4641: THEN p_out_line_rec.unit_standard_price :=
4642: p_old_line_rec.unit_standard_price;
4643: ELSE p_out_line_rec.unit_standard_price :=
4644: p_new_line_rec.unit_standard_price;
4645: END IF;
4646:
4647: IF (p_new_line_rec.revenue_amount = AR_NUMBER_DUMMY)

Line 4644: p_new_line_rec.unit_standard_price;

4640: IF (p_new_line_rec.unit_standard_price = AR_NUMBER_DUMMY)
4641: THEN p_out_line_rec.unit_standard_price :=
4642: p_old_line_rec.unit_standard_price;
4643: ELSE p_out_line_rec.unit_standard_price :=
4644: p_new_line_rec.unit_standard_price;
4645: END IF;
4646:
4647: IF (p_new_line_rec.revenue_amount = AR_NUMBER_DUMMY)
4648: THEN p_out_line_rec.revenue_amount := p_old_line_rec.revenue_amount;

Line 5513: inv_ctl.unit_standard_price,

5509: cm_ct.reason_code,
5510: inv_ctl.customer_trx_id,
5511: inv_ctl.customer_trx_line_id,
5512: cm_ctl.customer_trx_line_id,
5513: inv_ctl.unit_standard_price,
5514: inv_ctl.unit_selling_price,
5515: inv_ctl.gross_unit_selling_price, -- Bug 7389126 KALYAN
5516: inv_ctl.gross_extended_amount, -- 6882394
5517: inv_ctl.extended_amount, -- 6882394 (original)

Line 5645: l_trx_line_array.unit_standard_price,

5641: l_trx_line_array.reason_code,
5642: l_trx_line_array.previous_customer_trx_id,
5643: l_trx_line_array.previous_customer_trx_line_id,
5644: l_trx_line_array.link_to_cust_trx_line_id,
5645: l_trx_line_array.unit_standard_price,
5646: l_trx_line_array.unit_selling_price,
5647: l_trx_line_array.gross_unit_selling_price, -- Bug 7389126 KALYAN
5648: l_trx_line_array.gross_extended_amount, -- 6882394
5649: l_trx_line_array.original_extended_amount, -- 6882394

Line 5852: unit_standard_price,

5848: reason_code,
5849: previous_customer_trx_id,
5850: previous_customer_trx_line_id,
5851: link_to_cust_trx_line_id,
5852: unit_standard_price,
5853: unit_selling_price,
5854: gross_unit_selling_price, -- Bug 7389126 KALYAN
5855: quantity_credited,
5856: extended_amount,

Line 5906: l_trx_line_array.unit_standard_price(indx),

5902: l_trx_line_array.reason_code(indx),
5903: l_trx_line_array.previous_customer_trx_id(indx),
5904: l_trx_line_array.previous_customer_trx_line_id(indx),
5905: l_trx_line_array.link_to_cust_trx_line_id(indx),
5906: l_trx_line_array.unit_standard_price(indx),
5907: l_trx_line_array.unit_selling_price(indx),
5908: l_trx_line_array.gross_unit_selling_price(indx), -- Bug 7389126 KALYAN
5909: l_trx_line_array.quantity_credited(indx),
5910: l_trx_line_array.extended_amount(indx),