APPS.HZ_DSS_SCHEME_FUNCTIONS_PKG dependencies on FND_API

Line 33: FND_API.G_MISS_CHAR, NULL,

29: object_version_number
30: )
31: VALUES (
32: DECODE(x_security_scheme_code,
33: FND_API.G_MISS_CHAR, NULL,
34: x_security_scheme_code),
35: DECODE(x_data_operation_code,
36: FND_API.G_MISS_CHAR, NULL,
37: x_data_operation_code),

Line 36: FND_API.G_MISS_CHAR, NULL,

32: DECODE(x_security_scheme_code,
33: FND_API.G_MISS_CHAR, NULL,
34: x_security_scheme_code),
35: DECODE(x_data_operation_code,
36: FND_API.G_MISS_CHAR, NULL,
37: x_data_operation_code),
38: DECODE(x_function_id,
39: FND_API.G_MISS_NUM, NULL,
40: x_function_id),

Line 39: FND_API.G_MISS_NUM, NULL,

35: DECODE(x_data_operation_code,
36: FND_API.G_MISS_CHAR, NULL,
37: x_data_operation_code),
38: DECODE(x_function_id,
39: FND_API.G_MISS_NUM, NULL,
40: x_function_id),
41: DECODE(x_status,
42: FND_API.G_MISS_CHAR, 'A',
43: NULL, 'A',

Line 42: FND_API.G_MISS_CHAR, 'A',

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

Line 51: FND_API.G_MISS_NUM, NULL,

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

Line 82: FND_API.G_MISS_CHAR, NULL,

78: /*
79: security_scheme_code =
80: DECODE(x_security_scheme_code,
81: NULL, security_scheme_code,
82: FND_API.G_MISS_CHAR, NULL,
83: x_security_scheme_code),
84: data_operation_code =
85: DECODE(x_data_operation_code,
86: NULL, data_operation_code,

Line 87: FND_API.G_MISS_CHAR, NULL,

83: x_security_scheme_code),
84: data_operation_code =
85: DECODE(x_data_operation_code,
86: NULL, data_operation_code,
87: FND_API.G_MISS_CHAR, NULL,
88: x_data_operation_code),
89: function_id =
90: DECODE(x_function_id,
91: NULL, function_id,

Line 92: FND_API.G_MISS_NUM, NULL,

88: x_data_operation_code),
89: function_id =
90: DECODE(x_function_id,
91: NULL, function_id,
92: FND_API.G_MISS_NUM, NULL,
93: x_function_id),
94: */
95: status =
96: DECODE(x_status,

Line 98: FND_API.G_MISS_CHAR, NULL,

94: */
95: status =
96: DECODE(x_status,
97: NULL, status,
98: FND_API.G_MISS_CHAR, NULL,
99: x_status),
100: last_update_date = hz_utility_v2pub.last_update_date,
101: last_updated_by = hz_utility_v2pub.last_updated_by,
102: creation_date = creation_date,

Line 108: FND_API.G_MISS_NUM, NULL,

104: last_update_login = hz_utility_v2pub.last_update_login,
105: object_version_number =
106: DECODE(x_object_version_number,
107: NULL, object_version_number,
108: FND_API.G_MISS_NUM, NULL,
109: x_object_version_number)
110: WHERE rowid = x_rowid;
111:
112: IF ( SQL%NOTFOUND ) THEN

Line 199: NVL(status, FND_API.G_MISS_CHAR)

195: ) IS
196: BEGIN
197:
198: SELECT
199: NVL(status, FND_API.G_MISS_CHAR)
200: INTO
201: x_status
202: FROM HZ_DSS_SCHEME_FUNCTIONS
203: WHERE security_scheme_code = x_security_scheme_code

Line 213: RAISE FND_API.G_EXC_ERROR;

209: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
210: FND_MESSAGE.SET_TOKEN('RECORD', 'dss_entity_profile');
211: FND_MESSAGE.SET_TOKEN('VALUE', x_security_scheme_code);
212: FND_MSG_PUB.ADD;
213: RAISE FND_API.G_EXC_ERROR;
214:
215: END Select_Row;
216:
217: PROCEDURE Delete_Row (