APPS.IEX_DUNNING_PUB dependencies on IEX_DUNNING_PLANS_B

Line 735: from IEX_DUNNING_PLANS_B

731: x_return_status := FND_API.G_RET_STS_SUCCESS;
732:
733: select nvl(dunning_type,'DAYS_OVERDUE'),dunning_letter_set_id --Added for Bug 11656175 01-Mar-2011 barathsr
734: into l_dunning_type,l_dunning_letter_set_id
735: from IEX_DUNNING_PLANS_B
736: where dunning_plan_id = p_dunning_plan_id;
737: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_type ' || l_dunning_type);
738:
739:

Line 2065: from IEX_DUNNING_PLANS_B

2061:
2062:
2063: cursor c_dunning_type (p_dunn_plan_id number) is
2064: select nvl(dunning_type,'DAYS_OVERDUE')
2065: from IEX_DUNNING_PLANS_B
2066: where dunning_plan_id = p_dunn_plan_id;
2067:
2068:
2069:

Line 2534: from iex_dunning_plans_b dnb,

2530: dnb.dunning_level dunning_level,
2531: dntl.name name,
2532: dntl.description description,
2533: dnb.mig_dunning_letter_set_id mig_dunning_letter_set_id
2534: from iex_dunning_plans_b dnb,
2535: iex_dunning_plans_tl dntl
2536: where dnb.dunning_plan_id = dntl.dunning_plan_id
2537: and dntl.language = userenv('LANG')
2538: and dnb.dunning_type = 'STAGED_DUNNING'

Line 2630: UPDATE IEX_DUNNING_PLANS_B

2626: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. So data will get migrated. *');
2627: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2628:
2629: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - End dating the previously migrated dunning letter sets.');
2630: UPDATE IEX_DUNNING_PLANS_B
2631: SET LAST_UPDATE_DATE = sysdate,
2632: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2633: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,
2634: END_DATE = nvl(END_DATE,sysdate),

Line 2660: INSERT INTO IEX_DUNNING_PLANS_B

2656: --End bug 9725204 gnramasa 19th May 10
2657: l_include_current := 'N';
2658: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_plan_id= ' || l_dunning_plan_id);
2659:
2660: INSERT INTO IEX_DUNNING_PLANS_B
2661: (DUNNING_PLAN_ID,
2662: START_DATE,
2663: ENABLED_FLAG,
2664: AGING_BUCKET_ID,

Line 2784: UPDATE IEX_DUNNING_PLANS_B

2780: l_include_current := 'Y';
2781: end if;
2782: end loop;
2783:
2784: UPDATE IEX_DUNNING_PLANS_B
2785: SET INCLUDE_CURRENT = l_include_current
2786: WHERE
2787: DUNNING_PLAN_ID = l_dunning_plan_id;
2788:

Line 2850: --Update dunning_type as 'DAYS_OVERDUE' for existing records in IEX_DUNNING_PLANS_B table.

2846: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||SQLERRM);
2847: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
2848: END;
2849:
2850: --Update dunning_type as 'DAYS_OVERDUE' for existing records in IEX_DUNNING_PLANS_B table.
2851: update iex_dunning_plans_b
2852: set dunning_type = 'DAYS_OVERDUE'
2853: where dunning_type is null
2854: and aging_bucket_id is not null;

Line 2851: update iex_dunning_plans_b

2847: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
2848: END;
2849:
2850: --Update dunning_type as 'DAYS_OVERDUE' for existing records in IEX_DUNNING_PLANS_B table.
2851: update iex_dunning_plans_b
2852: set dunning_type = 'DAYS_OVERDUE'
2853: where dunning_type is null
2854: and aging_bucket_id is not null;
2855: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Updated dunning_type as DAYS_OVERDUE for existing records in IEX_DUNNING_PLANS_B table.');

Line 2855: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Updated dunning_type as DAYS_OVERDUE for existing records in IEX_DUNNING_PLANS_B table.');

2851: update iex_dunning_plans_b
2852: set dunning_type = 'DAYS_OVERDUE'
2853: where dunning_type is null
2854: and aging_bucket_id is not null;
2855: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Updated dunning_type as DAYS_OVERDUE for existing records in IEX_DUNNING_PLANS_B table.');
2856:
2857: --Set the Profile 'IEX: IPP Printer Name' as 'NOPRINT'.
2858: l_return := fnd_profile.save(x_name => 'IEX_PRT_IPP_PRINTER_NAME',
2859: x_value => 'NOPRINT',