APPS.OKL_FE_WF dependencies on FND_APPLICATION

Line 580: l_application_id fnd_application.application_id%TYPE;

576: x_return_status VARCHAR2(1);
577: l_api_name VARCHAR2(40) := 'get_std_rate_tmpl_data';
578: x_msg_count NUMBER;
579: x_msg_data VARCHAR2(32767);
580: l_application_id fnd_application.application_id%TYPE;
581: l_api_version NUMBER := 1.0;
582: p_api_version NUMBER := 1.0;
583:
584: CURSOR get_srt_attributes(p_srt_version_id NUMBER) IS

Line 623: FROM FND_APPLICATION

619: -- Get the valid application id from FND
620:
621: CURSOR c_get_app_id_csr IS
622: SELECT APPLICATION_ID
623: FROM FND_APPLICATION
624: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
625:
626: BEGIN
627: x_return_status := okl_api.start_activity(l_api_name,

Line 818: l_application_id fnd_application.application_id%TYPE;

814: x_return_status VARCHAR2(1);
815: l_api_name VARCHAR2(40) := 'get_adj_matrix_get_data';
816: x_msg_count NUMBER;
817: x_msg_data VARCHAR2(32767);
818: l_application_id fnd_application.application_id%TYPE;
819: l_api_version NUMBER := 1.0;
820: p_api_version NUMBEr := 1.0;
821:
822: CURSOR get_adj_mat_attr(p_adj_mat_ver_id NUMBER) IS

Line 850: FROM FND_APPLICATION

846: -- Get the valid application id from FND
847:
848: CURSOR c_get_app_id_csr IS
849: SELECT APPLICATION_ID
850: FROM FND_APPLICATION
851: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
852:
853: BEGIN
854: x_return_status := okl_api.start_activity(l_api_name,

Line 1038: l_application_id fnd_application.application_id%TYPE;

1034: x_return_status VARCHAR2(1);
1035: l_api_name VARCHAR2(40) := 'get_end_of_term_data';
1036: x_msg_count NUMBER;
1037: x_msg_data VARCHAR2(32767);
1038: l_application_id fnd_application.application_id%TYPE;
1039: l_api_version NUMBER := 1.0;
1040: p_api_version NUMBER := 1.0;
1041:
1042: CURSOR get_end_of_term_attr(p_eot_version_id NUMBER) IS

Line 1074: FROM FND_APPLICATION

1070: -- Get the valid application id from FND
1071:
1072: CURSOR c_get_app_id_csr IS
1073: SELECT APPLICATION_ID
1074: FROM FND_APPLICATION
1075: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
1076:
1077: BEGIN
1078: x_return_status := okl_api.start_activity(l_api_name,

Line 1274: l_application_id fnd_application.application_id%TYPE;

1270: x_return_status VARCHAR2(1);
1271: l_api_name VARCHAR2(40) := 'get_item_residual_data';
1272: x_msg_count NUMBER;
1273: x_msg_data VARCHAR2(32767);
1274: l_application_id fnd_application.application_id%TYPE;
1275: l_api_version NUMBER := 1.0;
1276: p_api_version NUMBER := 1.0;
1277:
1278: CURSOR get_lrs_attr(p_rate_set_ver_id NUMBER) IS

Line 1315: FROM FND_APPLICATION

1311: -- Get the valid application id from FND
1312:
1313: CURSOR c_get_app_id_csr IS
1314: SELECT APPLICATION_ID
1315: FROM FND_APPLICATION
1316: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
1317:
1318: BEGIN
1319: x_return_status := okl_api.start_activity(l_api_name,

Line 1575: l_application_id fnd_application.application_id%TYPE;

1571: x_return_status VARCHAR2(1);
1572: l_api_name VARCHAR2(40) := 'get_item_residual_data';
1573: x_msg_count NUMBER;
1574: x_msg_data VARCHAR2(32767);
1575: l_application_id fnd_application.application_id%TYPE;
1576: l_api_version NUMBER := 1.0;
1577: p_api_version NUMBER := 1.0;
1578:
1579: -- Cursor for Item

Line 1665: FROM FND_APPLICATION

1661: -- Get the valid application id from FND
1662:
1663: CURSOR c_get_app_id_csr IS
1664: SELECT APPLICATION_ID
1665: FROM FND_APPLICATION
1666: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
1667:
1668: CURSOR c_get_cat_type(p_item_resdl_version_id NUMBER) IS
1669: SELECT IRHV.CATEGORY_TYPE_CODE