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_NEW_DELIVERIES

Line 206: l_entity_name := 'WSH_NEW_DELIVERIES';

202: l_entity_name := p_entity_name;
203: ELSE
204: IF p_document_type = 'PACK_TYPE'
205: THEN
206: l_entity_name := 'WSH_NEW_DELIVERIES';
207: ELSIF p_document_type = 'BOL'
208: THEN
209: l_entity_name := 'WSH_DELIVERY_LEGS';
210: ELSIF p_document_type = 'MBOL'

Line 641: AND doc.entity_name='WSH_NEW_DELIVERIES'

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
644: THEN
645: l_isfinal := FND_API.g_true;

Line 815: AND doc.entity_name='WSH_NEW_DELIVERIES'

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'
816: AND doc.document_type=p_document_type;
817:
818: -- get message count and the message itself (if only one message)
819: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 903: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

899: -- p_init_msg_list should API reset message stack (default: false)
900: -- p_commit should API do a commit (default: false)
901: -- p_validation_level extent of validation done in the API (not used)
902: -- p_entity_name Entity for which the document is being created
903: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS
904: -- p_entity_id Entity id that the document belongs to
905: -- example: delivery_id, delivery_leg_id, etc
906: -- p_application_id Application which is creating the document (
907: -- should be same as the one that owns the

Line 1084: wsh_new_deliveries

1080: CURSOR delivery_csr (c_delivery_id IN NUMBER) IS
1081: SELECT
1082: delivery_id
1083: FROM
1084: wsh_new_deliveries
1085: WHERE delivery_id = c_delivery_id;
1086:
1087: CURSOR delivery_id_csr (c_delivery_leg_id IN NUMBER) IS
1088: SELECT

Line 1207: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

1203: OPEN delivery_id_csr (p_entity_id);
1204: FETCH delivery_id_csr INTO delivery_id_rec;
1205: l_delivery_id := delivery_id_rec.delivery_id;
1206: CLOSE delivery_id_csr;
1207: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'
1208: THEN
1209: l_delivery_id := p_entity_id;
1210: END IF;
1211:

Line 1293: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

1289: THEN
1290: OPEN document_csr ( l_entity_name
1291: , l_delivery_leg_id
1292: ) ;
1293: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'
1294: THEN
1295: OPEN document_csr (l_entity_name, l_delivery_id_tab(ctr));
1296: END IF;
1297:

Line 1394: ELSIF l_entity_name ='WSH_NEW_DELIVERIES' THEN

1390:
1391: IF l_entity_name = 'WSH_DELIVERY_LEGS' THEN
1392: l_status := 'PLANNED';
1393: l_entity_id := l_delivery_leg_id;
1394: ELSIF l_entity_name ='WSH_NEW_DELIVERIES' THEN
1395: l_status := 'OPEN';
1396: l_entity_id := l_delivery_id_tab(ctr);
1397: END IF;
1398:

Line 1405: -- then entity_name is WSH_NEW_DELIVERIES --

1401: ---------------------------------------------------------
1402: -- logic in insert statement: --
1403: -- --
1404: -- if the entity is delivery ( packing slips ) --
1405: -- then entity_name is WSH_NEW_DELIVERIES --
1406: -- and entity_id is delivery_id --
1407: -- and if there is consolidation --
1408: -- then for child deliveries --
1409: -- entity_name is WSH_NEW_DELIVERIES --

Line 1409: -- entity_name is WSH_NEW_DELIVERIES --

1405: -- then entity_name is WSH_NEW_DELIVERIES --
1406: -- and entity_id is delivery_id --
1407: -- and if there is consolidation --
1408: -- then for child deliveries --
1409: -- entity_name is WSH_NEW_DELIVERIES --
1410: -- entity_id is child delivery_id --
1411: -- if the entity is delivery leg ( bill of lading ) --
1412: -- then entity_name is WSH_DELIVERY_LEGS --
1413: -- and entity_id is delivery_leg_id --

Line 1687: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl

1683: END IF;
1684: ROLLBACK to WSH_Document_PVT;
1685:
1686: SELECT wnd.name INTO l_delivery_name
1687: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl
1688: WHERE wnd.delivery_id = wdl.delivery_id
1689: AND wdl.delivery_leg_id = l_delivery_leg_id;
1690:
1691: FND_MESSAGE.SET_NAME('WSH',' WSH_DLVY_DEL_LEG_LOCK');

Line 1779: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

1775: -- p_init_msg_list should API reset message stack (default: false)
1776: -- p_commit should API do a commit (default: false)
1777: -- p_validation_level extent of validation done in the API (not used)
1778: -- p_entity_name Entity for which the document is being updated
1779: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS
1780: -- p_entity_id Entity id that the document belongs to
1781: -- example: delivery_id, delivery_leg_id, etc
1782: -- p_document_type document type codes (PACK_TYPE, BOL, ASN etc.)
1783: -- p_pod_flag pod_flag for the document

Line 1852: l_delivery_id wsh_new_deliveries.delivery_id%type;

1848: ) IS
1849: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Document';
1850: L_API_VERSION CONSTANT NUMBER := 1.0;
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:

Line 1956: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

1952: OPEN delivery_id_csr (p_entity_id);
1953: FETCH delivery_id_csr INTO delivery_id_rec;
1954: l_delivery_id := delivery_id_rec.delivery_id;
1955: CLOSE delivery_id_csr;
1956: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'
1957: THEN
1958: l_delivery_id := p_entity_id;
1959: END IF;
1960:

Line 2017: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

