APPS.JTS_FLOW_STEPS_PKG dependencies on JTS_FLOW_STEPS_B

Line 14: l_step_id JTS_FLOW_STEPS_B.step_id%TYPE;

10: -- --------------------------------------------------------------------
11:
12:
13: FUNCTION GET_NEXT_STEP_ID RETURN NUMBER IS
14: l_step_id JTS_FLOW_STEPS_B.step_id%TYPE;
15: BEGIN
16: SELECT jts.jts_flow_steps_b_s.nextval
17: INTO l_step_id
18: FROM sys.dual;

Line 16: SELECT jts.jts_flow_steps_b_s.nextval

12:
13: FUNCTION GET_NEXT_STEP_ID RETURN NUMBER IS
14: l_step_id JTS_FLOW_STEPS_B.step_id%TYPE;
15: BEGIN
16: SELECT jts.jts_flow_steps_b_s.nextval
17: INTO l_step_id
18: FROM sys.dual;
19:
20: return (l_step_id);

Line 48: insert into JTS_FLOW_STEPS_B (

44: BEGIN
45:
46: x_step_id := get_next_step_id;
47:
48: insert into JTS_FLOW_STEPS_B (
49: SETUP_PAGE,
50: STEP_ID,
51: FLOW_ID,
52: MANDATORY_FLAG,

Line 118: DELETE FROM jts_flow_steps_b

114: -- Deletes a step based on step_id
115: -------------------------------------------------
116: PROCEDURE DELETE_ROW(p_step_id IN NUMBER) IS
117: BEGIN
118: DELETE FROM jts_flow_steps_b
119: WHERE step_id = p_step_id;
120:
121: DELETE FROM jts_flow_steps_tl
122: WHERE step_id = p_step_id;

Line 154: update JTS_FLOW_STEPS_B set

150: P_LAST_UPDATE_LOGIN in NUMBER
151: ) is
152: begin
153:
154: update JTS_FLOW_STEPS_B set
155: SETUP_PAGE = P_SETUP_PAGE,
156: FLOW_ID = P_FLOW_ID,
157: MANDATORY_FLAG = P_MANDATORY_FLAG,
158: CONCURRENT_FLAG = P_CONCURRENT_FLAG,

Line 238: l_user_id JTS_FLOW_STEPS_B.created_by%TYPE := 0;

234: p_description IN VARCHAR2,
235: P_impact in VARCHAR2
236: )
237: IS
238: l_user_id JTS_FLOW_STEPS_B.created_by%TYPE := 0;
239: l_count number := 0;
240: l_step_id JTS_FLOW_STEPS_B.step_id%TYPE;
241:
242: BEGIN

Line 240: l_step_id JTS_FLOW_STEPS_B.step_id%TYPE;

236: )
237: IS
238: l_user_id JTS_FLOW_STEPS_B.created_by%TYPE := 0;
239: l_count number := 0;
240: l_step_id JTS_FLOW_STEPS_B.step_id%TYPE;
241:
242: BEGIN
243: if P_OWNER = 'SEED' then
244: l_user_id := 1;

Line 249: from jts_flow_steps_b

245: end if;
246:
247: select count(*)
248: into l_count
249: from jts_flow_steps_b
250: where step_id = p_step_id;
251:
252:
253: IF (l_count = 0) THEN --no step with step_id exists. Use p_step_id to insert a new row

Line 315: from JTS_FLOW_STEPS_B

311: CONCURRENT_FLAG,
312: STEP_SEQUENCE,
313: SECURITY_GROUP_ID,
314: SETUP_PAGE
315: from JTS_FLOW_STEPS_B
316: where STEP_ID = X_STEP_ID
317: for update of STEP_ID nowait;
318: recinfo c%rowtype;
319:

Line 378: from JTS_FLOW_STEPS_B B

374: begin
375: delete from JTS_FLOW_STEPS_TL T
376: where not exists
377: (select NULL
378: from JTS_FLOW_STEPS_B B
379: where B.STEP_ID = T.STEP_ID
380: );
381:
382: update JTS_FLOW_STEPS_TL T set (