DBA Data[Home] [Help]

APPS.INVTTMTX dependencies on INV_LE_TIMEZONE_PUB

Line 35: TRUNC(INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Nvl(transaction_date,Sysdate),org_id))

31: FROM ORG_ACCT_PERIODS
32: WHERE PERIOD_CLOSE_DATE IS NULL
33: AND ORGANIZATION_ID = org_id
34: AND TRUNC(SCHEDULE_CLOSE_DATE) >=
35: TRUNC(INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Nvl(transaction_date,Sysdate),org_id))
36: AND TRUNC(PERIOD_START_DATE) <=
37: TRUNC(INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Nvl(transaction_date,Sysdate),org_id));
38: period_id := v_transaction_period_id;
39: G_TRANSACTION_PERIOD_ID := v_transaction_period_id;

Line 37: TRUNC(INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Nvl(transaction_date,Sysdate),org_id));

33: AND ORGANIZATION_ID = org_id
34: AND TRUNC(SCHEDULE_CLOSE_DATE) >=
35: TRUNC(INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Nvl(transaction_date,Sysdate),org_id))
36: AND TRUNC(PERIOD_START_DATE) <=
37: TRUNC(INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Nvl(transaction_date,Sysdate),org_id));
38: period_id := v_transaction_period_id;
39: G_TRANSACTION_PERIOD_ID := v_transaction_period_id;
40: G_PERIOD_STATUS := 1;
41:

Line 83: AND TRUNC(INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,org_id))

79: INTO v_current_period_id
80: FROM ORG_ACCT_PERIODS
81: WHERE PERIOD_CLOSE_DATE IS NULL
82: AND ORGANIZATION_ID = org_id
83: AND TRUNC(INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,org_id))
84: BETWEEN TRUNC(PERIOD_START_DATE) and
85: TRUNC(SCHEDULE_CLOSE_DATE);
86: G_CURRENT_PERIOD_ID := v_current_period_id;
87: