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.PO_DOCUMENT_UPDATE_PVT dependencies on PO_LINE_LOCATIONS_S

Line 162: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,

158:
159: PROCEDURE get_release_break_price (
160: p_line_location_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
161: p_quantity IN PO_LINE_LOCATIONS.quantity%TYPE,
162: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,
163: p_need_by_date IN PO_LINE_LOCATIONS.need_by_date%TYPE,
164: x_price OUT NOCOPY PO_LINES.unit_price%TYPE
165: );
166:

Line 171: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,

167: PROCEDURE get_po_break_price (
168: p_po_line_id IN PO_LINES.po_line_id%TYPE,
169: p_quantity IN PO_LINES.quantity%TYPE,
170: p_line_location_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
171: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,
172: p_need_by_date IN PO_LINE_LOCATIONS.need_by_date%TYPE,
173: x_price_break_id OUT NOCOPY PO_LINES.from_line_location_id%TYPE,
174: x_price OUT NOCOPY PO_LINES.unit_price%TYPE,
175: --

Line 2762: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;

2758: p_chg IN PO_CHANGES_REC_TYPE,
2759: i IN NUMBER
2760: ) RETURN BOOLEAN IS
2761: l_po_line_id PO_LINES.po_line_id%TYPE;
2762: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;
2763: l_ship_chg_i NUMBER;
2764: BEGIN
2765: -- Get the PO_LINE_ID and split shipment num for the i-th shipment change.
2766: l_po_line_id := p_chg.shipment_changes.c_po_line_id(i);

Line 2936: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;

2932: i IN NUMBER
2933: ) RETURN BOOLEAN IS
2934: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
2935: l_parent_line_loc_id PO_LINE_LOCATIONS.line_location_id%TYPE;
2936: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;
2937: l_dist_chg_i NUMBER;
2938: BEGIN
2939: l_line_location_id := p_chg.shipment_changes.po_line_location_id(i);
2940:

Line 3036: l_new_ship_to_loc_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;

3032: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
3033: l_new_price PO_LINE_LOCATIONS.price_override%TYPE;
3034: l_new_qty PO_LINE_LOCATIONS.quantity%TYPE;
3035: l_new_need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE;
3036: l_new_ship_to_loc_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
3037: l_price_break_id PO_LINES.from_line_location_id%TYPE;
3038: l_cur_uom2 PO_LINES.secondary_unit_of_measure%TYPE;
3039: l_derived_qty2 PO_LINES.secondary_quantity%TYPE;
3040: --

Line 4042: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,

4038: -------------------------------------------------------------------------------
4039: PROCEDURE get_release_break_price (
4040: p_line_location_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
4041: p_quantity IN PO_LINE_LOCATIONS.quantity%TYPE,
4042: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,
4043: p_need_by_date IN PO_LINE_LOCATIONS.need_by_date%TYPE,
4044: x_price OUT NOCOPY PO_LINES.unit_price%TYPE
4045: ) IS
4046: l_quantity PO_LINE_LOCATIONS.quantity%TYPE;

Line 4047: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;

4043: p_need_by_date IN PO_LINE_LOCATIONS.need_by_date%TYPE,
4044: x_price OUT NOCOPY PO_LINES.unit_price%TYPE
4045: ) IS
4046: l_quantity PO_LINE_LOCATIONS.quantity%TYPE;
4047: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
4048: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;
4049: l_need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE;
4050: l_po_line_id PO_LINE_LOCATIONS.po_line_id%TYPE;
4051: l_price_break_type PO_LINES.price_break_lookup_code %TYPE;

Line 4048: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;

4044: x_price OUT NOCOPY PO_LINES.unit_price%TYPE
4045: ) IS
4046: l_quantity PO_LINE_LOCATIONS.quantity%TYPE;
4047: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
4048: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;
4049: l_need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE;
4050: l_po_line_id PO_LINE_LOCATIONS.po_line_id%TYPE;
4051: l_price_break_type PO_LINES.price_break_lookup_code %TYPE;
4052: l_cumulative_flag BOOLEAN;

Line 4126: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,

4122: PROCEDURE get_po_break_price (
4123: p_po_line_id IN PO_LINES.po_line_id%TYPE,
4124: p_quantity IN PO_LINES.quantity%TYPE,
4125: p_line_location_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
4126: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,
4127: p_need_by_date IN PO_LINE_LOCATIONS.need_by_date%TYPE,
4128: x_price_break_id OUT NOCOPY PO_LINES.from_line_location_id%TYPE,
4129: x_price OUT NOCOPY PO_LINES.unit_price%TYPE,
4130: --

Line 4134: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;

4130: --
4131: x_base_unit_price OUT NOCOPY PO_LINES.base_unit_price%TYPE
4132: ) IS
4133: l_quantity PO_LINES.quantity%TYPE;
4134: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
4135: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;
4136: l_need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE;
4137: l_from_line_id PO_LINES.from_line_id%TYPE;
4138: l_return_status VARCHAR2(1);

Line 4135: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;

4131: x_base_unit_price OUT NOCOPY PO_LINES.base_unit_price%TYPE
4132: ) IS
4133: l_quantity PO_LINES.quantity%TYPE;
4134: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
4135: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;
4136: l_need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE;
4137: l_from_line_id PO_LINES.from_line_id%TYPE;
4138: l_return_status VARCHAR2(1);
4139:

Line 4712: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;

