DBA Data[Home] [Help]

APPS.WSH_DOCUMENT_PVT dependencies on WSH_DELIVERY_LEGS

Line 209: l_entity_name := 'WSH_DELIVERY_LEGS';

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'
211: THEN
212: l_entity_name := 'WSH_TRIPS';
213: END IF;

Line 256: wsh_delivery_legs

252: CURSOR delivery_leg_csr IS
253: SELECT
254: delivery_leg_id
255: FROM
256: wsh_delivery_legs
257: WHERE delivery_id = p_delivery_id
258: AND pick_up_stop_id = p_pick_up_stop_id
259: AND drop_off_stop_id = p_drop_off_stop_id;
260: --

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 1018: wsh_delivery_legs

1014: delivery_id
1015: , pick_up_stop_id
1016: , drop_off_stop_id
1017: FROM
1018: wsh_delivery_legs
1019: WHERE delivery_leg_id = p_entity_id;
1020:
1021:
1022: CURSOR document_csr ( c_entity_name IN VARCHAR2

Line 1091: wsh_delivery_legs

1087: CURSOR delivery_id_csr (c_delivery_leg_id IN NUMBER) IS
1088: SELECT
1089: delivery_id
1090: FROM
1091: wsh_delivery_legs
1092: WHERE delivery_leg_id = c_delivery_leg_id;
1093:
1094: --
1095: --Bug 4284167 (FP Bug 4149501)

Line 1099: FROM wsh_delivery_legs

1095: --Bug 4284167 (FP Bug 4149501)
1096: --
1097: CURSOR get_lock_on_leg(p_delivery_leg_id IN NUMBER) IS
1098: SELECT p_delivery_leg_id
1099: FROM wsh_delivery_legs
1100: WHERE delivery_leg_id = p_delivery_leg_id
1101: FOR UPDATE NOWAIT;
1102:
1103: document_rec document_csr%rowtype;

Line 1201: IF l_entity_name = 'WSH_DELIVERY_LEGS'

1197: -- to be used to build the child delivery table later --
1198: -------------------------------------------------------------
1199:
1200: l_entity_name := Init_Entity_Name (p_document_type, p_entity_name);
1201: IF l_entity_name = 'WSH_DELIVERY_LEGS'
1202: THEN
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;

Line 1216: IF l_entity_name = 'WSH_DELIVERY_LEGS'

1212: ----------------------------------------------
1213: -- if the document is for delivery leg --
1214: -- get its pick up and drop off trip stops --
1215: ----------------------------------------------
1216: IF l_entity_name = 'WSH_DELIVERY_LEGS'
1217: THEN
1218: OPEN trip_stop_csr;
1219: FETCH trip_stop_csr INTO trip_stop_rec;
1220: CLOSE trip_stop_csr;

Line 1268: IF l_entity_name = 'WSH_DELIVERY_LEGS'

1264: -- For each delivery, if the docuement is required for --
1265: -- delivery leg entity then identify the delivery leg id --
1266: -----------------------------------------------------------
1267:
1268: IF l_entity_name = 'WSH_DELIVERY_LEGS'
1269: THEN
1270:
1271: l_delivery_leg_id := Get_Delivery_Leg_Id ( l_delivery_id_tab(ctr)
1272: , trip_stop_rec.pick_up_stop_id

Line 1288: IF l_entity_name = 'WSH_DELIVERY_LEGS'

1284: IF document_csr%ISOPEN
1285: THEN
1286: CLOSE document_csr;
1287: END IF;
1288: IF l_entity_name = 'WSH_DELIVERY_LEGS'
1289: THEN
1290: OPEN document_csr ( l_entity_name
1291: , l_delivery_leg_id
1292: ) ;

Line 1391: IF l_entity_name = 'WSH_DELIVERY_LEGS' THEN

1387: -- The decode statements that were in the values clause of the coming insert stmt
1388: -- have been modified to make use of local variables for performance reasons.
1389: --
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';

Line 1412: -- then entity_name is WSH_DELIVERY_LEGS --

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 --
1414: -- and if there is consolidation --
1415: -- then for child deliveries --
1416: -- entity_name is WSH_DELIVERY_LEGS --

Line 1416: -- entity_name is WSH_DELIVERY_LEGS --

1412: -- then entity_name is WSH_DELIVERY_LEGS --
1413: -- and entity_id is delivery_leg_id --
1414: -- and if there is consolidation --
1415: -- then for child deliveries --
1416: -- entity_name is WSH_DELIVERY_LEGS --
1417: -- entity_id is the delivery_leg_id --
1418: -- that corresponds to the --
1419: -- child delivery_id, --
1420: -- master pick_up_stop_id, --

Line 1505: IF l_entity_name = 'WSH_DELIVERY_LEGS' THEN

1501: --
1502: --Bug 4284167 (FP Bug 4149501)ISSUED DATE OF A BOL IS NOT GETTING SYSTEM GENERATED.
1503: --
1504:
1505: IF l_entity_name = 'WSH_DELIVERY_LEGS' THEN
1506:
1507: OPEN get_lock_on_leg(l_delivery_leg_id);
1508:
1509: FETCH get_lock_on_leg INTO l_delivery_leg_id;

Line 1511: UPDATE wsh_delivery_legs

1507: OPEN get_lock_on_leg(l_delivery_leg_id);
1508:
1509: FETCH get_lock_on_leg INTO l_delivery_leg_id;
1510: IF (get_lock_on_leg%FOUND) THEN
1511: UPDATE wsh_delivery_legs
1512: SET doc_date_issued = SYSDATE
1513: WHERE current of get_lock_on_leg;
1514: END IF;
1515: CLOSE get_lock_on_leg;

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 1853: l_delivery_leg_id wsh_delivery_legs.delivery_leg_id%type;

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:
1857: CURSOR old_values_csr (c_entity_name IN VARCHAR2, c_entity_id IN NUMBER) IS

Line 1876: wsh_delivery_legs

1872: delivery_id
1873: , pick_up_stop_id
1874: , drop_off_stop_id
1875: FROM
1876: wsh_delivery_legs
1877: WHERE delivery_leg_id = p_entity_id;
1878:
1879: CURSOR delivery_id_csr (c_delivery_leg_id IN NUMBER) IS
1880: SELECT

Line 1883: wsh_delivery_legs

1879: CURSOR delivery_id_csr (c_delivery_leg_id IN NUMBER) IS
1880: SELECT
1881: delivery_id
1882: FROM
1883: wsh_delivery_legs
1884: WHERE delivery_leg_id = c_delivery_leg_id;
1885:
1886: old_values_rec old_values_csr%rowtype;
1887: trip_stop_rec trip_stop_csr%rowtype;

Line 1950: IF l_entity_name = 'WSH_DELIVERY_LEGS'

1946: -- to be used to build the child delivery table later --
1947: -------------------------------------------------------------
1948:
1949: l_entity_name := Init_Entity_Name (p_document_type, p_entity_name);
1950: IF l_entity_name = 'WSH_DELIVERY_LEGS'
1951: THEN
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;

Line 1966: IF l_entity_name = 'WSH_DELIVERY_LEGS'

1962: -- if the document is for delivery leg --
1963: -- get its pick up and drop off trip stops --
1964: ----------------------------------------------
1965:
1966: IF l_entity_name = 'WSH_DELIVERY_LEGS'
1967: THEN
1968: OPEN trip_stop_csr;
1969: FETCH trip_stop_csr INTO trip_stop_rec;
1970: CLOSE trip_stop_csr;

Line 2002: IF l_entity_name = 'WSH_DELIVERY_LEGS'

1998: -- For each delivery, if the docuement relates to --
1999: -- delivery leg entity then identify the delivery leg id --
2000: -----------------------------------------------------------
2001:
2002: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2003: THEN
2004: l_delivery_leg_id := Get_Delivery_Leg_Id ( l_delivery_id_tab(ctr)
2005: , trip_stop_rec.pick_up_stop_id
2006: , trip_stop_rec.drop_off_stop_id

Line 2014: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2010: IF old_values_csr%ISOPEN
2011: THEN
2012: CLOSE old_values_csr;
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

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 2173: l_delivery_leg_id wsh_delivery_legs.delivery_leg_id%type;

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: -------------------------------------------------------------------------
2177: -- cursor to fetch the current document (in PLAN/OPEN status) of --

Line 2201: wsh_delivery_legs

2197: delivery_id
2198: , pick_up_stop_id
2199: , drop_off_stop_id
2200: FROM
2201: wsh_delivery_legs
2202: WHERE delivery_leg_id = p_entity_id;
2203:
2204: CURSOR delivery_id_csr (c_delivery_leg_id IN NUMBER) IS
2205: SELECT

Line 2208: wsh_delivery_legs

2204: CURSOR delivery_id_csr (c_delivery_leg_id IN NUMBER) IS
2205: SELECT
2206: delivery_id
2207: FROM
2208: wsh_delivery_legs
2209: WHERE delivery_leg_id = c_delivery_leg_id;
2210:
2211: trip_stop_rec trip_stop_csr%rowtype;
2212: delivery_id_rec delivery_id_csr%rowtype;

Line 2275: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2271: l_entity_name := Init_Entity_Name (p_document_type, p_entity_name);
2272:
2273: IF l_entity_name <> 'WSH_TRIPS' THEN
2274:
2275: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2276: THEN
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;

Line 2291: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2287: -- if the document is for delivery leg --
2288: -- get its pick up and drop off trip stops --
2289: ----------------------------------------------
2290:
2291: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2292: THEN
2293: OPEN trip_stop_csr;
2294: FETCH trip_stop_csr INTO trip_stop_rec;
2295: CLOSE trip_stop_csr;

Line 2327: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2323: -- For each delivery, if the docuement relates to --
2324: -- delivery leg entity then identify the delivery leg id --
2325: -----------------------------------------------------------
2326:
2327: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2328: THEN
2329: l_delivery_leg_id := Get_Delivery_Leg_Id ( l_delivery_id_tab(ctr)
2330: , trip_stop_rec.pick_up_stop_id
2331: , trip_stop_rec.drop_off_stop_id

Line 2339: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2335: IF status_csr%ISOPEN
2336: THEN
2337: CLOSE status_csr;
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

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 2500: l_delivery_leg_id wsh_delivery_legs.delivery_leg_id%type;

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

Line 2520: wsh_delivery_legs

2516: delivery_id
2517: , pick_up_stop_id
2518: , drop_off_stop_id
2519: FROM
2520: wsh_delivery_legs
2521: WHERE delivery_leg_id = p_entity_id;
2522:
2523: CURSOR delivery_id_csr (c_delivery_leg_id IN NUMBER) IS
2524: SELECT

Line 2527: wsh_delivery_legs

2523: CURSOR delivery_id_csr (c_delivery_leg_id IN NUMBER) IS
2524: SELECT
2525: delivery_id
2526: FROM
2527: wsh_delivery_legs
2528: WHERE delivery_leg_id = c_delivery_leg_id;
2529:
2530: trip_stop_rec trip_stop_csr%rowtype;
2531: delivery_id_rec delivery_id_csr%rowtype;

Line 2591: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2587: -- to be used to build the child delivery table later --
2588: -------------------------------------------------------------
2589:
2590: l_entity_name := Init_Entity_Name (p_document_type, p_entity_name);
2591: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2592: THEN
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;

Line 2607: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2603: -- if the document is for delivery leg --
2604: -- get its pick up and drop off trip stops --
2605: ----------------------------------------------
2606:
2607: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2608: THEN
2609: OPEN trip_stop_csr;
2610: FETCH trip_stop_csr INTO trip_stop_rec;
2611: CLOSE trip_stop_csr;

Line 2643: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2639: -- For each delivery, if the docuement relates to --
2640: -- delivery leg entity then identify the delivery leg id --
2641: -----------------------------------------------------------
2642:
2643: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2644: THEN
2645: l_delivery_leg_id := Get_Delivery_Leg_Id ( l_delivery_id_tab(ctr)
2646: , trip_stop_rec.pick_up_stop_id
2647: , trip_stop_rec.drop_off_stop_id

Line 2655: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2651: IF status_csr%ISOPEN
2652: THEN
2653: CLOSE status_csr;
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

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 2804: l_delivery_leg_id wsh_delivery_legs.delivery_leg_id%type;

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

Line 2824: wsh_delivery_legs

2820: delivery_id
2821: , pick_up_stop_id
2822: , drop_off_stop_id
2823: FROM
2824: wsh_delivery_legs
2825: WHERE delivery_leg_id = p_entity_id;
2826:
2827: CURSOR delivery_id_csr (c_delivery_leg_id IN NUMBER) IS
2828: SELECT

Line 2831: wsh_delivery_legs

2827: CURSOR delivery_id_csr (c_delivery_leg_id IN NUMBER) IS
2828: SELECT
2829: delivery_id
2830: FROM
2831: wsh_delivery_legs
2832: WHERE delivery_leg_id = c_delivery_leg_id;
2833:
2834: trip_stop_rec trip_stop_csr%rowtype;
2835: delivery_id_rec delivery_id_csr%rowtype;

Line 2895: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2891: -- to be used to build the child delivery table later --
2892: -------------------------------------------------------------
2893:
2894: l_entity_name := Init_Entity_Name (p_document_type, p_entity_name);
2895: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2896: THEN
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;

Line 2911: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2907: -- if the document is for delivery leg --
2908: -- get its pick up and drop off trip stops --
2909: ----------------------------------------------
2910:
2911: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2912: THEN
2913: OPEN trip_stop_csr;
2914: FETCH trip_stop_csr INTO trip_stop_rec;
2915: CLOSE trip_stop_csr;

Line 2947: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2943: -- For each delivery, if the docuement relates to --
2944: -- delivery leg entity then identify the delivery leg id --
2945: -----------------------------------------------------------
2946:
2947: IF l_entity_name = 'WSH_DELIVERY_LEGS'
2948: THEN
2949: l_delivery_leg_id := Get_Delivery_Leg_Id ( l_delivery_id_tab(ctr)
2950: , trip_stop_rec.pick_up_stop_id
2951: , trip_stop_rec.drop_off_stop_id

Line 2959: IF l_entity_name = 'WSH_DELIVERY_LEGS'

2955: IF status_csr%ISOPEN
2956: THEN
2957: CLOSE status_csr;
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

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