DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WORK_PUB dependencies on IEX_DUNNING_PUB

Line 66: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

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:

Line 68: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;

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

Line 71: l_DUNNING_rec_upd_old 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
73: select a.dunning_id from iex_dunnings a
74: where a.object_id = p_workitem_id
75: and a.object_type = 'IEX_STRATEGY'

Line 1837: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

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:

Line 1839: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;

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

Line 1842: l_DUNNING_rec_upd_old 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
1844: select a.dunning_id from iex_dunnings a
1845: where a.object_id = p_workitem_id
1846: and a.object_type = 'WORK_ITEM'