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 1430: INSERT INTO wsh_document_instances

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

Line 1466: ( wsh_document_instances_s.nextval

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

Line 1588: INSERT INTO wsh_document_instances

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

Line 1624: ( wsh_document_instances_s.nextval

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

Line 1855: l_entity_name wsh_document_instances.entity_name%type;

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

Line 1863: wsh_document_instances

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

Line 2040: UPDATE wsh_document_instances

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

Line 2171: l_entity_name wsh_document_instances.entity_name%type;

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

Line 2188: wsh_document_instances

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

Line 2355: UPDATE wsh_document_instances

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

Line 2370: UPDATE wsh_document_instances

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

Line 2498: l_entity_name wsh_document_instances.entity_name%type;

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

Line 2507: wsh_document_instances

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

Line 2671: UPDATE wsh_document_instances

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

Line 2802: l_entity_name wsh_document_instances.entity_name%type;

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

Line 2811: wsh_document_instances

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

Line 2975: UPDATE wsh_document_instances

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

Line 3629: UPDATE wsh_document_instances

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

Line 3781: FROM wsh_document_instances

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

Line 3955: -- p_rowid Rowid of wsh_document_instances table

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

Line 4117: wsh_document_instances

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