DBA Data[Home] [Help]

APPS.MSD_CS_COLLECTION dependencies on MSD_CS_COLL_PARAMETERS

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

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

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

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