DBA Data[Home] [Help]

APPS.CS_CF_UPG_PKG dependencies on AK_REGION_ITEMS

Line 1113: from ak_region_items

1109: IF (l_region_count > 0) THEN
1110: l_newIdentifyProductExists := TRUE;
1111: select node_display_flag INTO
1112: l_displayRegProducts
1113: from ak_region_items
1114: where region_code = l_newIdentifyProductRegionCode
1115: and attribute_code = 'IBU_CF_SR_REG_PRODUCT_RG'
1116: and region_application_id = 672
1117: and attribute_application_id = 672;

Line 1121: from ak_region_items

1117: and attribute_application_id = 672;
1118:
1119: select node_display_flag INTO
1120: l_displayAllProducts
1121: from ak_region_items
1122: where region_code = l_newIdentifyProductRegionCode
1123: and attribute_code = 'IBU_CF_SR_ALL_PRODUCT_RG'
1124: and region_application_id = 672
1125: and attribute_application_id = 672;

Line 1179: from ak_region_items

1175: l_newIdentifyProblemExists := TRUE;
1176:
1177: select node_display_flag INTO
1178: l_displayAttachment
1179: from ak_region_items
1180: where region_code = l_newIdentifyProblemRegionCode
1181: and attribute_code = 'IBU_CF_SR_ATTACHMENTS_RG'
1182: and region_application_id = 672
1183: and attribute_application_id = 672;

Line 1209: from ak_region_items

1205: l_newProblemDetailsExists := TRUE;
1206:
1207: select node_display_flag INTO
1208: l_enableTemplate
1209: from ak_region_items
1210: where region_code = l_newProblemDetailsRegionCode
1211: and attribute_code = 'IBU_CF_SR_PROB_DETAILS'
1212: and region_application_id = 672
1213: and attribute_application_id = 672;

Line 1280: from ak_region_items

1276: IF (l_region_count > 0) THEN
1277: l_newDtlResolnExists := TRUE;
1278: select node_display_flag INTO
1279: l_displayTasks
1280: from ak_region_items
1281: where region_code = l_newDtlResolnRegionCode
1282: and attribute_code = 'IBU_CF_SR_DTL_ACTS_RG'
1283: and region_application_id = 672
1284: and attribute_application_id = 672;

Line 2485: from ak_region_items

2481: IF (l_region_count > 0) THEN
2482: l_newIdentifyProductExists := TRUE;
2483: select node_display_flag INTO
2484: l_displayRegProducts
2485: from ak_region_items
2486: where region_code = l_newIdentifyProductRegionCode
2487: and attribute_code = 'IBU_CF_SR_REG_PRODUCT_RG'
2488: and region_application_id = 672
2489: and attribute_application_id = 672;

Line 2493: from ak_region_items

2489: and attribute_application_id = 672;
2490:
2491: select node_display_flag INTO
2492: l_displayAllProducts
2493: from ak_region_items
2494: where region_code = l_newIdentifyProductRegionCode
2495: and attribute_code = 'IBU_CF_SR_ALL_PRODUCT_RG'
2496: and region_application_id = 672
2497: and attribute_application_id = 672;

Line 2551: from ak_region_items

2547: l_newIdentifyProblemExists := TRUE;
2548:
2549: select node_display_flag INTO
2550: l_displayAttachment
2551: from ak_region_items
2552: where region_code = l_newIdentifyProblemRegionCode
2553: and attribute_code = 'IBU_CF_SR_ATTACHMENTS_RG'
2554: and region_application_id = 672
2555: and attribute_application_id = 672;

Line 2581: from ak_region_items

2577: l_newProblemDetailsExists := TRUE;
2578:
2579: select node_display_flag INTO
2580: l_enableTemplate
2581: from ak_region_items
2582: where region_code = l_newProblemDetailsRegionCode
2583: and attribute_code = 'IBU_CF_SR_PROB_DETAILS'
2584: and region_application_id = 672
2585: and attribute_application_id = 672;

Line 2651: from ak_region_items

2647: IF (l_region_count > 0) THEN
2648: l_newDtlResolnExists := TRUE;
2649: select node_display_flag INTO
2650: l_displayTasks
2651: from ak_region_items
2652: where region_code = l_newDtlResolnRegionCode
2653: and attribute_code = 'IBU_CF_SR_DTL_ACTS_RG'
2654: and region_application_id = 672
2655: and attribute_application_id = 672;

Line 3717: from ak_region_items

3713: IF (l_region_count > 0) THEN
3714: l_newIdentifyProductExists := TRUE;
3715: select node_display_flag INTO
3716: l_displayRegProducts
3717: from ak_region_items
3718: where region_code = l_newIdentifyProductRegionCode
3719: and attribute_code = 'IBU_CF_SR_REG_PRODUCT_RG'
3720: and region_application_id = 672
3721: and attribute_application_id = 672;

Line 3725: from ak_region_items

3721: and attribute_application_id = 672;
3722:
3723: select node_display_flag INTO
3724: l_displayAllProducts
3725: from ak_region_items
3726: where region_code = l_newIdentifyProductRegionCode
3727: and attribute_code = 'IBU_CF_SR_ALL_PRODUCT_RG'
3728: and region_application_id = 672
3729: and attribute_application_id = 672;

Line 3780: from ak_region_items

3776: l_newIdentifyProblemExists := TRUE;
3777:
3778: select node_display_flag INTO
3779: l_displayAttachment
3780: from ak_region_items
3781: where region_code = l_newIdentifyProblemRegionCode
3782: and attribute_code = 'IBU_CF_SR_ATTACHMENTS_RG'
3783: and region_application_id = 672
3784: and attribute_application_id = 672;

Line 3810: from ak_region_items

3806: l_newProblemDetailsExists := TRUE;
3807:
3808: select node_display_flag INTO
3809: l_enableTemplate
3810: from ak_region_items
3811: where region_code = l_newProblemDetailsRegionCode
3812: and attribute_code = 'IBU_CF_SR_PROB_DETAILS'
3813: and region_application_id = 672
3814: and attribute_application_id = 672;

Line 3880: from ak_region_items

3876: IF (l_region_count > 0) THEN
3877: l_newDtlResolnExists := TRUE;
3878: select node_display_flag INTO
3879: l_displayTasks
3880: from ak_region_items
3881: where region_code = l_newDtlResolnRegionCode
3882: and attribute_code = 'IBU_CF_SR_DTL_ACTS_RG'
3883: and region_application_id = 672
3884: and attribute_application_id = 672;