[Home] [Help]
20: PROCEDURE Set_History IS
21: CURSOR cCol IS SELECT forecast_column_id, column_number, days_from, days_to
22: FROM ce_forecast_columns
23: WHERE forecast_header_id = XTR_CASH_FCST.G_rp_forecast_header_id;
24: error_msg FND_NEW_MESSAGES.message_text%TYPE;
25:
26: min_col NUMBER;
27: max_col NUMBER;
28: col_num NUMBER;
661: bank_account_id NUMBER;
662: forecast_amount NUMBER;
663:
664: l_emu GL_CURRENCIES.currency_code%TYPE;
665: error_msg fnd_new_messages.message_text%TYPE;
666: BEGIN
667:
668: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
669: xtr_debug_pkg.debug('>>XTR_CSH_FCST_POP.Execute_Main_Query');
811: GROUP_clause varchar2(100);
812: select_clause varchar2(300);
813: main_query varchar2(2000) := null;
814: counter number;
815: error_msg FND_NEW_MESSAGES.message_text%TYPE;
816:
817: BEGIN
818: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
819: xtr_debug_pkg.debug('>>XTR_CSH_FCAST_POP.Build_AP_Pay_Query');
1069: select_clause varchar2(300);
1070: view_name VARCHAR2(50);
1071: main_query varchar2(3000) := null;
1072: counter number;
1073: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1074:
1075: BEGIN
1076: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1077: xtr_debug_pkg.debug('>>Build_AR_Receipt_Query');
1177: where_clause varchar2(1000);
1178: group_clause varchar2(100);
1179: select_clause varchar2(300);
1180: main_query varchar2(2000) := null;
1181: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1182:
1183: BEGIN
1184: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1185: xtr_debug_pkg.debug('>>XTR_CSH_FCAST_POP.Build_PAY_Exp_Query');