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_FLOWS

Line 45: from AK_FLOWS

41: p_flow_code IN VARCHAR2
42: ) return BOOLEAN is
43: cursor l_check_csr is
44: select 1
45: from AK_FLOWS
46: where flow_application_id = p_flow_application_id
47: and flow_code = p_flow_code;
48: l_api_version_number CONSTANT number := 1.0;
49: l_api_name CONSTANT varchar2(30) := 'Flow_Exists';

Line 668: insert into AK_FLOWS (

664:
665: select userenv('LANG') into l_lang
666: from dual;
667:
668: insert into AK_FLOWS (
669: FLOW_APPLICATION_ID,
670: FLOW_CODE,
671: PRIMARY_PAGE_APPL_ID,
672: PRIMARY_PAGE_CODE,

Line 735: insert into AK_FLOWS_TL (

731: end if;
732: raise FND_API.G_EXC_ERROR;
733: end if;
734:
735: insert into AK_FLOWS_TL (
736: FLOW_APPLICATION_ID,
737: FLOW_CODE,
738: LANGUAGE,
739: NAME,

Line 763: from AK_FLOWS_TL T

759: from FND_LANGUAGES L
760: where L.INSTALLED_FLAG in ('I', 'B')
761: and not exists
762: (select NULL
763: from AK_FLOWS_TL T
764: where T.FLOW_APPLICATION_ID = p_flow_application_id
765: and T.FLOW_CODE = p_flow_code
766: and T.LANGUAGE = L.LANGUAGE_CODE);
767:

Line 2859: delete from ak_flows

2855: --
2856: -- delete flow once we checked that there are no references
2857: -- to it, or all references have been deleted.
2858: --
2859: delete from ak_flows
2860: where flow_application_id = p_flow_application_id
2861: and flow_code = p_flow_code;
2862:
2863: if (sql%notfound) then

Line 2871: delete from ak_flows_tl

2867: end if;
2868: raise FND_API.G_EXC_ERROR;
2869: end if;
2870:
2871: delete from ak_flows_tl
2872: where flow_application_id = p_flow_application_id
2873: and flow_code = p_flow_code;
2874:
2875: if (sql%notfound) then

Line 2973: from AK_FLOWS

2969: and page_application_id = p_page_application_id
2970: and page_code = p_page_code;
2971: cursor l_check_primary_csr is
2972: select 1
2973: from AK_FLOWS
2974: where flow_application_id = p_flow_application_id
2975: and flow_code = p_flow_code
2976: and primary_page_appl_id = p_page_application_id
2977: and primary_page_code = p_page_code;

Line 3041: -- AK_FLOWS (primary page of a flow)

3037: raise FND_API.G_EXC_ERROR;
3038: end if;
3039: close l_get_page_regions_csr;
3040: --
3041: -- AK_FLOWS (primary page of a flow)
3042: --
3043: open l_check_primary_csr;
3044: fetch l_check_primary_csr into l_dummy;
3045: if l_check_primary_csr%found then

Line 3086: -- AK_FLOWS (primary page of a flow)

3082: end if;
3083: end loop;
3084: close l_get_page_regions_csr;
3085: --
3086: -- AK_FLOWS (primary page of a flow)
3087: --
3088: -- - invalidates flow's primary page
3089: --
3090: open l_check_primary_csr;

Line 4158: from AK_FLOWS

4154: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
4155: ) is
4156: cursor l_get_row_csr is
4157: select *
4158: from AK_FLOWS
4159: where FLOW_APPLICATION_ID = p_flow_application_id
4160: and FLOW_CODE = p_flow_code
4161: for update of primary_page_appl_id;
4162: cursor l_get_tl_row_csr (lang_parm varchar2) is

Line 4164: from AK_FLOWS_TL

4160: and FLOW_CODE = p_flow_code
4161: for update of primary_page_appl_id;
4162: cursor l_get_tl_row_csr (lang_parm varchar2) is
4163: select *
4164: from AK_FLOWS_TL
4165: where FLOW_APPLICATION_ID = p_flow_application_id
4166: and FLOW_CODE = p_flow_code
4167: and LANGUAGE = lang_parm
4168: for update of name;

Line 4173: l_flows_rec ak_flows%ROWTYPE;

4169: l_api_version_number CONSTANT number := 1.0;
4170: l_api_name CONSTANT varchar2(30) := 'Update_Flow';
4171: l_created_by number;
4172: l_creation_date date;
4173: l_flows_rec ak_flows%ROWTYPE;
4174: l_flows_tl_rec ak_flows_tl%ROWTYPE;
4175: l_error boolean;
4176: l_lang varchar2(30);
4177: l_last_update_date date;

Line 4174: l_flows_tl_rec ak_flows_tl%ROWTYPE;

4170: l_api_name CONSTANT varchar2(30) := 'Update_Flow';
4171: l_created_by number;
4172: l_creation_date date;
4173: l_flows_rec ak_flows%ROWTYPE;
4174: l_flows_tl_rec ak_flows_tl%ROWTYPE;
4175: l_error boolean;
4176: l_lang varchar2(30);
4177: l_last_update_date date;
4178: l_last_update_login number;

Line 4202: -- retrieve ak_flows row if it exists

4198: select userenv('LANG') into l_lang
4199: from dual;
4200:
4201: --
4202: -- retrieve ak_flows row if it exists
4203: --
4204: open l_get_row_csr;
4205: fetch l_get_row_csr into l_flows_rec;
4206: if (l_get_row_csr%notfound) then

Line 4217: -- retrieve ak_flows_tl row if it exists

4213: end if;
4214: close l_get_row_csr;
4215:
4216: --
4217: -- retrieve ak_flows_tl row if it exists
4218: --
4219: open l_get_tl_row_csr(l_lang);
4220: fetch l_get_tl_row_csr into l_flows_tl_rec;
4221: if (l_get_tl_row_csr%notfound) then

Line 4381: update AK_FLOWS set

4377: p_db_last_update_date => l_flows_rec.last_update_date,
4378: p_last_update_login => l_last_update_login,
4379: p_create_or_update => 'UPDATE') then
4380:
4381: update AK_FLOWS set
4382: PRIMARY_PAGE_APPL_ID = l_flows_rec.primary_page_appl_id,
4383: PRIMARY_PAGE_CODE = l_flows_rec.primary_page_code,
4384: ATTRIBUTE_CATEGORY = l_flows_rec.attribute_category,
4385: ATTRIBUTE1 = l_flows_rec.attribute1,

Line 4413: update AK_FLOWS_TL set

4409: end if;
4410: raise FND_API.G_EXC_ERROR;
4411: end if;
4412:
4413: update AK_FLOWS_TL set
4414: NAME = l_flows_tl_rec.name,
4415: DESCRIPTION = l_flows_tl_rec.description,
4416: LAST_UPDATED_BY = l_last_updated_by,
4417: LAST_UPDATE_DATE = l_last_update_date,