APPS.HZ_DSS_SECURED_ENTITIES_PKG dependencies on FND_API

Line 33: FND_API.G_MISS_CHAR, NULL, x_dss_group_code),

29: object_version_number
30: )
31: VALUES (
32: DECODE(x_dss_group_code,
33: FND_API.G_MISS_CHAR, NULL, x_dss_group_code),
34: DECODE(x_entity_id,
35: FND_API.G_MISS_NUM, NULL,
36: x_entity_id),
37: DECODE(x_status,

Line 35: FND_API.G_MISS_NUM, NULL,

31: VALUES (
32: DECODE(x_dss_group_code,
33: FND_API.G_MISS_CHAR, NULL, x_dss_group_code),
34: DECODE(x_entity_id,
35: FND_API.G_MISS_NUM, NULL,
36: x_entity_id),
37: DECODE(x_status,
38: FND_API.G_MISS_CHAR, 'A',
39: NULL, 'A',

Line 38: FND_API.G_MISS_CHAR, 'A',

34: DECODE(x_entity_id,
35: FND_API.G_MISS_NUM, NULL,
36: x_entity_id),
37: DECODE(x_status,
38: FND_API.G_MISS_CHAR, 'A',
39: NULL, 'A',
40: x_status),
41: DECODE(x_dss_instance_set_id,
42: FND_API.G_MISS_NUM, NULL,

Line 42: FND_API.G_MISS_NUM, NULL,

38: FND_API.G_MISS_CHAR, 'A',
39: NULL, 'A',
40: x_status),
41: DECODE(x_dss_instance_set_id,
42: FND_API.G_MISS_NUM, NULL,
43: x_dss_instance_set_id),
44: hz_utility_v2pub.last_update_date,
45: hz_utility_v2pub.last_updated_by,
46: hz_utility_v2pub.creation_date,

Line 50: FND_API.G_MISS_NUM, NULL,

46: hz_utility_v2pub.creation_date,
47: hz_utility_v2pub.created_by,
48: hz_utility_v2pub.last_update_login,
49: DECODE(x_object_version_number,
50: FND_API.G_MISS_NUM, NULL,
51: x_object_version_number)
52: ) RETURNING
53: rowid
54: INTO

Line 81: FND_API.G_MISS_CHAR, NULL,

77: SET
78: status =
79: DECODE(x_status,
80: NULL, status,
81: FND_API.G_MISS_CHAR, NULL,
82: x_status),
83: /*
84: dss_instance_set_id =
85: DECODE(x_dss_instance_set_id,

Line 87: FND_API.G_MISS_NUM, NULL,

83: /*
84: dss_instance_set_id =
85: DECODE(x_dss_instance_set_id,
86: NULL, dss_instance_set_id,
87: FND_API.G_MISS_NUM, NULL,
88: x_dss_instance_set_id),
89: */
90: last_update_date = hz_utility_v2pub.last_update_date,
91: last_updated_by = hz_utility_v2pub.last_updated_by,

Line 98: FND_API.G_MISS_NUM, NULL,

94: last_update_login = hz_utility_v2pub.last_update_login,
95: object_version_number =
96: DECODE(x_object_version_number,
97: NULL, object_version_number,
98: FND_API.G_MISS_NUM, NULL,
99: x_object_version_number)
100: WHERE rowid = x_rowid;
101:
102: IF ( SQL%NOTFOUND ) THEN

Line 189: NVL(status, FND_API.G_MISS_CHAR),

185: ) IS
186: BEGIN
187:
188: SELECT
189: NVL(status, FND_API.G_MISS_CHAR),
190: NVL(dss_instance_set_id, FND_API.G_MISS_NUM)
191: INTO
192: x_status,
193: x_dss_instance_set_id

Line 190: NVL(dss_instance_set_id, FND_API.G_MISS_NUM)

186: BEGIN
187:
188: SELECT
189: NVL(status, FND_API.G_MISS_CHAR),
190: NVL(dss_instance_set_id, FND_API.G_MISS_NUM)
191: INTO
192: x_status,
193: x_dss_instance_set_id
194: FROM HZ_DSS_SECURED_ENTITIES

Line 204: RAISE FND_API.G_EXC_ERROR;

200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
201: FND_MESSAGE.SET_TOKEN('RECORD', 'dss_secured_entity');
202: FND_MESSAGE.SET_TOKEN('VALUE', x_dss_group_code);
203: FND_MSG_PUB.ADD;
204: RAISE FND_API.G_EXC_ERROR;
205:
206: END Select_Row;
207:
208: PROCEDURE Delete_Row (