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_SHIPMENTS_SV4 dependencies on PO_LINE_LOCATIONS_ALL

Line 23: TYPE l_shipment_type IS TABLE OF PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;

19: x_original_quantity NUMBER := '';
20: x_shipment_type VARCHAR2(15) :=''; --1560839
21:
22: --
23: TYPE l_shipment_type IS TABLE OF PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;
24: l_shipment_type_tbl l_shipment_type;
25: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
26: l_return_status VARCHAR2(1);
27: l_msg_count NUMBER;

Line 37: FROM po_line_locations_all /Bug6632095: using base table instead of view /

33: --
34:
35: CURSOR C_LINE is
36: SELECT line_location_id
37: FROM po_line_locations_all /*Bug6632095: using base table instead of view */
38: WHERE po_line_id = X_delete_id;
39:
40: CURSOR C_RELEASE is
41: SELECT line_location_id,

Line 44: FROM po_line_locations_all /Bug6632095: using base table instead of view /

40: CURSOR C_RELEASE is
41: SELECT line_location_id,
42: po_line_id,
43: quantity
44: FROM po_line_locations_all /*Bug6632095: using base table instead of view */
45: WHERE po_release_id = X_delete_id;
46:
47: CURSOR C_HEADER is
48: SELECT line_location_id

Line 49: FROM po_line_locations_all /Bug6632095: using base table instead of view /

45: WHERE po_release_id = X_delete_id;
46:
47: CURSOR C_HEADER is
48: SELECT line_location_id
49: FROM po_line_locations_all /*Bug6632095: using base table instead of view */
50: WHERE po_header_id = X_delete_id;
51:
52: BEGIN
53:

Line 167: DELETE FROM PO_LINE_LOCATIONS_ALL /Bug6632095: using base table instead of view /

163: end if; /* X_type_lookup_code not in RFQ and QUOTATION */
164:
165: -- Delete the shipments.
166: BEGIN
167: DELETE FROM PO_LINE_LOCATIONS_ALL /*Bug6632095: using base table instead of view */
168: WHERE po_header_id = X_delete_id
169: AND shipment_type in ('PLANNED', 'STANDARD', 'PRICE BREAK',
170: 'RFQ', 'QUOTATION')
171: --

Line 941: l_approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE := NULL;

937: ,p_doc_type IN VARCHAR2
938: ,p_style_disp_name IN VARCHAR2
939: ,x_message_text OUT NOCOPY VARCHAR2) IS
940: l_some_dists_reserved_flag VARCHAR2(1) := 'N';
941: l_approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE := NULL;
942: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;
943: l_dummy NUMBER := 0;
944: d_pos NUMBER := 0;
945: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_line_loc';

Line 942: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;

938: ,p_style_disp_name IN VARCHAR2
939: ,x_message_text OUT NOCOPY VARCHAR2) IS
940: l_some_dists_reserved_flag VARCHAR2(1) := 'N';
941: l_approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE := NULL;
942: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;
943: l_dummy NUMBER := 0;
944: d_pos NUMBER := 0;
945: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_line_loc';
946: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SHIPMENTS_SV4.validate_delete_line_loc';

Line 957: FROM po_line_locations_all

953: SELECT shipment_type,
954: approved_flag
955: INTO l_shipment_type,
956: l_approved_flag
957: FROM po_line_locations_all
958: WHERE line_location_id = p_line_loc_id;
959:
960: d_pos := 10;
961: IF (PO_LOG.d_stmt) THEN

Line 1001: FROM po_line_locations_all

997: -- to delete the shipment
998: BEGIN
999: SELECT line_location_id
1000: INTO l_dummy
1001: FROM po_line_locations_all
1002: WHERE po_line_id = p_po_line_id
1003: AND nvl(closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN) <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
1004: AND nvl(cancel_flag, 'N') <> 'Y';
1005:

Line 1041: -- PO_LINE_LOCATIONS_ALL

1037: -- Before calling this procedure one must call validate_delete_line_loc
1038: -- to ensure that deletion of the line location is a valid action
1039: --Modifies:
1040: -- PO_LINES_ALL
1041: -- PO_LINE_LOCATIONS_ALL
1042: --Locks:
1043: -- None
1044: --Function:
1045: -- Deletes the selected Line Location from the Database and

Line 1088: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;

1084: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1085: l_po_lines_rec PO_LINES_ALL%ROWTYPE;
1086: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;
1087: l_from_line_location_id PO_LINES_ALL.from_line_location_id%TYPE := NULL;
1088: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;
1089: l_ga_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE := NULL;
1090: l_ga_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE := NULL;
1091: l_is_source_info_changed BOOLEAN := FALSE;
1092: l_price NUMBER := NULL;

Line 1108: FROM po_line_locations_all

1104: d_pos := 10;
1105: --get the required data of shipment's header and line
1106: SELECT shipment_type
1107: INTO l_shipment_type
1108: FROM po_line_locations_all
1109: WHERE line_location_id = p_line_loc_id;
1110:
1111: d_pos := 20;
1112: po_shipments_sv4.delete_shipment(p_line_loc_id,

Line 1280: UPDATE po_line_locations_all

1276:
1277: END IF; --l_is_source_info_changed
1278: d_pos := 140;
1279: -- For this line, update all its corresponding shipment records
1280: UPDATE po_line_locations_all
1281: SET price_override = l_price,
1282: last_update_date = SYSDATE,
1283: last_updated_by = fnd_global.user_id
1284: WHERE po_line_id = l_po_lines_rec.po_line_id;