2013: END IF;
2014: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2015: THEN
2016: OPEN old_values_csr (l_entity_name, l_delivery_leg_id);
2017: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'
2018: THEN
2019: OPEN old_values_csr (l_entity_name, l_delivery_id_tab(ctr));
2020: END IF;
2021:

Line 2132: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

2128: -- p_init_msg_list should API reset message stack (default: false)
2129: -- p_commit should API do a commit (default: false)
2130: -- p_validation_level extent of validation done in the API (not used)
2131: -- p_entity_name Entity for which the document is being cancelled
2132: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS
2133: -- p_entity_id Entity id that the document belongs to
2134: -- example: delivery_id, delivery_leg_id, etc
2135: -- p_document_type document type codes (PACK_TYPE, BOL, ASN etc.)
2136: -- p_consolidate_option calling program's choice to cancel document(s)

Line 2172: l_delivery_id wsh_new_deliveries.delivery_id%type;

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:
2176: -------------------------------------------------------------------------

Line 2281: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

2277: OPEN delivery_id_csr (p_entity_id);
2278: FETCH delivery_id_csr INTO delivery_id_rec;
2279: l_delivery_id := delivery_id_rec.delivery_id;
2280: CLOSE delivery_id_csr;
2281: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'
2282: THEN
2283: l_delivery_id := p_entity_id;
2284: END IF;
2285:

Line 2342: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

2338: END IF;
2339: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2340: THEN
2341: OPEN status_csr (l_entity_name, l_delivery_leg_id);
2342: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'
2343: THEN
2344: OPEN status_csr (l_entity_name, l_delivery_id_tab(ctr));
2345: END IF;
2346:

Line 2459: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

2455: -- p_init_msg_list should API reset message stack (default: false)
2456: -- p_commit should API do a commit (default: false)
2457: -- p_validation_level extent of validation done in the API (not used)
2458: -- p_entity_name Entity for which the document is being opened
2459: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS
2460: -- p_entity_id Entity id that the document belongs to
2461: -- example: delivery_id, delivery_leg_id, etc
2462: -- p_document_type document type codes (PACK_TYPE, BOL, ASN etc.)
2463: -- p_consolidate_option calling program's choice to open document(s)

Line 2499: l_delivery_id wsh_new_deliveries.delivery_id%type;

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
2503: SELECT

Line 2597: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

2593: OPEN delivery_id_csr (p_entity_id);
2594: FETCH delivery_id_csr INTO delivery_id_rec;
2595: l_delivery_id := delivery_id_rec.delivery_id;
2596: CLOSE delivery_id_csr;
2597: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'
2598: THEN
2599: l_delivery_id := p_entity_id;
2600: END IF;
2601:

Line 2658: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

2654: END IF;
2655: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2656: THEN
2657: OPEN status_csr (l_entity_name, l_delivery_leg_id);
2658: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'
2659: THEN
2660: OPEN status_csr (l_entity_name, l_delivery_id_tab(ctr));
2661: END IF;
2662:

Line 2762: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

2758: -- p_init_msg_list should API reset message stack (default: false)
2759: -- p_commit should API do a commit (default: false)
2760: -- p_validation_level extent of validation done in the API (not used)
2761: -- p_entity_name Entity for which the document is being completed
2762: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS
2763: -- p_entity_id Entity id that the document belongs to
2764: -- example: delivery_id, delivery_leg_id, etc
2765: -- p_document_type document type codes (PACK_TYPE, BOL, ASN etc.)
2766: -- p_consolidate_option calling program's choice to complete document(s)

Line 2803: l_delivery_id wsh_new_deliveries.delivery_id%type;

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
2807: SELECT

Line 2901: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

2897: OPEN delivery_id_csr (p_entity_id);
2898: FETCH delivery_id_csr INTO delivery_id_rec;
2899: l_delivery_id := delivery_id_rec.delivery_id;
2900: CLOSE delivery_id_csr;
2901: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'
2902: THEN
2903: l_delivery_id := p_entity_id;
2904: END IF;
2905:

Line 2962: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

2958: END IF;
2959: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2960: THEN
2961: OPEN status_csr (l_entity_name, l_delivery_leg_id);
2962: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'
2963: THEN
2964: OPEN status_csr (l_entity_name, l_delivery_id_tab(ctr));
2965: END IF;
2966:

Line 3549: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

3545: -- p_init_msg_list should API reset message stack (default: false)
3546: -- p_commit should API do a commit (default: false)
3547: -- p_validation_level extent of validation done in the API (not used)
3548: -- p_entity_name Entity for which the document is being cancelled
3549: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS
3550: -- p_entity_id Entity id that the document belongs to
3551: -- example: delivery_id, delivery_leg_id, etc
3552: --
3553: -- OUT

Line 3717: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

3713: -- p_init_msg_list should API reset message stack (default: false)
3714: -- p_commit should API do a commit (default: false)
3715: -- p_validation_level extent of validation done in the API (not used)
3716: -- p_entity_name Entity for which the document is being cancelled
3717: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS
3718: -- p_entity_id Entity id that the document belongs to
3719: -- example: delivery_id, delivery_leg_id, etc
3720:
3721: -- OUT

Line 3962: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

3958: -- p_sequence_number sequence number of the document
3959: -- p_status status of the document
3960: -- p_final_print_date final print date
3961: -- p_entity_name Entity for which the document is being updated
3962: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS
3963: -- p_entity_id Entity id that the document belongs to
3964: -- example: delivery_id, delivery_leg_id, etc
3965: -- p_doc_sequence_category_id document sequence category id
3966: -- p_pod_flag pod_flag for the document