APPS.JTF_AMV_ATTACHMENT_PUB dependencies on JTF_PLSQL_API

Line 148: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

144:
145: PROCEDURE check_act_attachment_uk_items
146: (
147: p_act_attachment_rec IN act_attachment_rec_type,
148: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
149: x_return_status OUT NOCOPY VARCHAR2
150: ) AS
151: l_valid_flag VARCHAR2(1);
152: BEGIN

Line 158: IF p_validation_mode = JTF_PLSQL_API.g_create AND

154: x_return_status := FND_API.g_ret_sts_success;
155:
156: -- For create_act_attachment, when attachment_id is passed in, we
157: -- need to check if this attachment_id is unique.
158: IF p_validation_mode = JTF_PLSQL_API.g_create AND
159: p_act_attachment_rec.attachment_id IS NOT NULL THEN
160: IF check_uniqueness(
161: 'jtf_amv_attachments',
162: 'attachment_id = ' || p_act_attachment_rec.attachment_id

Line 723: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

719: END IF;
720: x_return_status := FND_API.G_RET_STS_SUCCESS;
721:
722: ----------------------- validate ----------------------
723: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
724: check_act_attachment_items
725: (
726: p_act_attachment_rec => p_act_attachment_rec,
727: p_validation_mode => JTF_PLSQL_API.g_update,

Line 727: p_validation_mode => JTF_PLSQL_API.g_update,

723: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
724: check_act_attachment_items
725: (
726: p_act_attachment_rec => p_act_attachment_rec,
727: p_validation_mode => JTF_PLSQL_API.g_update,
728: x_return_status => l_return_status
729: );
730:
731: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 741: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

737:
738: -- replace g_miss_char/num/date with current column values
739: complete_act_attachment_rec(p_act_attachment_rec, l_act_attachment_rec);
740:
741: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
742: check_act_attachment_record
743: (
744: p_act_attachment_rec => p_act_attachment_rec,
745: p_complete_rec => l_act_attachment_rec,

Line 1035: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1031: END IF;
1032: x_return_status := FND_API.g_ret_sts_success;
1033:
1034: ---------------------- validate ------------------------
1035: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1036: check_act_attachment_items
1037: (
1038: p_act_attachment_rec => p_act_attachment_rec,
1039: p_validation_mode => JTF_PLSQL_API.g_create,

Line 1039: p_validation_mode => JTF_PLSQL_API.g_create,

1035: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1036: check_act_attachment_items
1037: (
1038: p_act_attachment_rec => p_act_attachment_rec,
1039: p_validation_mode => JTF_PLSQL_API.g_create,
1040: x_return_status => l_return_status
1041: );
1042: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1043: RAISE FND_API.g_exc_unexpected_error;

Line 1049: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1045: RAISE FND_API.g_exc_error;
1046: END IF;
1047: END IF;
1048:
1049: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1050: check_act_attachment_record
1051: (
1052: p_act_attachment_rec => p_act_attachment_rec,
1053: p_complete_rec => NULL,

Line 1113: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1109: ---------------------------------------------------------------------
1110: PROCEDURE check_act_attachment_items
1111: (
1112: p_act_attachment_rec IN act_attachment_rec_type,
1113: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1114: x_return_status OUT NOCOPY VARCHAR2
1115: ) AS
1116: BEGIN
1117: