DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on FND_DATE

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

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

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

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

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

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

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

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

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

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

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

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

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

31990: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
31991:
31992: -- Convert the date to Varchar2
31993:
31994: l_start_date := Fnd_Date.date_to_canonical(p_start_date);
31995: l_end_date := Fnd_Date.date_to_canonical(p_end_date);
31996:
31997:
31998: -- Submit Concurrent Program Request for interest calculation

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

31991:
31992: -- Convert the date to Varchar2
31993:
31994: l_start_date := Fnd_Date.date_to_canonical(p_start_date);
31995: l_end_date := Fnd_Date.date_to_canonical(p_end_date);
31996:
31997:
31998: -- Submit Concurrent Program Request for interest calculation
31999: FND_REQUEST.set_org_id(mo_global.get_current_org_id); --MOAC- Concurrent request