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_PAGES

Line 116: from AK_FLOW_PAGES

112: p_page_code IN VARCHAR2
113: ) return BOOLEAN is
114: cursor l_check_csr is
115: select 1
116: from AK_FLOW_PAGES
117: where flow_application_id = p_flow_application_id
118: and flow_code = p_flow_code
119: and page_application_id = p_page_application_id
120: and page_code = p_page_code;

Line 1101: insert into AK_FLOW_PAGES (

1097:
1098: select userenv('LANG') into l_lang
1099: from dual;
1100:
1101: insert into AK_FLOW_PAGES (
1102: FLOW_APPLICATION_ID,
1103: FLOW_CODE,
1104: PAGE_APPLICATION_ID,
1105: PAGE_CODE,

Line 1174: insert into AK_FLOW_PAGES_TL (

1170: end if;
1171: raise FND_API.G_EXC_ERROR;
1172: end if;
1173:
1174: insert into AK_FLOW_PAGES_TL (
1175: FLOW_APPLICATION_ID,
1176: FLOW_CODE,
1177: PAGE_APPLICATION_ID,
1178: PAGE_CODE,

Line 1206: from AK_FLOW_PAGES_TL T

1202: from FND_LANGUAGES L
1203: where L.INSTALLED_FLAG in ('I', 'B')
1204: and not exists
1205: (select NULL
1206: from AK_FLOW_PAGES_TL T
1207: where T.FLOW_APPLICATION_ID = p_flow_application_id
1208: and T.FLOW_CODE = p_flow_code
1209: and T.PAGE_APPLICATION_ID = p_page_application_id
1210: and T.PAGE_CODE = p_page_code

Line 2764: from AK_FLOW_PAGES

2760: p_delete_cascade IN VARCHAR2
2761: ) is
2762: cursor l_get_pages_csr is
2763: select PAGE_APPLICATION_ID, PAGE_CODE
2764: from AK_FLOW_PAGES
2765: where flow_application_id = p_flow_application_id
2766: and flow_code = p_flow_code;
2767: l_api_version_number CONSTANT number := 1.0;
2768: l_api_name CONSTANT varchar2(30):= 'Delete_Flow';

Line 2811: -- AK_FLOW_PAGES

2807: -- If we are not deleting any referencing records, we cannot
2808: -- delete the flow if it is being referenced in any of
2809: -- following tables.
2810: --
2811: -- AK_FLOW_PAGES
2812: --
2813: open l_get_pages_csr;
2814: fetch l_get_pages_csr into l_page_application_id, l_page_code;
2815: if l_get_pages_csr%found then

Line 2828: -- AK_FLOW_PAGES

2824: else
2825: --
2826: -- Otherwise, delete all referencing rows in other tables
2827: --
2828: -- AK_FLOW_PAGES
2829: --
2830: open l_get_pages_csr;
2831: loop
2832: fetch l_get_pages_csr into l_page_application_id, l_page_code;

Line 3128: delete from ak_flow_pages

3124: --
3125: -- delete flow page once we checked that there are no references
3126: -- to it, or all references have been deleted.
3127: --
3128: delete from ak_flow_pages
3129: where flow_application_id = p_flow_application_id
3130: and flow_code = p_flow_code
3131: and page_application_id = p_page_application_id
3132: and page_code = p_page_code;

Line 3142: delete from ak_flow_pages_tl

3138: end if;
3139: raise FND_API.G_EXC_ERROR;
3140: end if;
3141:
3142: delete from ak_flow_pages_tl
3143: where flow_application_id = p_flow_application_id
3144: and flow_code = p_flow_code
3145: and page_application_id = p_page_application_id
3146: and page_code = p_page_code;

Line 3276: from AK_FLOW_PAGES

3272: and to_region_appl_id = p_region_application_id
3273: and to_region_code = p_region_code;
3274: cursor l_check_primary_csr is
3275: select 1
3276: from AK_FLOW_PAGES
3277: where flow_application_id = p_flow_application_id
3278: and flow_code = p_flow_code
3279: and page_application_id = p_page_application_id
3280: and page_code = p_page_code

Line 3406: -- AK_FLOW_PAGES (primary region of a page)

3402: raise FND_API.G_EXC_ERROR;
3403: end if;
3404: close l_get_child_regions_csr;
3405: --
3406: -- AK_FLOW_PAGES (primary region of a page)
3407: --
3408: open l_check_primary_csr;
3409: fetch l_check_primary_csr into l_dummy;
3410: if l_check_primary_csr%found then

Line 3554: -- AK_FLOW_PAGES (primary region of a page)

3550: end if;
3551: end loop;
3552: close l_get_child_regions_csr;
3553: --
3554: -- AK_FLOW_PAGES (primary region of a page)
3555: --
3556: -- - invalidates flow page's primary region
3557: --
3558: open l_check_primary_csr;

Line 4553: from AK_FLOW_PAGES

4549: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
4550: ) is
4551: cursor l_get_row_csr is
4552: select *
4553: from AK_FLOW_PAGES
4554: where FLOW_APPLICATION_ID = p_flow_application_id
4555: and FLOW_CODE = p_flow_code
4556: and page_application_id = p_page_application_id
4557: and page_code = p_page_code

Line 4561: from AK_FLOW_PAGES_TL

4557: and page_code = p_page_code
4558: for update of primary_region_appl_id;
4559: cursor l_get_tl_row_csr (lang_parm varchar2) is
4560: select *
4561: from AK_FLOW_PAGES_TL
4562: where FLOW_APPLICATION_ID = p_flow_application_id
4563: and FLOW_CODE = p_flow_code
4564: and page_application_id = p_page_application_id
4565: and page_code = p_page_code

Line 4579: l_pages_rec ak_flow_pages%ROWTYPE;

4575: l_lang varchar2(30);
4576: l_last_update_date date;
4577: l_last_update_login number;
4578: l_last_updated_by number;
4579: l_pages_rec ak_flow_pages%ROWTYPE;
4580: l_pages_tl_rec ak_flow_pages_tl%ROWTYPE;
4581: l_return_status varchar2(1);
4582: l_file_version number;
4583: begin

Line 4580: l_pages_tl_rec ak_flow_pages_tl%ROWTYPE;

4576: l_last_update_date date;
4577: l_last_update_login number;
4578: l_last_updated_by number;
4579: l_pages_rec ak_flow_pages%ROWTYPE;
4580: l_pages_tl_rec ak_flow_pages_tl%ROWTYPE;
4581: l_return_status varchar2(1);
4582: l_file_version number;
4583: begin
4584: IF NOT FND_API.Compatible_API_Call (

Line 4603: -- retrieve ak_flow_pages row if it exists

4599: select userenv('LANG') into l_lang
4600: from dual;
4601:
4602: --
4603: -- retrieve ak_flow_pages row if it exists
4604: --
4605: open l_get_row_csr;
4606: fetch l_get_row_csr into l_pages_rec;
4607: if (l_get_row_csr%notfound) then

Line 4783: update AK_FLOW_PAGES set

4779: p_db_last_update_date => l_pages_rec.last_update_date,
4780: p_last_update_login => l_last_update_login,
4781: p_create_or_update => 'UPDATE') then
4782:
4783: update AK_FLOW_PAGES set
4784: PRIMARY_REGION_APPL_ID = l_pages_rec.primary_region_appl_id,
4785: PRIMARY_REGION_CODE = l_pages_rec.primary_region_code,
4786: ATTRIBUTE_CATEGORY = l_pages_rec.attribute_category,
4787: ATTRIBUTE1 = l_pages_rec.attribute1,

Line 4817: update AK_FLOW_PAGES_TL set

4813: end if;
4814: raise FND_API.G_EXC_ERROR;
4815: end if;
4816:
4817: update AK_FLOW_PAGES_TL set
4818: NAME = l_pages_tl_rec.name,
4819: DESCRIPTION = l_pages_tl_rec.description,
4820: LAST_UPDATED_BY = l_last_updated_by,
4821: LAST_UPDATE_DATE = l_last_update_date,