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.OKL_FE_WF dependencies on FND_USER

Line 614: CURSOR fnd_user_csr IS

610: TEMPLATE_DESC
611: FROM OKL_FE_STD_RT_TMP_VERS_V
612: WHERE STD_RATE_TMPL_VER_ID = p_srt_version_id;
613:
614: CURSOR fnd_user_csr IS
615: SELECT USER_NAME
616: FROM FND_USER
617: WHERE USER_ID = fnd_global.user_id;
618:

Line 616: FROM FND_USER

612: WHERE STD_RATE_TMPL_VER_ID = p_srt_version_id;
613:
614: CURSOR fnd_user_csr IS
615: SELECT USER_NAME
616: FROM FND_USER
617: WHERE USER_ID = fnd_global.user_id;
618:
619: -- Get the valid application id from FND
620:

Line 676: OPEN fnd_user_csr;

672: itemkey,
673: 'EFFECTIVE_TO',
674: l_srt_rec.EFFECTIVE_TO_DATE);
675: END LOOP;
676: OPEN fnd_user_csr;
677: FETCH fnd_user_csr INTO l_user_name ;
678: CLOSE fnd_user_csr;
679:
680: -- get the application id

Line 677: FETCH fnd_user_csr INTO l_user_name ;

673: 'EFFECTIVE_TO',
674: l_srt_rec.EFFECTIVE_TO_DATE);
675: END LOOP;
676: OPEN fnd_user_csr;
677: FETCH fnd_user_csr INTO l_user_name ;
678: CLOSE fnd_user_csr;
679:
680: -- get the application id
681:

Line 678: CLOSE fnd_user_csr;

674: l_srt_rec.EFFECTIVE_TO_DATE);
675: END LOOP;
676: OPEN fnd_user_csr;
677: FETCH fnd_user_csr INTO l_user_name ;
678: CLOSE fnd_user_csr;
679:
680: -- get the application id
681:
682: OPEN c_get_app_id_csr;

Line 841: CURSOR fnd_user_csr IS

837: ADJ_MAT_DESC
838: FROM OKL_FE_ADJ_MAT_VERS_V
839: WHERE ADJ_MAT_VERSION_ID = p_adj_mat_ver_id;
840:
841: CURSOR fnd_user_csr IS
842: SELECT USER_NAME
843: FROM FND_USER
844: WHERE USER_ID = fnd_global.user_id;
845:

Line 843: FROM FND_USER

839: WHERE ADJ_MAT_VERSION_ID = p_adj_mat_ver_id;
840:
841: CURSOR fnd_user_csr IS
842: SELECT USER_NAME
843: FROM FND_USER
844: WHERE USER_ID = fnd_global.user_id;
845:
846: -- Get the valid application id from FND
847:

Line 899: OPEN fnd_user_csr;

895: itemkey,
896: 'EFFECTIVE_TO',
897: l_adj_mat_rec.EFFECTIVE_TO_DATE);
898: END LOOP;
899: OPEN fnd_user_csr;
900: FETCH fnd_user_csr INTO l_user_name ;
901: CLOSE fnd_user_csr;
902:
903: -- get the application id

Line 900: FETCH fnd_user_csr INTO l_user_name ;

896: 'EFFECTIVE_TO',
897: l_adj_mat_rec.EFFECTIVE_TO_DATE);
898: END LOOP;
899: OPEN fnd_user_csr;
900: FETCH fnd_user_csr INTO l_user_name ;
901: CLOSE fnd_user_csr;
902:
903: -- get the application id
904:

Line 901: CLOSE fnd_user_csr;

897: l_adj_mat_rec.EFFECTIVE_TO_DATE);
898: END LOOP;
899: OPEN fnd_user_csr;
900: FETCH fnd_user_csr INTO l_user_name ;
901: CLOSE fnd_user_csr;
902:
903: -- get the application id
904:
905: OPEN c_get_app_id_csr;

Line 1065: CURSOR fnd_user_csr IS

1061: WHERE END_OF_TERM_VER_ID = p_eot_version_id;
1062:
1063: -- find the user
1064:
1065: CURSOR fnd_user_csr IS
1066: SELECT USER_NAME
1067: FROM FND_USER
1068: WHERE USER_ID = fnd_global.user_id;
1069:

Line 1067: FROM FND_USER

1063: -- find the user
1064:
1065: CURSOR fnd_user_csr IS
1066: SELECT USER_NAME
1067: FROM FND_USER
1068: WHERE USER_ID = fnd_global.user_id;
1069:
1070: -- Get the valid application id from FND
1071:

Line 1135: OPEN fnd_user_csr;

1131: itemkey,
1132: 'EFFECTIVE_TO',
1133: l_eot_val_rec.EFFECTIVE_TO_DATE);
1134: END LOOP;
1135: OPEN fnd_user_csr;
1136: FETCH fnd_user_csr INTO l_user_name ;
1137: CLOSE fnd_user_csr;
1138:
1139: -- get the application id