4708: l_new_line_qty_amt PO_LINES.quantity%TYPE;
4709: l_exist_ship_qty_amt PO_LINE_LOCATIONS.quantity%TYPE;
4710: l_new_ship_qty_amt PO_LINE_LOCATIONS.quantity%TYPE;
4711: l_cum_qty_amt PO_LINE_LOCATIONS.quantity%TYPE;
4712: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;
4713: l_exist_dist_qty PO_DISTRIBUTIONS.quantity_ordered%TYPE;
4714: l_exist_dist_amt PO_DISTRIBUTIONS.amount_ordered%TYPE;
4715: l_exist_dist_qty_amt PO_DISTRIBUTIONS.quantity_ordered%TYPE;
4716: l_new_dist_qty_amt PO_DISTRIBUTIONS.quantity_ordered%TYPE;

Line 5761: l_new_ship_to_loc_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;

5757: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;
5758: l_amt_received PO_LINE_LOCATIONS.amount_received%TYPE;
5759: l_amt_billed PO_LINE_LOCATIONS.amount_billed%TYPE;
5760: l_qty_shipped PO_LINE_LOCATIONS.quantity_shipped%TYPE;
5761: l_new_ship_to_loc_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
5762: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;
5763: l_new_promised_date PO_LINE_LOCATIONS.need_by_date%TYPE;
5764: l_new_need_by_date PO_LINE_LOCATIONS.promised_date%TYPE;
5765: l_approved_date PO_LINE_LOCATIONS.approved_date%TYPE;

Line 5762: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;

5758: l_amt_received PO_LINE_LOCATIONS.amount_received%TYPE;
5759: l_amt_billed PO_LINE_LOCATIONS.amount_billed%TYPE;
5760: l_qty_shipped PO_LINE_LOCATIONS.quantity_shipped%TYPE;
5761: l_new_ship_to_loc_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
5762: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;
5763: l_new_promised_date PO_LINE_LOCATIONS.need_by_date%TYPE;
5764: l_new_need_by_date PO_LINE_LOCATIONS.promised_date%TYPE;
5765: l_approved_date PO_LINE_LOCATIONS.approved_date%TYPE;
5766: l_encumbered_flag PO_LINE_LOCATIONS.encumbered_flag%TYPE;

Line 5767: l_shipment_type PO_LINE_LOCATIONS.shipment_type%TYPE;

5763: l_new_promised_date PO_LINE_LOCATIONS.need_by_date%TYPE;
5764: l_new_need_by_date PO_LINE_LOCATIONS.promised_date%TYPE;
5765: l_approved_date PO_LINE_LOCATIONS.approved_date%TYPE;
5766: l_encumbered_flag PO_LINE_LOCATIONS.encumbered_flag%TYPE;
5767: l_shipment_type PO_LINE_LOCATIONS.shipment_type%TYPE;
5768: l_pending_rcv_transactions NUMBER;
5769: l_allow_price_override PO_LINES.allow_price_override_flag%TYPE;
5770: l_ship_to_loc_valid NUMBER;
5771: l_message_name VARCHAR2(30);

Line 5772: l_new_sales_order_update_date PO_LINE_LOCATIONS.sales_order_update_date%TYPE;

5768: l_pending_rcv_transactions NUMBER;
5769: l_allow_price_override PO_LINES.allow_price_override_flag%TYPE;
5770: l_ship_to_loc_valid NUMBER;
5771: l_message_name VARCHAR2(30);
5772: l_new_sales_order_update_date PO_LINE_LOCATIONS.sales_order_update_date%TYPE;
5773:
5774: l_is_split_shipment BOOLEAN;
5775: l_is_drop_ship BOOLEAN;
5776: l_last_msg_list_index NUMBER;

Line 5783: l_new_secondary_qty PO_LINE_LOCATIONS.SECONDARY_QUANTITY%TYPE; -- INVCONV

5779: l_retroactive_price_change VARCHAR2(1);
5780:
5781: l_grade MTL_GRADES.grade_code%TYPE ; -- sschinch INVCONV
5782: l_new_preferred_grade MTL_GRADES.grade_code%TYPE; -- INVCONV
5783: l_new_secondary_qty PO_LINE_LOCATIONS.SECONDARY_QUANTITY%TYPE; -- INVCONV
5784: l_orig_qty PO_LINE_LOCATIONS.quantity%TYPE; --
5785:
5786: BEGIN
5787: IF (g_fnd_debug = 'Y') THEN

Line 7233: SELECT PO_LINE_LOCATIONS_S.nextval

7229: p_chg.shipment_changes.parent_line_location_id(l_ship_chg_i);
7230:
7231: IF (l_parent_line_loc_id IS NOT NULL) THEN -- This is a split shipment.
7232: -- Generate a new LINE_LOCATION_ID from the sequence.
7233: SELECT PO_LINE_LOCATIONS_S.nextval
7234: INTO l_line_location_id
7235: FROM dual;
7236:
7237: -- Update the split shipment change with the new LINE_LOCATION_ID.

Line 8687: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE

8683: FUNCTION get_split_ship_change (
8684: p_chg IN PO_CHANGES_REC_TYPE,
8685: p_po_line_id IN PO_LINES.po_line_id%TYPE,
8686: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
8687: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
8688: ) RETURN NUMBER IS
8689: l_ship_chg_i NUMBER;
8690: BEGIN
8691: -- Loop through the split shipment changes.

Line 8728: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE

8724: FUNCTION get_split_dist_change (
8725: p_chg IN PO_CHANGES_REC_TYPE,
8726: p_parent_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE,
8727: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
8728: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
8729: ) RETURN NUMBER IS
8730: l_dist_chg_i NUMBER;
8731: BEGIN
8732: -- Loop through the split distribution changes.

Line 8770: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE

8766: FUNCTION find_split_dist_change (
8767: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
8768: p_parent_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE,
8769: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
8770: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
8771: ) RETURN NUMBER IS
8772: i NUMBER;
8773: BEGIN
8774: i := get_split_dist_change(p_chg, p_parent_distribution_id,