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.CS_KNOWLEDGE_AUDIT_PVT dependencies on DBMS_SQL

Line 3000: l_cursor := DBMS_SQL.OPEN_CURSOR;

2996: 'and it.organization_id = :l_org_id '||
2997: 'and ic.category_set_id = :l_prof_val '||
2998: 'and upper(it.description) = upper(:l_name) ';
2999:
3000: l_cursor := DBMS_SQL.OPEN_CURSOR;
3001: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3002: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3003: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
3004: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);

Line 3001: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);

2997: 'and ic.category_set_id = :l_prof_val '||
2998: 'and upper(it.description) = upper(:l_name) ';
2999:
3000: l_cursor := DBMS_SQL.OPEN_CURSOR;
3001: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3002: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3003: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
3004: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3005: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);

Line 3002: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);

2998: 'and upper(it.description) = upper(:l_name) ';
2999:
3000: l_cursor := DBMS_SQL.OPEN_CURSOR;
3001: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3002: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3003: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
3004: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3005: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3006: ignore := DBMS_SQL.EXECUTE(l_cursor);

Line 3003: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));

2999:
3000: l_cursor := DBMS_SQL.OPEN_CURSOR;
3001: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3002: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3003: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
3004: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3005: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3006: ignore := DBMS_SQL.EXECUTE(l_cursor);
3007:

Line 3004: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);

3000: l_cursor := DBMS_SQL.OPEN_CURSOR;
3001: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3002: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3003: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
3004: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3005: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3006: ignore := DBMS_SQL.EXECUTE(l_cursor);
3007:
3008: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN

Line 3005: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);

3001: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3002: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3003: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
3004: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3005: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3006: ignore := DBMS_SQL.EXECUTE(l_cursor);
3007:
3008: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3009: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);

Line 3006: ignore := DBMS_SQL.EXECUTE(l_cursor);

3002: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3003: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
3004: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3005: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3006: ignore := DBMS_SQL.EXECUTE(l_cursor);
3007:
3008: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3009: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3010: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 3008: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN

3004: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3005: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3006: ignore := DBMS_SQL.EXECUTE(l_cursor);
3007:
3008: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3009: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3010: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3011: RETURN OKAY_STATUS;
3012: ELSE

Line 3009: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);

3005: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3006: ignore := DBMS_SQL.EXECUTE(l_cursor);
3007:
3008: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3009: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3010: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3011: RETURN OKAY_STATUS;
3012: ELSE
3013: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 3010: DBMS_SQL.CLOSE_CURSOR(l_cursor);

3006: ignore := DBMS_SQL.EXECUTE(l_cursor);
3007:
3008: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3009: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3010: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3011: RETURN OKAY_STATUS;
3012: ELSE
3013: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3014: RETURN ERROR_STATUS;

Line 3013: DBMS_SQL.CLOSE_CURSOR(l_cursor);

3009: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3010: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3011: RETURN OKAY_STATUS;
3012: ELSE
3013: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3014: RETURN ERROR_STATUS;
3015: END IF;
3016:
3017: EXCEPTION

Line 3082: l_cursor := DBMS_SQL.OPEN_CURSOR;

3078: 'and it.organization_id = :l_org_id '||
3079: 'and ic.category_set_id = :l_prof_val '||
3080: 'and upper(it.description) = upper(:l_name) ';
3081:
3082: l_cursor := DBMS_SQL.OPEN_CURSOR;
3083: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3084: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3085: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3086: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);

Line 3083: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);

3079: 'and ic.category_set_id = :l_prof_val '||
3080: 'and upper(it.description) = upper(:l_name) ';
3081:
3082: l_cursor := DBMS_SQL.OPEN_CURSOR;
3083: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3084: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3085: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3086: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3087: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);

Line 3084: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);

3080: 'and upper(it.description) = upper(:l_name) ';
3081:
3082: l_cursor := DBMS_SQL.OPEN_CURSOR;
3083: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3084: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3085: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3086: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3087: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3088: ignore := DBMS_SQL.EXECUTE(l_cursor);

Line 3085: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));

3081:
3082: l_cursor := DBMS_SQL.OPEN_CURSOR;
3083: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3084: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3085: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3086: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3087: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3088: ignore := DBMS_SQL.EXECUTE(l_cursor);
3089:

Line 3086: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);

3082: l_cursor := DBMS_SQL.OPEN_CURSOR;
3083: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3084: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3085: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3086: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3087: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3088: ignore := DBMS_SQL.EXECUTE(l_cursor);
3089:
3090: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN

Line 3087: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);

3083: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3084: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3085: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3086: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3087: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3088: ignore := DBMS_SQL.EXECUTE(l_cursor);
3089:
3090: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3091: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);

Line 3088: ignore := DBMS_SQL.EXECUTE(l_cursor);

3084: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3085: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3086: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3087: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3088: ignore := DBMS_SQL.EXECUTE(l_cursor);
3089:
3090: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3091: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3092: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 3090: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN

3086: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3087: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3088: ignore := DBMS_SQL.EXECUTE(l_cursor);
3089:
3090: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3091: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3092: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3093: RETURN OKAY_STATUS;
3094: ELSE

Line 3091: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);

3087: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3088: ignore := DBMS_SQL.EXECUTE(l_cursor);
3089:
3090: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3091: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3092: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3093: RETURN OKAY_STATUS;
3094: ELSE
3095: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 3092: DBMS_SQL.CLOSE_CURSOR(l_cursor);

3088: ignore := DBMS_SQL.EXECUTE(l_cursor);
3089:
3090: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3091: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3092: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3093: RETURN OKAY_STATUS;
3094: ELSE
3095: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3096: RETURN ERROR_STATUS;

Line 3095: DBMS_SQL.CLOSE_CURSOR(l_cursor);

3091: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3092: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3093: RETURN OKAY_STATUS;
3094: ELSE
3095: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3096: RETURN ERROR_STATUS;
3097: END IF;
3098:
3099: EXCEPTION