APPS.IEX_DUNNING_PVT dependencies on JTF_FM_REQUEST_GRP

Line 6000: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

5996: l_Content_tbl IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE;
5997: l_Content_rec IEX_SEND_FFM_PVT.CONTENT_REC_TYPE;
5998: l_content_id NUMBER;
5999: l_doc_type VARCHAR2(50);
6000: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6001: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6002: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6003: --
6004: l_content_nm VARCHAR2(100);

Line 6001: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

5997: l_Content_rec IEX_SEND_FFM_PVT.CONTENT_REC_TYPE;
5998: l_content_id NUMBER;
5999: l_doc_type VARCHAR2(50);
6000: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6001: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6002: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6003: --
6004: l_content_nm VARCHAR2(100);
6005: l_party_id NUMBER;

Line 6002: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

5998: l_content_id NUMBER;
5999: l_doc_type VARCHAR2(50);
6000: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6001: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6002: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6003: --
6004: l_content_nm VARCHAR2(100);
6005: l_party_id NUMBER;
6006: l_user_id NUMBER;

Line 6488: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

6484: l_Content_tbl IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE;
6485: l_Content_rec IEX_SEND_FFM_PVT.CONTENT_REC_TYPE;
6486: l_content_id NUMBER;
6487: l_doc_type VARCHAR2(50);
6488: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6489: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6490: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6491: l_bind_cnt_tbl NUMBER;
6492: --

Line 6489: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

6485: l_Content_rec IEX_SEND_FFM_PVT.CONTENT_REC_TYPE;
6486: l_content_id NUMBER;
6487: l_doc_type VARCHAR2(50);
6488: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6489: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6490: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6491: l_bind_cnt_tbl NUMBER;
6492: --
6493: l_content_nm VARCHAR2(100);

Line 6490: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

6486: l_content_id NUMBER;
6487: l_doc_type VARCHAR2(50);
6488: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6489: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6490: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
6491: l_bind_cnt_tbl NUMBER;
6492: --
6493: l_content_nm VARCHAR2(100);
6494: l_party_id NUMBER;

Line 8265: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

8261: WHERE query_id = IN_ID
8262: AND nvl(upper(f_deletedflag),'0') <>'D';
8263: --
8264:
8265: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
8266: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
8267: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
8268: l_bind_cnt_tbl NUMBER;
8269: l_keep_flag NUMBER := 1;

Line 8266: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

8262: AND nvl(upper(f_deletedflag),'0') <>'D';
8263: --
8264:
8265: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
8266: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
8267: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
8268: l_bind_cnt_tbl NUMBER;
8269: l_keep_flag NUMBER := 1;
8270: l_query VARCHAR2(4000);

Line 8267: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

8263: --
8264:
8265: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
8266: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
8267: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
8268: l_bind_cnt_tbl NUMBER;
8269: l_keep_flag NUMBER := 1;
8270: l_query VARCHAR2(4000);
8271: l_part_query VARCHAR2(4000);