APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_STD

Line 2508: l_set_product_org_ids(i) := cs_std.get_item_valdn_orgzn_id;

2504:
2505: -- Populate org id table
2506: l_set_product_org_ids.extend(p_set_product_ids.count);
2507: for i in 1..l_set_product_org_ids.count loop
2508: l_set_product_org_ids(i) := cs_std.get_item_valdn_orgzn_id;
2509: end loop;
2510:
2511: -- link the set to products
2512: cs_kb_assoc_pkg.add_link(p_item_id => p_set_product_ids,

Line 2527: l_set_platform_org_ids(i) := cs_std.get_item_valdn_orgzn_id;

2523: -- Populate org id table
2524: l_set_platform_org_ids.extend(p_set_platform_ids.count);
2525:
2526: for i in 1..l_set_platform_org_ids.count loop
2527: l_set_platform_org_ids(i) := cs_std.get_item_valdn_orgzn_id;
2528: end loop;
2529:
2530: -- link the set to platforms
2531: cs_kb_assoc_pkg.add_link(p_item_id => p_set_platform_ids,

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 3040: open cur_segments(cs_std.get_item_valdn_orgzn_id,

3036: and it.organization_id = cp_org_id
3037: and ic.category_set_id = cp_prof_val
3038: and upper(it.concatenated_segments) = upper(cp_segments) ;
3039: BEGIN
3040: open cur_segments(cs_std.get_item_valdn_orgzn_id,
3041: fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'),
3042: p_segment);
3043: fetch cur_segments into x_number;
3044: if cur_segments%NOTFOUND then

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 3123: open cur_segments(cs_std.get_item_valdn_orgzn_id,

3119: and ic.category_set_id = cp_prof_val
3120: and upper(it.concatenated_segments) = upper(cp_segments) ;
3121:
3122: BEGIN
3123: open cur_segments(cs_std.get_item_valdn_orgzn_id,
3124: fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'),
3125: p_segment);
3126: fetch cur_segments into x_number;
3127: if cur_segments%NOTFOUND then

Line 3986: and it.organization_id = cs_std.get_item_valdn_orgzn_id

3982: SELECT it.description,it.concatenated_segments
3983: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_products a
3984: where it.inventory_item_id = ic.inventory_item_id
3985: and it.organization_id = ic.organization_id
3986: and it.organization_id = cs_std.get_item_valdn_orgzn_id
3987: and ic.category_set_id = fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET')
3988: and it.inventory_item_id = a.product_id
3989: and a.set_id = c_set_id;
3990:

Line 3997: and it.organization_id = cs_std.get_item_valdn_orgzn_id

3993: SELECT it.description,it.concatenated_segments
3994: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_platforms a
3995: where it.inventory_item_id = ic.inventory_item_id
3996: and it.organization_id = ic.organization_id
3997: and it.organization_id = cs_std.get_item_valdn_orgzn_id
3998: and ic.category_set_id = fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET')
3999: and it.inventory_item_id = a.platform_id
4000: and a.set_id = c_set_id;
4001: