APPS.QA_AK_MAPPING_API dependencies on AK_ATTRIBUTES

Line 799: FROM ak_attributes

795: l_row_exists VARCHAR2(4);
796:
797: CURSOR c IS
798: SELECT 'TRUE'
799: FROM ak_attributes
800: WHERE attribute_application_id = p_attribute_application_id
801: AND attribute_code = p_attribute_code;
802:
803: BEGIN

Line 831: ak_attributes_pkg.delete_row(p_attribute_application_id,

827: -- if the combination already exists.
828:
829: IF attribute_exists(p_attribute_application_id, p_attribute_code) THEN
830: -- dbms_output.put_line('Deleting Element : ' || p_attribute_code);
831: ak_attributes_pkg.delete_row(p_attribute_application_id,
832: p_attribute_code);
833: END IF;
834:
835: END delete_attribute_for_plan;

Line 854: ak_attributes_pkg.delete_row(p_attribute_application_id,

850:
851: IF attribute_exists(p_attribute_application_id, l_attribute_code) THEN
852:
853: -- dbms_output.put_line('Deleting Element : ' || l_attribute_code);
854: ak_attributes_pkg.delete_row(p_attribute_application_id,
855: l_attribute_code);
856: END IF;
857:
858: END delete_element_mapping;

Line 1247: ak_attributes_pkg.insert_row (

1243: ELSE
1244: l_date_default := qltdate.canon_to_date(l_default_value);
1245: END IF;
1246:
1247: ak_attributes_pkg.insert_row (
1248: X_ROWID => l_row_id,
1249: X_ATTRIBUTE_APPLICATION_ID => p_attribute_application_id,
1250: X_ATTRIBUTE_CODE => l_attribute_code,
1251: X_ATTRIBUTE_LABEL_LENGTH => l_label_length,

Line 1344: ak_attributes_pkg.insert_row (

1340: ELSE
1341: l_date_default := qltdate.canon_to_date(l_default_value);
1342: END IF;
1343:
1344: ak_attributes_pkg.insert_row (
1345: X_ROWID => l_row_id,
1346: X_ATTRIBUTE_APPLICATION_ID => p_attribute_application_id,
1347: X_ATTRIBUTE_CODE => l_attribute_code,
1348: X_ATTRIBUTE_LABEL_LENGTH => l_label_length,

Line 1701: -- if the attribute exists in ak_attributes if it does not,

1697: l_region_code := construct_ak_code(p_appendix, p_plan_id);
1698: l_attribute_code := construct_ak_code(g_element_appendix, p_char_id);
1699:
1700: -- As a part of our upgrade strategy, we want to find out
1701: -- if the attribute exists in ak_attributes if it does not,
1702: -- we should create it.
1703:
1704: IF NOT attribute_exists(p_attribute_application_id, l_attribute_code) THEN
1705:

Line 1912: -- if the attribute exists in ak_attributes if it does not,

1908: l_update_flag := 'N';
1909: l_element_id := retrieve_id(p_attribute_code);
1910:
1911: -- As a part of our upgrade strategy, we want to find out
1912: -- if the attribute exists in ak_attributes if it does not,
1913: -- we should create it.
1914:
1915: IF NOT attribute_exists(p_attribute_application_id, p_attribute_code) THEN
1916: