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 160: DELETE FROM PO_LINE_LOCATIONS_ALL /Bug6632095: using base table instead of view /

156: end if; /* X_type_lookup_code not in RFQ and QUOTATION */
157:
158: -- Delete the shipments.
159: BEGIN
160: DELETE FROM PO_LINE_LOCATIONS_ALL /*Bug6632095: using base table instead of view */
161: WHERE po_header_id = X_delete_id
162: AND shipment_type in ('PLANNED', 'STANDARD', 'PRICE BREAK',
163: 'RFQ', 'QUOTATION')
164: --

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

917: ,p_doc_type IN VARCHAR2
918: ,p_style_disp_name IN VARCHAR2
919: ,x_message_text OUT NOCOPY VARCHAR2) IS
920: l_some_dists_reserved_flag VARCHAR2(1) := 'N';
921: l_approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE := NULL;
922: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;
923: l_dummy NUMBER := 0;
924: d_pos NUMBER := 0;
925: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_line_loc';

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

918: ,p_style_disp_name IN VARCHAR2
919: ,x_message_text OUT NOCOPY VARCHAR2) IS
920: l_some_dists_reserved_flag VARCHAR2(1) := 'N';
921: l_approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE := NULL;
922: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;
923: l_dummy NUMBER := 0;
924: d_pos NUMBER := 0;
925: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_line_loc';
926: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SHIPMENTS_SV4.validate_delete_line_loc';

Line 937: FROM po_line_locations_all

933: SELECT shipment_type,
934: approved_flag
935: INTO l_shipment_type,
936: l_approved_flag
937: FROM po_line_locations_all
938: WHERE line_location_id = p_line_loc_id;
939:
940: d_pos := 10;
941: IF (PO_LOG.d_stmt) THEN

Line 981: FROM po_line_locations_all

977: -- to delete the shipment
978: BEGIN
979: SELECT line_location_id
980: INTO l_dummy
981: FROM po_line_locations_all
982: WHERE po_line_id = p_po_line_id
983: AND nvl(closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN) <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
984: AND nvl(cancel_flag, 'N') <> 'Y';
985:

Line 1021: -- PO_LINE_LOCATIONS_ALL

1017: -- Before calling this procedure one must call validate_delete_line_loc
1018: -- to ensure that deletion of the line location is a valid action
1019: --Modifies:
1020: -- PO_LINES_ALL
1021: -- PO_LINE_LOCATIONS_ALL
1022: --Locks:
1023: -- None
1024: --Function:
1025: -- Deletes the selected Line Location from the Database and

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

1064: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1065: l_po_lines_rec PO_LINES_ALL%ROWTYPE;
1066: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;
1067: l_from_line_location_id PO_LINES_ALL.from_line_location_id%TYPE := NULL;
1068: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;
1069: l_ga_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE := NULL;
1070: l_ga_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE := NULL;
1071: l_is_source_info_changed BOOLEAN := FALSE;
1072: l_price NUMBER := NULL;

Line 1088: FROM po_line_locations_all

1084: d_pos := 10;
1085: --get the required data of shipment's header and line
1086: SELECT shipment_type
1087: INTO l_shipment_type
1088: FROM po_line_locations_all
1089: WHERE line_location_id = p_line_loc_id;
1090:
1091: d_pos := 20;
1092: po_shipments_sv4.delete_shipment(p_line_loc_id,

Line 1260: UPDATE po_line_locations_all

1256:
1257: END IF; --l_is_source_info_changed
1258: d_pos := 140;
1259: -- For this line, update all its corresponding shipment records
1260: UPDATE po_line_locations_all
1261: SET price_override = l_price,
1262: last_update_date = SYSDATE,
1263: last_updated_by = fnd_global.user_id
1264: WHERE po_line_id = l_po_lines_rec.po_line_id;