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 2990: l_cursor := DBMS_SQL.OPEN_CURSOR;

2986: 'and it.organization_id = :l_org_id '||
2987: 'and ic.category_set_id = :l_prof_val '||
2988: 'and upper(it.description) = upper(:l_name) ';
2989:
2990: l_cursor := DBMS_SQL.OPEN_CURSOR;
2991: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
2992: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
2993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
2994: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);

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

2987: 'and ic.category_set_id = :l_prof_val '||
2988: 'and upper(it.description) = upper(:l_name) ';
2989:
2990: l_cursor := DBMS_SQL.OPEN_CURSOR;
2991: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
2992: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
2993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
2994: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
2995: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);

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

2988: 'and upper(it.description) = upper(:l_name) ';
2989:
2990: l_cursor := DBMS_SQL.OPEN_CURSOR;
2991: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
2992: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
2993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
2994: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
2995: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
2996: ignore := DBMS_SQL.EXECUTE(l_cursor);

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

2989:
2990: l_cursor := DBMS_SQL.OPEN_CURSOR;
2991: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
2992: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
2993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
2994: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
2995: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
2996: ignore := DBMS_SQL.EXECUTE(l_cursor);
2997:

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

2990: l_cursor := DBMS_SQL.OPEN_CURSOR;
2991: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
2992: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
2993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
2994: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
2995: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
2996: ignore := DBMS_SQL.EXECUTE(l_cursor);
2997:
2998: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN

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

2991: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
2992: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
2993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
2994: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
2995: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
2996: ignore := DBMS_SQL.EXECUTE(l_cursor);
2997:
2998: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
2999: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);

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

2992: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
2993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'));
2994: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
2995: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
2996: ignore := DBMS_SQL.EXECUTE(l_cursor);
2997:
2998: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
2999: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3000: DBMS_SQL.CLOSE_CURSOR(l_cursor);

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

2994: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
2995: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
2996: ignore := DBMS_SQL.EXECUTE(l_cursor);
2997:
2998: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
2999: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3000: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3001: RETURN OKAY_STATUS;
3002: ELSE

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

2995: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
2996: ignore := DBMS_SQL.EXECUTE(l_cursor);
2997:
2998: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
2999: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3000: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3001: RETURN OKAY_STATUS;
3002: ELSE
3003: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 3000: DBMS_SQL.CLOSE_CURSOR(l_cursor);

2996: ignore := DBMS_SQL.EXECUTE(l_cursor);
2997:
2998: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
2999: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3000: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3001: RETURN OKAY_STATUS;
3002: ELSE
3003: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3004: RETURN ERROR_STATUS;

Line 3003: DBMS_SQL.CLOSE_CURSOR(l_cursor);

2999: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3000: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3001: RETURN OKAY_STATUS;
3002: ELSE
3003: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3004: RETURN ERROR_STATUS;
3005: END IF;
3006:
3007: EXCEPTION

Line 3072: l_cursor := DBMS_SQL.OPEN_CURSOR;

3068: 'and it.organization_id = :l_org_id '||
3069: 'and ic.category_set_id = :l_prof_val '||
3070: 'and upper(it.description) = upper(:l_name) ';
3071:
3072: l_cursor := DBMS_SQL.OPEN_CURSOR;
3073: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3074: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3075: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3076: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);

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

3069: 'and ic.category_set_id = :l_prof_val '||
3070: 'and upper(it.description) = upper(:l_name) ';
3071:
3072: l_cursor := DBMS_SQL.OPEN_CURSOR;
3073: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3074: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3075: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3076: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3077: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);

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

3070: 'and upper(it.description) = upper(:l_name) ';
3071:
3072: l_cursor := DBMS_SQL.OPEN_CURSOR;
3073: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3074: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3075: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3076: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3077: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3078: ignore := DBMS_SQL.EXECUTE(l_cursor);

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

3071:
3072: l_cursor := DBMS_SQL.OPEN_CURSOR;
3073: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3074: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3075: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3076: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3077: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3078: ignore := DBMS_SQL.EXECUTE(l_cursor);
3079:

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

3072: l_cursor := DBMS_SQL.OPEN_CURSOR;
3073: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3074: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3075: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3076: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3077: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3078: ignore := DBMS_SQL.EXECUTE(l_cursor);
3079:
3080: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN

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

3073: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
3074: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3075: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3076: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3077: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3078: ignore := DBMS_SQL.EXECUTE(l_cursor);
3079:
3080: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3081: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);

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

3074: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_org_id', cs_std.get_item_valdn_orgzn_id);
3075: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_prof_val', fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'));
3076: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3077: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3078: ignore := DBMS_SQL.EXECUTE(l_cursor);
3079:
3080: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3081: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3082: DBMS_SQL.CLOSE_CURSOR(l_cursor);

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

3076: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_name', p_name);
3077: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3078: ignore := DBMS_SQL.EXECUTE(l_cursor);
3079:
3080: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3081: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3082: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3083: RETURN OKAY_STATUS;
3084: ELSE

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

3077: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_number);
3078: ignore := DBMS_SQL.EXECUTE(l_cursor);
3079:
3080: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3081: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3082: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3083: RETURN OKAY_STATUS;
3084: ELSE
3085: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 3082: DBMS_SQL.CLOSE_CURSOR(l_cursor);

3078: ignore := DBMS_SQL.EXECUTE(l_cursor);
3079:
3080: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
3081: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3082: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3083: RETURN OKAY_STATUS;
3084: ELSE
3085: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3086: RETURN ERROR_STATUS;

Line 3085: DBMS_SQL.CLOSE_CURSOR(l_cursor);

3081: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_number);
3082: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3083: RETURN OKAY_STATUS;
3084: ELSE
3085: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3086: RETURN ERROR_STATUS;
3087: END IF;
3088:
3089: EXCEPTION