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_REGION_RELATIONS

Line 354: from AK_FLOW_REGION_RELATIONS

350: p_to_region_code IN VARCHAR2
351: ) return BOOLEAN is
352: cursor l_check_csr is
353: select 1
354: from AK_FLOW_REGION_RELATIONS
355: where flow_application_id = p_flow_application_id
356: and flow_code = p_flow_code
357: and foreign_key_name = p_foreign_key_name
358: and from_page_appl_id = p_from_page_appl_id

Line 2576: insert into AK_FLOW_REGION_RELATIONS (

2572:
2573: select userenv('LANG') into l_lang
2574: from dual;
2575:
2576: insert into AK_FLOW_REGION_RELATIONS (
2577: FLOW_APPLICATION_ID,
2578: FLOW_CODE,
2579: FOREIGN_KEY_NAME,
2580: FROM_PAGE_APPL_ID,

Line 3257: from AK_FLOW_REGION_RELATIONS

3253: and region_code = p_region_code;
3254: cursor l_get_from_relations_csr is
3255: select FOREIGN_KEY_NAME, TO_PAGE_APPL_ID, TO_PAGE_CODE,
3256: TO_REGION_APPL_ID, TO_REGION_CODE
3257: from AK_FLOW_REGION_RELATIONS
3258: where flow_application_id = p_flow_application_id
3259: and flow_code = p_flow_code
3260: and from_page_appl_id = p_page_application_id
3261: and from_page_code = p_page_code

Line 3267: from AK_FLOW_REGION_RELATIONS

3263: and from_region_code = p_region_code;
3264: cursor l_get_to_relations_csr is
3265: select FOREIGN_KEY_NAME, FROM_PAGE_APPL_ID, FROM_PAGE_CODE,
3266: FROM_REGION_APPL_ID, FROM_REGION_CODE
3267: from AK_FLOW_REGION_RELATIONS
3268: where flow_application_id = p_flow_application_id
3269: and flow_code = p_flow_code
3270: and to_page_appl_id = p_page_application_id
3271: and to_page_code = p_page_code

Line 3362: -- AK_FLOW_REGION_RELATIONS (as from page region)

3358: raise FND_API.G_EXC_ERROR;
3359: end if;
3360: close l_get_items_csr;
3361: --
3362: -- AK_FLOW_REGION_RELATIONS (as from page region)
3363: --
3364: open l_get_from_relations_csr;
3365: fetch l_get_from_relations_csr into l_foreign_key_name,
3366: l_page_appl_id, l_page_code, l_region_appl_id, l_region_code;

Line 3377: -- AK_FLOW_REGION_RELATIONS (as to page region)

3373: raise FND_API.G_EXC_ERROR;
3374: end if;
3375: close l_get_from_relations_csr;
3376: --
3377: -- AK_FLOW_REGION_RELATIONS (as to page region)
3378: --
3379: open l_get_to_relations_csr;
3380: fetch l_get_to_relations_csr into l_foreign_key_name,
3381: l_page_appl_id, l_page_code, l_region_appl_id, l_region_code;

Line 3453: -- AK_FLOW_REGION_RELATIONS (as from page region)

3449: end if;
3450: end loop;
3451: close l_get_items_csr;
3452: --
3453: -- AK_FLOW_REGION_RELATIONS (as from page region)
3454: --
3455: open l_get_from_relations_csr;
3456: loop
3457: fetch l_get_from_relations_csr into l_foreign_key_name,

Line 3487: -- AK_FLOW_REGION_RELATIONS (as to page region)

3483: end if;
3484: end loop;
3485: close l_get_from_relations_csr;
3486: --
3487: -- AK_FLOW_REGION_RELATIONS (as to page region)
3488: --
3489: open l_get_to_relations_csr;
3490: loop
3491: fetch l_get_to_relations_csr into l_foreign_key_name,

Line 4016: delete from ak_flow_region_relations

4012: --
4013: -- delete region relation once we checked that there are no references
4014: -- to it, or all references have been deleted.
4015: --
4016: delete from ak_flow_region_relations
4017: where flow_application_id = p_flow_application_id
4018: and flow_code = p_flow_code
4019: and foreign_key_name = p_foreign_key_name
4020: and from_page_appl_id = p_from_page_appl_id

Line 5020: from AK_FLOW_REGION_RELATIONS

5016: for update of display_sequence;
5017: cursor l_get_old_fk_csr (parent_region_appl_id_param NUMBER,
5018: parent_region_code_param varchar2) is
5019: select foreign_key_name
5020: from AK_FLOW_REGION_RELATIONS
5021: where flow_application_id = p_flow_application_id
5022: and flow_code = p_flow_code
5023: and from_page_appl_id = p_page_application_id
5024: and from_page_code = p_page_code

Line 6008: from AK_FLOW_REGION_RELATIONS

6004: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
6005: ) is
6006: cursor l_get_row_csr is
6007: select *
6008: from AK_FLOW_REGION_RELATIONS
6009: where flow_application_id = p_flow_application_id
6010: and flow_code = p_flow_code
6011: and foreign_key_name = p_foreign_key_name
6012: and from_page_appl_id = p_from_page_appl_id

Line 6025: l_relations_rec AK_FLOW_REGION_RELATIONS%ROWTYPE;

6021: l_api_version_number CONSTANT number := 1.0;
6022: l_api_name CONSTANT varchar2(30) := 'Update_Region_Relation';
6023: l_created_by number;
6024: l_creation_date date;
6025: l_relations_rec AK_FLOW_REGION_RELATIONS%ROWTYPE;
6026: l_lang varchar2(30);
6027: l_last_update_date date;
6028: l_last_update_login number;
6029: l_last_updated_by number;

Line 6051: -- retrieve ak_flow_region_relations row if it exists

6047:
6048: select userenv('LANG') into l_lang
6049: from dual;
6050:
6051: --** retrieve ak_flow_region_relations row if it exists **
6052: open l_get_row_csr;
6053: fetch l_get_row_csr into l_relations_rec;
6054: if (l_get_row_csr%notfound) then
6055: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 6195: update AK_FLOW_REGION_RELATIONS set

6191: p_db_last_update_date => l_relations_rec.last_update_date,
6192: p_last_update_login => l_last_update_login,
6193: p_create_or_update => 'UPDATE') then
6194:
6195: update AK_FLOW_REGION_RELATIONS set
6196: APPLICATION_ID = l_relations_rec.application_id,
6197: ATTRIBUTE_CATEGORY = l_relations_rec.attribute_category,
6198: ATTRIBUTE1 = l_relations_rec.attribute1,
6199: ATTRIBUTE2 = l_relations_rec.attribute2,