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 158: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,

154:
155: PROCEDURE get_release_break_price (
156: p_line_location_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
157: p_quantity IN PO_LINE_LOCATIONS.quantity%TYPE,
158: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,
159: p_need_by_date IN PO_LINE_LOCATIONS.need_by_date%TYPE,
160: x_price OUT NOCOPY PO_LINES.unit_price%TYPE
161: );
162:

Line 167: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,

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

Line 2739: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;

2735: p_chg IN PO_CHANGES_REC_TYPE,
2736: i IN NUMBER
2737: ) RETURN BOOLEAN IS
2738: l_po_line_id PO_LINES.po_line_id%TYPE;
2739: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;
2740: l_ship_chg_i NUMBER;
2741: BEGIN
2742: -- Get the PO_LINE_ID and split shipment num for the i-th shipment change.
2743: l_po_line_id := p_chg.shipment_changes.c_po_line_id(i);

Line 2913: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;

2909: i IN NUMBER
2910: ) RETURN BOOLEAN IS
2911: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
2912: l_parent_line_loc_id PO_LINE_LOCATIONS.line_location_id%TYPE;
2913: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;
2914: l_dist_chg_i NUMBER;
2915: BEGIN
2916: l_line_location_id := p_chg.shipment_changes.po_line_location_id(i);
2917:

Line 3013: l_new_ship_to_loc_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;

3009: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
3010: l_new_price PO_LINE_LOCATIONS.price_override%TYPE;
3011: l_new_qty PO_LINE_LOCATIONS.quantity%TYPE;
3012: l_new_need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE;
3013: l_new_ship_to_loc_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
3014: l_price_break_id PO_LINES.from_line_location_id%TYPE;
3015: l_cur_uom2 PO_LINES.secondary_unit_of_measure%TYPE;
3016: l_derived_qty2 PO_LINES.secondary_quantity%TYPE;
3017: --

Line 4005: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,

4001: -------------------------------------------------------------------------------
4002: PROCEDURE get_release_break_price (
4003: p_line_location_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
4004: p_quantity IN PO_LINE_LOCATIONS.quantity%TYPE,
4005: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,
4006: p_need_by_date IN PO_LINE_LOCATIONS.need_by_date%TYPE,
4007: x_price OUT NOCOPY PO_LINES.unit_price%TYPE
4008: ) IS
4009: l_quantity PO_LINE_LOCATIONS.quantity%TYPE;

Line 4010: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;

4006: p_need_by_date IN PO_LINE_LOCATIONS.need_by_date%TYPE,
4007: x_price OUT NOCOPY PO_LINES.unit_price%TYPE
4008: ) IS
4009: l_quantity PO_LINE_LOCATIONS.quantity%TYPE;
4010: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
4011: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;
4012: l_need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE;
4013: l_po_line_id PO_LINE_LOCATIONS.po_line_id%TYPE;
4014: l_price_break_type PO_LINES.price_break_lookup_code %TYPE;

Line 4011: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;

4007: x_price OUT NOCOPY PO_LINES.unit_price%TYPE
4008: ) IS
4009: l_quantity PO_LINE_LOCATIONS.quantity%TYPE;
4010: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
4011: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;
4012: l_need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE;
4013: l_po_line_id PO_LINE_LOCATIONS.po_line_id%TYPE;
4014: l_price_break_type PO_LINES.price_break_lookup_code %TYPE;
4015: l_cumulative_flag BOOLEAN;

Line 4089: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,

4085: PROCEDURE get_po_break_price (
4086: p_po_line_id IN PO_LINES.po_line_id%TYPE,
4087: p_quantity IN PO_LINES.quantity%TYPE,
4088: p_line_location_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
4089: p_ship_to_location_id IN PO_LINE_LOCATIONS.ship_to_location_id%TYPE,
4090: p_need_by_date IN PO_LINE_LOCATIONS.need_by_date%TYPE,
4091: x_price_break_id OUT NOCOPY PO_LINES.from_line_location_id%TYPE,
4092: x_price OUT NOCOPY PO_LINES.unit_price%TYPE,
4093: --

Line 4097: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;

4093: --
4094: x_base_unit_price OUT NOCOPY PO_LINES.base_unit_price%TYPE
4095: ) IS
4096: l_quantity PO_LINES.quantity%TYPE;
4097: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
4098: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;
4099: l_need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE;
4100: l_from_line_id PO_LINES.from_line_id%TYPE;
4101: l_return_status VARCHAR2(1);

Line 4098: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;

4094: x_base_unit_price OUT NOCOPY PO_LINES.base_unit_price%TYPE
4095: ) IS
4096: l_quantity PO_LINES.quantity%TYPE;
4097: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
4098: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;
4099: l_need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE;
4100: l_from_line_id PO_LINES.from_line_id%TYPE;
4101: l_return_status VARCHAR2(1);
4102:

Line 4675: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;

4671: l_new_line_qty_amt PO_LINES.quantity%TYPE;
4672: l_exist_ship_qty_amt PO_LINE_LOCATIONS.quantity%TYPE;
4673: l_new_ship_qty_amt PO_LINE_LOCATIONS.quantity%TYPE;
4674: l_cum_qty_amt PO_LINE_LOCATIONS.quantity%TYPE;
4675: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;
4676: l_exist_dist_qty PO_DISTRIBUTIONS.quantity_ordered%TYPE;
4677: l_exist_dist_amt PO_DISTRIBUTIONS.amount_ordered%TYPE;
4678: l_exist_dist_qty_amt PO_DISTRIBUTIONS.quantity_ordered%TYPE;
4679: l_new_dist_qty_amt PO_DISTRIBUTIONS.quantity_ordered%TYPE;