Line 1136: FETCH fnd_user_csr INTO l_user_name ;

1132: 'EFFECTIVE_TO',
1133: l_eot_val_rec.EFFECTIVE_TO_DATE);
1134: END LOOP;
1135: OPEN fnd_user_csr;
1136: FETCH fnd_user_csr INTO l_user_name ;
1137: CLOSE fnd_user_csr;
1138:
1139: -- get the application id
1140:

Line 1137: CLOSE fnd_user_csr;

1133: l_eot_val_rec.EFFECTIVE_TO_DATE);
1134: END LOOP;
1135: OPEN fnd_user_csr;
1136: FETCH fnd_user_csr INTO l_user_name ;
1137: CLOSE fnd_user_csr;
1138:
1139: -- get the application id
1140:
1141: OPEN c_get_app_id_csr;

Line 1306: CURSOR fnd_user_csr IS

1302: WHERE A.ID = B.RATE_SET_ID
1303: AND B.RATE_SET_VERSION_ID = p_rate_set_ver_id;
1304: l_lrv_rec get_lrs_attr%ROWTYPE;
1305:
1306: CURSOR fnd_user_csr IS
1307: SELECT USER_NAME
1308: FROM FND_USER
1309: WHERE USER_ID = fnd_global.user_id;
1310:

Line 1308: FROM FND_USER

1304: l_lrv_rec get_lrs_attr%ROWTYPE;
1305:
1306: CURSOR fnd_user_csr IS
1307: SELECT USER_NAME
1308: FROM FND_USER
1309: WHERE USER_ID = fnd_global.user_id;
1310:
1311: -- Get the valid application id from FND
1312:

Line 1430: OPEN fnd_user_csr;

1426: l_lrv_rec.ADJ_MAT_VERSION_ID);
1427:
1428: -- get the user name
1429:
1430: OPEN fnd_user_csr;
1431: FETCH fnd_user_csr INTO l_user_name ;
1432: CLOSE fnd_user_csr;
1433:
1434: -- get the application id

Line 1431: FETCH fnd_user_csr INTO l_user_name ;

1427:
1428: -- get the user name
1429:
1430: OPEN fnd_user_csr;
1431: FETCH fnd_user_csr INTO l_user_name ;
1432: CLOSE fnd_user_csr;
1433:
1434: -- get the application id
1435:

Line 1432: CLOSE fnd_user_csr;

1428: -- get the user name
1429:
1430: OPEN fnd_user_csr;
1431: FETCH fnd_user_csr INTO l_user_name ;
1432: CLOSE fnd_user_csr;
1433:
1434: -- get the application id
1435:
1436: OPEN c_get_app_id_csr;

Line 1656: CURSOR fnd_user_csr IS

1652: AND ICPV.ITEM_RESIDUAL_ID = IRHV.ITEM_RESIDUAL_ID
1653: AND ICPV.ID = p_itm_resdl_ver_id;
1654: l_attr_rec get_irs_attr_item%ROWTYPE;
1655:
1656: CURSOR fnd_user_csr IS
1657: SELECT USER_NAME
1658: FROM FND_USER
1659: WHERE USER_ID = fnd_global.user_id;
1660:

Line 1658: FROM FND_USER

1654: l_attr_rec get_irs_attr_item%ROWTYPE;
1655:
1656: CURSOR fnd_user_csr IS
1657: SELECT USER_NAME
1658: FROM FND_USER
1659: WHERE USER_ID = fnd_global.user_id;
1660:
1661: -- Get the valid application id from FND
1662:

Line 1773: OPEN fnd_user_csr;

1769: wf_engine.SetItemAttrDate(itemtype,
1770: itemkey,
1771: 'EFFECTIVE_TO',
1772: l_attr_rec.end_date);
1773: OPEN fnd_user_csr;
1774: FETCH fnd_user_csr INTO l_user_name ;
1775: CLOSE fnd_user_csr;
1776:
1777: -- get the application id

Line 1774: FETCH fnd_user_csr INTO l_user_name ;

1770: itemkey,
1771: 'EFFECTIVE_TO',
1772: l_attr_rec.end_date);
1773: OPEN fnd_user_csr;
1774: FETCH fnd_user_csr INTO l_user_name ;
1775: CLOSE fnd_user_csr;
1776:
1777: -- get the application id
1778:

Line 1775: CLOSE fnd_user_csr;

1771: 'EFFECTIVE_TO',
1772: l_attr_rec.end_date);
1773: OPEN fnd_user_csr;
1774: FETCH fnd_user_csr INTO l_user_name ;
1775: CLOSE fnd_user_csr;
1776:
1777: -- get the application id
1778:
1779: OPEN c_get_app_id_csr;