APPS.CS_KB_WF_PKG dependencies on CS_LOOKUPS

Line 59: returnValue CS_LOOKUPS.MEANING%TYPE;

55: g_action IN VARCHAR2
56: )
57: RETURN VARCHAR2
58: IS
59: returnValue CS_LOOKUPS.MEANING%TYPE;
60: BEGIN
61: SELECT
62: MAX(MEANING)
63: INTO

Line 66: CS_LOOKUPS

62: MAX(MEANING)
63: INTO
64: returnValue
65: FROM
66: CS_LOOKUPS
67: WHERE
68: lookup_code = g_action
69: AND
70: lookup_type = 'CS_KB_INTERNAL_CODES';

Line 117: returnValue CS_LOOKUPS.MEANING%TYPE;

113: g_setId IN NUMBER
114: )
115: RETURN VARCHAR2
116: IS
117: returnValue CS_LOOKUPS.MEANING%TYPE;
118: BEGIN
119: SELECT
120: MAX(DECODE(B.STATUS,'NOT',LU2.MEANING,LU1.MEANING))
121: INTO

Line 126: CS_LOOKUPS LU1,

122: returnValue
123: FROM
124: cs_kb_sets_b B,
125: cs_kb_wf_flow_details D,
126: CS_LOOKUPS LU1,
127: CS_LOOKUPS LU2
128: WHERE
129: B.flow_details_id = D.flow_details_id (+)
130: AND

Line 127: CS_LOOKUPS LU2

123: FROM
124: cs_kb_sets_b B,
125: cs_kb_wf_flow_details D,
126: CS_LOOKUPS LU1,
127: CS_LOOKUPS LU2
128: WHERE
129: B.flow_details_id = D.flow_details_id (+)
130: AND
131: B.status = LU1.lookup_code

Line 428: FROM CS_LOOKUPS

424: where flow_details_id = p_flow_details_id;
425:
426: SELECT MAX(MEANING)
427: INTO x_step_meaning
428: FROM CS_LOOKUPS
429: WHERE lookup_code = x_step_code
430: AND lookup_type = 'CS_KB_STATUS';
431:
432: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'FLOWSTEP', x_step_meaning);

Line 1084: SQL1 VARCHAR2(1000) := 'SELECT DISTINCT CS_LOOKUPS.LOOKUP_CODE, CS_LOOKUPS.MEANING FROM CS_LOOKUPS ';

1080:
1081: steps INTEGER;
1082: cursorReturn INTEGER;
1083:
1084: SQL1 VARCHAR2(1000) := 'SELECT DISTINCT CS_LOOKUPS.LOOKUP_CODE, CS_LOOKUPS.MEANING FROM CS_LOOKUPS ';
1085: SQL2 VARCHAR2(1000) := ' WHERE CS_LOOKUPS.LOOKUP_TYPE = :T AND TRUNC(SYSDATE) BETWEEN Trunc(NVL(start_date_active,sysdate)) AND Trunc(NVL(end_date_active,sysdate)) AND enabled_flag = ''Y'''; --5198112
1086: SQL3 VARCHAR2(100) := ' ORDER BY CS_LOOKUPS.MEANING ';
1087:
1088: -- Temp variables.

Line 1085: SQL2 VARCHAR2(1000) := ' WHERE CS_LOOKUPS.LOOKUP_TYPE = :T AND TRUNC(SYSDATE) BETWEEN Trunc(NVL(start_date_active,sysdate)) AND Trunc(NVL(end_date_active,sysdate)) AND enabled_flag = ''Y'''; --5198112

1081: steps INTEGER;
1082: cursorReturn INTEGER;
1083:
1084: SQL1 VARCHAR2(1000) := 'SELECT DISTINCT CS_LOOKUPS.LOOKUP_CODE, CS_LOOKUPS.MEANING FROM CS_LOOKUPS ';
1085: SQL2 VARCHAR2(1000) := ' WHERE CS_LOOKUPS.LOOKUP_TYPE = :T AND TRUNC(SYSDATE) BETWEEN Trunc(NVL(start_date_active,sysdate)) AND Trunc(NVL(end_date_active,sysdate)) AND enabled_flag = ''Y'''; --5198112
1086: SQL3 VARCHAR2(100) := ' ORDER BY CS_LOOKUPS.MEANING ';
1087:
1088: -- Temp variables.
1089: st CS_LOOKUPS.LOOKUP_CODE%TYPE; -- temp step.

Line 1086: SQL3 VARCHAR2(100) := ' ORDER BY CS_LOOKUPS.MEANING ';

1082: cursorReturn INTEGER;
1083:
1084: SQL1 VARCHAR2(1000) := 'SELECT DISTINCT CS_LOOKUPS.LOOKUP_CODE, CS_LOOKUPS.MEANING FROM CS_LOOKUPS ';
1085: SQL2 VARCHAR2(1000) := ' WHERE CS_LOOKUPS.LOOKUP_TYPE = :T AND TRUNC(SYSDATE) BETWEEN Trunc(NVL(start_date_active,sysdate)) AND Trunc(NVL(end_date_active,sysdate)) AND enabled_flag = ''Y'''; --5198112
1086: SQL3 VARCHAR2(100) := ' ORDER BY CS_LOOKUPS.MEANING ';
1087:
1088: -- Temp variables.
1089: st CS_LOOKUPS.LOOKUP_CODE%TYPE; -- temp step.
1090: na CS_LOOKUPS.MEANING%TYPE; -- temp names

Line 1089: st CS_LOOKUPS.LOOKUP_CODE%TYPE; -- temp step.

1085: SQL2 VARCHAR2(1000) := ' WHERE CS_LOOKUPS.LOOKUP_TYPE = :T AND TRUNC(SYSDATE) BETWEEN Trunc(NVL(start_date_active,sysdate)) AND Trunc(NVL(end_date_active,sysdate)) AND enabled_flag = ''Y'''; --5198112
1086: SQL3 VARCHAR2(100) := ' ORDER BY CS_LOOKUPS.MEANING ';
1087:
1088: -- Temp variables.
1089: st CS_LOOKUPS.LOOKUP_CODE%TYPE; -- temp step.
1090: na CS_LOOKUPS.MEANING%TYPE; -- temp names
1091:
1092: -- Counter variable.
1093: counter NUMBER := 1;

Line 1090: na CS_LOOKUPS.MEANING%TYPE; -- temp names

1086: SQL3 VARCHAR2(100) := ' ORDER BY CS_LOOKUPS.MEANING ';
1087:
1088: -- Temp variables.
1089: st CS_LOOKUPS.LOOKUP_CODE%TYPE; -- temp step.
1090: na CS_LOOKUPS.MEANING%TYPE; -- temp names
1091:
1092: -- Counter variable.
1093: counter NUMBER := 1;
1094:

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);