APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on INV_LE_TIMEZONE_PUB

Line 52: inv_le_timezone_pub.get_le_day_for_inv_org(nvl(p_transaction_date,SYSDATE),

48: FROM org_acct_periods
49: WHERE period_close_date IS NULL
50: AND organization_id = p_organization_id
51: AND (schedule_close_date + 1) >
52: inv_le_timezone_pub.get_le_day_for_inv_org(nvl(p_transaction_date,SYSDATE),
53: p_organization_id)
54: AND period_start_date <=
55: inv_le_timezone_pub.get_le_day_for_inv_org(nvl(p_transaction_date,SYSDATE),
56: p_organization_id) ;

Line 55: inv_le_timezone_pub.get_le_day_for_inv_org(nvl(p_transaction_date,SYSDATE),

51: AND (schedule_close_date + 1) >
52: inv_le_timezone_pub.get_le_day_for_inv_org(nvl(p_transaction_date,SYSDATE),
53: p_organization_id)
54: AND period_start_date <=
55: inv_le_timezone_pub.get_le_day_for_inv_org(nvl(p_transaction_date,SYSDATE),
56: p_organization_id) ;
57:
58: IF (l_debug = 1) THEN
59: print_debug('x_acct_period_id = ' || x_acct_period_id, 9);

Line 3752: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(deferred_trxs.transaction_date,p_organization_id);

3748: END IF;
3749:
3750: BEGIN
3751: l_transaction_date :=
3752: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(deferred_trxs.transaction_date,p_organization_id);
3753:
3754: EXCEPTION
3755: WHEN others THEN
3756: IF (l_debug = 1) THEN

Line 3854: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(p_period_start_date,p_organization_id);

3850: May 31 2003, 10:00:00 > Jun 30 2003, 10:50:00 >=
3851: Jun 30 2003, 09:59:59
3852:
3853: l_period_start_date :=
3854: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(p_period_start_date,p_organization_id);
3855: l_period_end_date :=
3856: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(p_period_end_date,p_organization_id);
3857:
3858: BEGIN

Line 3856: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(p_period_end_date,p_organization_id);

3852:
3853: l_period_start_date :=
3854: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(p_period_start_date,p_organization_id);
3855: l_period_end_date :=
3856: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(p_period_end_date,p_organization_id);
3857:
3858: BEGIN
3859: SELECT COUNT(1) into l_count
3860: FROM