DBA Data[Home] [Help]

APPS.MSD_CS_COLLECTION dependencies on MSD_CS_COLL_PARAMETERS

Line 1752: select count(1) into l_count from msd_cs_coll_parameters

1748:
1749: IF l_multi_flag = 'Y' THEN
1750: /* If multi input parar then check whether user entered
1751: any values for the multi input parameters */
1752: select count(1) into l_count from msd_cs_coll_parameters
1753: where conc_request_id = p_request_id and
1754: parameter_number = p_para_num;
1755: /* If user hasn't entered any multi input parameters then
1756: use user specified default column name */

Line 1763: ' (SELECT parameter_code FROM msd_cs_coll_parameters ' ||

1759: l_default_col ||
1760: substr(p_where_cond, end_pos + 1);
1761: ELSE
1762: p_where_cond := substr(p_where_cond, 1, start_pos - 2) ||
1763: ' (SELECT parameter_code FROM msd_cs_coll_parameters ' ||
1764: ' WHERE conc_request_id = ' || p_request_id ||
1765: ' AND parameter_number = ' || p_para_num || ' ) ' ||
1766: substr(p_where_cond, end_pos + 1);
1767: END IF;