Line 5716: l_new_ship_to_loc_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;

5712: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;
5713: l_amt_received PO_LINE_LOCATIONS.amount_received%TYPE;
5714: l_amt_billed PO_LINE_LOCATIONS.amount_billed%TYPE;
5715: l_qty_shipped PO_LINE_LOCATIONS.quantity_shipped%TYPE;
5716: l_new_ship_to_loc_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
5717: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;
5718: l_new_promised_date PO_LINE_LOCATIONS.need_by_date%TYPE;
5719: l_new_need_by_date PO_LINE_LOCATIONS.promised_date%TYPE;
5720: l_approved_date PO_LINE_LOCATIONS.approved_date%TYPE;

Line 5717: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;

5713: l_amt_received PO_LINE_LOCATIONS.amount_received%TYPE;
5714: l_amt_billed PO_LINE_LOCATIONS.amount_billed%TYPE;
5715: l_qty_shipped PO_LINE_LOCATIONS.quantity_shipped%TYPE;
5716: l_new_ship_to_loc_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;
5717: l_ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE;
5718: l_new_promised_date PO_LINE_LOCATIONS.need_by_date%TYPE;
5719: l_new_need_by_date PO_LINE_LOCATIONS.promised_date%TYPE;
5720: l_approved_date PO_LINE_LOCATIONS.approved_date%TYPE;
5721: l_encumbered_flag PO_LINE_LOCATIONS.encumbered_flag%TYPE;

Line 5722: l_shipment_type PO_LINE_LOCATIONS.shipment_type%TYPE;

5718: l_new_promised_date PO_LINE_LOCATIONS.need_by_date%TYPE;
5719: l_new_need_by_date PO_LINE_LOCATIONS.promised_date%TYPE;
5720: l_approved_date PO_LINE_LOCATIONS.approved_date%TYPE;
5721: l_encumbered_flag PO_LINE_LOCATIONS.encumbered_flag%TYPE;
5722: l_shipment_type PO_LINE_LOCATIONS.shipment_type%TYPE;
5723: l_pending_rcv_transactions NUMBER;
5724: l_allow_price_override PO_LINES.allow_price_override_flag%TYPE;
5725: l_ship_to_loc_valid NUMBER;
5726: l_message_name VARCHAR2(30);

Line 5727: l_new_sales_order_update_date PO_LINE_LOCATIONS.sales_order_update_date%TYPE;

5723: l_pending_rcv_transactions NUMBER;
5724: l_allow_price_override PO_LINES.allow_price_override_flag%TYPE;
5725: l_ship_to_loc_valid NUMBER;
5726: l_message_name VARCHAR2(30);
5727: l_new_sales_order_update_date PO_LINE_LOCATIONS.sales_order_update_date%TYPE;
5728:
5729: l_is_split_shipment BOOLEAN;
5730: l_is_drop_ship BOOLEAN;
5731: l_last_msg_list_index NUMBER;

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

5734: l_retroactive_price_change VARCHAR2(1);
5735:
5736: l_grade MTL_GRADES.grade_code%TYPE ; -- sschinch INVCONV
5737: l_new_preferred_grade MTL_GRADES.grade_code%TYPE; -- INVCONV
5738: l_new_secondary_qty PO_LINE_LOCATIONS.SECONDARY_QUANTITY%TYPE; -- INVCONV
5739:
5740: BEGIN
5741: IF (g_fnd_debug = 'Y') THEN
5742: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 7121: SELECT PO_LINE_LOCATIONS_S.nextval

7117: p_chg.shipment_changes.parent_line_location_id(l_ship_chg_i);
7118:
7119: IF (l_parent_line_loc_id IS NOT NULL) THEN -- This is a split shipment.
7120: -- Generate a new LINE_LOCATION_ID from the sequence.
7121: SELECT PO_LINE_LOCATIONS_S.nextval
7122: INTO l_line_location_id
7123: FROM dual;
7124:
7125: -- Update the split shipment change with the new LINE_LOCATION_ID.

Line 8552: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE

8548: FUNCTION get_split_ship_change (
8549: p_chg IN PO_CHANGES_REC_TYPE,
8550: p_po_line_id IN PO_LINES.po_line_id%TYPE,
8551: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
8552: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
8553: ) RETURN NUMBER IS
8554: l_ship_chg_i NUMBER;
8555: BEGIN
8556: -- Loop through the split shipment changes.

Line 8593: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE

8589: FUNCTION get_split_dist_change (
8590: p_chg IN PO_CHANGES_REC_TYPE,
8591: p_parent_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE,
8592: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
8593: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
8594: ) RETURN NUMBER IS
8595: l_dist_chg_i NUMBER;
8596: BEGIN
8597: -- Loop through the split distribution changes.

Line 8635: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE

8631: FUNCTION find_split_dist_change (
8632: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
8633: p_parent_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE,
8634: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
8635: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
8636: ) RETURN NUMBER IS
8637: i NUMBER;
8638: BEGIN
8639: i := get_split_dist_change(p_chg, p_parent_distribution_id,