APPS.JTS_CONFIGURATION_PVT dependencies on JTS_CONFIGURATIONS_B

Line 14: l_new_config_id JTS_CONFIGURATIONS_B.configuration_id%TYPE;

10: -- --------------------------------------------------------------------
11:
12: -- get next sequence for configuration id
13: FUNCTION GET_NEXT_CONFIG_ID RETURN NUMBER IS
14: l_new_config_id JTS_CONFIGURATIONS_B.configuration_id%TYPE;
15: BEGIN
16: SELECT jts_configurations_b_s.nextval
17: INTO l_new_config_id
18: FROM sys.dual;

Line 16: SELECT jts_configurations_b_s.nextval

12: -- get next sequence for configuration id
13: FUNCTION GET_NEXT_CONFIG_ID RETURN NUMBER IS
14: l_new_config_id JTS_CONFIGURATIONS_B.configuration_id%TYPE;
15: BEGIN
16: SELECT jts_configurations_b_s.nextval
17: INTO l_new_config_id
18: FROM sys.dual;
19:
20: return (l_new_config_id);

Line 27: l_config_id JTS_CONFIGURATIONS_B.configuration_id%TYPE;

23: APP_EXCEPTION.RAISE_EXCEPTION;
24: END GET_NEXT_CONFIG_ID;
25:
26: FUNCTION GET_CONFIG_ID(p_config_name IN VARCHAR2) RETURN NUMBER IS
27: l_config_id JTS_CONFIGURATIONS_B.configuration_id%TYPE;
28: BEGIN
29: SELECT configuration_id
30: INTO l_config_id
31: FROM jts_configurations_b

Line 31: FROM jts_configurations_b

27: l_config_id JTS_CONFIGURATIONS_B.configuration_id%TYPE;
28: BEGIN
29: SELECT configuration_id
30: INTO l_config_id
31: FROM jts_configurations_b
32: WHERE config_name = p_config_name;
33:
34: return l_config_id;
35: EXCEPTION

Line 41: l_config_name JTS_CONFIGURATIONS_B.config_name%TYPE;

37: return NULL;
38: END GET_CONFIG_ID;
39:
40: FUNCTION GET_CONFIG_NAME(p_config_id IN NUMBER) RETURN VARCHAR2 IS
41: l_config_name JTS_CONFIGURATIONS_B.config_name%TYPE;
42: BEGIN
43: SELECT config_name
44: INTO l_config_name
45: FROM jts_configurations_b

Line 45: FROM jts_configurations_b

41: l_config_name JTS_CONFIGURATIONS_B.config_name%TYPE;
42: BEGIN
43: SELECT config_name
44: INTO l_config_name
45: FROM jts_configurations_b
46: WHERE configuration_id = p_config_id;
47:
48: return l_config_name;
49: EXCEPTION

Line 62: insert into JTS_CONFIGURATIONS_B (

58: BEGIN
59:
60: x_config_id := GET_NEXT_CONFIG_ID;
61:
62: insert into JTS_CONFIGURATIONS_B (
63: CONFIGURATION_ID,
64: CONFIG_NAME,
65: FLOW_ID,
66: RECORD_MODE,

Line 156: l_config_id JTS_CONFIGURATIONS_B.config_name%TYPE;

152: FUNCTION CHECK_CONFIG_NAME_UNIQUE(p_config_name IN VARCHAR2,
153: p_config_id IN NUMBER
154: ) return BOOLEAN IS
155: l_count NUMBER := 0;
156: l_config_id JTS_CONFIGURATIONS_B.config_name%TYPE;
157: BEGIN
158: SELECT count(*)
159: INTO l_count
160: FROM jts_configurations_b

Line 160: FROM jts_configurations_b

156: l_config_id JTS_CONFIGURATIONS_B.config_name%TYPE;
157: BEGIN
158: SELECT count(*)
159: INTO l_count
160: FROM jts_configurations_b
161: WHERE config_name = p_config_name;
162:
163: IF l_count = 0 THEN
164: return TRUE;

Line 400: UPDATE jts_configurations_b

396: p_configuration_rec => l_config_rec,
397: x_return_status => x_return_status);
398:
399: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
400: UPDATE jts_configurations_b
401: SET config_name = p_config_name,
402: last_update_date = sysdate,
403: last_updated_by = FND_GLOBAL.user_id,
404: last_update_login = FND_GLOBAL.user_id

Line 724: FROM jts_configurations_b

720:
721: BEGIN
722: SELECT flow_id
723: INTO x_flow_id
724: FROM jts_configurations_b
725: WHERE configuration_id = p_config_id;
726:
727: EXCEPTION
728: WHEN NO_DATA_FOUND THEN