eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_JOBCLOSE_PRIV dependencies on INV_LE_TIMEZONE_PUB

Line 1825: WHERE INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) >= TRUNC(PERIOD_START_DATE)

1821: INTO l_acct_period_id ,
1822: l_per_str_date,
1823: l_per_cls_date
1824: FROM ORG_ACCT_PERIODS
1825: WHERE INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) >= TRUNC(PERIOD_START_DATE)
1826: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) <= TRUNC(SCHEDULE_CLOSE_DATE)
1827: AND ORGANIZATION_ID = p_organization_id;
1828:
1829: SELECT COUNT(*)

Line 1826: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) <= TRUNC(SCHEDULE_CLOSE_DATE)

1822: l_per_str_date,
1823: l_per_cls_date
1824: FROM ORG_ACCT_PERIODS
1825: WHERE INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) >= TRUNC(PERIOD_START_DATE)
1826: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) <= TRUNC(SCHEDULE_CLOSE_DATE)
1827: AND ORGANIZATION_ID = p_organization_id;
1828:
1829: SELECT COUNT(*)
1830: INTO l_std_org_count

Line 2170: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (l_act_close_date,p_organization_id)

2166: SELECT ACCT_PERIOD_ID
2167: INTO l_acct_period_id
2168: FROM ORG_ACCT_PERIODS
2169: WHERE ORGANIZATION_ID = p_organization_id
2170: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (l_act_close_date,p_organization_id)
2171: BETWEEN PERIOD_START_DATE AND SCHEDULE_CLOSE_DATE
2172: AND PERIOD_CLOSE_DATE IS NULL;
2173:
2174: EXCEPTION

Line 2562: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(nvl(l_acct_period_close_date,to_date(p_act_close_date,'YYYY/MM/DD HH24:MI:SS')),p_organization_id)

2558: FROM ORG_ACCT_PERIODS oap
2559: WHERE
2560: oap.ORGANIZATION_ID = p_organization_id
2561: AND oap.PERIOD_CLOSE_DATE IS NULL
2562: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(nvl(l_acct_period_close_date,to_date(p_act_close_date,'YYYY/MM/DD HH24:MI:SS')),p_organization_id)
2563: BETWEEN oap.PERIOD_START_DATE and oap.SCHEDULE_CLOSE_DATE;
2564:
2565: fnd_file.put_line(FND_FILE.LOG,'Last accounting Period ID : '||to_char(l_acct_period_id));
2566: END;

Line 2649: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (wdct.ACTUAL_CLOSE_DATE, wdct.ORGANIZATION_ID)

2645: AND we.organization_id = p_organization_id
2646: AND wdct.ORGANIZATION_ID = p_organization_id
2647: AND oap.ORGANIZATION_ID = p_organization_id
2648: AND oap.PERIOD_CLOSE_DATE IS NULL
2649: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (wdct.ACTUAL_CLOSE_DATE, wdct.ORGANIZATION_ID)
2650: BETWEEN oap.PERIOD_START_DATE and oap.SCHEDULE_CLOSE_DATE;
2651:
2652: /*==============================================================+
2653: | CALL COSTING function to update variances |