APPS.AK_FLOW2_PVT dependencies on AK_FLOW_REGION_RELATIONS

Line 368: from AK_FLOW_REGION_RELATIONS

364: parent_region_code_param varchar2,
365: region_appl_id_param number,
366: region_code_param varchar2) is
367: select foreign_key_name
368: from AK_FLOW_REGION_RELATIONS
369: where FLOW_APPLICATION_ID = p_flow_application_id
370: and FLOW_CODE = p_flow_code
371: and FROM_PAGE_APPL_ID = p_page_application_id
372: and FROM_PAGE_CODE = p_page_code

Line 1091: from AK_FLOW_REGION_RELATIONS

1087: p_flow_code IN VARCHAR2
1088: ) is
1089: cursor l_get_relations_csr is
1090: select *
1091: from AK_FLOW_REGION_RELATIONS
1092: where FLOW_APPLICATION_ID = p_flow_application_id
1093: and FLOW_CODE = p_flow_code
1094: and ( (FROM_PAGE_APPL_ID <> TO_PAGE_APPL_ID) or
1095: (FROM_PAGE_CODE <> TO_PAGE_CODE) );

Line 1099: l_relations_rec AK_FLOW_REGION_RELATIONS%ROWTYPE;

1095: (FROM_PAGE_CODE <> TO_PAGE_CODE) );
1096: l_api_name CONSTANT varchar2(30) := 'Write_Relations_to_buffer';
1097: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1098: l_index NUMBER;
1099: l_relations_rec AK_FLOW_REGION_RELATIONS%ROWTYPE;
1100: l_return_status varchar2(1);
1101: begin
1102: -- Find out where the next buffer entry to be written to
1103: l_index := 1;

Line 4230: from ak_flow_region_relations

4226: );
4227: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
4228: select last_updated_by, last_update_date
4229: into l_user_id1, l_update1
4230: from ak_flow_region_relations
4231: where flow_code = l_relation_tbl(l_index).flow_code
4232: and flow_application_id = l_relation_tbl(l_index).flow_application_id
4233: and foreign_key_name = l_relation_tbl(l_index).foreign_key_name
4234: and from_page_code = l_relation_tbl(l_index).from_page_code