APPS.OKL_SUBSIDY_POOL_RPT_PVT dependencies on FND_DATE

Line 1346: l_from_date:= FND_DATE.CANONICAL_TO_DATE(p_date);

1342: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1343: RAISE OKL_API.G_EXCEPTION_ERROR;
1344: END IF;
1345:
1346: l_from_date:= FND_DATE.CANONICAL_TO_DATE(p_date);
1347:
1348: -- Printing Subsidy pools report header.
1349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
1350: RPAD(' ', 53 , ' ' ));

Line 2182: l_from_date:= FND_DATE.CANONICAL_TO_DATE(p_from_date);

2178: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2179: RAISE OKL_API.G_EXCEPTION_ERROR;
2180: END IF;
2181:
2182: l_from_date:= FND_DATE.CANONICAL_TO_DATE(p_from_date);
2183: l_to_date:= FND_DATE.CANONICAL_TO_DATE(p_to_date);
2184:
2185: -- Printing Subsidy pools report header.
2186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||

Line 2183: l_to_date:= FND_DATE.CANONICAL_TO_DATE(p_to_date);

2179: RAISE OKL_API.G_EXCEPTION_ERROR;
2180: END IF;
2181:
2182: l_from_date:= FND_DATE.CANONICAL_TO_DATE(p_from_date);
2183: l_to_date:= FND_DATE.CANONICAL_TO_DATE(p_to_date);
2184:
2185: -- Printing Subsidy pools report header.
2186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
2187: RPAD(' ', 53 , ' ' ));

Line 2731: l_date:= FND_DATE.CANONICAL_TO_DATE(p_end_date);

2727: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2728: RAISE OKL_API.G_EXCEPTION_ERROR;
2729: END IF;
2730:
2731: l_date:= FND_DATE.CANONICAL_TO_DATE(p_end_date);
2732:
2733: -- Printing Subsidy pools report header.
2734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
2735: RPAD(' ', 53 , ' ' ));

Line 3167: l_from_date:= FND_DATE.CANONICAL_TO_DATE(P_DATE);

3163: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3164: RAISE OKL_API.G_EXCEPTION_ERROR;
3165: END IF;
3166:
3167: l_from_date:= FND_DATE.CANONICAL_TO_DATE(P_DATE);
3168:
3169: -- Use this record to retain the currency of the input pool(user entered)
3170: OPEN get_pool_dtls(P_POOL_ID);
3171: FETCH get_pool_dtls INTO l_input_pool_rec;

Line 3452: l_date:= FND_DATE.CANONICAL_TO_DATE(P_END_DATE);

3448:
3449: l_api_version := 1.0;
3450: l_init_msg_list := Okl_Api.g_false;
3451: l_msg_count := 0;
3452: l_date:= FND_DATE.CANONICAL_TO_DATE(P_END_DATE);
3453: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
3454: G_PKG_NAME,
3455: l_init_msg_list,
3456: l_api_version,

Line 3634: l_date:= FND_DATE.CANONICAL_TO_DATE(l_date);

3630: END IF;
3631: END IF;
3632: END LOOP;
3633: ELSIF(l_date is not null) THEN
3634: l_date:= FND_DATE.CANONICAL_TO_DATE(l_date);
3635: FOR each_row IN c_get_dates(l_date) LOOP
3636: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);
3637: l_event_name := G_WF_EVT_POOL_NEAR_EXPIR;
3638: INSERT INTO

Line 4302: l_from_date:= FND_DATE.CANONICAL_TO_DATE(P_FROM_DATE);

4298: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4299: RAISE OKL_API.G_EXCEPTION_ERROR;
4300: END IF;
4301:
4302: l_from_date:= FND_DATE.CANONICAL_TO_DATE(P_FROM_DATE);
4303: l_to_date:= FND_DATE.CANONICAL_TO_DATE(P_TO_DATE);
4304:
4305: -- Get the record for user entered pool name.
4306: l_pool_rec := get_parent_record(P_POOL_ID);

Line 4303: l_to_date:= FND_DATE.CANONICAL_TO_DATE(P_TO_DATE);

4299: RAISE OKL_API.G_EXCEPTION_ERROR;
4300: END IF;
4301:
4302: l_from_date:= FND_DATE.CANONICAL_TO_DATE(P_FROM_DATE);
4303: l_to_date:= FND_DATE.CANONICAL_TO_DATE(P_TO_DATE);
4304:
4305: -- Get the record for user entered pool name.
4306: l_pool_rec := get_parent_record(P_POOL_ID);
4307: