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 1085: wsh_new_deliveries

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

Line 1208: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

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

Line 1294: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

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

Line 1395: ELSIF l_entity_name ='WSH_NEW_DELIVERIES' THEN

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

Line 1406: -- then entity_name is WSH_NEW_DELIVERIES --

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

Line 1410: -- entity_name is WSH_NEW_DELIVERIES --

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

Line 1688: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl

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

Line 1780: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

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

Line 1853: l_delivery_id wsh_new_deliveries.delivery_id%type;

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

Line 1957: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

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

Line 2018: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

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

Line 2133: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

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

Line 2173: l_delivery_id wsh_new_deliveries.delivery_id%type;

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

Line 2282: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

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

Line 2343: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

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

Line 2460: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

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

Line 2500: l_delivery_id wsh_new_deliveries.delivery_id%type;

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

Line 2598: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

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

Line 2659: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

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

Line 2763: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

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

Line 2804: l_delivery_id wsh_new_deliveries.delivery_id%type;

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

Line 2902: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

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

Line 2963: ELSIF l_entity_name = 'WSH_NEW_DELIVERIES'

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

Line 3550: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

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

Line 3718: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

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

Line 3963: -- examples: WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS

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