APPS.INV_HV_TXN_PURGE dependencies on FND_DATE

Line 57: l_cut_off_date DATE := fnd_date.canonical_to_date(p_cut_off_date);

53: )
54: IS
55:
56: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
57: l_cut_off_date DATE := fnd_date.canonical_to_date(p_cut_off_date);
58: s_cut_off_date VARCHAR2(10);
59:
60: s_sql_stmt VARCHAR2(1000);
61: l_ret_msg BOOLEAN;

Line 129: --l_cut_off_date := To_Date( To_Char(fnd_date.canonical_to_date(p_cut_off_date),'MM-DD-RRRR'), 'MM-DD-RRRR');

125: inv_trx_util_pub.TRACE('Debug Level = '|| l_debug);
126: inv_trx_util_pub.TRACE('Organization Id = '|| p_organization_id);
127: inv_trx_util_pub.TRACE('Cut off date = '|| p_cut_off_date);
128:
129: --l_cut_off_date := To_Date( To_Char(fnd_date.canonical_to_date(p_cut_off_date),'MM-DD-RRRR'), 'MM-DD-RRRR');
130: s_cut_off_date := To_Char(fnd_date.canonical_to_date(p_cut_off_date),'MM-DD-RRRR');
131: inv_trx_util_pub.TRACE('Cut off date (' || l_cut_off_date || ') in MM-DD-RRRR format = '|| s_cut_off_date);
132:
133: inv_user_name := upper('INV');

Line 130: s_cut_off_date := To_Char(fnd_date.canonical_to_date(p_cut_off_date),'MM-DD-RRRR');

126: inv_trx_util_pub.TRACE('Organization Id = '|| p_organization_id);
127: inv_trx_util_pub.TRACE('Cut off date = '|| p_cut_off_date);
128:
129: --l_cut_off_date := To_Date( To_Char(fnd_date.canonical_to_date(p_cut_off_date),'MM-DD-RRRR'), 'MM-DD-RRRR');
130: s_cut_off_date := To_Char(fnd_date.canonical_to_date(p_cut_off_date),'MM-DD-RRRR');
131: inv_trx_util_pub.TRACE('Cut off date (' || l_cut_off_date || ') in MM-DD-RRRR format = '|| s_cut_off_date);
132:
133: inv_user_name := upper('INV');
134: inv_trx_util_pub.TRACE('Inventory User Name = '|| inv_user_name);