APPS.JTS_SETUP_FLOW_HIEARCHY_PKG dependencies on JTS_SETUP_FLOWS_B

Line 14: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;

10: -- --------------------------------------------------------------------
11:
12:
13: FUNCTION GET_NEXT_FLOW_ID RETURN NUMBER IS
14: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;
15: BEGIN
16: SELECT jts_setup_flows_b_s.nextval
17: INTO l_flow_id
18: FROM sys.dual;

Line 16: SELECT jts_setup_flows_b_s.nextval

12:
13: FUNCTION GET_NEXT_FLOW_ID RETURN NUMBER IS
14: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;
15: BEGIN
16: SELECT jts_setup_flows_b_s.nextval
17: INTO l_flow_id
18: FROM sys.dual;
19:
20: return (l_flow_id);

Line 27: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE := NULL;

23: APP_EXCEPTION.RAISE_EXCEPTION;
24: END GET_NEXT_FLOW_ID;
25:
26: FUNCTION GET_FLOW_ID(p_code IN VARCHAR2) RETURN NUMBER IS
27: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE := NULL;
28: BEGIN
29: SELECT flow_id
30: INTO l_flow_id
31: FROM JTS_SETUP_FLOWS_B

Line 31: FROM JTS_SETUP_FLOWS_B

27: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE := NULL;
28: BEGIN
29: SELECT flow_id
30: INTO l_flow_id
31: FROM JTS_SETUP_FLOWS_B
32: WHERE flow_code = p_code;
33: return (l_flow_id);
34: EXCEPTION
35: WHEN NO_DATA_FOUND THEN

Line 65: l_parent_id JTS_SETUP_FLOWS_B.parent_id%TYPE;

61: p_last_updated_by IN NUMBER,
62: p_last_update_login IN NUMBER,
63: x_flow_id OUT NUMBER
64: ) IS
65: l_parent_id JTS_SETUP_FLOWS_B.parent_id%TYPE;
66: BEGIN
67:
68: x_flow_id := get_next_flow_id;
69:

Line 72: insert into JTS_SETUP_FLOWS_B (

68: x_flow_id := get_next_flow_id;
69:
70: l_parent_id := get_flow_id(p_parent_code);
71:
72: insert into JTS_SETUP_FLOWS_B (
73: FLOW_ID,
74: FLOW_CODE,
75: FLOW_TYPE,
76: PARENT_ID,

Line 152: DELETE FROM jts_setup_flows_b

148: -- Deletes a flow based on flow_code
149: -------------------------------------------------
150: PROCEDURE DELETE_ROW(p_flow_code IN VARCHAR2) IS
151: BEGIN
152: DELETE FROM jts_setup_flows_b
153: WHERE flow_code = p_flow_code;
154:
155: DELETE FROM jts_setup_flows_tl
156: WHERE flow_code = p_flow_code;

Line 170: DELETE FROM jts_setup_flows_b

166: -- Deletes a flow based on flow_id
167: -------------------------------------------------
168: PROCEDURE DELETE_ROW(p_flow_id IN NUMBER) IS
169: BEGIN
170: DELETE FROM jts_setup_flows_b
171: WHERE flow_id = p_flow_id;
172:
173: DELETE FROM jts_setup_flows_tl
174: WHERE flow_id = p_flow_id;

Line 206: l_parent_id JTS_SETUP_FLOWS_B.parent_id%TYPE;

202: P_LAST_UPDATE_DATE in DATE,
203: P_LAST_UPDATED_BY in NUMBER,
204: P_LAST_UPDATE_LOGIN in NUMBER
205: ) is
206: l_parent_id JTS_SETUP_FLOWS_B.parent_id%TYPE;
207: begin
208: l_parent_id := get_flow_id(p_parent_code);
209:
210: update JTS_SETUP_FLOWS_B set

Line 210: update JTS_SETUP_FLOWS_B set

206: l_parent_id JTS_SETUP_FLOWS_B.parent_id%TYPE;
207: begin
208: l_parent_id := get_flow_id(p_parent_code);
209:
210: update JTS_SETUP_FLOWS_B set
211: FLOW_TYPE = P_FLOW_TYPE,
212: PARENT_ID = L_PARENT_ID,
213: HAS_CHILD_FLAG = P_HAS_CHILD_FLAG,
214: FLOW_SEQUENCE = P_FLOW_SEQUENCE,

Line 294: l_user_id JTS_SETUP_FLOWS_B.created_by%TYPE := 0;

290: P_DPF_ASN in VARCHAR2,
291: P_FLOW_NAME IN VARCHAR2
292: )
293: IS
294: l_user_id JTS_SETUP_FLOWS_B.created_by%TYPE := 0;
295: l_count number := 0;
296: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;
297:
298: BEGIN

Line 296: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;

292: )
293: IS
294: l_user_id JTS_SETUP_FLOWS_B.created_by%TYPE := 0;
295: l_count number := 0;
296: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;
297:
298: BEGIN
299: if P_OWNER = 'SEED' then
300: l_user_id := 1;

Line 305: from jts_setup_flows_b

301: end if;
302:
303: select count(*)
304: into l_count
305: from jts_setup_flows_b
306: where flow_code = p_flow_code;
307:
308:
309: IF (l_count = 0) THEN --no flow with p_flow_code exists. Use p_flow_code to insert a new row

Line 382: from JTS_SETUP_FLOWS_B

378: DPF_ASN,
379: NUM_STEPS,
380: SECURITY_GROUP_ID,
381: OBJECT_VERSION_NUMBER
382: from JTS_SETUP_FLOWS_B
383: where FLOW_ID = X_FLOW_ID
384: and FLOW_CODE = X_FLOW_CODE
385: for update of FLOW_ID nowait;
386: recinfo c%rowtype;

Line 453: from JTS_SETUP_FLOWS_B B

449: begin
450: delete from JTS_SETUP_FLOWS_TL T
451: where not exists
452: (select NULL
453: from JTS_SETUP_FLOWS_B B
454: where B.FLOW_ID = T.FLOW_ID
455: and B.FLOW_CODE = T.FLOW_CODE
456: );
457: