APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_STD

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

2494:
2495: -- Populate org id table
2496: l_set_product_org_ids.extend(p_set_product_ids.count);
2497: for i in 1..l_set_product_org_ids.count loop
2498: l_set_product_org_ids(i) := cs_std.get_item_valdn_orgzn_id;
2499: end loop;
2500:
2501: -- link the set to products
2502: cs_kb_assoc_pkg.add_link(p_item_id => p_set_product_ids,

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

2513: -- Populate org id table
2514: l_set_platform_org_ids.extend(p_set_platform_ids.count);
2515:
2516: for i in 1..l_set_platform_org_ids.count loop
2517: l_set_platform_org_ids(i) := cs_std.get_item_valdn_orgzn_id;
2518: end loop;
2519:
2520: -- link the set to platforms
2521: cs_kb_assoc_pkg.add_link(p_item_id => p_set_platform_ids,

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

3026: and it.organization_id = cp_org_id
3027: and ic.category_set_id = cp_prof_val
3028: and upper(it.concatenated_segments) = upper(cp_segments) ;
3029: BEGIN
3030: open cur_segments(cs_std.get_item_valdn_orgzn_id,
3031: fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET'),
3032: p_segment);
3033: fetch cur_segments into x_number;
3034: if cur_segments%NOTFOUND then

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

3109: and ic.category_set_id = cp_prof_val
3110: and upper(it.concatenated_segments) = upper(cp_segments) ;
3111:
3112: BEGIN
3113: open cur_segments(cs_std.get_item_valdn_orgzn_id,
3114: fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET'),
3115: p_segment);
3116: fetch cur_segments into x_number;
3117: if cur_segments%NOTFOUND then

Line 3976: and it.organization_id = cs_std.get_item_valdn_orgzn_id

3972: SELECT it.description,it.concatenated_segments
3973: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_products a
3974: where it.inventory_item_id = ic.inventory_item_id
3975: and it.organization_id = ic.organization_id
3976: and it.organization_id = cs_std.get_item_valdn_orgzn_id
3977: and ic.category_set_id = fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET')
3978: and it.inventory_item_id = a.product_id
3979: and a.set_id = c_set_id;
3980:

Line 3987: and it.organization_id = cs_std.get_item_valdn_orgzn_id

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