APPS.WSH_SHIP_CONFIRM_RULES_PVT dependencies on WSH_SHIP_CONFIRM_RULES

Line 1: PACKAGE BODY WSH_SHIP_CONFIRM_RULES_PVT AS

1: PACKAGE BODY WSH_SHIP_CONFIRM_RULES_PVT AS
2: /* $Header: WSHSCTHB.pls 120.1 2005/07/29 19:22:47 wrudge noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_SHIP_CONFIRM_RULES_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_SHIP_CONFIRM_RULES_PVT';

1: PACKAGE BODY WSH_SHIP_CONFIRM_RULES_PVT AS
2: /* $Header: WSHSCTHB.pls 120.1 2005/07/29 19:22:47 wrudge noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_SHIP_CONFIRM_RULES_PVT';
6:
7: PROCEDURE Insert_Row (
8: p_ship_confirm_rule_info IN ship_confirm_rule_rectype,
9: x_rule_id OUT NOCOPY NUMBER,

Line 18: FROM WSH_SHIP_CONFIRM_RULES

14: l_dup_id NUMBER;
15:
16: CURSOR c_dup_name IS
17: SELECT ship_confirm_rule_id
18: FROM WSH_SHIP_CONFIRM_RULES
19: WHERE name = p_ship_confirm_rule_info.name;
20:
21: Begin
22:

Line 37: INSERT INTO WSH_SHIP_CONFIRM_RULES

33: RAISE WSH_DUPLICATE_NAME;
34: END IF;
35:
36:
37: INSERT INTO WSH_SHIP_CONFIRM_RULES
38: (
39: ship_confirm_rule_id,
40: effective_start_date,
41: name,

Line 65: wsh_ship_confirm_rules_s.nextval,

61: last_update_date
62: )
63: VALUES
64: (
65: wsh_ship_confirm_rules_s.nextval,
66: p_ship_confirm_rule_info.effective_start_date,
67: p_ship_confirm_rule_info.name,
68: p_ship_confirm_rule_info.effective_end_date,
69: p_ship_confirm_rule_info.action_flag,

Line 104: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_RULES_PVT.Insert_Row');

100: WHEN others THEN
101: IF c_dup_name%ISOPEN THEN
102: CLOSE c_dup_name;
103: END IF;
104: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_RULES_PVT.Insert_Row');
105: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
106:
107: End Insert_Row;
108:

Line 119: FROM WSH_SHIP_CONFIRM_RULES

115: l_dup_id NUMBER;
116:
117: CURSOR c_dup_name IS
118: SELECT ship_confirm_rule_id
119: FROM WSH_SHIP_CONFIRM_RULES
120: WHERE name = p_ship_confirm_rule_info.name
121: and ship_confirm_rule_id <> p_ship_confirm_rule_info.ship_confirm_rule_id ;
122:
123: Begin

Line 140: Update WSH_SHIP_CONFIRM_RULES

136: END IF;
137:
138:
139:
140: Update WSH_SHIP_CONFIRM_RULES
141:
142: SET
143:
144: EFFECTIVE_START_DATE = p_ship_confirm_rule_info.effective_start_date,

Line 180: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_RULES_PVT.Update_Row');

176: WHEN others THEN
177: IF c_dup_name%ISOPEN THEN
178: CLOSE c_dup_name;
179: END IF;
180: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_RULES_PVT.Update_Row');
181: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
182: End Update_Row;
183:
184:

Line 214: FROM WSH_SHIP_CONFIRM_RULES

210: CREATION_DATE,
211: CREATED_BY,
212: LAST_UPDATED_BY,
213: LAST_UPDATE_DATE
214: FROM WSH_SHIP_CONFIRM_RULES
215: WHERE rowid = p_rowid
216: FOR UPDATE OF SHIP_CONFIRM_RULE_ID NOWAIT;
217:
218: recinfo C_Lock_Row%ROWTYPE;

Line 400: DELETE FROM WSH_SHIP_CONFIRM_RULES

396: --
397: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
398: END IF;
399: --
400: DELETE FROM WSH_SHIP_CONFIRM_RULES
401: WHERE rowid = p_rowid;
402: IF SQL%NOTFOUND THEN
403: RAISE NO_DATA_FOUND;
404: END IF;

Line 418: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_RULES_PVT.DELETE_ROW');

414: --
415: EXCEPTION
416: WHEN others THEN
417: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
418: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_RULES_PVT.DELETE_ROW');
419:
420: --
421: -- Debug Statements
422: --

Line 435: END WSH_SHIP_CONFIRM_RULES_PVT;

431:
432:
433:
434:
435: END WSH_SHIP_CONFIRM_RULES_PVT;