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.WSH_DOCUMENT_PVT dependencies on WSH_DOCUMENT_INSTANCES

Line 175: l_entity_name wsh_document_instances.entity_name%type;

171: FUNCTION Init_Entity_Name ( p_document_type IN VARCHAR2
172: , p_entity_name IN VARCHAR2 )
173: RETURN VARCHAR2
174: IS
175: l_entity_name wsh_document_instances.entity_name%type;
176: --
177: l_debug_on BOOLEAN;
178: --
179: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INIT_ENTITY_NAME';

Line 639: FROM wsh_document_instances doc

635: -- if p_consolidate_option is CONSOLIDATE or BOTH, we need to check
636: -- the parent delivery first
637: SELECT doc.final_print_date
638: INTO l_temp_date
639: FROM wsh_document_instances doc
640: WHERE doc.entity_id=p_delivery_id
641: AND doc.entity_name='WSH_NEW_DELIVERIES'
642: AND doc.document_type=p_document_type;
643: IF l_temp_date IS NOT NULL

Line 734: -- PRE-CONDITIONS : FINAL_PRINT_DATE column of WSH_DOCUMENT_INSTANCES

730: -- x_msg_data message if there is only one message in stack
731: -- x_return_status API return status ('S', 'E', 'U')
732: --
733: --
734: -- PRE-CONDITIONS : FINAL_PRINT_DATE column of WSH_DOCUMENT_INSTANCES
735: -- rows of related deliveries have NULL value
736: -- POST-CONDITIONS : such FINAL_PRINT_DATE columns have SYSDATE value
737: -- EXCEPTIONS : None
738: ------------------------------------------------------------------------------

Line 811: wsh_document_instances doc

807: -- initialize l_temp_date to p_final_print_date
808: l_temp_date := p_final_print_date;
809:
810: UPDATE
811: wsh_document_instances doc
812: SET
813: doc.final_print_date = l_temp_date
814: WHERE doc.entity_id=p_delivery_id
815: AND doc.entity_name='WSH_NEW_DELIVERIES'

Line 1004: l_entity_name wsh_document_instances.entity_name%type;

1000: wsh_doc_sequence_categories.doc_sequence_category_id%type;
1001: l_document_number VARCHAR2(255);
1002: l_seq_return NUMBER;
1003: l_seq_type VARCHAR2(255);
1004: l_entity_name wsh_document_instances.entity_name%type;
1005: l_debug_msg VARCHAR2(32000);
1006: l_prefix VARCHAR2(10);
1007: l_suffix VARCHAR2(10);
1008: l_delivery_name VARCHAR2(30);

Line 1028: wsh_document_instances

1024: IS
1025: SELECT
1026: sequence_number
1027: FROM
1028: wsh_document_instances
1029: WHERE entity_name = c_entity_name
1030: AND entity_id = c_entity_id
1031: AND status <> 'CANCELLED'
1032: -- AND status = 'OPEN'

Line 1431: INSERT INTO wsh_document_instances

