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_FLOW2_PVT dependencies on AK_FLOW_PVT

Line 1886: --dbms_output.put_line('returning from ak_flow_pvt.download_flow: ' ||

1882: -- Ready to download the next flow in the list
1883: l_index := l_flow_pk_tbl.NEXT(l_index);
1884: end loop;
1885:
1886: --dbms_output.put_line('returning from ak_flow_pvt.download_flow: ' ||
1887: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
1888:
1889: -- p_buffer_tbl := l_region_buf_tbl;
1890: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

Line 3444: if NOT AK_FLOW_PVT.FLOW_EXISTS (

3440: --
3441: if (l_flow_tbl.count > 0) then
3442: for l_index in l_flow_tbl.FIRST .. l_flow_tbl.LAST loop
3443: if (l_flow_tbl.exists(l_index)) then
3444: if NOT AK_FLOW_PVT.FLOW_EXISTS (
3445: p_api_version_number => 1.0,
3446: p_return_status => l_return_status,
3447: p_flow_application_id =>
3448: l_flow_tbl(l_index).flow_application_id,

Line 3450: AK_FLOW_PVT.CREATE_FLOW (

3446: p_return_status => l_return_status,
3447: p_flow_application_id =>
3448: l_flow_tbl(l_index).flow_application_id,
3449: p_flow_code => l_flow_tbl(l_index).flow_code) then
3450: AK_FLOW_PVT.CREATE_FLOW (
3451: p_validation_level => p_validation_level,
3452: p_api_version_number => 1.0,
3453: p_msg_count => l_msg_count,
3454: p_msg_data => l_msg_data,

Line 3492: end if; -- /* if AK_FLOW_PVT.FLOW_EXISTS */

3488: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3489: (l_return_status = FND_API.G_RET_STS_ERROR) then
3490: RAISE FND_API.G_EXC_ERROR;
3491: end if;
3492: end if; -- /* if AK_FLOW_PVT.FLOW_EXISTS */
3493: end if;
3494: end loop;
3495: end if;
3496:

Line 3511: if NOT AK_FLOW_PVT.PAGE_EXISTS (

3507: --
3508: if (l_page_tbl.count > 0) then
3509: for l_index in l_page_tbl.FIRST .. l_page_tbl.LAST loop
3510: if (l_page_tbl.exists(l_index)) then
3511: if NOT AK_FLOW_PVT.PAGE_EXISTS (
3512: p_api_version_number => 1.0,
3513: p_return_status => l_return_status,
3514: p_flow_application_id =>
3515: l_page_tbl(l_index).flow_application_id,

Line 3520: AK_FLOW_PVT.CREATE_PAGE (

3516: p_flow_code => l_page_tbl(l_index).flow_code,
3517: p_page_application_id =>
3518: l_page_tbl(l_index).page_application_id,
3519: p_page_code => l_page_tbl(l_index).page_code) then
3520: AK_FLOW_PVT.CREATE_PAGE (
3521: p_validation_level => p_validation_level,
3522: p_api_version_number => 1.0,
3523: p_msg_count => l_msg_count,
3524: p_msg_data => l_msg_data,

Line 3583: AK_FLOW_PVT.UPDATE_FLOW (

3579: for l_index in l_flow_tbl.FIRST .. l_flow_tbl.LAST loop
3580: if (l_flow_tbl.exists(l_index)) then
3581: -- update all records
3582: if ( AK_UPLOAD_GRP.G_UPDATE_MODE ) then
3583: AK_FLOW_PVT.UPDATE_FLOW (
3584: p_validation_level => p_validation_level,
3585: p_api_version_number => 1.0,
3586: p_msg_count => l_msg_count,
3587: p_msg_data => l_msg_data,

Line 3660: AK_FLOW_PVT.UPDATE_FLOW (

3656: p_create_or_update => 'UPDATE'))
3657: or
3658: ( l_temp_key_code <> l_flow_tbl(l_index).primary_page_code and
3659: l_temp_key_appl_id <> l_flow_tbl(l_index).primary_page_appl_id ) ) then
3660: AK_FLOW_PVT.UPDATE_FLOW (
3661: p_validation_level => p_validation_level,
3662: p_api_version_number => 1.0,
3663: p_msg_count => l_msg_count,
3664: p_msg_data => l_msg_data,

Line 3721: if AK_FLOW_PVT.PAGE_REGION_EXISTS (

3717: --
3718: if (l_region_tbl.count > 0) then
3719: for l_index in l_region_tbl.FIRST .. l_region_tbl.LAST loop
3720: if (l_region_tbl.exists(l_index)) then
3721: if AK_FLOW_PVT.PAGE_REGION_EXISTS (
3722: p_api_version_number => 1.0,
3723: p_return_status => l_return_status,
3724: p_flow_application_id =>
3725: l_region_tbl(l_index).flow_application_id,

Line 3737: AK_FLOW_PVT.UPDATE_PAGE_REGION (

3733: --
3734: -- Update Page Region only if Update Mode is TRUE
3735: --
3736: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
3737: AK_FLOW_PVT.UPDATE_PAGE_REGION (
3738: p_validation_level => p_validation_level,
3739: p_api_version_number => 1.0,
3740: p_msg_count => l_msg_count,
3741: p_msg_data => l_msg_data,

Line 3808: AK_FLOW_PVT.UPDATE_PAGE_REGION (

3804: p_db_last_update_date => l_update1,
3805: p_last_update_login => l_region_tbl(l_index).last_update_login,
3806: p_create_or_update => 'UPDATE') then
3807:
3808: AK_FLOW_PVT.UPDATE_PAGE_REGION (
3809: p_validation_level => p_validation_level,
3810: p_api_version_number => 1.0,
3811: p_msg_count => l_msg_count,
3812: p_msg_data => l_msg_data,

Line 3859: AK_FLOW_PVT.CREATE_PAGE_REGION (

3855: );
3856: end if; -- /* if l_user_id1 = 1 */
3857: end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE */
3858: else
3859: AK_FLOW_PVT.CREATE_PAGE_REGION (
3860: p_validation_level => p_validation_level,
3861: p_api_version_number => 1.0,
3862: p_msg_count => l_msg_count,
3863: p_msg_data => l_msg_data,

Line 3937: AK_FLOW_PVT.UPDATE_PAGE_REGION (

3933: for l_index in l_region_tbl.FIRST .. l_region_tbl.LAST loop
3934: if (l_region_tbl.exists(l_index)) then
3935: if ( (l_region_tbl(l_index).parent_region_appl_id is not null) or
3936: (l_region_tbl(l_index).parent_region_code is not null) ) then
3937: AK_FLOW_PVT.UPDATE_PAGE_REGION (
3938: p_validation_level => p_validation_level,
3939: p_api_version_number => 1.0,
3940: p_msg_count => l_msg_count,
3941: p_msg_data => l_msg_data,

Line 4009: AK_FLOW_PVT.UPDATE_PAGE (

4005: for l_index in l_page_tbl.FIRST .. l_page_tbl.LAST loop
4006: if (l_page_tbl.exists(l_index)) then
4007: -- update all records
4008: if ( AK_UPLOAD_GRP.G_UPDATE_MODE ) then
4009: AK_FLOW_PVT.UPDATE_PAGE (
4010: p_validation_level => p_validation_level,
4011: p_api_version_number => 1.0,
4012: p_msg_count => l_msg_count,
4013: p_msg_data => l_msg_data,

Line 4093: AK_FLOW_PVT.UPDATE_PAGE (

4089: p_create_or_update => 'UPDATE'))
4090: or
4091: ( l_temp_key_appl_id <> l_page_tbl(l_index).primary_region_appl_id and
4092: l_temp_key_code <> l_page_tbl(l_index).primary_region_code ) ) then
4093: AK_FLOW_PVT.UPDATE_PAGE (
4094: p_validation_level => p_validation_level,
4095: p_api_version_number => 1.0,
4096: p_msg_count => l_msg_count,
4097: p_msg_data => l_msg_data,

Line 4160: if AK_FLOW_PVT.REGION_RELATION_EXISTS (

4156: --
4157: if (l_relation_tbl.count > 0) then
4158: for l_index in l_relation_tbl.FIRST .. l_relation_tbl.LAST loop
4159: if (l_relation_tbl.exists(l_index)) then
4160: if AK_FLOW_PVT.REGION_RELATION_EXISTS (
4161: p_api_version_number => 1.0,
4162: p_return_status => l_return_status,
4163: p_flow_application_id =>
4164: l_relation_tbl(l_index).flow_application_id,

Line 4181: AK_FLOW_PVT.UPDATE_REGION_RELATION (

4177: --
4178: -- Update Flow Page Region Relation only if G_UPDATE_MODE is TRUE
4179: --
4180: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
4181: AK_FLOW_PVT.UPDATE_REGION_RELATION (
4182: p_validation_level => p_validation_level,
4183: p_api_version_number => 1.0,
4184: p_msg_count => l_msg_count,
4185: p_msg_data => l_msg_data,

Line 4255: AK_FLOW_PVT.UPDATE_REGION_RELATION (

4251: p_db_last_update_date => l_update1,
4252: p_last_update_login => l_relation_tbl(l_index).last_update_login,
4253: p_create_or_update => 'UPDATE') then
4254:
4255: AK_FLOW_PVT.UPDATE_REGION_RELATION (
4256: p_validation_level => p_validation_level,
4257: p_api_version_number => 1.0,
4258: p_msg_count => l_msg_count,
4259: p_msg_data => l_msg_data,

Line 4304: AK_FLOW_PVT.CREATE_REGION_RELATION (

4300: );
4301: end if; -- /* if l_user_id1 = 1 */
4302: end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE */
4303: else
4304: AK_FLOW_PVT.CREATE_REGION_RELATION (
4305: p_validation_level => p_validation_level,
4306: p_api_version_number => 1.0,
4307: p_msg_count => l_msg_count,
4308: p_msg_data => l_msg_data,

Line 4375: if AK_FLOW_PVT.PAGE_REGION_ITEM_EXISTS (

4371: --
4372: if (l_item_tbl.count > 0) then
4373: for l_index in l_item_tbl.FIRST .. l_item_tbl.LAST loop
4374: if (l_item_tbl.exists(l_index)) then
4375: if AK_FLOW_PVT.PAGE_REGION_ITEM_EXISTS (
4376: p_api_version_number => 1.0,
4377: p_return_status => l_return_status,
4378: p_flow_application_id =>
4379: l_item_tbl(l_index).flow_application_id,

Line 4394: AK_FLOW_PVT.UPDATE_PAGE_REGION_ITEM (

4390: --
4391: -- Update Flow Page Region Item only if G_UPDATE_MODE is TRUE
4392: --
4393: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
4394: AK_FLOW_PVT.UPDATE_PAGE_REGION_ITEM (
4395: p_validation_level => p_validation_level,
4396: p_api_version_number => 1.0,
4397: p_msg_count => l_msg_count,
4398: p_msg_data => l_msg_data,

Line 4467: AK_FLOW_PVT.UPDATE_PAGE_REGION_ITEM (

4463: p_db_last_update_date => l_update1,
4464: p_last_update_login => l_item_tbl(l_index).last_update_login,
4465: p_create_or_update => 'UPDATE') then
4466:
4467: AK_FLOW_PVT.UPDATE_PAGE_REGION_ITEM (
4468: p_validation_level => p_validation_level,
4469: p_api_version_number => 1.0,
4470: p_msg_count => l_msg_count,
4471: p_msg_data => l_msg_data,

Line 4519: AK_FLOW_PVT.CREATE_PAGE_REGION_ITEM (

4515: );
4516: end if; -- /* if l_user_id1 = 1 */
4517: end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE */
4518: else
4519: AK_FLOW_PVT.CREATE_PAGE_REGION_ITEM (
4520: p_validation_level => p_validation_level,
4521: p_api_version_number => 1.0,
4522: p_msg_count => l_msg_count,
4523: p_msg_data => l_msg_data,

Line 4664: if NOT AK_FLOW_PVT.FLOW_EXISTS (

4660: -- dbms_output.put_line('number of redo flows: '||to_char(G_FLOW_REDO_INDEX));
4661:
4662: for l_index in G_FLOW_REDO_TBL.FIRST .. G_FLOW_REDO_TBL.LAST loop
4663: if (G_FLOW_REDO_TBL.exists(l_index)) then
4664: if NOT AK_FLOW_PVT.FLOW_EXISTS (
4665: p_api_version_number => 1.0,
4666: p_return_status => l_return_status,
4667: p_flow_application_id =>
4668: G_FLOW_REDO_TBL(l_index).flow_application_id,

Line 4670: AK_FLOW_PVT.CREATE_FLOW (

4666: p_return_status => l_return_status,
4667: p_flow_application_id =>
4668: G_FLOW_REDO_TBL(l_index).flow_application_id,
4669: p_flow_code => G_FLOW_REDO_TBL(l_index).flow_code) then
4670: AK_FLOW_PVT.CREATE_FLOW (
4671: p_validation_level => p_validation_level,
4672: p_api_version_number => 1.0,
4673: p_msg_count => l_msg_count,
4674: p_msg_data => l_msg_data,

Line 4696: end if; -- /* if AK_FLOW_PVT.FLOW_EXISTS */

4692: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4693: (l_return_status = FND_API.G_RET_STS_ERROR) then
4694: RAISE FND_API.G_EXC_ERROR;
4695: end if;
4696: end if; -- /* if AK_FLOW_PVT.FLOW_EXISTS */
4697: end if;
4698: end loop;
4699: --don't initialize G_FLOW_REDO_TBL it's used later
4700: end if;

Line 4717: if NOT AK_FLOW_PVT.PAGE_EXISTS (

4713: if (G_PAGE_REDO_INDEX > 0) then
4714: -- dbms_output.put_line('number of redo pages: '||to_char(G_PAGE_REDO_INDEX));
4715: for l_index in G_PAGE_REDO_TBL.FIRST .. G_PAGE_REDO_TBL.LAST loop
4716: if (G_PAGE_REDO_TBL.exists(l_index)) then
4717: if NOT AK_FLOW_PVT.PAGE_EXISTS (
4718: p_api_version_number => 1.0,
4719: p_return_status => l_return_status,
4720: p_flow_application_id =>
4721: G_PAGE_REDO_TBL(l_index).flow_application_id,

Line 4726: AK_FLOW_PVT.CREATE_PAGE (

4722: p_flow_code => G_PAGE_REDO_TBL(l_index).flow_code,
4723: p_page_application_id =>
4724: G_PAGE_REDO_TBL(l_index).page_application_id,
4725: p_page_code => G_PAGE_REDO_TBL(l_index).page_code) then
4726: AK_FLOW_PVT.CREATE_PAGE (
4727: p_validation_level => p_validation_level,
4728: p_api_version_number => 1.0,
4729: p_msg_count => l_msg_count,
4730: p_msg_data => l_msg_data,

Line 4788: AK_FLOW_PVT.UPDATE_FLOW (

4784: --
4785: if (G_FLOW_REDO_TBL.count > 0) then
4786: for l_index in G_FLOW_REDO_TBL.FIRST .. G_FLOW_REDO_TBL.LAST loop
4787: if (G_FLOW_REDO_TBL.exists(l_index)) then
4788: AK_FLOW_PVT.UPDATE_FLOW (
4789: p_validation_level => p_validation_level,
4790: p_api_version_number => 1.0,
4791: p_msg_count => l_msg_count,
4792: p_msg_data => l_msg_data,

Line 4845: if AK_FLOW_PVT.PAGE_REGION_EXISTS (

4841: if (G_PAGE_REGION_REDO_INDEX > 0) then
4842: -- dbms_output.put_line('number of redo page regions: '||to_char(G_PAGE_REGION_REDO_INDEX));
4843: for l_index in G_PAGE_REGION_REDO_TBL.FIRST .. G_PAGE_REGION_REDO_TBL.LAST loop
4844: if (G_PAGE_REGION_REDO_TBL.exists(l_index)) then
4845: if AK_FLOW_PVT.PAGE_REGION_EXISTS (
4846: p_api_version_number => 1.0,
4847: p_return_status => l_return_status,
4848: p_flow_application_id =>
4849: G_PAGE_REGION_REDO_TBL(l_index).flow_application_id,

Line 4857: AK_FLOW_PVT.UPDATE_PAGE_REGION (

4853: p_page_code => G_PAGE_REGION_REDO_TBL(l_index).page_code,
4854: p_region_application_id =>
4855: G_PAGE_REGION_REDO_TBL(l_index).region_application_id,
4856: p_region_code => G_PAGE_REGION_REDO_TBL(l_index).region_code) then
4857: AK_FLOW_PVT.UPDATE_PAGE_REGION (
4858: p_validation_level => p_validation_level,
4859: p_api_version_number => 1.0,
4860: p_msg_count => l_msg_count,
4861: p_msg_data => l_msg_data,

Line 4906: AK_FLOW_PVT.CREATE_PAGE_REGION (

4902: p_pass => p_pass,
4903: p_copy_redo_flag => l_copy_redo_flag
4904: );
4905: else
4906: AK_FLOW_PVT.CREATE_PAGE_REGION (
4907: p_validation_level => p_validation_level,
4908: p_api_version_number => 1.0,
4909: p_msg_count => l_msg_count,
4910: p_msg_data => l_msg_data,

Line 4979: AK_FLOW_PVT.UPDATE_PAGE_REGION (

4975: for l_index in G_PAGE_REGION_REDO_TBL.FIRST .. G_PAGE_REGION_REDO_TBL.LAST loop
4976: if (G_PAGE_REGION_REDO_TBL.exists(l_index)) then
4977: if ( (G_PAGE_REGION_REDO_TBL(l_index).parent_region_appl_id is not null) or
4978: (G_PAGE_REGION_REDO_TBL(l_index).parent_region_code is not null) ) then
4979: AK_FLOW_PVT.UPDATE_PAGE_REGION (
4980: p_validation_level => p_validation_level,
4981: p_api_version_number => 1.0,
4982: p_msg_count => l_msg_count,
4983: p_msg_data => l_msg_data,

Line 5041: AK_FLOW_PVT.UPDATE_PAGE (

5037: --
5038: if (G_PAGE_REDO_TBL.count > 0) then
5039: for l_index in G_PAGE_REDO_TBL.FIRST .. G_PAGE_REDO_TBL.LAST loop
5040: if (G_PAGE_REDO_TBL.exists(l_index)) then
5041: AK_FLOW_PVT.UPDATE_PAGE (
5042: p_validation_level => p_validation_level,
5043: p_api_version_number => 1.0,
5044: p_msg_count => l_msg_count,
5045: p_msg_data => l_msg_data,

Line 5098: if AK_FLOW_PVT.REGION_RELATION_EXISTS (

5094: --
5095: if (G_REGION_RELATION_REDO_INDEX > 0) then
5096: for l_index in G_REGION_RELATION_REDO_TBL.FIRST .. G_REGION_RELATION_REDO_TBL.LAST loop
5097: if (G_REGION_RELATION_REDO_TBL.exists(l_index)) then
5098: if AK_FLOW_PVT.REGION_RELATION_EXISTS (
5099: p_api_version_number => 1.0,
5100: p_return_status => l_return_status,
5101: p_flow_application_id =>
5102: G_REGION_RELATION_REDO_TBL(l_index).flow_application_id,

Line 5115: AK_FLOW_PVT.UPDATE_REGION_RELATION (

5111: p_to_page_code => G_REGION_RELATION_REDO_TBL(l_index).to_page_code,
5112: p_to_region_appl_id =>
5113: G_REGION_RELATION_REDO_TBL(l_index).to_region_appl_id,
5114: p_to_region_code => G_REGION_RELATION_REDO_TBL(l_index).to_region_code) then
5115: AK_FLOW_PVT.UPDATE_REGION_RELATION (
5116: p_validation_level => p_validation_level,
5117: p_api_version_number => 1.0,
5118: p_msg_count => l_msg_count,
5119: p_msg_data => l_msg_data,

Line 5162: AK_FLOW_PVT.CREATE_REGION_RELATION (

5158: p_pass => p_pass,
5159: p_copy_redo_flag => l_copy_redo_flag
5160: );
5161: else
5162: AK_FLOW_PVT.CREATE_REGION_RELATION (
5163: p_validation_level => p_validation_level,
5164: p_api_version_number => 1.0,
5165: p_msg_count => l_msg_count,
5166: p_msg_data => l_msg_data,

Line 5230: if AK_FLOW_PVT.PAGE_REGION_ITEM_EXISTS (

5226: --
5227: if (G_PAGE_REGION_ITEM_REDO_INDEX > 0) then
5228: for l_index in G_PAGE_REGION_ITEM_REDO_TBL.FIRST .. G_PAGE_REGION_ITEM_REDO_TBL.LAST loop
5229: if (G_PAGE_REGION_ITEM_REDO_TBL.exists(l_index)) then
5230: if AK_FLOW_PVT.PAGE_REGION_ITEM_EXISTS (
5231: p_api_version_number => 1.0,
5232: p_return_status => l_return_status,
5233: p_flow_application_id =>
5234: G_PAGE_REGION_ITEM_REDO_TBL(l_index).flow_application_id,

Line 5245: AK_FLOW_PVT.UPDATE_PAGE_REGION_ITEM (

5241: p_region_code => G_PAGE_REGION_ITEM_REDO_TBL(l_index).region_code,
5242: p_attribute_application_id =>
5243: G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute_application_id,
5244: p_attribute_code => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute_code) then
5245: AK_FLOW_PVT.UPDATE_PAGE_REGION_ITEM (
5246: p_validation_level => p_validation_level,
5247: p_api_version_number => 1.0,
5248: p_msg_count => l_msg_count,
5249: p_msg_data => l_msg_data,

Line 5295: AK_FLOW_PVT.CREATE_PAGE_REGION_ITEM (

5291: p_pass => p_pass,
5292: p_copy_redo_flag => l_copy_redo_flag
5293: );
5294: else
5295: AK_FLOW_PVT.CREATE_PAGE_REGION_ITEM (
5296: p_validation_level => p_validation_level,
5297: p_api_version_number => 1.0,
5298: p_msg_count => l_msg_count,
5299: p_msg_data => l_msg_data,