DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WORK_PUB dependencies on IEX_DUNNING_PUB

Line 65: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

61: l_callback_flag VARCHAR2(1);
62: l_callback_date DATE;
63: -- l_template_id NUMBER;
64: l_campaign_sched_id NUMBER;
65: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
66: l_DUNNING_id NUMBER;
67: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
68: l_dunning_method varchar2(2000);
69:

Line 67: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;

63: -- l_template_id NUMBER;
64: l_campaign_sched_id NUMBER;
65: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
66: l_DUNNING_id NUMBER;
67: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
68: l_dunning_method varchar2(2000);
69:
70: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;
71: cursor c_get_dunning(p_workitem_id number) is

Line 70: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;

66: l_DUNNING_id NUMBER;
67: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
68: l_dunning_method varchar2(2000);
69:
70: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;
71: cursor c_get_dunning(p_workitem_id number) is
72: select a.dunning_id from iex_dunnings a
73: where a.object_id = p_workitem_id
74: and a.object_type = 'IEX_STRATEGY'

Line 1589: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

1585: l_callback_flag VARCHAR2(1);
1586: l_callback_date DATE;
1587: -- l_template_id NUMBER;
1588: l_campaign_sched_id NUMBER;
1589: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1590: l_DUNNING_id NUMBER;
1591: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1592: l_dunning_method varchar2(2000);
1593:

Line 1591: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;

1587: -- l_template_id NUMBER;
1588: l_campaign_sched_id NUMBER;
1589: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1590: l_DUNNING_id NUMBER;
1591: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1592: l_dunning_method varchar2(2000);
1593:
1594: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1595: cursor c_get_dunning(p_workitem_id number) is

Line 1594: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;

1590: l_DUNNING_id NUMBER;
1591: l_DUNNING_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1592: l_dunning_method varchar2(2000);
1593:
1594: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1595: cursor c_get_dunning(p_workitem_id number) is
1596: select a.dunning_id from iex_dunnings a
1597: where a.object_id = p_workitem_id
1598: and a.object_type = 'WORK_ITEM'