APPS.OKL_OPEN_INTERFACE_PVT dependencies on FND_DATE

Line 845: -- It changes date input to canonical_date format as specified in FND_DATE

841: END get_can_bto;
842:
843: ------------------------------------------------------------------------------
844: -- PROCEDURE get_canonical_date
845: -- It changes date input to canonical_date format as specified in FND_DATE
846: -- routine. Only required for date columns which are defined as rule segments
847: -- Calls:
848: -- Called by:
849: ------------------------------------------------------------------------------

Line 859: SELECT TO_CHAR(p_from_date ,fnd_date.canonical_mask)

855: BEGIN
856:
857: l_canonical_date := NULL;
858:
859: SELECT TO_CHAR(p_from_date ,fnd_date.canonical_mask)
860: INTO l_canonical_date
861: FROM dual;
862:
863: RETURN l_canonical_date;

Line 971: * p_start_date_from => FND_DATE.CANONICAL_TO_DATE(p_start_date_from),

967: * x_return_status => X_return_status,
968: * x_msg_count => X_msg_count,
969: * x_msg_data => X_msg_data,
970: * p_batch_number => p_batch_number,
971: * p_start_date_from => FND_DATE.CANONICAL_TO_DATE(p_start_date_from),
972: * p_start_date_to => FND_DATE.CANONICAL_TO_DATE(p_start_date_to),
973: * p_contract_number => p_contract_number,
974: * p_customer_number => p_customer_number,
975: * x_total_checked => x_total_checked

Line 972: * p_start_date_to => FND_DATE.CANONICAL_TO_DATE(p_start_date_to),

968: * x_msg_count => X_msg_count,
969: * x_msg_data => X_msg_data,
970: * p_batch_number => p_batch_number,
971: * p_start_date_from => FND_DATE.CANONICAL_TO_DATE(p_start_date_from),
972: * p_start_date_to => FND_DATE.CANONICAL_TO_DATE(p_start_date_to),
973: * p_contract_number => p_contract_number,
974: * p_customer_number => p_customer_number,
975: * x_total_checked => x_total_checked
976: * );

Line 999: p_start_date_from => FND_DATE.CANONICAL_TO_DATE(p_start_date_from),

995: x_return_status => X_return_status,
996: x_msg_count => X_msg_count,
997: x_msg_data => X_msg_data,
998: p_batch_number => p_batch_number,
999: p_start_date_from => FND_DATE.CANONICAL_TO_DATE(p_start_date_from),
1000: p_start_date_to => FND_DATE.CANONICAL_TO_DATE(p_start_date_to),
1001: p_contract_number => p_contract_number,
1002: p_customer_number => p_customer_number,
1003: x_total_loaded => x_total_loaded

Line 1000: p_start_date_to => FND_DATE.CANONICAL_TO_DATE(p_start_date_to),

996: x_msg_count => X_msg_count,
997: x_msg_data => X_msg_data,
998: p_batch_number => p_batch_number,
999: p_start_date_from => FND_DATE.CANONICAL_TO_DATE(p_start_date_from),
1000: p_start_date_to => FND_DATE.CANONICAL_TO_DATE(p_start_date_to),
1001: p_contract_number => p_contract_number,
1002: p_customer_number => p_customer_number,
1003: x_total_loaded => x_total_loaded
1004: );

Line 31528: l_start_date := Fnd_Date.date_to_canonical(p_start_date);

31524: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
31525:
31526: -- Convert the date to Varchar2
31527:
31528: l_start_date := Fnd_Date.date_to_canonical(p_start_date);
31529: l_end_date := Fnd_Date.date_to_canonical(p_end_date);
31530:
31531:
31532: -- Submit Concurrent Program Request for interest calculation

Line 31529: l_end_date := Fnd_Date.date_to_canonical(p_end_date);

31525:
31526: -- Convert the date to Varchar2
31527:
31528: l_start_date := Fnd_Date.date_to_canonical(p_start_date);
31529: l_end_date := Fnd_Date.date_to_canonical(p_end_date);
31530:
31531:
31532: -- Submit Concurrent Program Request for interest calculation
31533: FND_REQUEST.set_org_id(mo_global.get_current_org_id); --MOAC- Concurrent request