eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on DBMS_SQL

Line 2164: l_cursor := dbms_sql.open_cursor;

2160: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2161: 'act_val:' || l_action_value);
2162: END IF;
2163:
2164: l_cursor := dbms_sql.open_cursor;
2165: dbms_sql.parse(l_cursor, l_action, dbms_sql.native);
2166:
2167: IF p_process_type = G_LEAD_RATING
2168: THEN

Line 2165: dbms_sql.parse(l_cursor, l_action, dbms_sql.native);

2161: 'act_val:' || l_action_value);
2162: END IF;
2163:
2164: l_cursor := dbms_sql.open_cursor;
2165: dbms_sql.parse(l_cursor, l_action, dbms_sql.native);
2166:
2167: IF p_process_type = G_LEAD_RATING
2168: THEN
2169: l_lead_rank_id := TO_NUMBER(l_action_value);

Line 2170: dbms_sql.bind_variable(l_cursor, ':lead_rank_id', l_lead_rank_id);

2166:
2167: IF p_process_type = G_LEAD_RATING
2168: THEN
2169: l_lead_rank_id := TO_NUMBER(l_action_value);
2170: dbms_sql.bind_variable(l_cursor, ':lead_rank_id', l_lead_rank_id);
2171: ELSIF p_process_type = G_CHANNEL_SELECTION
2172: THEN
2173: -- CHANNEL_SELECTION
2174: dbms_sql.bind_variable(l_cursor, ':channel_code', l_action_value);

Line 2174: dbms_sql.bind_variable(l_cursor, ':channel_code', l_action_value);

2170: dbms_sql.bind_variable(l_cursor, ':lead_rank_id', l_lead_rank_id);
2171: ELSIF p_process_type = G_CHANNEL_SELECTION
2172: THEN
2173: -- CHANNEL_SELECTION
2174: dbms_sql.bind_variable(l_cursor, ':channel_code', l_action_value);
2175: -- ckapoor : disqualification project
2176: ELSIF p_process_type = G_LEAD_QUALIFICATION --qualification case
2177: THEN
2178:

Line 2179: dbms_sql.bind_variable(l_cursor, ':qualified_flag',l_action_value);

2175: -- ckapoor : disqualification project
2176: ELSIF p_process_type = G_LEAD_QUALIFICATION --qualification case
2177: THEN
2178:
2179: dbms_sql.bind_variable(l_cursor, ':qualified_flag',l_action_value);
2180: -- end ckapoor
2181:
2182: END IF;
2183: dbms_sql.bind_variable(l_cursor, ':sales_lead_id',

Line 2183: dbms_sql.bind_variable(l_cursor, ':sales_lead_id',

2179: dbms_sql.bind_variable(l_cursor, ':qualified_flag',l_action_value);
2180: -- end ckapoor
2181:
2182: END IF;
2183: dbms_sql.bind_variable(l_cursor, ':sales_lead_id',
2184: p_sales_lead_id);
2185: l_rows_inserted := dbms_sql.execute(l_cursor);
2186: dbms_sql.close_cursor(l_cursor);
2187: x_action_value := l_action_value;

Line 2185: l_rows_inserted := dbms_sql.execute(l_cursor);

2181:
2182: END IF;
2183: dbms_sql.bind_variable(l_cursor, ':sales_lead_id',
2184: p_sales_lead_id);
2185: l_rows_inserted := dbms_sql.execute(l_cursor);
2186: dbms_sql.close_cursor(l_cursor);
2187: x_action_value := l_action_value;
2188: ELSE
2189: -- no rules matched

Line 2186: dbms_sql.close_cursor(l_cursor);

2182: END IF;
2183: dbms_sql.bind_variable(l_cursor, ':sales_lead_id',
2184: p_sales_lead_id);
2185: l_rows_inserted := dbms_sql.execute(l_cursor);
2186: dbms_sql.close_cursor(l_cursor);
2187: x_action_value := l_action_value;
2188: ELSE
2189: -- no rules matched
2190: IF p_process_type = G_LEAD_RATING