DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on INV_LE_TIMEZONE_PUB

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

3661: END IF;
3662:
3663: BEGIN
3664: l_transaction_date :=
3665: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(deferred_trxs.transaction_date,p_organization_id);
3666:
3667: EXCEPTION
3668: WHEN others THEN
3669: IF (l_debug = 1) THEN

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

3763: May 31 2003, 10:00:00 > Jun 30 2003, 10:50:00 >=
3764: Jun 30 2003, 09:59:59
3765:
3766: l_period_start_date :=
3767: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(p_period_start_date,p_organization_id);
3768: l_period_end_date :=
3769: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(p_period_end_date,p_organization_id);
3770:
3771: BEGIN

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

3765:
3766: l_period_start_date :=
3767: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(p_period_start_date,p_organization_id);
3768: l_period_end_date :=
3769: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(p_period_end_date,p_organization_id);
3770:
3771: BEGIN
3772: SELECT COUNT(1) into l_count
3773: FROM