APPS.QA_AK_MAPPING_API dependencies on AK_REGION_ITEMS

Line 530: FROM ak_region_items

526: max_display_sequence NUMBER DEFAULT 0;
527:
528: CURSOR c IS
529: SELECT MAX(display_sequence)
530: FROM ak_region_items
531: WHERE region_code = p_region_code
532: AND region_application_id = p_region_application_id;
533:
534: BEGIN

Line 536: -- display_sequence is a not null and unique field in ak_region_items.

532: AND region_application_id = p_region_application_id;
533:
534: BEGIN
535:
536: -- display_sequence is a not null and unique field in ak_region_items.
537: -- When adding region items dynamically there is a need to know the next
538: -- available display sequence. This function computes that.
539:
540: OPEN c;

Line 561: FROM ak_region_items

557: max_display_sequence NUMBER DEFAULT 0;
558:
559: CURSOR c IS
560: SELECT MAX(display_sequence)
561: FROM ak_region_items
562: WHERE region_code = p_region_code
563: AND region_application_id = p_region_application_id
564: AND item_style <> 'HIDDEN';
565:

Line 568: -- display_sequence is a not null and unique field in ak_region_items.

564: AND item_style <> 'HIDDEN';
565:
566: BEGIN
567:
568: -- display_sequence is a not null and unique field in ak_region_items.
569: -- When adding region items dynamically there is a need to know the next
570: -- available display sequence. However, in case of special region items
571: -- there is a little complexity. There is a ATG bug that we have to work
572: -- around, which mandates that all hidden elements are addded at the end.

Line 1075: FROM ak_region_items

1071: l_char_id NUMBER;
1072:
1073: CURSOR c IS
1074: SELECT 'TRUE'
1075: FROM ak_region_items
1076: WHERE region_application_id = p_region_application_id
1077: AND region_code = p_region_code
1078: AND attribute_application_id = p_attribute_application_id
1079: AND attribute_code = p_attribute_code;

Line 1096: ak_region_items_pkg.delete_row(

1092:
1093: -- dbms_output.put_line('Deleting Item : ' || p_region_code|| ' ' ||
1094: -- p_attribute_code);
1095:
1096: ak_region_items_pkg.delete_row(
1097: p_region_application_id,
1098: p_region_code,
1099: p_attribute_application_id,
1100: p_attribute_code);

Line 1754: AK_REGION_ITEMS_PKG.insert_row (

1750: ELSE
1751: l_display_sequence :=l_qa_plan_chars_row.prompt_sequence;
1752: END IF;
1753:
1754: AK_REGION_ITEMS_PKG.insert_row (
1755: X_ROWID => l_row_id,
1756: X_REGION_APPLICATION_ID => p_region_application_id,
1757: X_REGION_CODE => l_region_code,
1758: X_ATTRIBUTE_APPLICATION_ID => p_attribute_application_id,

Line 1947: AK_REGION_ITEMS_PKG.insert_row (

1943: l_query_flag := 'Y';
1944: END IF;
1945:
1946:
1947: AK_REGION_ITEMS_PKG.insert_row (
1948: X_ROWID => l_row_id,
1949: X_REGION_APPLICATION_ID => p_region_application_id,
1950: X_REGION_CODE => l_region_code,
1951: X_ATTRIBUTE_APPLICATION_ID => p_attribute_application_id,

Line 2102: AK_REGION_ITEMS_PKG.insert_row (

2098: p_region_application_id);
2099:
2100: END IF;
2101:
2102: AK_REGION_ITEMS_PKG.insert_row (
2103: X_ROWID => l_row_id,
2104: X_REGION_APPLICATION_ID => p_region_application_id,
2105: X_REGION_CODE => l_region_code,
2106: X_ATTRIBUTE_APPLICATION_ID => p_attribute_application_id,

Line 2351: AK_REGION_ITEMS_PKG.insert_row (

2347:
2348: -- dbms_output.put_line('Adding Item (S) : ' || l_region_code || ' ' ||
2349: -- p_attribute_code);
2350:
2351: AK_REGION_ITEMS_PKG.insert_row (
2352: X_ROWID => l_row_id,
2353: X_REGION_APPLICATION_ID => p_region_application_id,
2354: X_REGION_CODE => l_region_code,
2355: X_ATTRIBUTE_APPLICATION_ID => p_attribute_application_id,

Line 2932: FROM ak_region_items

2928: l_top_region VARCHAR2(30);
2929:
2930: CURSOR c (x_region_code VARCHAR2) IS
2931: SELECT attribute_code
2932: FROM ak_region_items
2933: WHERE region_code = x_region_code
2934: AND region_application_id = g_application_id;
2935:
2936: BEGIN