[Home] [Help]
428: AND org.org_id = NVL(r.org_id, org.org_id);
429:
430: curr FND_CURRENCIES.currency_code%TYPE;
431: to_curr FND_CURRENCIES.currency_code%TYPE;
432: error_msg FND_NEW_MESSAGES.message_text%TYPE;
433: xrate NUMBER;
434: all_exist_flag BOOLEAN := TRUE;
435: BEGIN
436: cep_standard.debug('>>CE_CASH_FCST.populate_base_xrate_table');
555: curr FND_CURRENCIES.currency_code%TYPE;
556: from_curr FND_CURRENCIES.currency_code%TYPE;
557: to_curr FND_CURRENCIES.currency_code%TYPE;
558: euro_curr FND_CURRENCIES.currency_code%TYPE;
559: error_msg FND_NEW_MESSAGES.message_text%TYPE;
560: xrate NUMBER;
561: skip_err_log BOOLEAN;
562: all_exist_flag BOOLEAN := TRUE;
563: fcast_curr_is_emu VARCHAR2(1);
804: FUNCTION valid_calendar_name RETURN BOOLEAN IS
805: valid_period BOOLEAN := TRUE;
806: sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
807: calendar GL_PERIODS.period_set_name%TYPE;
808: error_msg fnd_new_messages.message_text%TYPE;
809: sob_name GL_SETS_OF_BOOKS.name%TYPE;
810:
811: CURSOR sob_c IS
812: SELECT gsb.period_set_name, org.set_of_books_id, org.set_of_books_name
874: | HISTORY |
875: | 21-AUG-1997 Created Wynne Chan |
876: --------------------------------------------------------------------- */
877: FUNCTION valid_col_info RETURN BOOLEAN IS
878: error_msg FND_NEW_MESSAGES.message_text%TYPE;
879: valid_col BOOLEAN := TRUE;
880: col_count NUMBER;
881: BEGIN
882: SELECT count(1)
921: CURSOR cCol IS SELECT forecast_column_id, column_number, days_from, days_to
922: FROM ce_forecast_columns
923: WHERE forecast_header_id = G_rp_forecast_header_id;
924:
925: error_msg FND_NEW_MESSAGES.message_text%TYPE;
926: col_num NUMBER;
927: cid NUMBER;
928: days_from NUMBER;
929: days_to NUMBER;
984: | HISTORY |
985: | 21-AUG-1997 Created Wynne Chan |
986: --------------------------------------------------------------------- */
987: FUNCTION valid_row_info RETURN BOOLEAN IS
988: error_msg FND_NEW_MESSAGES.message_text%TYPE;
989: valid_row BOOLEAN := TRUE;
990: row_exists BOOLEAN := FALSE;
991: BEGIN
992: G_gl_cash_only := FALSE;
1225: --------------------------------------------------------------------- */
1226: PROCEDURE create_forecast_header IS
1227: l_forecast_rowid VARCHAR2(30);
1228: fid NUMBER;
1229: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1230: duplicate_name BOOLEAN DEFAULT FALSE;
1231: l_fc_count NUMBER;
1232: l_reqid NUMBER;
1233: l_request_id NUMBER;
1348: | HISTORY |
1349: | 26-SEP-1997 Created Wynne Chan |
1350: --------------------------------------------------------------------- */
1351: FUNCTION valid_exchange_pmr RETURN BOOLEAN IS
1352: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1353: valid_pmr BOOLEAN := TRUE;
1354: BEGIN
1355: IF((G_rp_src_curr_type = 'E' AND
1356: G_rp_forecast_currency <> G_rp_src_currency) OR
1789: FROM pa_projects_all
1790: WHERE segment1 >= p_start_project_num
1791: AND segment1 <= p_end_project_num;
1792:
1793: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1794: p_amount_threshold NUMBER;
1795: BEGIN
1796: cep_standard.debug('>>CE_CASH_FCST.Forecast (with p_dummy)'); -- 14164001: Added
1797:
1965: FROM pa_projects_all
1966: WHERE segment1 >= p_start_project_num
1967: AND segment1 <= p_end_project_num;
1968:
1969: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1970: p_amount_threshold NUMBER;
1971:
1972: BEGIN
1973: cep_standard.debug('>>CE_CASH_FCST.Forecast (without p_dummy)');