APPS.CST_REVENUECOGSMATCH_PVT dependencies on INV_LE_TIMEZONE_PUB

Line 1295: AND inv_le_timezone_pub.get_le_day_time_for_ou(cce.event_date, caiv.operating_unit)

1291: AND crcml.organization_id = oap.organization_id
1292: AND crcml.inventory_item_id = msi.inventory_item_id
1293: AND crcml.organization_id = msi.organization_id
1294: AND crcml.organization_id = caiv.organization_id
1295: AND inv_le_timezone_pub.get_le_day_time_for_ou(cce.event_date, caiv.operating_unit)
1296: BETWEEN oap.period_start_date AND oap.schedule_close_date+EndDateNum;
1297:
1298: l_stmt_num := 70;
1299: debug(l_stmt_num);

Line 1763: inv_le_timezone_pub.get_server_day_time_for_le(

1759: number_1,
1760: varchar_1
1761: )
1762: SELECT organization_id,
1763: inv_le_timezone_pub.get_server_day_time_for_le(
1764: l_dummy_date,
1765: legal_entity
1766: ) - l_dummy_date,
1767: 'TIMEZONE'

Line 3197: AND inv_le_timezone_pub.get_le_day_time_for_ou(cce.event_date, caiv.operating_unit)

3193: AND crcml.organization_id = msi.organization_id
3194: AND crcml.inventory_item_id = msi.inventory_item_id
3195: AND crcml.organization_id = oap.organization_id
3196: AND crcml.organization_id = caiv.organization_id
3197: AND inv_le_timezone_pub.get_le_day_time_for_ou(cce.event_date, caiv.operating_unit)
3198: BETWEEN oap.period_start_date AND oap.schedule_close_date+EndDateNum;
3199:
3200: -- Then insert from the global temp table into CCE
3201: l_stmt_num := 70;

Line 4375: l_ou_offset_tbl(l_ou_id_tbl(i)) := INV_LE_TIMEZONE_PUB.get_le_day_time_for_ou(

4371: FOR i IN l_event_id_tbl.FIRST..l_event_id_tbl.LAST LOOP
4372:
4373: IF NOT l_ou_offset_tbl.EXISTS(l_ou_id_tbl(i)) THEN
4374:
4375: l_ou_offset_tbl(l_ou_id_tbl(i)) := INV_LE_TIMEZONE_PUB.get_le_day_time_for_ou(
4376: SYSDATE, l_ou_id_tbl(i)) - SYSDATE;
4377:
4378: END IF;
4379:

Line 6039: l_date_offset := inv_le_timezone_pub.get_le_day_time_for_ou(

6035: -- Perpetual report
6036: ----------------------------------------------------------------------------------------------
6037:
6038: l_dummy_date := SYSDATE;
6039: l_date_offset := inv_le_timezone_pub.get_le_day_time_for_ou(
6040: l_dummy_date,
6041: i_operating_unit
6042: ) - l_dummy_date;
6043:

Line 6422: SELECT inv_le_timezone_pub.get_server_day_time_for_le(

6418: -- PAC report
6419: ----------------------------------------------------------------------------------------------
6420: l_dummy_date := SYSDATE;
6421:
6422: SELECT inv_le_timezone_pub.get_server_day_time_for_le(
6423: l_dummy_date,
6424: legal_entity
6425: ) - l_dummy_date
6426: INTO l_date_offset