DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PUB dependencies on STANDARD

Line 4: -- standard global constants

1: PACKAGE BODY WSH_DELIVERY_DETAILS_PUB as
2: /* $Header: WSHDDPBB.pls 120.5.12020000.2 2013/05/17 05:42:54 skanduku ship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERY_DETAILS_PUB';
6: p_message_type CONSTANT VARCHAR2(1) := 'E';
7:
8:

Line 23: -- 5) other standard parameters

19: -- 3) delivery_id: need to specify delivery id or delivery name
20: -- if the action is 'ASSIGN'
21: -- 4) delivery_name: need to specify delivery id or delivery
22: -- name if the action is 'ASSIGN'
23: -- 5) other standard parameters
24: --
25: --
26: -- Description: This procedure assign/unassign delivery_details to
27: -- a delivery.

Line 34: -- Standard parameters

30: -- p_delivery_id: required if action='ASSIGN'
31: -- -----------------------------------------------------------------------
32:
33: PROCEDURE detail_to_delivery(
34: -- Standard parameters
35: p_api_version IN NUMBER,
36: p_init_msg_list IN VARCHAR2,
37: p_commit IN VARCHAR2,
38: p_validation_level IN NUMBER,

Line 50: -- Standard call to check for call compatibility

46: p_delivery_id IN NUMBER,
47: p_delivery_name IN VARCHAR2
48: ) IS
49:
50: -- Standard call to check for call compatibility
51: l_api_version CONSTANT NUMBER := 1.0;
52: l_api_name CONSTANT VARCHAR2(30):= 'delivery_detail_to_delivery';
53:
54: l_return_status VARCHAR2(30) := NULL;

Line 83: -- Standard begin of API savepoint

79: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DETAIL_TO_DELIVERY';
80: --
81: begin
82:
83: -- Standard begin of API savepoint
84: --
85: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
86: --
87: IF l_debug_on IS NULL

Line 268: -- Standard parameters

264: -- ----------------------------------------------------------------------
265:
266: PROCEDURE split_line
267: (
268: -- Standard parameters
269: p_api_version IN NUMBER,
270: p_init_msg_list IN VARCHAR2,
271: p_commit IN VARCHAR2,
272: p_validation_level IN NUMBER,

Line 322: -- Standard call to check for call compatibility.

318: where delivery_detail_id = P_FROM_DETAIL_ID;
319:
320: --MUOM Bug 16806520 :End of changes
321:
322: -- Standard call to check for call compatibility.
323: l_api_version CONSTANT NUMBER := 1.0;
324: l_api_name CONSTANT VARCHAR2(30):= 'delivery_detail_to_delivery';
325:
326: l_debug_on BOOLEAN;

Line 332: -- Standard begin of API savepoint

328: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'SPLIT_LINE';
329: --
330: BEGIN
331:
332: -- Standard begin of API savepoint
333: --
334: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
335: --
336: IF l_debug_on IS NULL

Line 689: -- Standard parameters

685: --CREATED: During patchset I
686: --========================================================================
687:
688: PROCEDURE Update_Shipping_Attributes (
689: -- Standard parameters
690: p_api_version_number IN NUMBER
691: , p_init_msg_list IN VARCHAR2
692: , p_commit IN VARCHAR2
693: , x_return_status OUT NOCOPY VARCHAR2

Line 769: -- Standard call to check for call compatibility

765: --
766:
767: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
768:
769: -- Standard call to check for call compatibility
770: IF NOT FND_API.Compatible_API_Call(
771: l_api_version_number,
772: p_api_version_number,
773: l_api_name,

Line 1008: -- Standard parameters

1004: -- specified then only Org_Id is used
1005: --========================================================================
1006:
1007: PROCEDURE Update_Shipping_Attributes (
1008: -- Standard parameters
1009: p_api_version_number IN NUMBER
1010: , p_init_msg_list IN VARCHAR2
1011: , p_commit IN VARCHAR2
1012: , x_return_status OUT NOCOPY VARCHAR2

Line 1094: -- Standard call to check for call compatibility

1090: --
1091:
1092: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1093:
1094: -- Standard call to check for call compatibility
1095: IF NOT FND_API.Compatible_API_Call(
1096: l_api_version_number,
1097: p_api_version_number,
1098: l_api_name,

Line 1411: -- Standard parameters

1407: --
1408: END get_detail_status;
1409:
1410: PROCEDURE Autocreate_Deliveries(
1411: -- Standard parameters
1412: p_api_version_number IN NUMBER
1413: , p_init_msg_list IN VARCHAR2
1414: , p_commit IN VARCHAR2
1415: , x_return_status OUT NOCOPY VARCHAR2

Line 1446: -- Standard begin of API savepoint

1442: --
1443: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'AUTOCREATE_DELIVERIES';
1444: --
1445: BEGIN
1446: -- Standard begin of API savepoint
1447: --
1448: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1449: --
1450: IF l_debug_on IS NULL

Line 1605: -- Standard parameters

1601: --
1602: END Autocreate_Deliveries;
1603:
1604: PROCEDURE Autocreate_del_trip(
1605: -- Standard parameters
1606: p_api_version_number IN NUMBER
1607: , p_init_msg_list IN VARCHAR2
1608: , p_commit IN VARCHAR2
1609: , x_return_status OUT NOCOPY VARCHAR2

Line 1626: -- Standard begin of API savepoint

1622: --
1623: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'AUTOCREATE_DEL_TRIP - single trip';
1624:
1625: BEGIN
1626: -- Standard begin of API savepoint
1627: --
1628: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1629: --
1630: IF l_debug_on IS NULL THEN

Line 1648: -- Standard parameters

1644: END IF;
1645:
1646:
1647: WSH_DELIVERY_DETAILS_PUB.Autocreate_del_trip(
1648: -- Standard parameters
1649: p_api_version_number => p_api_version_number,
1650: p_init_msg_list => p_init_msg_list,
1651: p_commit => p_commit,
1652: x_return_status => x_return_status,

Line 1701: -- Standard parameters

1697: END Autocreate_del_trip;
1698:
1699:
1700: PROCEDURE Autocreate_del_trip(
1701: -- Standard parameters
1702: p_api_version_number IN NUMBER
1703: , p_init_msg_list IN VARCHAR2
1704: , p_commit IN VARCHAR2
1705: , x_return_status OUT NOCOPY VARCHAR2

Line 1737: -- Standard begin of API savepoint

1733: --
1734: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'AUTOCREATE_DEL_TRIP - multiple trips';
1735: --
1736: BEGIN
1737: -- Standard begin of API savepoint
1738: --
1739: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1740: --
1741: IF l_debug_on IS NULL