1427: -- delivery for consolidation purposes) will have a --
1428: -- delivery leg created before the Bill of Lading can --
1429: -- be created. --
1430: ---------------------------------------------------------
1431: INSERT INTO wsh_document_instances
1432: ( document_instance_id
1433: , document_type
1434: , sequence_number
1435: , status

Line 1467: ( wsh_document_instances_s.nextval

1463: , attribute14
1464: , attribute15
1465: )
1466: VALUES
1467: ( wsh_document_instances_s.nextval
1468: , p_document_type
1469: , l_document_number
1470: , l_status
1471: , null

Line 1589: INSERT INTO wsh_document_instances

1585: x_document_number := l_document_number;
1586:
1587: l_status := 'OPEN'; --bug # 3789154
1588:
1589: INSERT INTO wsh_document_instances
1590: ( document_instance_id
1591: , document_type
1592: , sequence_number
1593: , status

Line 1625: ( wsh_document_instances_s.nextval

1621: , attribute14
1622: , attribute15
1623: )
1624: VALUES
1625: ( wsh_document_instances_s.nextval
1626: , p_document_type
1627: , l_document_number
1628: , l_status --Bug# 3789154
1629: , null

Line 1856: l_entity_name wsh_document_instances.entity_name%type;

1852: l_delivery_id_tab delivery_id_tabtype := delivery_id_tabtype();
1853: l_delivery_id wsh_new_deliveries.delivery_id%type;
1854: l_delivery_leg_id wsh_delivery_legs.delivery_leg_id%type;
1855: l_table_count NUMBER;
1856: l_entity_name wsh_document_instances.entity_name%type;
1857:
1858: CURSOR old_values_csr (c_entity_name IN VARCHAR2, c_entity_id IN NUMBER) IS
1859:
1860: --Changed for BUG#3330869

Line 1864: wsh_document_instances

1860: --Changed for BUG#3330869
1861: SELECT status
1862: --SELECT *
1863: FROM
1864: wsh_document_instances
1865: WHERE entity_name = c_entity_name
1866: AND entity_id = c_entity_id
1867: AND document_type = p_document_type
1868: AND status not in ('COMPLETE', 'CANCELLED')

Line 2041: UPDATE wsh_document_instances

2037:
2038: -- need to change this update within loop to a bulk update later.
2039: -- probably use temporary tables with a join
2040:
2041: UPDATE wsh_document_instances
2042: SET
2043: last_update_date = sysdate
2044: , last_updated_by = fnd_global.user_id
2045: , last_update_login = fnd_global.login_id

Line 2172: l_entity_name wsh_document_instances.entity_name%type;

2168: L_API_NAME CONSTANT VARCHAR2(30) := 'WSH_Document_PVT';
2169: L_API_VERSION CONSTANT NUMBER := 1.0;
2170: l_delivery_id_tab delivery_id_tabtype := delivery_id_tabtype();
2171: l_table_count NUMBER;
2172: l_entity_name wsh_document_instances.entity_name%type;
2173: l_delivery_id wsh_new_deliveries.delivery_id%type;
2174: l_delivery_leg_id wsh_delivery_legs.delivery_leg_id%type;
2175:
2176:

Line 2189: wsh_document_instances

2185: SELECT
2186: entity_id
2187: , status
2188: FROM
2189: wsh_document_instances
2190: WHERE entity_name = c_entity_name
2191: AND entity_id = c_entity_id
2192: AND document_type = p_document_type
2193: AND status in ('OPEN', 'PLANNED')

Line 2356: UPDATE wsh_document_instances

2352: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2353: RAISE FND_API.G_EXC_ERROR;
2354: END IF;
2355:
2356: UPDATE wsh_document_instances
2357: SET status = 'CANCELLED'
2358: , last_update_date = sysdate
2359: , last_updated_by = fnd_global.user_id
2360: , last_update_login = fnd_global.login_id

Line 2371: UPDATE wsh_document_instances

2367: END IF;
2368:
2369: ELSIF l_entity_name = 'WSH_TRIPS' THEN
2370:
2371: UPDATE wsh_document_instances
2372: SET status = 'CANCELLED'
2373: , last_update_date = sysdate
2374: , last_updated_by = fnd_global.user_id
2375: , last_update_login = fnd_global.login_id

Line 2499: l_entity_name wsh_document_instances.entity_name%type;

2495: L_API_NAME CONSTANT VARCHAR2(30) := 'WSH_Document_PVT';
2496: L_API_VERSION CONSTANT NUMBER := 1.0;
2497: l_delivery_id_tab delivery_id_tabtype := delivery_id_tabtype();
2498: l_table_count NUMBER;
2499: l_entity_name wsh_document_instances.entity_name%type;
2500: l_delivery_id wsh_new_deliveries.delivery_id%type;
2501: l_delivery_leg_id wsh_delivery_legs.delivery_leg_id%type;
2502:
2503: CURSOR status_csr (c_entity_name IN VARCHAR2, c_entity_id IN NUMBER) IS

Line 2508: wsh_document_instances

2504: SELECT
2505: entity_id
2506: , status
2507: FROM
2508: wsh_document_instances
2509: WHERE entity_name = c_entity_name
2510: AND entity_id = c_entity_id
2511: AND document_type = p_document_type
2512: AND status = 'PLANNED'

Line 2672: UPDATE wsh_document_instances

2668: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2669: RAISE FND_API.G_EXC_ERROR;
2670: END IF;
2671:
2672: UPDATE wsh_document_instances
2673: SET status = 'OPEN'
2674: , last_update_date = sysdate
2675: , last_updated_by = fnd_global.user_id
2676: , last_update_login = fnd_global.login_id

Line 2803: l_entity_name wsh_document_instances.entity_name%type;

2799: L_API_NAME CONSTANT VARCHAR2(30) := 'WSH_Document_PVT';
2800: L_API_VERSION CONSTANT NUMBER := 1.0;
2801: l_delivery_id_tab delivery_id_tabtype := delivery_id_tabtype();
2802: l_table_count NUMBER;
2803: l_entity_name wsh_document_instances.entity_name%type;
2804: l_delivery_id wsh_new_deliveries.delivery_id%type;
2805: l_delivery_leg_id wsh_delivery_legs.delivery_leg_id%type;
2806:
2807: CURSOR status_csr (c_entity_name IN VARCHAR2, c_entity_id IN NUMBER) IS

Line 2812: wsh_document_instances

2808: SELECT
2809: entity_id
2810: , status
2811: FROM
2812: wsh_document_instances
2813: WHERE entity_name = c_entity_name
2814: AND entity_id = c_entity_id
2815: AND document_type = p_document_type
2816: AND status not in ('CANCELLED')

Line 2976: UPDATE wsh_document_instances

2972: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2973: RAISE FND_API.G_EXC_ERROR;
2974: END IF;
2975:
2976: UPDATE wsh_document_instances
2977: SET status = 'COMPLETE'
2978: , last_update_date = sysdate
2979: , last_updated_by = fnd_global.user_id
2980: , last_update_login = fnd_global.login_id

Line 3630: UPDATE wsh_document_instances

3626: -- initialize API return status to success
3627: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
3628:
3629:
3630: UPDATE wsh_document_instances
3631: SET status = 'CANCELLED'
3632: , last_update_date = sysdate
3633: , last_updated_by = fnd_global.user_id
3634: , last_update_login = fnd_global.login_id

Line 3782: FROM wsh_document_instances

3778: , attribute12
3779: , attribute13
3780: , attribute14
3781: , attribute15
3782: FROM wsh_document_instances
3783: WHERE entity_name = p_entity_name
3784: AND entity_id = p_entity_id;
3785:
3786: i NUMBER := 1; -- loop counter

Line 3956: -- p_rowid Rowid of wsh_document_instances table

3952: -- PARAMETER LIST :
3953: --
3954: -- IN
3955: --
3956: -- p_rowid Rowid of wsh_document_instances table
3957: -- p_document_instance_id document instance id
3958: -- p_document_type document type codes (PACK_TYPE, BOL, ASN etc.)
3959: -- p_sequence_number sequence number of the document
3960: -- p_status status of the document

Line 4118: wsh_document_instances

4114: , attribute13
4115: , attribute14
4116: , attribute15
4117: FROM
4118: wsh_document_instances
4119: WHERE rowid = p_rowid
4120: FOR UPDATE OF document_instance_id NOWAIT;
4121: lock_rec lock_csr%rowtype;
4122: --