APPS.CSM_QUERY_PKG dependencies on CSM_QUERY_VARIABLES_B

Line 273: INSERT INTO CSM_QUERY_VARIABLES_B ( QUERY_ID, VARIABLE_ID, VARIABLE_NAME,

269:
270: FOR i in 1..l_variable_count LOOP
271: --Insert the Query Variable Definition into the base table
272: l_VARIABLE_VALUE_CHAR := SUBSTR(p_VARIABLE_VALUE_CHAR(i),1, 4000);
273: INSERT INTO CSM_QUERY_VARIABLES_B ( QUERY_ID, VARIABLE_ID, VARIABLE_NAME,
274: VARIABLE_TYPE, VARIABLE_VALUE_CHAR, VARIABLE_VALUE_DATE,
275: HIDDEN, DEFAULT_FLAG, CREATION_DATE,
276: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
277: LAST_UPDATE_LOGIN )

Line 345: FROM CSM_QUERY_VARIABLES_B

341: AS
342: CURSOR c_get_existing_var_count(c_query_id NUMBER) --get the count of existing variables
343: IS
344: SELECT count(*)
345: FROM CSM_QUERY_VARIABLES_B
346: WHERE QUERY_ID =c_query_id ;
347:
348: CURSOR c_get_query(c_query_id NUMBER) --get the existing query data
349: IS

Line 589: DELETE FROM CSM_QUERY_VARIABLES_B WHERE QUERY_ID =p_QUERY_ID;

585: IF l_Existing_variable_count <> l_variable_count THEN
586:
587: IF l_Existing_variable_count > 0 THEN
588: --Delete all the existing variables and insert again
589: DELETE FROM CSM_QUERY_VARIABLES_B WHERE QUERY_ID =p_QUERY_ID;
590: END IF;
591: FOR i in 1..l_variable_count LOOP
592: --Insert the Query Variable Definition into the base table
593: l_VARIABLE_VALUE_CHAR := SUBSTR(p_VARIABLE_VALUE_CHAR(i),1, 4000);

Line 594: INSERT INTO CSM_QUERY_VARIABLES_B ( QUERY_ID, VARIABLE_ID, VARIABLE_NAME,

590: END IF;
591: FOR i in 1..l_variable_count LOOP
592: --Insert the Query Variable Definition into the base table
593: l_VARIABLE_VALUE_CHAR := SUBSTR(p_VARIABLE_VALUE_CHAR(i),1, 4000);
594: INSERT INTO CSM_QUERY_VARIABLES_B ( QUERY_ID, VARIABLE_ID, VARIABLE_NAME,
595: VARIABLE_TYPE, VARIABLE_VALUE_CHAR, VARIABLE_VALUE_DATE,
596: HIDDEN, DEFAULT_FLAG, CREATION_DATE,
597: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
598: LAST_UPDATE_LOGIN )

Line 613: UPDATE CSM_QUERY_VARIABLES_B

609: --Update the Existing Variable as they are changed
610: FOR i in 1..l_variable_count LOOP
611: --Insert the Query Variable Definition into the base table
612: l_VARIABLE_VALUE_CHAR := SUBSTR(p_VARIABLE_VALUE_CHAR(i),1, 4000);
613: UPDATE CSM_QUERY_VARIABLES_B
614: SET VARIABLE_NAME = p_VARIABLE_NAME(i),
615: VARIABLE_TYPE = p_VARIABLE_TYPE(i),
616: VARIABLE_VALUE_CHAR = l_VARIABLE_VALUE_CHAR,
617: VARIABLE_VALUE_DATE = p_VARIABLE_VALUE_DATE(i),

Line 837: CSM_QUERY_VARIABLES_B vb

833: vb.VARIABLE_NAME
834: FROM
835: CSM_QUERY_INSTANCES_ACC iacc,
836: CSM_QUERY_VARIABLE_VALUES_ACC vacc,
837: CSM_QUERY_VARIABLES_B vb
838: WHERE iacc.USER_ID = vacc.USER_ID
839: AND iacc.QUERY_ID = vacc.QUERY_ID
840: AND iacc.INSTANCE_ID = vacc.INSTANCE_ID
841: AND vacc.QUERY_ID = vb.QUERY_ID

Line 1212: FROM CSM_QUERY_VARIABLES_B vb

1208: SELECT vb.VARIABLE_ID,
1209: vb.VARIABLE_VALUE_CHAR,
1210: vb.VARIABLE_VALUE_DATE,
1211: vb.VARIABLE_TYPE
1212: FROM CSM_QUERY_VARIABLES_B vb
1213: WHERE vb.QUERY_ID = c_QUERY_ID;
1214:
1215: CURSOR c_get_next_instance
1216: IS