APPS.CS_KB_WF_PKG dependencies on CS_KB_WF_FLOW_DETAILS_S

Line 850: sta CS_KB_WF_FLOW_DETAILS.step%TYPE; -- temp step

846:
847: -- Temp variables.
848: did CS_KB_WF_FLOW_DETAILS.flow_details_id%TYPE; -- temp flow details id.
849: orn NUMBER; -- temp order number
850: sta CS_KB_WF_FLOW_DETAILS.step%TYPE; -- temp step
851: gid NUMBER; -- temp group id
852: act CS_KB_WF_FLOW_DETAILS.action%TYPE; -- temp action
853: counter NUMBER := 1;
854: BEGIN

Line 1099: SQL2 := SQL2 || ' AND CS_KB_WF_FLOW_DETAILS.STEP = CS_LOOKUPS.LOOKUP_CODE AND CS_KB_WF_FLOW_DETAILS.ACTION = :N ';

1095: BEGIN
1096:
1097: IF(p_restriction = 1) THEN
1098: SQL1 := SQL1 || ' ,CS_KB_WF_FLOW_DETAILS ';
1099: SQL2 := SQL2 || ' AND CS_KB_WF_FLOW_DETAILS.STEP = CS_LOOKUPS.LOOKUP_CODE AND CS_KB_WF_FLOW_DETAILS.ACTION = :N ';
1100: END IF;
1101: -- open and parse statement
1102: steps := DBMS_SQL.OPEN_CURSOR;
1103: DBMS_SQL.PARSE(steps, SQL1||SQL2||SQL3, DBMS_SQL.V7);

Line 1367: cs_kb_wf_flow_details_s.NextVal

1363: BEGIN
1364:
1365: -- Get next available details id number
1366: SELECT
1367: cs_kb_wf_flow_details_s.NextVal
1368: INTO
1369: p_flow_details_id
1370: FROM
1371: DUAL;