62: l_callback_flag VARCHAR2(1);
63: l_callback_date DATE;
64: -- l_template_id NUMBER;
65: l_campaign_sched_id NUMBER;
66: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
67: l_DUNNING_id NUMBER;
68: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
69: l_dunning_method varchar2(2000);
70:
64: -- l_template_id NUMBER;
65: l_campaign_sched_id NUMBER;
66: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
67: l_DUNNING_id NUMBER;
68: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
69: l_dunning_method varchar2(2000);
70:
71: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;
72: cursor c_get_dunning(p_workitem_id number) is
67: l_DUNNING_id NUMBER;
68: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
69: l_dunning_method varchar2(2000);
70:
71: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;
72: cursor c_get_dunning(p_workitem_id number) is
73: select a.dunning_id from iex_dunnings a
74: where a.object_id = p_workitem_id
75: and a.object_type = 'IEX_STRATEGY'
1833: l_callback_flag VARCHAR2(1);
1834: l_callback_date DATE;
1835: -- l_template_id NUMBER;
1836: l_campaign_sched_id NUMBER;
1837: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1838: l_DUNNING_id NUMBER;
1839: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1840: l_dunning_method varchar2(2000);
1841:
1835: -- l_template_id NUMBER;
1836: l_campaign_sched_id NUMBER;
1837: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1838: l_DUNNING_id NUMBER;
1839: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1840: l_dunning_method varchar2(2000);
1841:
1842: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1843: cursor c_get_dunning(p_workitem_id number) is
1838: l_DUNNING_id NUMBER;
1839: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1840: l_dunning_method varchar2(2000);
1841:
1842: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1843: cursor c_get_dunning(p_workitem_id number) is
1844: select a.dunning_id from iex_dunnings a
1845: where a.object_id = p_workitem_id
1846: and a.object_type = 'WORK_ITEM'