APPS.AK_FLOW_PVT dependencies on AK_FLOW_PAGE_REGIONS

Line 191: from AK_FLOW_PAGE_REGIONS

187: p_region_code IN VARCHAR2
188: ) return BOOLEAN is
189: cursor l_check_csr is
190: select 1
191: from AK_FLOW_PAGE_REGIONS
192: where flow_application_id = p_flow_application_id
193: and flow_code = p_flow_code
194: and page_application_id = p_page_application_id
195: and page_code = p_page_code

Line 1647: insert into AK_FLOW_PAGE_REGIONS (

1643:
1644: select userenv('LANG') into l_lang
1645: from dual;
1646:
1647: insert into AK_FLOW_PAGE_REGIONS (
1648: FLOW_APPLICATION_ID,
1649: FLOW_CODE,
1650: PAGE_APPLICATION_ID,
1651: PAGE_CODE,

Line 2966: from AK_FLOW_PAGE_REGIONS

2962: p_delete_cascade IN VARCHAR2
2963: ) is
2964: cursor l_get_page_regions_csr is
2965: select REGION_APPLICATION_ID, REGION_CODE
2966: from AK_FLOW_PAGE_REGIONS
2967: where flow_application_id = p_flow_application_id
2968: and flow_code = p_flow_code
2969: and page_application_id = p_page_application_id
2970: and page_code = p_page_code;

Line 3027: -- AK_FLOW_PAGE_REGIONS

3023: -- If we are not deleting any referencing records, we cannot
3024: -- delete the flow page if it is being referenced in any of
3025: -- following tables.
3026: --
3027: -- AK_FLOW_PAGE_REGIONS
3028: --
3029: open l_get_page_regions_csr;
3030: fetch l_get_page_regions_csr into l_region_application_id, l_region_code;
3031: if l_get_page_regions_csr%found then

Line 3058: -- AK_FLOW_PAGE_REGIONS

3054: else
3055: --
3056: -- Otherwise, delete all referencing rows in other tables
3057: --
3058: -- AK_FLOW_PAGE_REGIONS
3059: --
3060: open l_get_page_regions_csr;
3061: loop
3062: fetch l_get_page_regions_csr into l_region_application_id, l_region_code;

Line 3285: from AK_FLOW_PAGE_REGIONS

3281: and primary_region_appl_id = p_region_application_id
3282: and primary_region_code = p_region_code;
3283: cursor l_get_child_regions_csr is
3284: select region_application_id, region_code
3285: from AK_FLOW_PAGE_REGIONS
3286: where flow_application_id = p_flow_application_id
3287: and flow_code = p_flow_code
3288: and page_application_id = p_page_application_id
3289: and page_code = p_page_code

Line 3392: -- AK_FLOW_PAGE_REGIONS (parent region of another region)

3388: raise FND_API.G_EXC_ERROR;
3389: end if;
3390: close l_get_to_relations_csr;
3391: --
3392: -- AK_FLOW_PAGE_REGIONS (parent region of another region)
3393: --
3394: open l_get_child_regions_csr;
3395: fetch l_get_child_regions_csr into l_region_appl_id, l_region_code;
3396: if l_get_child_regions_csr%found then

Line 3521: -- AK_FLOW_PAGE_REGIONS (parent region of another region)

3517: end if;
3518: end loop;
3519: close l_get_to_relations_csr;
3520: --
3521: -- AK_FLOW_PAGE_REGIONS (parent region of another region)
3522: --
3523: -- -blank out the parent region columns of the child regions.
3524: --
3525: open l_get_child_regions_csr;

Line 3600: delete from ak_flow_page_regions

3596: --
3597: -- delete flow page region once we checked that there are no references
3598: -- to it, or all references have been deleted.
3599: --
3600: delete from ak_flow_page_regions
3601: where flow_application_id = p_flow_application_id
3602: and flow_code = p_flow_code
3603: and page_application_id = p_page_application_id
3604: and page_code = p_page_code

Line 5009: from AK_FLOW_PAGE_REGIONS

5005: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
5006: ) is
5007: cursor l_get_row_csr is
5008: select *
5009: from AK_FLOW_PAGE_REGIONS
5010: where FLOW_APPLICATION_ID = p_flow_application_id
5011: and FLOW_CODE = p_flow_code
5012: and page_application_id = p_page_application_id
5013: and page_code = p_page_code

Line 5045: l_regions_rec ak_flow_page_regions%ROWTYPE;

5041: l_last_update_date date;
5042: l_last_update_login number;
5043: l_last_updated_by number;
5044: l_parent_region_changed varchar2(1);
5045: l_regions_rec ak_flow_page_regions%ROWTYPE;
5046: l_return_status varchar2(1);
5047: l_file_version number;
5048: begin
5049: IF NOT FND_API.Compatible_API_Call (

Line 5068: -- retrieve ak_flow_page_regions row if it exists

5064: select userenv('LANG') into l_lang
5065: from dual;
5066:
5067: --
5068: -- retrieve ak_flow_page_regions row if it exists
5069: --
5070: open l_get_row_csr;
5071: fetch l_get_row_csr into l_regions_rec;
5072: if (l_get_row_csr%notfound) then

Line 5382: update AK_FLOW_PAGE_REGIONS set

5378: end if; --/* if l_return_status */
5379: end if;
5380: end if;
5381:
5382: update AK_FLOW_PAGE_REGIONS set
5383: DISPLAY_SEQUENCE = l_regions_rec.display_sequence,
5384: REGION_STYLE = l_regions_rec.region_style,
5385: NUM_COLUMNS = l_regions_rec.num_columns,
5386: PARENT_REGION_APPLICATION_ID =l_regions_rec.parent_region_application_id,

Line 6359: from ak_flow_page_regions

6355: page_code_param IN VARCHAR2,
6356: page_application_id_param IN NUMBER,
6357: display_sequence_param IN NUMBER) is
6358: select *
6359: from ak_flow_page_regions
6360: where flow_code = flow_code_param
6361: and flow_application_id = flow_application_id_param
6362: and page_code = page_code_param
6363: and page_application_id = page_application_id_param

Line 6369: l_fpr_rec ak_flow_page_regions%ROWTYPE;

6365:
6366: l_api_name CONSTANT varchar2(30) := 'Check_Display_Sequence';
6367: l_new_display_sequence NUMBER;
6368: l_return_status VARCHAR2(1);
6369: l_fpr_rec ak_flow_page_regions%ROWTYPE;
6370: l_orig_fpr_rec ak_flow_page_regions%ROWTYPE;
6371:
6372: begin
6373: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6370: l_orig_fpr_rec ak_flow_page_regions%ROWTYPE;

6366: l_api_name CONSTANT varchar2(30) := 'Check_Display_Sequence';
6367: l_new_display_sequence NUMBER;
6368: l_return_status VARCHAR2(1);
6369: l_fpr_rec ak_flow_page_regions%ROWTYPE;
6370: l_orig_fpr_rec ak_flow_page_regions%ROWTYPE;
6371:
6372: begin
6373: l_return_status := FND_API.G_RET_STS_SUCCESS;
6374: open l_fpr_csr( p_flow_code,