DBA Data[Home] [Help]

APPS.WSH_REPORTS_MLS_LANG dependencies on FND_REQUEST_INFO

Line 19: -- Therefore, fnd_request_info.get_parameter is used to get the parameter

15: l_dummy INTEGER;
16: l_lang_str VARCHAR2(500);
17: BEGIN
18: -- The external docs have parameters which are in the same positions
19: -- Therefore, fnd_request_info.get_parameter is used to get the parameter
20: -- values based on positions without using IF statements to check for
21: -- the program short name first
22: v_departure_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(1));
23: v_departure_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(2));

Line 22: v_departure_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(1));

18: -- The external docs have parameters which are in the same positions
19: -- Therefore, fnd_request_info.get_parameter is used to get the parameter
20: -- values based on positions without using IF statements to check for
21: -- the program short name first
22: v_departure_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(1));
23: v_departure_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(2));
24: v_departure_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(3));
25: v_freight_carrier := FND_REQUEST_INFO.GET_PARAMETER(4);
26: v_delivery_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(5));

Line 23: v_departure_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(2));

19: -- Therefore, fnd_request_info.get_parameter is used to get the parameter
20: -- values based on positions without using IF statements to check for
21: -- the program short name first
22: v_departure_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(1));
23: v_departure_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(2));
24: v_departure_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(3));
25: v_freight_carrier := FND_REQUEST_INFO.GET_PARAMETER(4);
26: v_delivery_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(5));
27: v_warehouse_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(8));

Line 24: v_departure_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(3));

20: -- values based on positions without using IF statements to check for
21: -- the program short name first
22: v_departure_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(1));
23: v_departure_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(2));
24: v_departure_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(3));
25: v_freight_carrier := FND_REQUEST_INFO.GET_PARAMETER(4);
26: v_delivery_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(5));
27: v_warehouse_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(8));
28:

Line 25: v_freight_carrier := FND_REQUEST_INFO.GET_PARAMETER(4);

21: -- the program short name first
22: v_departure_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(1));
23: v_departure_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(2));
24: v_departure_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(3));
25: v_freight_carrier := FND_REQUEST_INFO.GET_PARAMETER(4);
26: v_delivery_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(5));
27: v_warehouse_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(8));
28:
29: -- Get base language

Line 26: v_delivery_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(5));

22: v_departure_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(1));
23: v_departure_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(2));
24: v_departure_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(3));
25: v_freight_carrier := FND_REQUEST_INFO.GET_PARAMETER(4);
26: v_delivery_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(5));
27: v_warehouse_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(8));
28:
29: -- Get base language
30: SELECT language_code INTO l_base_lang FROM fnd_languages

Line 27: v_warehouse_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(8));

23: v_departure_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(2));
24: v_departure_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(3));
25: v_freight_carrier := FND_REQUEST_INFO.GET_PARAMETER(4);
26: v_delivery_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(5));
27: v_warehouse_id := to_number(FND_REQUEST_INFO.GET_PARAMETER(8));
28:
29: -- Get base language
30: SELECT language_code INTO l_base_lang FROM fnd_languages
31: WHERE installed_flag = 'B';