APPS.INV_PURGE_PUB dependencies on FND_DATE

Line 75: AND period_start_date <= inv_le_timezone_pub.get_le_day_for_inv_org(fnd_date.canonical_to_date(p_purge_date), p_orgid)

71: SELECT 1
72: INTO l_tempvar
73: FROM org_acct_periods
74: WHERE organization_id = p_orgid
75: AND period_start_date <= inv_le_timezone_pub.get_le_day_for_inv_org(fnd_date.canonical_to_date(p_purge_date), p_orgid)
76: AND schedule_close_date >= inv_le_timezone_pub.get_le_day_for_inv_org(fnd_date.canonical_to_date(p_purge_date), p_orgid)
77: AND open_flag = 'N';
78: EXCEPTION
79: WHEN NO_DATA_FOUND THEN

Line 76: AND schedule_close_date >= inv_le_timezone_pub.get_le_day_for_inv_org(fnd_date.canonical_to_date(p_purge_date), p_orgid)

72: INTO l_tempvar
73: FROM org_acct_periods
74: WHERE organization_id = p_orgid
75: AND period_start_date <= inv_le_timezone_pub.get_le_day_for_inv_org(fnd_date.canonical_to_date(p_purge_date), p_orgid)
76: AND schedule_close_date >= inv_le_timezone_pub.get_le_day_for_inv_org(fnd_date.canonical_to_date(p_purge_date), p_orgid)
77: AND open_flag = 'N';
78: EXCEPTION
79: WHEN NO_DATA_FOUND THEN
80: fnd_msg_pub.initialize;

Line 109: , fnd_date.canonical_to_date(p_purge_date)

105: , l_user_id
106: , l_login_id
107: , SYSDATE
108: , l_user_id
109: , fnd_date.canonical_to_date(p_purge_date)
110: , p_purge_name
111: , p_orgid
112: );
113: END IF;

Line 116: l_purge_date := fnd_date.canonical_to_date(p_purge_date) + 1 -(1 /(24 * 3600));

112: );
113: END IF;
114:
115: /* Bug: 3145486*/
116: l_purge_date := fnd_date.canonical_to_date(p_purge_date) + 1 -(1 /(24 * 3600));
117:
118: /* Bug# 3542452 */
119: inv_txn_purge_main.txn_purge_main(x_errbuf, x_retcode, p_orgid, l_purge_date);
120: