APPS.CST_REVENUECOGSMATCH_PVT dependencies on INV_LE_TIMEZONE_PUB

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

1112: AND crcml.organization_id = oap.organization_id
1113: AND crcml.inventory_item_id = msi.inventory_item_id
1114: AND crcml.organization_id = msi.organization_id
1115: AND crcml.organization_id = caiv.organization_id
1116: AND inv_le_timezone_pub.get_le_day_time_for_ou(cce.event_date, caiv.operating_unit)
1117: BETWEEN oap.period_start_date AND oap.schedule_close_date+.99999;
1118:
1119: l_stmt_num := 70;
1120: debug(l_stmt_num);

Line 1559: inv_le_timezone_pub.get_server_day_time_for_le(

1555: list_id,
1556: number_1
1557: )
1558: SELECT organization_id,
1559: inv_le_timezone_pub.get_server_day_time_for_le(
1560: l_dummy_date,
1561: legal_entity
1562: ) - l_dummy_date
1563: FROM ( SELECT

Line 1586: inv_le_timezone_pub.get_server_day_time_for_le(

1582: list_id,
1583: number_1
1584: )
1585: SELECT organization_id,
1586: inv_le_timezone_pub.get_server_day_time_for_le(
1587: l_dummy_date,
1588: legal_entity
1589: ) - l_dummy_date
1590: FROM ( SELECT

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

3169: AND crcml.organization_id = msi.organization_id
3170: AND crcml.inventory_item_id = msi.inventory_item_id
3171: AND crcml.organization_id = oap.organization_id
3172: AND crcml.organization_id = caiv.organization_id
3173: AND inv_le_timezone_pub.get_le_day_time_for_ou(cce.event_date, caiv.operating_unit)
3174: BETWEEN oap.period_start_date AND oap.schedule_close_date+.99999;
3175:
3176: -- Then insert from the global temp table into CCE
3177: l_stmt_num := 70;

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

4307: FOR i IN l_event_id_tbl.FIRST..l_event_id_tbl.LAST LOOP
4308:
4309: IF NOT l_ou_offset_tbl.EXISTS(l_ou_id_tbl(i)) THEN
4310:
4311: l_ou_offset_tbl(l_ou_id_tbl(i)) := INV_LE_TIMEZONE_PUB.get_le_day_time_for_ou(
4312: SYSDATE, l_ou_id_tbl(i)) - SYSDATE;
4313:
4314: END IF;
4315:

Line 5924: l_date_offset := inv_le_timezone_pub.get_le_day_time_for_ou(

5920: -- Perpetual report
5921: ----------------------------------------------------------------------------------------------
5922:
5923: l_dummy_date := SYSDATE;
5924: l_date_offset := inv_le_timezone_pub.get_le_day_time_for_ou(
5925: l_dummy_date,
5926: i_operating_unit
5927: ) - l_dummy_date;
5928:

Line 6133: SELECT inv_le_timezone_pub.get_server_day_time_for_le(

6129: -- PAC report
6130: ----------------------------------------------------------------------------------------------
6131: l_dummy_date := SYSDATE;
6132:
6133: SELECT inv_le_timezone_pub.get_server_day_time_for_le(
6134: l_dummy_date,
6135: legal_entity
6136: ) - l_dummy_date
6137: INTO l_date_offset