APPS.AMS_UPGRADE_TRACK_ERROR_PKG dependencies on AMS_UPGRADE_TRACK_ERROR

Line 1: PACKAGE BODY AMS_UPGRADE_TRACK_ERROR_PKG as

1: PACKAGE BODY AMS_UPGRADE_TRACK_ERROR_PKG as
2: /* $Header: amstuteb.pls 120.0 2005/05/31 21:55:15 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_UPGRADE_TRACK_ERROR_PKG

2: /* $Header: amstuteb.pls 120.0 2005/05/31 21:55:15 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_UPGRADE_TRACK_ERROR_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_UPGRADE_TRACK_ERROR_PKG';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_UPGRADE_TRACK_ERROR_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstuteb.pls';
19:
20:
21: ----------------------------------------------------------

Line 54: INSERT INTO AMS_UPGRADE_TRACK_ERROR(

50:
51: BEGIN
52:
53:
54: INSERT INTO AMS_UPGRADE_TRACK_ERROR(
55: object_code,
56: object_id,
57: creation_date,
58: error_code,

Line 103: Update AMS_UPGRADE_TRACK_ERROR

99: p_proposed_action VARCHAR2)
100:
101: IS
102: BEGIN
103: Update AMS_UPGRADE_TRACK_ERROR
104: SET
105: object_code = DECODE( p_object_code, FND_API.g_miss_char, object_code, p_object_code),
106: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
107: error_code = DECODE( p_error_code, FND_API.g_miss_char, error_code, p_error_code),

Line 142: DELETE FROM AMS_UPGRADE_TRACK_ERROR

138: p_OBJECT_CODE Number
139: ,p_OBJECT_ID NUMBER)
140: IS
141: BEGIN
142: DELETE FROM AMS_UPGRADE_TRACK_ERROR
143: WHERE OBJECT_CODE = p_OBJECT_CODE
144: AND OBJECT_ID = p_OBJECT_ID;
145: If (SQL%NOTFOUND) then
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 150: END AMS_UPGRADE_TRACK_ERROR_PKG;

146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: End If;
148: END Delete_Row ;
149:
150: END AMS_UPGRADE_TRACK_ERROR_PKG;