APPS.WIP_SFCB_UTILITIES dependencies on FLM_TIMEZONE

Line 1009: -- add flm_timezone call to support timezone

1005: -- This is a hack and is used to update the availability of
1006: -- the line to be null on the non working days as per
1007: -- the decision by jgu and dsoosai
1008:
1009: -- add flm_timezone call to support timezone
1010: SELECT organization_id
1011: INTO x_org_id
1012: FROM wip_lines
1013: WHERE line_id = p_line_id;

Line 1014: flm_timezone.init_timezone(x_org_id);

1010: SELECT organization_id
1011: INTO x_org_id
1012: FROM wip_lines
1013: WHERE line_id = p_line_id;
1014: flm_timezone.init_timezone(x_org_id);
1015: UPDATE wip_indicators_temp wit
1016: SET wit.available_quantity = 0
1017: WHERE wit.group_id = x_group_id
1018: and flm_timezone.client_to_calendar(wit.transaction_date) NOT IN (

Line 1018: and flm_timezone.client_to_calendar(wit.transaction_date) NOT IN (

1014: flm_timezone.init_timezone(x_org_id);
1015: UPDATE wip_indicators_temp wit
1016: SET wit.available_quantity = 0
1017: WHERE wit.group_id = x_group_id
1018: and flm_timezone.client_to_calendar(wit.transaction_date) NOT IN (
1019: SELECT bcd.calendar_date
1020: FROM bom_calendar_dates bcd,
1021: mtl_parameters mp,
1022: wip_lines wl

Line 1029: flm_timezone.client_to_calendar(p_date_from) and

1025: and mp.organization_id = wl.organization_id
1026: and bcd.calendar_code = mp.calendar_code
1027: and bcd.exception_set_id = mp.calendar_exception_set_id
1028: and bcd.calendar_date between
1029: flm_timezone.client_to_calendar(p_date_from) and
1030: flm_timezone.client_to_calendar(p_date_to)
1031: and bcd.seq_num is not null
1032: ) ;
1033:

Line 1030: flm_timezone.client_to_calendar(p_date_to)

1026: and bcd.calendar_code = mp.calendar_code
1027: and bcd.exception_set_id = mp.calendar_exception_set_id
1028: and bcd.calendar_date between
1029: flm_timezone.client_to_calendar(p_date_from) and
1030: flm_timezone.client_to_calendar(p_date_to)
1031: and bcd.seq_num is not null
1032: ) ;
1033:
1034: