APPS.IEX_DUNNING_PVT dependencies on JTF_FM_REQUEST_GRP

Line 13053: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

13049: l_Content_tbl IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE;
13050: l_Content_rec IEX_SEND_FFM_PVT.CONTENT_REC_TYPE;
13051: l_content_id NUMBER;
13052: l_doc_type VARCHAR2(50);
13053: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13054: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13055: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13056: --
13057: l_content_nm VARCHAR2(100);

Line 13054: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

13050: l_Content_rec IEX_SEND_FFM_PVT.CONTENT_REC_TYPE;
13051: l_content_id NUMBER;
13052: l_doc_type VARCHAR2(50);
13053: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13054: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13055: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13056: --
13057: l_content_nm VARCHAR2(100);
13058: l_party_id NUMBER;

Line 13055: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

13051: l_content_id NUMBER;
13052: l_doc_type VARCHAR2(50);
13053: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13054: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13055: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13056: --
13057: l_content_nm VARCHAR2(100);
13058: l_party_id NUMBER;
13059: l_user_id NUMBER;

Line 13545: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

13541: l_Content_tbl IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE;
13542: l_Content_rec IEX_SEND_FFM_PVT.CONTENT_REC_TYPE;
13543: l_content_id NUMBER;
13544: l_doc_type VARCHAR2(50);
13545: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13546: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13547: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13548: l_bind_cnt_tbl NUMBER;
13549: --

Line 13546: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

13542: l_Content_rec IEX_SEND_FFM_PVT.CONTENT_REC_TYPE;
13543: l_content_id NUMBER;
13544: l_doc_type VARCHAR2(50);
13545: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13546: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13547: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13548: l_bind_cnt_tbl NUMBER;
13549: --
13550: l_content_nm VARCHAR2(100);

Line 13547: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

13543: l_content_id NUMBER;
13544: l_doc_type VARCHAR2(50);
13545: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13546: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13547: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
13548: l_bind_cnt_tbl NUMBER;
13549: --
13550: l_content_nm VARCHAR2(100);
13551: l_party_id NUMBER;

Line 15770: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

15766: WHERE query_id = IN_ID
15767: AND nvl(upper(f_deletedflag),'0') <>'D';
15768: --
15769:
15770: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
15771: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
15772: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
15773: l_bind_cnt_tbl NUMBER;
15774: l_keep_flag NUMBER := 1;

Line 15771: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

15767: AND nvl(upper(f_deletedflag),'0') <>'D';
15768: --
15769:
15770: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
15771: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
15772: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
15773: l_bind_cnt_tbl NUMBER;
15774: l_keep_flag NUMBER := 1;
15775: l_query VARCHAR2(4000);

Line 15772: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

15768: --
15769:
15770: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
15771: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
15772: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
15773: l_bind_cnt_tbl NUMBER;
15774: l_keep_flag NUMBER := 1;
15775: l_query VARCHAR2(4000);
15776: l_part_query VARCHAR2(4000);