APPS.JTF_IH_PUB dependencies on AMS_SOURCE_CODES

Line 25: FROM ams_source_codes

21: ((x_source_code IS NULL) OR
22: (x_source_code = fnd_api.g_miss_char)) THEN
23: BEGIN
24: SELECT source_code into x_source_code
25: FROM ams_source_codes
26: WHERE source_code_id = x_source_code_id;
27: IF (SQL%NOTFOUND) THEN
28: x_return_status := fnd_api.g_ret_sts_error;
29: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(x_source_code_id), 'SOUREC_CODE');

Line 41: FROM ams_source_codes

37: ((x_source_code_id IS NULL) OR
38: (x_source_code_id = fnd_api.g_miss_num)) THEN
39: BEGIN
40: SELECT source_code_id into x_source_code_id
41: FROM ams_source_codes
42: WHERE source_code = x_source_code;
43: IF (SQL%NOTFOUND) THEN
44: x_return_status := fnd_api.g_ret_sts_error;
45: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, x_source_code, 'SOURCE_CODE');

Line 721: ams_source_codes

717: BEGIN
718: SELECT
719: count(source_code_id) into l_count
720: FROM
721: ams_source_codes
722: WHERE
723: source_code_id = p_int_val_rec.source_code_id;
724: IF (l_count <= 0) THEN
725: x_return_status := fnd_api.g_ret_sts_error;

Line 746: ams_source_codes

742: BEGIN
743: SELECT
744: count(source_code_id) into l_count
745: FROM
746: ams_source_codes
747: WHERE
748: source_code = p_int_val_rec.source_code;
749: IF (l_count <= 0) THEN
750: x_return_status := fnd_api.g_ret_sts_error;

Line 770: ams_source_codes

766: BEGIN
767: SELECT
768: count(source_code_id) into l_count
769: FROM
770: ams_source_codes
771: WHERE
772: source_code = p_int_val_rec.source_code AND
773: source_code_id = p_int_val_rec.source_code_id;
774: IF (l_count <= 0) THEN

Line 1095: ams_source_codes

1091: BEGIN
1092: SELECT
1093: count(source_code_id) into l_count
1094: FROM
1095: ams_source_codes
1096: WHERE
1097: source_code_id = p_act_val_rec.source_code_id;
1098: IF (l_count <= 0) THEN
1099: x_return_status := fnd_api.g_ret_sts_error;

Line 1120: ams_source_codes

1116: BEGIN
1117: SELECT
1118: count(source_code_id) into l_count
1119: FROM
1120: ams_source_codes
1121: WHERE
1122: source_code = p_act_val_rec.source_code;
1123: IF (l_count <= 0) THEN
1124: x_return_status := fnd_api.g_ret_sts_error;

Line 1144: ams_source_codes

1140: BEGIN
1141: SELECT
1142: count(source_code_id) into l_count
1143: FROM
1144: ams_source_codes
1145: WHERE
1146: source_code = p_act_val_rec.source_code AND
1147: source_code_id = p_act_val_rec.source_code_id;
1148: IF (l_count <= 0) THEN