eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_FLOW_PVT dependencies on AK_FLOW_PVT

Line 1: package body AK_FLOW_PVT as

1: package body AK_FLOW_PVT as
2: /* $Header: akdvflob.pls 120.3 2005/09/15 22:18:27 tshort ship $ */
3:
4: --
5: -- global constants

Line 513: if AK_FLOW_PVT.FLOW_EXISTS (

509:
510: --
511: --** check to see if row already exists **
512: --
513: if AK_FLOW_PVT.FLOW_EXISTS (
514: p_api_version_number => 1.0,
515: p_return_status => l_return_status,
516: p_flow_application_id => p_flow_application_id,
517: p_flow_code => p_flow_code) then

Line 723: if NOT AK_FLOW_PVT.FLOW_EXISTS (

719: l_last_update_login
720: );
721:
722: --** row should exists before inserting rows for other languages **
723: if NOT AK_FLOW_PVT.FLOW_EXISTS (
724: p_api_version_number => 1.0,
725: p_return_status => l_return_status,
726: p_flow_application_id => p_flow_application_id,
727: p_flow_code => p_flow_code) then

Line 942: if AK_FLOW_PVT.PAGE_EXISTS (

938:
939: --
940: --** check to see if row already exists **
941: --
942: if AK_FLOW_PVT.PAGE_EXISTS (
943: p_api_version_number => 1.0,
944: p_return_status => l_return_status,
945: p_flow_application_id => p_flow_application_id,
946: p_flow_code => p_flow_code,

Line 1160: if NOT AK_FLOW_PVT.PAGE_EXISTS (

1156: l_last_update_login
1157: );
1158:
1159: --** row should exists before inserting rows for other languages **
1160: if NOT AK_FLOW_PVT.PAGE_EXISTS (
1161: p_api_version_number => 1.0,
1162: p_return_status => l_return_status,
1163: p_flow_application_id => p_flow_application_id,
1164: p_flow_code => p_flow_code,

Line 1221: AK_FLOW_PVT.UPDATE_FLOW (

1217: -- Set current page as the primary page of the flow if
1218: -- p_set_primary_page is 'Y'.
1219: --
1220: if (p_set_primary_page = 'Y') then
1221: AK_FLOW_PVT.UPDATE_FLOW (
1222: p_validation_level => p_validation_level,
1223: p_api_version_number => 1.0,
1224: p_msg_count => l_msg_count,
1225: p_msg_data => l_msg_data,

Line 1454: if AK_FLOW_PVT.PAGE_REGION_EXISTS (

1450:
1451: --
1452: --** check to see if row already exists **
1453: --
1454: if AK_FLOW_PVT.PAGE_REGION_EXISTS (
1455: p_api_version_number => 1.0,
1456: p_return_status => l_return_status,
1457: p_flow_application_id => p_flow_application_id,
1458: p_flow_code => p_flow_code,

Line 1725: AK_FLOW_PVT.UPDATE_PAGE (

1721: -- Set current region as the primary region of the flow page if
1722: -- p_set_primary_region is 'Y'.
1723: --
1724: if (p_set_primary_region = 'Y') then
1725: AK_FLOW_PVT.UPDATE_PAGE (
1726: p_validation_level => p_validation_level,
1727: p_api_version_number => 1.0,
1728: p_msg_count => l_msg_count,
1729: p_msg_data => l_msg_data,

Line 1778: AK_FLOW_PVT.CREATE_REGION_RELATION (

1774: (p_parent_region_application_id <> FND_API.G_MISS_NUM) and
1775: (p_parent_region_application_id is not null) and
1776: (p_parent_region_code <> FND_API.G_MISS_CHAR) and
1777: (p_parent_region_code is not null) then
1778: AK_FLOW_PVT.CREATE_REGION_RELATION (
1779: p_validation_level => p_validation_level,
1780: p_api_version_number => 1.0,
1781: p_msg_count => p_msg_count,
1782: p_msg_data => p_msg_data,

Line 1994: if AK_FLOW_PVT.PAGE_REGION_ITEM_EXISTS (

1990:
1991: --
1992: --** check to see if row already exists **
1993: --
1994: if AK_FLOW_PVT.PAGE_REGION_ITEM_EXISTS (
1995: p_api_version_number => 1.0,
1996: p_return_status => l_return_status,
1997: p_flow_application_id => p_flow_application_id,
1998: p_flow_code => p_flow_code,

Line 2417: if AK_FLOW_PVT.REGION_RELATION_EXISTS (

2413:
2414: savepoint start_create_relation;
2415:
2416: --** check to see if row already exists **
2417: if AK_FLOW_PVT.REGION_RELATION_EXISTS (
2418: p_api_version_number => 1.0,
2419: p_return_status => l_return_status,
2420: p_flow_application_id => p_flow_application_id,
2421: p_flow_code => p_flow_code,

Line 2793: if NOT AK_FLOW_PVT.FLOW_EXISTS (

2789:
2790: --
2791: -- error if flow to be deleted does not exists
2792: --
2793: if NOT AK_FLOW_PVT.FLOW_EXISTS (
2794: p_api_version_number => 1.0,
2795: p_return_status => l_return_status,
2796: p_flow_application_id => p_flow_application_id,
2797: p_flow_code => p_flow_code) then

Line 2834: AK_FLOW_PVT.DELETE_PAGE (

2830: open l_get_pages_csr;
2831: loop
2832: fetch l_get_pages_csr into l_page_application_id, l_page_code;
2833: exit when l_get_pages_csr%notfound;
2834: AK_FLOW_PVT.DELETE_PAGE (
2835: p_validation_level => p_validation_level,
2836: p_api_version_number => 1.0,
2837: p_msg_count => l_msg_count,
2838: p_msg_data => l_msg_data,

Line 3007: if NOT AK_FLOW_PVT.PAGE_EXISTS (

3003:
3004: --
3005: -- error if flow page to be deleted does not exists
3006: --
3007: if NOT AK_FLOW_PVT.PAGE_EXISTS (
3008: p_api_version_number => 1.0,
3009: p_return_status => l_return_status,
3010: p_flow_application_id => p_flow_application_id,
3011: p_flow_code => p_flow_code,

Line 3064: AK_FLOW_PVT.DELETE_PAGE_REGION (

3060: open l_get_page_regions_csr;
3061: loop
3062: fetch l_get_page_regions_csr into l_region_application_id, l_region_code;
3063: exit when l_get_page_regions_csr%notfound;
3064: AK_FLOW_PVT.DELETE_PAGE_REGION (
3065: p_validation_level => p_validation_level,
3066: p_api_version_number => 1.0,
3067: p_msg_count => l_msg_count,
3068: p_msg_data => l_msg_data,

Line 3093: AK_FLOW_PVT.UPDATE_FLOW (

3089: --
3090: open l_check_primary_csr;
3091: fetch l_check_primary_csr into l_dummy;
3092: if l_check_primary_csr%found then
3093: AK_FLOW_PVT.UPDATE_FLOW (
3094: p_validation_level => p_validation_level,
3095: p_api_version_number => 1.0,
3096: p_msg_count => l_msg_count,
3097: p_msg_data => l_msg_data,

Line 3326: if NOT AK_FLOW_PVT.PAGE_REGION_EXISTS (

3322:
3323: --
3324: -- error if page region to be deleted does not exists
3325: --
3326: if NOT AK_FLOW_PVT.PAGE_REGION_EXISTS (
3327: p_api_version_number => 1.0,
3328: p_return_status => l_return_status,
3329: p_flow_application_id => p_flow_application_id,
3330: p_flow_code => p_flow_code,

Line 3429: AK_FLOW_PVT.DELETE_PAGE_REGION_ITEM (

3425: open l_get_items_csr;
3426: loop
3427: fetch l_get_items_csr into l_attribute_appl_id, l_attribute_code;
3428: exit when l_get_items_csr%notfound;
3429: AK_FLOW_PVT.DELETE_PAGE_REGION_ITEM (
3430: p_validation_level => p_validation_level,
3431: p_api_version_number => 1.0,
3432: p_msg_count => l_msg_count,
3433: p_msg_data => l_msg_data,

Line 3460: AK_FLOW_PVT.DELETE_REGION_RELATION (

3456: loop
3457: fetch l_get_from_relations_csr into l_foreign_key_name,
3458: l_page_appl_id, l_page_code, l_region_appl_id, l_region_code;
3459: exit when l_get_from_relations_csr%notfound;
3460: AK_FLOW_PVT.DELETE_REGION_RELATION (
3461: p_validation_level => p_validation_level,
3462: p_api_version_number => 1.0,
3463: p_msg_count => l_msg_count,
3464: p_msg_data => l_msg_data,

Line 3494: AK_FLOW_PVT.DELETE_REGION_RELATION (

3490: loop
3491: fetch l_get_to_relations_csr into l_foreign_key_name,
3492: l_page_appl_id, l_page_code, l_region_appl_id, l_region_code;
3493: exit when l_get_to_relations_csr%notfound;
3494: AK_FLOW_PVT.DELETE_REGION_RELATION (
3495: p_validation_level => p_validation_level,
3496: p_api_version_number => 1.0,
3497: p_msg_count => l_msg_count,
3498: p_msg_data => l_msg_data,

Line 3529: AK_FLOW_PVT.UPDATE_PAGE_REGION (

3525: open l_get_child_regions_csr;
3526: loop
3527: fetch l_get_child_regions_csr into l_region_appl_id, l_region_code;
3528: exit when l_get_child_regions_csr%notfound;
3529: AK_FLOW_PVT.UPDATE_PAGE_REGION (
3530: p_validation_level => p_validation_level,
3531: p_api_version_number => 1.0,
3532: p_msg_count => l_msg_count,
3533: p_msg_data => l_msg_data,

Line 3561: AK_FLOW_PVT.UPDATE_PAGE (

3557: --
3558: open l_check_primary_csr;
3559: fetch l_check_primary_csr into l_dummy;
3560: if l_check_primary_csr%found then
3561: AK_FLOW_PVT.UPDATE_PAGE (
3562: p_validation_level => p_validation_level,
3563: p_api_version_number => 1.0,
3564: p_msg_count => l_msg_count,
3565: p_msg_data => l_msg_data,

Line 3735: if NOT AK_FLOW_PVT.PAGE_REGION_ITEM_EXISTS (

3731:
3732: --
3733: -- error if page region item to be deleted does not exists
3734: --
3735: if NOT AK_FLOW_PVT.PAGE_REGION_ITEM_EXISTS (
3736: p_api_version_number => 1.0,
3737: p_return_status => l_return_status,
3738: p_flow_application_id => p_flow_application_id,
3739: p_flow_code => p_flow_code,

Line 3937: if NOT AK_FLOW_PVT.REGION_RELATION_EXISTS (

3933:
3934: --
3935: -- error if region relation to be deleted does not exists
3936: --
3937: if NOT AK_FLOW_PVT.REGION_RELATION_EXISTS (
3938: p_api_version_number => 1.0,
3939: p_return_status => l_return_status,
3940: p_flow_application_id => p_flow_application_id,
3941: p_flow_code => p_flow_code,

Line 3987: AK_FLOW_PVT.DELETE_PAGE_REGION_ITEM (

3983: open l_get_items_csr;
3984: loop
3985: fetch l_get_items_csr into l_attribute_application_id, l_attribute_code;
3986: exit when l_get_items_csr%notfound;
3987: AK_FLOW_PVT.DELETE_PAGE_REGION_ITEM (
3988: p_validation_level => p_validation_level,
3989: p_api_version_number => 1.0,
3990: p_msg_count => l_msg_count,
3991: p_msg_data => l_msg_data,

Line 4845: AK_FLOW_PVT.UPDATE_FLOW (

4841: -- Set current page as the primary page of the flow if
4842: -- p_set_primary_page is 'Y'.
4843: --
4844: if (p_set_primary_page = 'Y') then
4845: AK_FLOW_PVT.UPDATE_FLOW (
4846: p_validation_level => p_validation_level,
4847: p_api_version_number => 1.0,
4848: p_msg_count => l_msg_count,
4849: p_msg_data => l_msg_data,

Line 5169: AK_FLOW_PVT.DELETE_REGION_RELATION (

5165: --
5166: -- delete only if such a relation exists
5167: --
5168: if (l_foreign_key_name_old is not null) then
5169: AK_FLOW_PVT.DELETE_REGION_RELATION (
5170: p_validation_level => p_validation_level,
5171: p_api_version_number => 1.0,
5172: p_msg_count => p_msg_count,
5173: p_msg_data => p_msg_data,

Line 5328: if NOT AK_FLOW_PVT.REGION_RELATION_EXISTS (

5324: --
5325: -- Create region relation only if it doesn't already exists,
5326: -- and a parent region is given.
5327: --
5328: if NOT AK_FLOW_PVT.REGION_RELATION_EXISTS (
5329: p_api_version_number => 1.0,
5330: p_return_status => l_return_status,
5331: p_flow_application_id => l_regions_rec.flow_application_id,
5332: p_flow_code => l_regions_rec.flow_code,

Line 5345: AK_FLOW_PVT.CREATE_REGION_RELATION (

5341: p_to_region_code => l_regions_rec.region_code
5342: ) and
5343: (l_regions_rec.parent_region_application_id is not null) and
5344: (l_regions_rec.parent_region_code is not null) then
5345: AK_FLOW_PVT.CREATE_REGION_RELATION (
5346: p_validation_level => p_validation_level,
5347: p_api_version_number => 1.0,
5348: p_msg_count => p_msg_count,
5349: p_msg_data => p_msg_data,

Line 5431: AK_FLOW_PVT.UPDATE_PAGE (

5427: -- Set current region as the primary region of the flow page if
5428: -- p_set_primary_region is 'Y'.
5429: --
5430: if (p_set_primary_region = 'Y') then
5431: AK_FLOW_PVT.UPDATE_PAGE (
5432: p_validation_level => p_validation_level,
5433: p_api_version_number => 1.0,
5434: p_msg_count => l_msg_count,
5435: p_msg_data => l_msg_data,

Line 6412: AK_FLOW_PVT.UPDATE_PAGE_REGION (

6408: fetch l_fpr_csr into l_fpr_rec;
6409: end loop;
6410:
6411: --** ASSUMPTION: You have found a unique sequence number for this flow_code + page_code combination.
6412: AK_FLOW_PVT.UPDATE_PAGE_REGION (
6413: p_validation_level => p_validation_level,
6414: p_api_version_number => 1.0,
6415: p_msg_count => p_msg_count,
6416: p_msg_data => p_msg_data,

Line 6450: end AK_FLOW_PVT;

6446: FND_MSG_PUB.Add;
6447:
6448: end CHECK_DISPLAY_SEQUENCE;
6449:
6450: end AK_FLOW_PVT;