APPS.PV_ATTR_PRINCIPALS_PKG dependencies on PV_ATTR_PRINCIPALS

Line 1: PACKAGE BODY "PV_ATTR_PRINCIPALS_PKG" AS

1: PACKAGE BODY "PV_ATTR_PRINCIPALS_PKG" AS
2: /* $Header: pvxtatpb.pls 120.0 2007/12/20 07:10:07 abnagapp noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

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

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

Line 58: INSERT INTO PV_ATTR_PRINCIPALS(

54:
55: px_object_version_number := 1;
56:
57:
58: INSERT INTO PV_ATTR_PRINCIPALS(
59: attr_principal_id,
60: last_update_date,
61: last_updated_by,
62: creation_date,

Line 112: Update PV_ATTR_PRINCIPALS

108: )
109:
110: IS
111: BEGIN
112: Update PV_ATTR_PRINCIPALS
113: SET
114: attr_principal_id = DECODE( p_attr_principal_id, FND_API.g_miss_num, attr_principal_id, p_attr_principal_id),
115: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
116: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 152: DELETE FROM PV_ATTR_PRINCIPALS

148: PROCEDURE Delete_Row(
149: p_attr_principal_id NUMBER)
150: IS
151: BEGIN
152: DELETE FROM PV_ATTR_PRINCIPALS
153: WHERE attr_principal_id = p_attr_principal_id;
154: If (SQL%NOTFOUND) then
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: End If;

Line 192: FROM PV_ATTR_PRINCIPALS

188:
189: IS
190: CURSOR C IS
191: SELECT *
192: FROM PV_ATTR_PRINCIPALS
193: WHERE attr_principal_id = p_attr_principal_id
194: FOR UPDATE of attr_principal_id NOWAIT;
195: Recinfo C%ROWTYPE;
196: BEGIN