eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_CSH_FCST_POP dependencies on XTR_CASH_FCST

Line 23: WHERE forecast_header_id = XTR_CASH_FCST.G_rp_forecast_header_id;

19: --------------------------------------------------------------------- */
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;

Line 36: xtr_debug_pkg.debug('>>XTR_CASH_FCST.Set_History');

32: history_date DATE;
33: history_period VARCHAR2(30);
34: BEGIN
35: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
36: xtr_debug_pkg.debug('>>XTR_CASH_FCST.Set_History');
37:
38: xtr_debug_pkg.debug('G_roll_forward_type: '|| XTR_CASH_FCST.G_roll_forward_type);
39:
40: xtr_debug_pkg.debug('G_roll_forward_period : ' || XTR_CASH_FCST.G_roll_forward_period);

Line 38: xtr_debug_pkg.debug('G_roll_forward_type: '|| XTR_CASH_FCST.G_roll_forward_type);

34: BEGIN
35: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
36: xtr_debug_pkg.debug('>>XTR_CASH_FCST.Set_History');
37:
38: xtr_debug_pkg.debug('G_roll_forward_type: '|| XTR_CASH_FCST.G_roll_forward_type);
39:
40: xtr_debug_pkg.debug('G_roll_forward_period : ' || XTR_CASH_FCST.G_roll_forward_period);
41:
42: xtr_debug_pkg.debug('G_start_period: ' || XTR_CASH_FCST.G_rp_forecast_start_period);

Line 40: xtr_debug_pkg.debug('G_roll_forward_period : ' || XTR_CASH_FCST.G_roll_forward_period);

36: xtr_debug_pkg.debug('>>XTR_CASH_FCST.Set_History');
37:
38: xtr_debug_pkg.debug('G_roll_forward_type: '|| XTR_CASH_FCST.G_roll_forward_type);
39:
40: xtr_debug_pkg.debug('G_roll_forward_period : ' || XTR_CASH_FCST.G_roll_forward_period);
41:
42: xtr_debug_pkg.debug('G_start_period: ' || XTR_CASH_FCST.G_rp_forecast_start_period);
43:
44: xtr_debug_pkg.debug('period_set_name: ' || CEFC_VIEW_CONST.get_period_set_name);

Line 42: xtr_debug_pkg.debug('G_start_period: ' || XTR_CASH_FCST.G_rp_forecast_start_period);

38: xtr_debug_pkg.debug('G_roll_forward_type: '|| XTR_CASH_FCST.G_roll_forward_type);
39:
40: xtr_debug_pkg.debug('G_roll_forward_period : ' || XTR_CASH_FCST.G_roll_forward_period);
41:
42: xtr_debug_pkg.debug('G_start_period: ' || XTR_CASH_FCST.G_rp_forecast_start_period);
43:
44: xtr_debug_pkg.debug('period_set_name: ' || CEFC_VIEW_CONST.get_period_set_name);
45:
46: END IF;

Line 48: IF (XTR_CASH_FCST.G_roll_forward_type = 'D') THEN

44: xtr_debug_pkg.debug('period_set_name: ' || CEFC_VIEW_CONST.get_period_set_name);
45:
46: END IF;
47:
48: IF (XTR_CASH_FCST.G_roll_forward_type = 'D') THEN
49: CEFC_VIEW_CONST.set_start_date(XTR_CASH_FCST.G_rp_forecast_start_date - XTR_CASH_FCST.G_roll_forward_period);
50: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN

Line 49: CEFC_VIEW_CONST.set_start_date(XTR_CASH_FCST.G_rp_forecast_start_date - XTR_CASH_FCST.G_roll_forward_period);

45:
46: END IF;
47:
48: IF (XTR_CASH_FCST.G_roll_forward_type = 'D') THEN
49: CEFC_VIEW_CONST.set_start_date(XTR_CASH_FCST.G_rp_forecast_start_date - XTR_CASH_FCST.G_roll_forward_period);
50: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);

Line 50: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);

46: END IF;
47:
48: IF (XTR_CASH_FCST.G_roll_forward_type = 'D') THEN
49: CEFC_VIEW_CONST.set_start_date(XTR_CASH_FCST.G_rp_forecast_start_date - XTR_CASH_FCST.G_roll_forward_period);
50: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
54: CEFC_VIEW_CONST.set_start_date(history_date);

Line 51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);

47:
48: IF (XTR_CASH_FCST.G_roll_forward_type = 'D') THEN
49: CEFC_VIEW_CONST.set_start_date(XTR_CASH_FCST.G_rp_forecast_start_date - XTR_CASH_FCST.G_roll_forward_period);
50: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
54: CEFC_VIEW_CONST.set_start_date(history_date);
55: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period*30);

Line 52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN

48: IF (XTR_CASH_FCST.G_roll_forward_type = 'D') THEN
49: CEFC_VIEW_CONST.set_start_date(XTR_CASH_FCST.G_rp_forecast_start_date - XTR_CASH_FCST.G_roll_forward_period);
50: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
54: CEFC_VIEW_CONST.set_start_date(history_date);
55: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period*30);
56: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period*30);

Line 53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);

49: CEFC_VIEW_CONST.set_start_date(XTR_CASH_FCST.G_rp_forecast_start_date - XTR_CASH_FCST.G_roll_forward_period);
50: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
54: CEFC_VIEW_CONST.set_start_date(history_date);
55: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period*30);
56: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period*30);
57: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'A') THEN

Line 55: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period*30);

51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
54: CEFC_VIEW_CONST.set_start_date(history_date);
55: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period*30);
56: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period*30);
57: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'A') THEN
58: BEGIN
59: SELECT gps.period_name

Line 56: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period*30);

52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
54: CEFC_VIEW_CONST.set_start_date(history_date);
55: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period*30);
56: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period*30);
57: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'A') THEN
58: BEGIN
59: SELECT gps.period_name
60: INTO history_period

Line 57: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'A') THEN

53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
54: CEFC_VIEW_CONST.set_start_date(history_date);
55: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period*30);
56: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period*30);
57: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'A') THEN
58: BEGIN
59: SELECT gps.period_name
60: INTO history_period
61: FROM gl_periods gps,

Line 64: WHERE gps.period_num =DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),

60: INTO history_period
61: FROM gl_periods gps,
62: gl_periods gp,
63: gl_period_types gpt
64: WHERE gps.period_num =DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),
65: 1,gp.period_num - XTR_CASH_FCST.G_roll_forward_period,
66: gpt.number_per_fiscal_year +
67: mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year))
68: AND gps.period_year = gp.period_year +

Line 65: 1,gp.period_num - XTR_CASH_FCST.G_roll_forward_period,

61: FROM gl_periods gps,
62: gl_periods gp,
63: gl_period_types gpt
64: WHERE gps.period_num =DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),
65: 1,gp.period_num - XTR_CASH_FCST.G_roll_forward_period,
66: gpt.number_per_fiscal_year +
67: mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year))
68: AND gps.period_year = gp.period_year +
69: DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),1,0,

Line 67: mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year))

63: gl_period_types gpt
64: WHERE gps.period_num =DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),
65: 1,gp.period_num - XTR_CASH_FCST.G_roll_forward_period,
66: gpt.number_per_fiscal_year +
67: mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year))
68: AND gps.period_year = gp.period_year +
69: DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),1,0,
70: DECODE(mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year),0,
71: FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)-1,

Line 69: DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),1,0,

65: 1,gp.period_num - XTR_CASH_FCST.G_roll_forward_period,
66: gpt.number_per_fiscal_year +
67: mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year))
68: AND gps.period_year = gp.period_year +
69: DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),1,0,
70: DECODE(mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year),0,
71: FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)-1,
72: FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)))
73: AND gp.period_set_name = gps.period_set_name

Line 70: DECODE(mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year),0,

66: gpt.number_per_fiscal_year +
67: mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year))
68: AND gps.period_year = gp.period_year +
69: DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),1,0,
70: DECODE(mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year),0,
71: FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)-1,
72: FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)))
73: AND gp.period_set_name = gps.period_set_name
74: AND gps.period_type = gp.period_type

Line 71: FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)-1,

67: mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year))
68: AND gps.period_year = gp.period_year +
69: DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),1,0,
70: DECODE(mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year),0,
71: FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)-1,
72: FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)))
73: AND gp.period_set_name = gps.period_set_name
74: AND gps.period_type = gp.period_type
75: AND gpt.period_type = gp.period_type

Line 72: FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)))

68: AND gps.period_year = gp.period_year +
69: DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),1,0,
70: DECODE(mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year),0,
71: FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)-1,
72: FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)))
73: AND gp.period_set_name = gps.period_set_name
74: AND gps.period_type = gp.period_type
75: AND gpt.period_type = gp.period_type
76: AND gp.period_name = XTR_CASH_FCST.G_rp_forecast_start_period

Line 76: AND gp.period_name = XTR_CASH_FCST.G_rp_forecast_start_period

72: FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)))
73: AND gp.period_set_name = gps.period_set_name
74: AND gps.period_type = gp.period_type
75: AND gpt.period_type = gp.period_type
76: AND gp.period_name = XTR_CASH_FCST.G_rp_forecast_start_period
77: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
78:
79: CEFC_VIEW_CONST.set_start_period_name(history_period);
80: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);

Line 80: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);

76: AND gp.period_name = XTR_CASH_FCST.G_rp_forecast_start_period
77: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
78:
79: CEFC_VIEW_CONST.set_start_period_name(history_period);
80: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
81: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
82: EXCEPTION
83: WHEN NO_DATA_FOUND THEN
84: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 81: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);

77: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
78:
79: CEFC_VIEW_CONST.set_start_period_name(history_period);
80: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
81: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
82: EXCEPTION
83: WHEN NO_DATA_FOUND THEN
84: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
85: xtr_debug_pkg.debug('NO DATA FOUND FOR HISTORY PERIOD');

Line 98: XTR_CASH_FCST.G_invalid_overdue_row := FALSE;

94: END IF;
95:
96: min_col := CEFC_VIEW_CONST.get_min_col;
97: max_col := CEFC_VIEW_CONST.get_max_col;
98: XTR_CASH_FCST.G_invalid_overdue_row := FALSE;
99: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
100: xtr_debug_pkg.debug('< 101: END IF;
102: EXCEPTION

Line 100: xtr_debug_pkg.debug('<

96: min_col := CEFC_VIEW_CONST.get_min_col;
97: max_col := CEFC_VIEW_CONST.get_max_col;
98: XTR_CASH_FCST.G_invalid_overdue_row := FALSE;
99: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
100: xtr_debug_pkg.debug('< 101: END IF;
102: EXCEPTION
103: WHEN OTHERS THEN
104: IF(cCol%ISOPEN)THEN CLOSE cCol; END IF;

Line 156: l_start_date := XTR_CASH_FCST.G_rp_forecast_start_date;

152: XTR_DEBUG_PKG.DEBUG('EXCEPTION:populate_temp_buckets-->delete');
153: RAISE;
154: END;
155:
156: l_start_date := XTR_CASH_FCST.G_rp_forecast_start_date;
157:
158: FOR p_rec IN C_periods LOOP
159: IF p_rec.length_type = 'D' THEN
160: l_end_date := LAST_DAY(l_start_date + p_rec.length_of_period);

Line 270: | XTR_CASH_FCST.create_forecast |

266: | DESCRIPTION |
267: | Return real aging buckets by considering the transaction |
268: | calendar into account |
269: | CALLED BY |
270: | XTR_CASH_FCST.create_forecast |
271: | REQUIRES |
272: | |
273: | HISTORY |
274: | 30-DEC-1998 Created BHChung |

Line 290: IF(XTR_CASH_FCST.G_transaction_calendar_id IS NOT NULL)THEN

286: xtr_debug_pkg.debug('>>ce_csh_fcst_pop.populate_aging_buckets');
287: END IF;
288: populate_temp_buckets;
289:
290: IF(XTR_CASH_FCST.G_transaction_calendar_id IS NOT NULL)THEN
291: OPEN C1;
292: FETCH C1 INTO fid, start_date, end_date;
293:
294: LOOP

Line 300: IF(XTR_CASH_FCST.G_transaction_calendar_id IS NOT NULL)THEN

296:
297: new_start_date := NULL;
298: new_end_date := NULL;
299:
300: IF(XTR_CASH_FCST.G_transaction_calendar_id IS NOT NULL)THEN
301: IF(start_date <= G_calendar_start OR
302: start_date-1 > G_calendar_end) THEN
303: new_start_date := start_date;
304: ELSE

Line 309: where transaction_calendar_id = XTR_CASH_FCST.G_transaction_calendar_id

305: BEGIN
306: select max(transaction_date)+1
307: into new_start_date
308: from gl_transaction_dates
309: where transaction_calendar_id = XTR_CASH_FCST.G_transaction_calendar_id
310: and transaction_date < start_date
311: and business_day_flag = 'Y';
312:
313: IF (new_start_date IS NULL) THEN

Line 331: where transaction_calendar_id = XTR_CASH_FCST.G_transaction_calendar_id

327: BEGIN
328: select max(transaction_date)
329: into new_end_date
330: from gl_transaction_dates
331: where transaction_calendar_id = XTR_CASH_FCST.G_transaction_calendar_id
332: and transaction_date <= end_date
333: and business_day_flag = 'Y';
334:
335: IF (new_end_date IS NULL) THEN

Line 393: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452

389: --------------------------------------------------------------------- */
390: FUNCTION Get_Select_Clause RETURN VARCHAR2 IS
391: select_clause VARCHAR2(300);
392: BEGIN
393: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
394: select_clause := '
395: SELECT cab.forecast_period_temp_id,
396: src.currency_code,
397: SUM(src.amount),

Line 457: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452

453: --------------------------------------------------------------------- */
454: FUNCTION Get_Group_Clause RETURN VARCHAR2 IS
455: group_clause VARCHAR2(100);
456: BEGIN
457: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
458: group_clause := '
459: GROUP BY cab.forecast_period_temp_id, src.currency_code,
460: src.bank_account_id ';
461: else

Line 488: IF(XTR_CASH_FCST.G_rp_src_curr_type = 'E')THEN

484: --------------------------------------------------------------------- */
485: FUNCTION Add_Where(criteria VARCHAR2) RETURN VARCHAR2 IS
486: BEGIN
487: IF(criteria = 'SRC_CURR_TYPE')THEN
488: IF(XTR_CASH_FCST.G_rp_src_curr_type = 'E')THEN
489: return ('
490: AND src.currency_code = '''||XTR_CASH_FCST.G_rp_src_currency||''' ');
491: ELSIF(XTR_CASH_FCST.G_rp_src_curr_type = 'F')THEN
492: return ('

Line 490: AND src.currency_code = '''||XTR_CASH_FCST.G_rp_src_currency||''' ');

486: BEGIN
487: IF(criteria = 'SRC_CURR_TYPE')THEN
488: IF(XTR_CASH_FCST.G_rp_src_curr_type = 'E')THEN
489: return ('
490: AND src.currency_code = '''||XTR_CASH_FCST.G_rp_src_currency||''' ');
491: ELSIF(XTR_CASH_FCST.G_rp_src_curr_type = 'F')THEN
492: return ('
493: AND org.currency_code = '''||XTR_CASH_FCST.G_rp_src_currency||'''
494: AND (org.org_id = src.org_id or org.org_id IS NULL) ');

Line 491: ELSIF(XTR_CASH_FCST.G_rp_src_curr_type = 'F')THEN

487: IF(criteria = 'SRC_CURR_TYPE')THEN
488: IF(XTR_CASH_FCST.G_rp_src_curr_type = 'E')THEN
489: return ('
490: AND src.currency_code = '''||XTR_CASH_FCST.G_rp_src_currency||''' ');
491: ELSIF(XTR_CASH_FCST.G_rp_src_curr_type = 'F')THEN
492: return ('
493: AND org.currency_code = '''||XTR_CASH_FCST.G_rp_src_currency||'''
494: AND (org.org_id = src.org_id or org.org_id IS NULL) ');
495: END IF;

Line 493: AND org.currency_code = '''||XTR_CASH_FCST.G_rp_src_currency||'''

489: return ('
490: AND src.currency_code = '''||XTR_CASH_FCST.G_rp_src_currency||''' ');
491: ELSIF(XTR_CASH_FCST.G_rp_src_curr_type = 'F')THEN
492: return ('
493: AND org.currency_code = '''||XTR_CASH_FCST.G_rp_src_currency||'''
494: AND (org.org_id = src.org_id or org.org_id IS NULL) ');
495: END IF;
496:
497: ELSIF(criteria = 'EXCHANGE_TYPE')THEN

Line 498: IF(XTR_CASH_FCST.G_rp_exchange_type IS NULL OR

494: AND (org.org_id = src.org_id or org.org_id IS NULL) ');
495: END IF;
496:
497: ELSIF(criteria = 'EXCHANGE_TYPE')THEN
498: IF(XTR_CASH_FCST.G_rp_exchange_type IS NULL OR
499: XTR_CASH_FCST.G_rp_exchange_type <> 'User')THEN
500: return ('
501: AND curr.forecast_request_id = '||XTR_CASH_FCST.G_forecast_id||'
502: AND curr.to_currency = '''||XTR_CASH_FCST.G_rp_forecast_currency||'''

Line 499: XTR_CASH_FCST.G_rp_exchange_type <> 'User')THEN

495: END IF;
496:
497: ELSIF(criteria = 'EXCHANGE_TYPE')THEN
498: IF(XTR_CASH_FCST.G_rp_exchange_type IS NULL OR
499: XTR_CASH_FCST.G_rp_exchange_type <> 'User')THEN
500: return ('
501: AND curr.forecast_request_id = '||XTR_CASH_FCST.G_forecast_id||'
502: AND curr.to_currency = '''||XTR_CASH_FCST.G_rp_forecast_currency||'''
503: AND curr.currency_code = src.currency_code ');

Line 501: AND curr.forecast_request_id = '||XTR_CASH_FCST.G_forecast_id||'

497: ELSIF(criteria = 'EXCHANGE_TYPE')THEN
498: IF(XTR_CASH_FCST.G_rp_exchange_type IS NULL OR
499: XTR_CASH_FCST.G_rp_exchange_type <> 'User')THEN
500: return ('
501: AND curr.forecast_request_id = '||XTR_CASH_FCST.G_forecast_id||'
502: AND curr.to_currency = '''||XTR_CASH_FCST.G_rp_forecast_currency||'''
503: AND curr.currency_code = src.currency_code ');
504: END IF;
505:

Line 502: AND curr.to_currency = '''||XTR_CASH_FCST.G_rp_forecast_currency||'''

498: IF(XTR_CASH_FCST.G_rp_exchange_type IS NULL OR
499: XTR_CASH_FCST.G_rp_exchange_type <> 'User')THEN
500: return ('
501: AND curr.forecast_request_id = '||XTR_CASH_FCST.G_forecast_id||'
502: AND curr.to_currency = '''||XTR_CASH_FCST.G_rp_forecast_currency||'''
503: AND curr.currency_code = src.currency_code ');
504: END IF;
505:
506: ELSIF(criteria = 'VENDOR_TYPE')THEN

Line 507: IF(XTR_CASH_FCST.G_vendor_type IS NOT NULL)THEN

503: AND curr.currency_code = src.currency_code ');
504: END IF;
505:
506: ELSIF(criteria = 'VENDOR_TYPE')THEN
507: IF(XTR_CASH_FCST.G_vendor_type IS NOT NULL)THEN
508: return ('
509: AND src.vendor_type = '''||replace(XTR_CASH_FCST.G_vendor_type,'''','''''')||''' ');
510: END IF;
511:

Line 509: AND src.vendor_type = '''||replace(XTR_CASH_FCST.G_vendor_type,'''','''''')||''' ');

505:
506: ELSIF(criteria = 'VENDOR_TYPE')THEN
507: IF(XTR_CASH_FCST.G_vendor_type IS NOT NULL)THEN
508: return ('
509: AND src.vendor_type = '''||replace(XTR_CASH_FCST.G_vendor_type,'''','''''')||''' ');
510: END IF;
511:
512: ELSIF(criteria = 'PAY_GROUP')THEN
513: IF(XTR_CASH_FCST.G_pay_group IS NOT NULL)THEN

Line 513: IF(XTR_CASH_FCST.G_pay_group IS NOT NULL)THEN

509: AND src.vendor_type = '''||replace(XTR_CASH_FCST.G_vendor_type,'''','''''')||''' ');
510: END IF;
511:
512: ELSIF(criteria = 'PAY_GROUP')THEN
513: IF(XTR_CASH_FCST.G_pay_group IS NOT NULL)THEN
514: return ('
515: AND src.paygroup = '''||replace(XTR_CASH_FCST.G_pay_group,'''','''''')||''' ');
516: END IF;
517:

Line 515: AND src.paygroup = '''||replace(XTR_CASH_FCST.G_pay_group,'''','''''')||''' ');

511:
512: ELSIF(criteria = 'PAY_GROUP')THEN
513: IF(XTR_CASH_FCST.G_pay_group IS NOT NULL)THEN
514: return ('
515: AND src.paygroup = '''||replace(XTR_CASH_FCST.G_pay_group,'''','''''')||''' ');
516: END IF;
517:
518: ELSIF(criteria = 'PAYMENT_PRIORITY')THEN
519: IF(XTR_CASH_FCST.G_payment_priority IS NOT NULL)THEN

Line 519: IF(XTR_CASH_FCST.G_payment_priority IS NOT NULL)THEN

515: AND src.paygroup = '''||replace(XTR_CASH_FCST.G_pay_group,'''','''''')||''' ');
516: END IF;
517:
518: ELSIF(criteria = 'PAYMENT_PRIORITY')THEN
519: IF(XTR_CASH_FCST.G_payment_priority IS NOT NULL)THEN
520: return ('
521: AND src.payment_priority <= '||to_char(XTR_CASH_FCST.G_payment_priority));
522: END IF;
523:

Line 521: AND src.payment_priority <= '||to_char(XTR_CASH_FCST.G_payment_priority));

517:
518: ELSIF(criteria = 'PAYMENT_PRIORITY')THEN
519: IF(XTR_CASH_FCST.G_payment_priority IS NOT NULL)THEN
520: return ('
521: AND src.payment_priority <= '||to_char(XTR_CASH_FCST.G_payment_priority));
522: END IF;
523:
524: ELSIF(criteria = 'BANK_ACCOUNT_ID')THEN
525: IF(XTR_CASH_FCST.G_bank_account_id IS NOT NULL)THEN

Line 525: IF(XTR_CASH_FCST.G_bank_account_id IS NOT NULL)THEN

521: AND src.payment_priority <= '||to_char(XTR_CASH_FCST.G_payment_priority));
522: END IF;
523:
524: ELSIF(criteria = 'BANK_ACCOUNT_ID')THEN
525: IF(XTR_CASH_FCST.G_bank_account_id IS NOT NULL)THEN
526: return ('
527: AND src.bank_account_id = '||TO_CHAR(XTR_CASH_FCST.G_bank_account_id));
528: END IF;
529:

Line 527: AND src.bank_account_id = '||TO_CHAR(XTR_CASH_FCST.G_bank_account_id));

523:
524: ELSIF(criteria = 'BANK_ACCOUNT_ID')THEN
525: IF(XTR_CASH_FCST.G_bank_account_id IS NOT NULL)THEN
526: return ('
527: AND src.bank_account_id = '||TO_CHAR(XTR_CASH_FCST.G_bank_account_id));
528: END IF;
529:
530: ELSIF(criteria = 'RECEIPT_METHOD_ID')THEN
531: IF(XTR_CASH_FCST.G_receipt_method_id IS NOT NULL)THEN

Line 531: IF(XTR_CASH_FCST.G_receipt_method_id IS NOT NULL)THEN

527: AND src.bank_account_id = '||TO_CHAR(XTR_CASH_FCST.G_bank_account_id));
528: END IF;
529:
530: ELSIF(criteria = 'RECEIPT_METHOD_ID')THEN
531: IF(XTR_CASH_FCST.G_receipt_method_id IS NOT NULL)THEN
532: return ('
533: AND src.receipt_method_id = '||TO_CHAR(XTR_CASH_FCST.G_receipt_method_id));
534: END IF;
535:

Line 533: AND src.receipt_method_id = '||TO_CHAR(XTR_CASH_FCST.G_receipt_method_id));

529:
530: ELSIF(criteria = 'RECEIPT_METHOD_ID')THEN
531: IF(XTR_CASH_FCST.G_receipt_method_id IS NOT NULL)THEN
532: return ('
533: AND src.receipt_method_id = '||TO_CHAR(XTR_CASH_FCST.G_receipt_method_id));
534: END IF;
535:
536: ELSIF(criteria = 'CUSTOMER_PROFILE_CLASS_ID')THEN
537: IF(XTR_CASH_FCST.G_customer_profile_class_id IS NOT NULL)THEN

Line 537: IF(XTR_CASH_FCST.G_customer_profile_class_id IS NOT NULL)THEN

533: AND src.receipt_method_id = '||TO_CHAR(XTR_CASH_FCST.G_receipt_method_id));
534: END IF;
535:
536: ELSIF(criteria = 'CUSTOMER_PROFILE_CLASS_ID')THEN
537: IF(XTR_CASH_FCST.G_customer_profile_class_id IS NOT NULL)THEN
538: return ('
539: AND src.profile_class_id = '||to_char(XTR_CASH_FCST.G_customer_profile_class_id));
540: END IF;
541:

Line 539: AND src.profile_class_id = '||to_char(XTR_CASH_FCST.G_customer_profile_class_id));

535:
536: ELSIF(criteria = 'CUSTOMER_PROFILE_CLASS_ID')THEN
537: IF(XTR_CASH_FCST.G_customer_profile_class_id IS NOT NULL)THEN
538: return ('
539: AND src.profile_class_id = '||to_char(XTR_CASH_FCST.G_customer_profile_class_id));
540: END IF;
541:
542: ELSIF(criteria = 'AUTHORIZATION_STATUS')THEN
543: IF(XTR_CASH_FCST.G_authorization_status IS NOT NULL)THEN

Line 543: IF(XTR_CASH_FCST.G_authorization_status IS NOT NULL)THEN

539: AND src.profile_class_id = '||to_char(XTR_CASH_FCST.G_customer_profile_class_id));
540: END IF;
541:
542: ELSIF(criteria = 'AUTHORIZATION_STATUS')THEN
543: IF(XTR_CASH_FCST.G_authorization_status IS NOT NULL)THEN
544: return ('
545: AND src.status = '''||replace(XTR_CASH_FCST.G_authorization_status,'''','''''')||''' ');
546: END IF;
547:

Line 545: AND src.status = '''||replace(XTR_CASH_FCST.G_authorization_status,'''','''''')||''' ');

541:
542: ELSIF(criteria = 'AUTHORIZATION_STATUS')THEN
543: IF(XTR_CASH_FCST.G_authorization_status IS NOT NULL)THEN
544: return ('
545: AND src.status = '''||replace(XTR_CASH_FCST.G_authorization_status,'''','''''')||''' ');
546: END IF;
547:
548: ELSIF(criteria = 'PAYMENT_METHOD')THEN
549: IF(XTR_CASH_FCST.G_payment_method IS NOT NULL)THEN

Line 549: IF(XTR_CASH_FCST.G_payment_method IS NOT NULL)THEN

545: AND src.status = '''||replace(XTR_CASH_FCST.G_authorization_status,'''','''''')||''' ');
546: END IF;
547:
548: ELSIF(criteria = 'PAYMENT_METHOD')THEN
549: IF(XTR_CASH_FCST.G_payment_method IS NOT NULL)THEN
550: return ('
551: AND src.payment_method = '''||replace(XTR_CASH_FCST.G_payment_method,'''','''''')||''' ');
552: END IF;
553:

Line 551: AND src.payment_method = '''||replace(XTR_CASH_FCST.G_payment_method,'''','''''')||''' ');

547:
548: ELSIF(criteria = 'PAYMENT_METHOD')THEN
549: IF(XTR_CASH_FCST.G_payment_method IS NOT NULL)THEN
550: return ('
551: AND src.payment_method = '''||replace(XTR_CASH_FCST.G_payment_method,'''','''''')||''' ');
552: END IF;
553:
554: ELSIF(criteria = 'ORG_PAYMENT_METHOD_ID')THEN
555: IF(XTR_CASH_FCST.G_org_payment_method_id IS NOT NULL)THEN

Line 555: IF(XTR_CASH_FCST.G_org_payment_method_id IS NOT NULL)THEN

551: AND src.payment_method = '''||replace(XTR_CASH_FCST.G_payment_method,'''','''''')||''' ');
552: END IF;
553:
554: ELSIF(criteria = 'ORG_PAYMENT_METHOD_ID')THEN
555: IF(XTR_CASH_FCST.G_org_payment_method_id IS NOT NULL)THEN
556: return ('
557: AND src.org_payment_method_id = '||to_char(XTR_CASH_FCST.G_org_payment_method_id));
558: END IF;
559:

Line 557: AND src.org_payment_method_id = '||to_char(XTR_CASH_FCST.G_org_payment_method_id));

553:
554: ELSIF(criteria = 'ORG_PAYMENT_METHOD_ID')THEN
555: IF(XTR_CASH_FCST.G_org_payment_method_id IS NOT NULL)THEN
556: return ('
557: AND src.org_payment_method_id = '||to_char(XTR_CASH_FCST.G_org_payment_method_id));
558: END IF;
559:
560: ELSIF(criteria = 'PAYROLL_ID')THEN
561: IF( XTR_CASH_FCST.G_payroll_id IS NOT NULL )THEN

Line 561: IF( XTR_CASH_FCST.G_payroll_id IS NOT NULL )THEN

557: AND src.org_payment_method_id = '||to_char(XTR_CASH_FCST.G_org_payment_method_id));
558: END IF;
559:
560: ELSIF(criteria = 'PAYROLL_ID')THEN
561: IF( XTR_CASH_FCST.G_payroll_id IS NOT NULL )THEN
562: return ('
563: AND src.payroll_id = '||to_char(XTR_CASH_FCST.G_payroll_id));
564: END IF;
565:

Line 563: AND src.payroll_id = '||to_char(XTR_CASH_FCST.G_payroll_id));

559:
560: ELSIF(criteria = 'PAYROLL_ID')THEN
561: IF( XTR_CASH_FCST.G_payroll_id IS NOT NULL )THEN
562: return ('
563: AND src.payroll_id = '||to_char(XTR_CASH_FCST.G_payroll_id));
564: END IF;
565:
566: ELSIF(criteria = 'CHANNEL_CODE')THEN
567: IF( XTR_CASH_FCST.G_channel_code IS NOT NULL )THEN

Line 567: IF( XTR_CASH_FCST.G_channel_code IS NOT NULL )THEN

563: AND src.payroll_id = '||to_char(XTR_CASH_FCST.G_payroll_id));
564: END IF;
565:
566: ELSIF(criteria = 'CHANNEL_CODE')THEN
567: IF( XTR_CASH_FCST.G_channel_code IS NOT NULL )THEN
568: return ('
569: AND src.channel_code = '''||replace(XTR_CASH_FCST.G_channel_code,'''','''''')||''' ');
570: END IF;
571:

Line 569: AND src.channel_code = '''||replace(XTR_CASH_FCST.G_channel_code,'''','''''')||''' ');

565:
566: ELSIF(criteria = 'CHANNEL_CODE')THEN
567: IF( XTR_CASH_FCST.G_channel_code IS NOT NULL )THEN
568: return ('
569: AND src.channel_code = '''||replace(XTR_CASH_FCST.G_channel_code,'''','''''')||''' ');
570: END IF;
571:
572: ELSIF(criteria = 'SALES_STAGE_ID')THEN
573: IF( XTR_CASH_FCST.G_sales_stage_id IS NOT NULL )THEN

Line 573: IF( XTR_CASH_FCST.G_sales_stage_id IS NOT NULL )THEN

569: AND src.channel_code = '''||replace(XTR_CASH_FCST.G_channel_code,'''','''''')||''' ');
570: END IF;
571:
572: ELSIF(criteria = 'SALES_STAGE_ID')THEN
573: IF( XTR_CASH_FCST.G_sales_stage_id IS NOT NULL )THEN
574: return ('
575: AND src.sales_stage_id = '||to_char(XTR_CASH_FCST.G_sales_stage_id));
576: END IF;
577:

Line 575: AND src.sales_stage_id = '||to_char(XTR_CASH_FCST.G_sales_stage_id));

571:
572: ELSIF(criteria = 'SALES_STAGE_ID')THEN
573: IF( XTR_CASH_FCST.G_sales_stage_id IS NOT NULL )THEN
574: return ('
575: AND src.sales_stage_id = '||to_char(XTR_CASH_FCST.G_sales_stage_id));
576: END IF;
577:
578: ELSIF(criteria = 'SALES_FORECAST_STATUS')THEN
579: IF( XTR_CASH_FCST.G_sales_forecast_status IS NOT NULL )THEN

Line 579: IF( XTR_CASH_FCST.G_sales_forecast_status IS NOT NULL )THEN

575: AND src.sales_stage_id = '||to_char(XTR_CASH_FCST.G_sales_stage_id));
576: END IF;
577:
578: ELSIF(criteria = 'SALES_FORECAST_STATUS')THEN
579: IF( XTR_CASH_FCST.G_sales_forecast_status IS NOT NULL )THEN
580: return ('
581: AND src.status_code = '''||replace(XTR_CASH_FCST.G_sales_forecast_status,'''','''''')||''' ');
582: END IF;
583:

Line 581: AND src.status_code = '''||replace(XTR_CASH_FCST.G_sales_forecast_status,'''','''''')||''' ');

577:
578: ELSIF(criteria = 'SALES_FORECAST_STATUS')THEN
579: IF( XTR_CASH_FCST.G_sales_forecast_status IS NOT NULL )THEN
580: return ('
581: AND src.status_code = '''||replace(XTR_CASH_FCST.G_sales_forecast_status,'''','''''')||''' ');
582: END IF;
583:
584: ELSE
585: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 612: xtr_debug_pkg.debug('>>XTR_CASH_FCST.Get_Where_Clause');

608: where_clause VARCHAR2(1000);
609:
610: BEGIN
611: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
612: xtr_debug_pkg.debug('>>XTR_CASH_FCST.Get_Where_Clause');
613: END IF;
614:
615: where_clause := ' WHERE src.org_id IN ' ||XTR_CASH_FCST.G_rp_org_ids;
616:

Line 615: where_clause := ' WHERE src.org_id IN ' ||XTR_CASH_FCST.G_rp_org_ids;

611: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
612: xtr_debug_pkg.debug('>>XTR_CASH_FCST.Get_Where_Clause');
613: END IF;
614:
615: where_clause := ' WHERE src.org_id IN ' ||XTR_CASH_FCST.G_rp_org_ids;
616:
617: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
618: xtr_debug_pkg.debug('< 619: END IF;

Line 618: xtr_debug_pkg.debug('<

614:
615: where_clause := ' WHERE src.org_id IN ' ||XTR_CASH_FCST.G_rp_org_ids;
616:
617: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
618: xtr_debug_pkg.debug('< 619: END IF;
620: return where_clause;
621: END Get_Where_Clause;
622:

Line 690: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452

686:
687: DBMS_SQL.Define_Column(cursor_id, 1, forecast_period_temp_id);
688: DBMS_SQL.Define_Column(cursor_id, 2, currency, 15);
689: DBMS_SQL.Define_Column(cursor_id, 3, forecast_amount);
690: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
691: DBMS_SQL.Define_Column(cursor_id, 4, bank_account_id);
692: end if;
693:
694: exec_id := DBMS_SQL.execute(cursor_id);

Line 704: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452

700:
701: DBMS_SQL.Column_Value(cursor_id, 1, forecast_period_temp_id);
702: DBMS_SQL.Column_Value(cursor_id, 2, currency);
703: DBMS_SQL.Column_Value(cursor_id, 3, forecast_amount);
704: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
705: DBMS_SQL.Column_Value(cursor_id, 4, bank_account_id);
706: end if;
707:
708: IF(amount_date < XTR_CASH_FCST.G_rp_forecast_start_date)THEN -- Overdue Periods

Line 708: IF(amount_date < XTR_CASH_FCST.G_rp_forecast_start_date)THEN -- Overdue Periods

704: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
705: DBMS_SQL.Column_Value(cursor_id, 4, bank_account_id);
706: end if;
707:
708: IF(amount_date < XTR_CASH_FCST.G_rp_forecast_start_date)THEN -- Overdue Periods
709: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
710: xtr_debug_pkg.debug('Execute_Main_Query: Overdue transaction period');
711: xtr_debug_pkg.debug('Execute_Main_Query: trx_type = '
712: || XTR_CASH_FCST.G_trx_type || ', forecast_method = ' || XTR_CASH_FCST.G_forecast_method);

Line 712: || XTR_CASH_FCST.G_trx_type || ', forecast_method = ' || XTR_CASH_FCST.G_forecast_method);

708: IF(amount_date < XTR_CASH_FCST.G_rp_forecast_start_date)THEN -- Overdue Periods
709: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
710: xtr_debug_pkg.debug('Execute_Main_Query: Overdue transaction period');
711: xtr_debug_pkg.debug('Execute_Main_Query: trx_type = '
712: || XTR_CASH_FCST.G_trx_type || ', forecast_method = ' || XTR_CASH_FCST.G_forecast_method);
713: END IF;
714:
715: IF(XTR_CASH_FCST.G_trx_type = 'PAY')THEN
716: forecast_amount := 0;

Line 715: IF(XTR_CASH_FCST.G_trx_type = 'PAY')THEN

711: xtr_debug_pkg.debug('Execute_Main_Query: trx_type = '
712: || XTR_CASH_FCST.G_trx_type || ', forecast_method = ' || XTR_CASH_FCST.G_forecast_method);
713: END IF;
714:
715: IF(XTR_CASH_FCST.G_trx_type = 'PAY')THEN
716: forecast_amount := 0;
717: END IF;
718: IF(XTR_CASH_FCST.G_trx_type IN ('APP', 'ARR') AND
719: XTR_CASH_FCST.G_forecast_method = 'P')THEN

Line 718: IF(XTR_CASH_FCST.G_trx_type IN ('APP', 'ARR') AND

714:
715: IF(XTR_CASH_FCST.G_trx_type = 'PAY')THEN
716: forecast_amount := 0;
717: END IF;
718: IF(XTR_CASH_FCST.G_trx_type IN ('APP', 'ARR') AND
719: XTR_CASH_FCST.G_forecast_method = 'P')THEN
720: forecast_amount := 0;
721: END IF;
722: IF(XTR_CASH_FCST.G_invalid_overdue_row)THEN

Line 719: XTR_CASH_FCST.G_forecast_method = 'P')THEN

715: IF(XTR_CASH_FCST.G_trx_type = 'PAY')THEN
716: forecast_amount := 0;
717: END IF;
718: IF(XTR_CASH_FCST.G_trx_type IN ('APP', 'ARR') AND
719: XTR_CASH_FCST.G_forecast_method = 'P')THEN
720: forecast_amount := 0;
721: END IF;
722: IF(XTR_CASH_FCST.G_invalid_overdue_row)THEN
723: forecast_amount := 0;

Line 722: IF(XTR_CASH_FCST.G_invalid_overdue_row)THEN

718: IF(XTR_CASH_FCST.G_trx_type IN ('APP', 'ARR') AND
719: XTR_CASH_FCST.G_forecast_method = 'P')THEN
720: forecast_amount := 0;
721: END IF;
722: IF(XTR_CASH_FCST.G_invalid_overdue_row)THEN
723: forecast_amount := 0;
724: END IF;
725: END IF;
726:

Line 735: XTR_CASH_FCST.G_rp_forecast_start_date,

731: IF l_emu = 'EMU' THEN
732: BEGIN
733: forecast_amount := GL_CURRENCY_API.convert_amount(currency,
734: 'EUR',
735: XTR_CASH_FCST.G_rp_forecast_start_date,
736: 'EMU-FIXED',
737: forecast_amount);
738:
739: currency := 'EUR';

Line 744: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id,

740: EXCEPTION
741: WHEN OTHERS THEN
742: FND_MESSAGE.set_name('GL', 'GL_JE_INVALID_CONVERSION_INFO');
743: error_msg := fnd_message.get;
744: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id,
745: XTR_CASH_FCST.G_rp_forecast_header_id, XTR_CASH_FCST.G_forecast_row_id,
746: 'GL_JE_INVALID_CONVERSION_INFO', error_msg);
747: END;
748: END IF;

Line 745: XTR_CASH_FCST.G_rp_forecast_header_id, XTR_CASH_FCST.G_forecast_row_id,

741: WHEN OTHERS THEN
742: FND_MESSAGE.set_name('GL', 'GL_JE_INVALID_CONVERSION_INFO');
743: error_msg := fnd_message.get;
744: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id,
745: XTR_CASH_FCST.G_rp_forecast_header_id, XTR_CASH_FCST.G_forecast_row_id,
746: 'GL_JE_INVALID_CONVERSION_INFO', error_msg);
747: END;
748: END IF;
749:

Line 765: XTR_CASH_FCST.G_party_code,

761: level_of_summary)
762: VALUES (amount_date,
763: nvl(forecast_amount,0),
764: currency,
765: XTR_CASH_FCST.G_party_code,
766: XTR_CASH_FCST.G_trx_type,
767: bank_account_id,
768: level_of_summary);
769: ELSE

Line 766: XTR_CASH_FCST.G_trx_type,

762: VALUES (amount_date,
763: nvl(forecast_amount,0),
764: currency,
765: XTR_CASH_FCST.G_party_code,
766: XTR_CASH_FCST.G_trx_type,
767: bank_account_id,
768: level_of_summary);
769: ELSE
770: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 834: IF (NVL(XTR_CASH_FCST.G_forecast_method,'F') = 'P') THEN

830: END IF;
831:
832: where_clause := Get_Where_Clause || Add_Where('PAYMENT_METHOD') || Add_Where('BANK_ACCOUNT_ID');
833:
834: IF (NVL(XTR_CASH_FCST.G_forecast_method,'F') = 'P') THEN
835: BEGIN
836: Set_History;
837:
838: EXCEPTION

Line 841: xtr_debug_pkg.debug('row_id = ' || to_char(XTR_CASH_FCST.G_forecast_row_id));

837:
838: EXCEPTION
839: When NO_DATA_FOUND Then
840: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
841: xtr_debug_pkg.debug('row_id = ' || to_char(XTR_CASH_FCST.G_forecast_row_id));
842: END IF;
843: UPDATE ce_forecasts
844: SET error_status = 'E'
845: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;

Line 873: ||to_char(XTR_CASH_FCST.G_lead_time)||

869:
870: ELSE
871: where_clause := where_clause || '
872: AND NVL(src.maturity_date(+),src.payment_date(+)) +'
873: ||to_char(XTR_CASH_FCST.G_lead_time)||
874: ' BETWEEN cab.start_date and cab.end_date
875: AND src.status = ''NEGOTIABLE'' ';
876: END IF;
877: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 933: IF (NVL(XTR_CASH_FCST.G_discount_option,'N') = 'N') THEN

929: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
930: xtr_debug_pkg.debug('Built Select Clause');
931: END IF;
932:
933: IF (NVL(XTR_CASH_FCST.G_discount_option,'N') = 'N') THEN
934: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
935: xtr_debug_pkg.debug('Discount NOT taken');
936: END IF;
937: from_clause := Get_From_Clause('ce_ap_fc_due_invoices_v');

Line 950: ||to_char(XTR_CASH_FCST.G_lead_time)||

946: END IF;
947:
948: where_clause := Get_Where_Clause || '
949: AND src.trx_date(+) +'
950: ||to_char(XTR_CASH_FCST.G_lead_time)||
951: ' BETWEEN cab.start_date and cab.end_date ' ||
952: Add_Where('PAYMENT_PRIORITY') || Add_Where('PAY_GROUP') || Add_Where('VENDOR_TYPE');
953:
954: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1004: IF (XTR_CASH_FCST.G_include_dispute_flag = 'N') THEN

1000: BEGIN
1001: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1002: xtr_debug_pkg.debug('>>Build_AR_Invoice_Query');
1003: END IF;
1004: IF (XTR_CASH_FCST.G_include_dispute_flag = 'N') THEN
1005: select_clause := ' SELECT cab.forecast_period_temp_id,
1006: src.currency_code,
1007: SUM(src.amount-src.dispute_amount) ';
1008: ELSE

Line 1023: ||to_char(XTR_CASH_FCST.G_lead_time)||

1019: END IF;
1020:
1021: where_clause := Get_Where_Clause || '
1022: AND src.trx_date +'
1023: ||to_char(XTR_CASH_FCST.G_lead_time)||
1024: ' BETWEEN cab.start_date and cab.end_date '||
1025: Add_Where('CUSTOMER_PROFILE_CLASS_ID');
1026: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1027: xtr_debug_pkg.debug('Built Where Clause');

Line 1092: IF (NVL(XTR_CASH_FCST.G_forecast_method,'F') = 'P') THEN

1088: END IF;
1089:
1090: where_clause := Get_Where_Clause || Add_Where('BANK_ACCOUNT_ID') || Add_Where('RECEIPT_METHOD_ID');
1091:
1092: IF (NVL(XTR_CASH_FCST.G_forecast_method,'F') = 'P') THEN
1093: BEGIN
1094: Set_History;
1095:
1096: EXCEPTION

Line 1099: xtr_debug_pkg.debug('row_id = ' || to_char(XTR_CASH_FCST.G_forecast_row_id));

1095:
1096: EXCEPTION
1097: When NO_DATA_FOUND Then
1098: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1099: xtr_debug_pkg.debug('row_id = ' || to_char(XTR_CASH_FCST.G_forecast_row_id));
1100: END IF;
1101:
1102: UPDATE ce_forecasts
1103: SET error_status = 'E'

Line 1131: ||to_char(XTR_CASH_FCST.G_lead_time)||

1127: AND src.status = ''CLEARED'' ';
1128: ELSE
1129: where_clause := where_clause || '
1130: AND nvl(src.effective_date(+),NVL(src.maturity_date(+),src.trx_date(+))) +'
1131: ||to_char(XTR_CASH_FCST.G_lead_time)||
1132: ' BETWEEN cab.start_date and cab.end_date
1133: AND src.status <> ''CLEARED'' ';
1134:
1135:

Line 1212: xtr_debug_pkg.debug('row_id = ' || to_char(XTR_CASH_FCST.G_forecast_row_id));

1208: Set_History;
1209: EXCEPTION
1210: When NO_DATA_FOUND Then
1211: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1212: xtr_debug_pkg.debug('row_id = ' || to_char(XTR_CASH_FCST.G_forecast_row_id));
1213: END IF;
1214: UPDATE ce_forecasts
1215: SET error_status = 'E'
1216: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;

Line 1282: AND src.trx_date(+) +'||to_char(XTR_CASH_FCST.G_lead_time)||'

1278: xtr_debug_pkg.debug('Built From Clause');
1279: END IF;
1280:
1281: where_clause := Get_Where_Clause|| '
1282: AND src.trx_date(+) +'||to_char(XTR_CASH_FCST.G_lead_time)||'
1283: BETWEEN cab.start_date and cab.end_date ' ||
1284: Add_Where('AUTHORIZATION_STATUS') || Add_Where('PAYMENT_PRIORITY') ||
1285: Add_Where('PAY_GROUP') || Add_Where('VENDOR_TYPE');
1286:

Line 1344: AND src.trx_date(+) +'||to_char(XTR_CASH_FCST.G_lead_time)|| '

1340: xtr_debug_pkg.debug('Built From Clause');
1341: END IF;
1342:
1343: where_clause := Get_Where_Clause || '
1344: AND src.trx_date(+) +'||to_char(XTR_CASH_FCST.G_lead_time)|| '
1345: BETWEEN cab.start_date and cab.end_date '||
1346: Add_Where('AUTHORIZATION_STATUS');
1347:
1348: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1406: IF( XTR_CASH_FCST.G_order_status = 'O') THEN

1402:
1403: where_clause := Get_Where_Clause ||
1404: Add_Where('CUSTOMER_PROFILE_CLASS_ID');
1405:
1406: IF( XTR_CASH_FCST.G_order_status = 'O') THEN
1407: where_clause := where_clause || '
1408: AND src.booked_flag = ''N'' ';
1409: ELSIF( XTR_CASH_FCST.G_order_status = 'B')THEN
1410: where_clause := where_clause || '

Line 1409: ELSIF( XTR_CASH_FCST.G_order_status = 'B')THEN

1405:
1406: IF( XTR_CASH_FCST.G_order_status = 'O') THEN
1407: where_clause := where_clause || '
1408: AND src.booked_flag = ''N'' ';
1409: ELSIF( XTR_CASH_FCST.G_order_status = 'B')THEN
1410: where_clause := where_clause || '
1411: AND src.booked_flag = ''Y'' ';
1412: END IF;
1413:

Line 1414: IF(XTR_CASH_FCST.G_order_date_type = 'R')THEN

1410: where_clause := where_clause || '
1411: AND src.booked_flag = ''Y'' ';
1412: END IF;
1413:
1414: IF(XTR_CASH_FCST.G_order_date_type = 'R')THEN
1415: where_clause := where_clause || '
1416: AND src.date_requested(+) +'||to_char(XTR_CASH_FCST.G_lead_time)||'
1417: BETWEEN cab.start_date and cab.end_date ';
1418: ELSE

Line 1416: AND src.date_requested(+) +'||to_char(XTR_CASH_FCST.G_lead_time)||'

1412: END IF;
1413:
1414: IF(XTR_CASH_FCST.G_order_date_type = 'R')THEN
1415: where_clause := where_clause || '
1416: AND src.date_requested(+) +'||to_char(XTR_CASH_FCST.G_lead_time)||'
1417: BETWEEN cab.start_date and cab.end_date ';
1418: ELSE
1419: where_clause := where_clause || '
1420: AND src.date_ordered(+) +'||to_char(XTR_CASH_FCST.G_lead_time)||'

Line 1420: AND src.date_ordered(+) +'||to_char(XTR_CASH_FCST.G_lead_time)||'

1416: AND src.date_requested(+) +'||to_char(XTR_CASH_FCST.G_lead_time)||'
1417: BETWEEN cab.start_date and cab.end_date ';
1418: ELSE
1419: where_clause := where_clause || '
1420: AND src.date_ordered(+) +'||to_char(XTR_CASH_FCST.G_lead_time)||'
1421: BETWEEN cab.start_date and cab.end_date ';
1422: END IF;
1423: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1424: xtr_debug_pkg.debug('Built Where Clause');

Line 1473: xtr_debug_pkg.debug('Get database information for database: '||XTR_CASH_FCST.G_external_source_type);

1469: --
1470: -- Get view and db information from the external source type
1471: --
1472: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1473: xtr_debug_pkg.debug('Get database information for database: '||XTR_CASH_FCST.G_external_source_type);
1474: END IF;
1475: BEGIN
1476:
1477: SELECT external_source_view, db_link_name

Line 1480: WHERE external_source_type = XTR_CASH_FCST.G_external_source_type;

1476:
1477: SELECT external_source_view, db_link_name
1478: INTO source_view, db_link
1479: FROM ce_forecast_ext_views
1480: WHERE external_source_type = XTR_CASH_FCST.G_external_source_type;
1481:
1482: EXCEPTION
1483: WHEN NO_DATA_FOUND THEN
1484: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1488: FND_MESSAGE.set_token('EXT_TYPE', XTR_CASH_FCST.G_external_source_type);

1484: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1485: xtr_debug_pkg.debug('EXCEPTION:Build_Remote_Query - View def not found');
1486: END IF;
1487: FND_MESSAGE.set_name('CE','CE_FC_EXT_SOURCE_UNDEFINED');
1488: FND_MESSAGE.set_token('EXT_TYPE', XTR_CASH_FCST.G_external_source_type);
1489: error_msg := FND_MESSAGE.get;
1490: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1491: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_EXT_SOURCE_UNDEFINED', error_msg);
1492: RETURN;

Line 1490: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,

1486: END IF;
1487: FND_MESSAGE.set_name('CE','CE_FC_EXT_SOURCE_UNDEFINED');
1488: FND_MESSAGE.set_token('EXT_TYPE', XTR_CASH_FCST.G_external_source_type);
1489: error_msg := FND_MESSAGE.get;
1490: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1491: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_EXT_SOURCE_UNDEFINED', error_msg);
1492: RETURN;
1493: END;
1494:

Line 1491: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_EXT_SOURCE_UNDEFINED', error_msg);

1487: FND_MESSAGE.set_name('CE','CE_FC_EXT_SOURCE_UNDEFINED');
1488: FND_MESSAGE.set_token('EXT_TYPE', XTR_CASH_FCST.G_external_source_type);
1489: error_msg := FND_MESSAGE.get;
1490: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1491: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_EXT_SOURCE_UNDEFINED', error_msg);
1492: RETURN;
1493: END;
1494:
1495:

Line 1533: XTR_CASH_FCST.G_criteria1,

1529:
1530: main_query := main_query ||'(
1531: '''||source_view||''',
1532: '''||db_link||''',
1533: XTR_CASH_FCST.G_criteria1,
1534: XTR_CASH_FCST.G_criteria2,
1535: XTR_CASH_FCST.G_criteria3,
1536: XTR_CASH_FCST.G_criteria4,
1537: XTR_CASH_FCST.G_criteria5,

Line 1534: XTR_CASH_FCST.G_criteria2,

1530: main_query := main_query ||'(
1531: '''||source_view||''',
1532: '''||db_link||''',
1533: XTR_CASH_FCST.G_criteria1,
1534: XTR_CASH_FCST.G_criteria2,
1535: XTR_CASH_FCST.G_criteria3,
1536: XTR_CASH_FCST.G_criteria4,
1537: XTR_CASH_FCST.G_criteria5,
1538: XTR_CASH_FCST.G_criteria6,

Line 1535: XTR_CASH_FCST.G_criteria3,

1531: '''||source_view||''',
1532: '''||db_link||''',
1533: XTR_CASH_FCST.G_criteria1,
1534: XTR_CASH_FCST.G_criteria2,
1535: XTR_CASH_FCST.G_criteria3,
1536: XTR_CASH_FCST.G_criteria4,
1537: XTR_CASH_FCST.G_criteria5,
1538: XTR_CASH_FCST.G_criteria6,
1539: XTR_CASH_FCST.G_criteria7,

Line 1536: XTR_CASH_FCST.G_criteria4,

1532: '''||db_link||''',
1533: XTR_CASH_FCST.G_criteria1,
1534: XTR_CASH_FCST.G_criteria2,
1535: XTR_CASH_FCST.G_criteria3,
1536: XTR_CASH_FCST.G_criteria4,
1537: XTR_CASH_FCST.G_criteria5,
1538: XTR_CASH_FCST.G_criteria6,
1539: XTR_CASH_FCST.G_criteria7,
1540: XTR_CASH_FCST.G_criteria8,

Line 1537: XTR_CASH_FCST.G_criteria5,

1533: XTR_CASH_FCST.G_criteria1,
1534: XTR_CASH_FCST.G_criteria2,
1535: XTR_CASH_FCST.G_criteria3,
1536: XTR_CASH_FCST.G_criteria4,
1537: XTR_CASH_FCST.G_criteria5,
1538: XTR_CASH_FCST.G_criteria6,
1539: XTR_CASH_FCST.G_criteria7,
1540: XTR_CASH_FCST.G_criteria8,
1541: XTR_CASH_FCST.G_criteria9,

Line 1538: XTR_CASH_FCST.G_criteria6,

1534: XTR_CASH_FCST.G_criteria2,
1535: XTR_CASH_FCST.G_criteria3,
1536: XTR_CASH_FCST.G_criteria4,
1537: XTR_CASH_FCST.G_criteria5,
1538: XTR_CASH_FCST.G_criteria6,
1539: XTR_CASH_FCST.G_criteria7,
1540: XTR_CASH_FCST.G_criteria8,
1541: XTR_CASH_FCST.G_criteria9,
1542: XTR_CASH_FCST.G_criteria10,

Line 1539: XTR_CASH_FCST.G_criteria7,

1535: XTR_CASH_FCST.G_criteria3,
1536: XTR_CASH_FCST.G_criteria4,
1537: XTR_CASH_FCST.G_criteria5,
1538: XTR_CASH_FCST.G_criteria6,
1539: XTR_CASH_FCST.G_criteria7,
1540: XTR_CASH_FCST.G_criteria8,
1541: XTR_CASH_FCST.G_criteria9,
1542: XTR_CASH_FCST.G_criteria10,
1543: XTR_CASH_FCST.G_criteria11,

Line 1540: XTR_CASH_FCST.G_criteria8,

1536: XTR_CASH_FCST.G_criteria4,
1537: XTR_CASH_FCST.G_criteria5,
1538: XTR_CASH_FCST.G_criteria6,
1539: XTR_CASH_FCST.G_criteria7,
1540: XTR_CASH_FCST.G_criteria8,
1541: XTR_CASH_FCST.G_criteria9,
1542: XTR_CASH_FCST.G_criteria10,
1543: XTR_CASH_FCST.G_criteria11,
1544: XTR_CASH_FCST.G_criteria12,

Line 1541: XTR_CASH_FCST.G_criteria9,

1537: XTR_CASH_FCST.G_criteria5,
1538: XTR_CASH_FCST.G_criteria6,
1539: XTR_CASH_FCST.G_criteria7,
1540: XTR_CASH_FCST.G_criteria8,
1541: XTR_CASH_FCST.G_criteria9,
1542: XTR_CASH_FCST.G_criteria10,
1543: XTR_CASH_FCST.G_criteria11,
1544: XTR_CASH_FCST.G_criteria12,
1545: XTR_CASH_FCST.G_criteria13,

Line 1542: XTR_CASH_FCST.G_criteria10,

1538: XTR_CASH_FCST.G_criteria6,
1539: XTR_CASH_FCST.G_criteria7,
1540: XTR_CASH_FCST.G_criteria8,
1541: XTR_CASH_FCST.G_criteria9,
1542: XTR_CASH_FCST.G_criteria10,
1543: XTR_CASH_FCST.G_criteria11,
1544: XTR_CASH_FCST.G_criteria12,
1545: XTR_CASH_FCST.G_criteria13,
1546: XTR_CASH_FCST.G_criteria14,

Line 1543: XTR_CASH_FCST.G_criteria11,

1539: XTR_CASH_FCST.G_criteria7,
1540: XTR_CASH_FCST.G_criteria8,
1541: XTR_CASH_FCST.G_criteria9,
1542: XTR_CASH_FCST.G_criteria10,
1543: XTR_CASH_FCST.G_criteria11,
1544: XTR_CASH_FCST.G_criteria12,
1545: XTR_CASH_FCST.G_criteria13,
1546: XTR_CASH_FCST.G_criteria14,
1547: XTR_CASH_FCST.G_criteria15);

Line 1544: XTR_CASH_FCST.G_criteria12,

1540: XTR_CASH_FCST.G_criteria8,
1541: XTR_CASH_FCST.G_criteria9,
1542: XTR_CASH_FCST.G_criteria10,
1543: XTR_CASH_FCST.G_criteria11,
1544: XTR_CASH_FCST.G_criteria12,
1545: XTR_CASH_FCST.G_criteria13,
1546: XTR_CASH_FCST.G_criteria14,
1547: XTR_CASH_FCST.G_criteria15);
1548:

Line 1545: XTR_CASH_FCST.G_criteria13,

1541: XTR_CASH_FCST.G_criteria9,
1542: XTR_CASH_FCST.G_criteria10,
1543: XTR_CASH_FCST.G_criteria11,
1544: XTR_CASH_FCST.G_criteria12,
1545: XTR_CASH_FCST.G_criteria13,
1546: XTR_CASH_FCST.G_criteria14,
1547: XTR_CASH_FCST.G_criteria15);
1548:
1549: IF( error_code = 0 )THEN

Line 1546: XTR_CASH_FCST.G_criteria14,

1542: XTR_CASH_FCST.G_criteria10,
1543: XTR_CASH_FCST.G_criteria11,
1544: XTR_CASH_FCST.G_criteria12,
1545: XTR_CASH_FCST.G_criteria13,
1546: XTR_CASH_FCST.G_criteria14,
1547: XTR_CASH_FCST.G_criteria15);
1548:
1549: IF( error_code = 0 )THEN
1550: null;

Line 1547: XTR_CASH_FCST.G_criteria15);

1543: XTR_CASH_FCST.G_criteria11,
1544: XTR_CASH_FCST.G_criteria12,
1545: XTR_CASH_FCST.G_criteria13,
1546: XTR_CASH_FCST.G_criteria14,
1547: XTR_CASH_FCST.G_criteria15);
1548:
1549: IF( error_code = 0 )THEN
1550: null;
1551: ELSIF( error_code = -1 )THEN

Line 1557: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,

1553: xtr_debug_pkg.debug(''Remote error: missing view'');
1554: END IF;
1555: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_MISSING_VIEW_EXPT'');
1556: error_msg := FND_MESSAGE.get;
1557: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1558: XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_MISSING_VIEW_EXPT'', error_msg);
1559: return;
1560: ELSIF( error_code = -2 )THEN
1561: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1558: XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_MISSING_VIEW_EXPT'', error_msg);

1554: END IF;
1555: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_MISSING_VIEW_EXPT'');
1556: error_msg := FND_MESSAGE.get;
1557: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1558: XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_MISSING_VIEW_EXPT'', error_msg);
1559: return;
1560: ELSIF( error_code = -2 )THEN
1561: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1562: xtr_debug_pkg.debug(''Remote error: invalid view'');

Line 1566: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,

1562: xtr_debug_pkg.debug(''Remote error: invalid view'');
1563: END IF;
1564: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_INVALID_VIEW_EXPT'');
1565: error_msg := FND_MESSAGE.get;
1566: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1567: XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_INVALID_VIEW_EXPT'', error_msg);
1568: return;
1569: ELSE
1570: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1567: XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_INVALID_VIEW_EXPT'', error_msg);

1563: END IF;
1564: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_INVALID_VIEW_EXPT'');
1565: error_msg := FND_MESSAGE.get;
1566: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1567: XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_INVALID_VIEW_EXPT'', error_msg);
1568: return;
1569: ELSE
1570: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1571: xtr_debug_pkg.debug(''Remote error: others'');

Line 1575: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,

1571: xtr_debug_pkg.debug(''Remote error: others'');
1572: END IF;
1573: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_EXCEPTION'');
1574: error_msg := FND_MESSAGE.get;
1575: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1576: XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_EXCEPTION'', error_msg);
1577: return;
1578: END IF;
1579: end; ';

Line 1576: XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_EXCEPTION'', error_msg);

1572: END IF;
1573: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_EXCEPTION'');
1574: error_msg := FND_MESSAGE.get;
1575: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1576: XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_EXCEPTION'', error_msg);
1577: return;
1578: END IF;
1579: end; ';
1580: BEGIN

Line 1592: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,

1588: DBMS_SQL.close_cursor(cursor_id);
1589: END IF;
1590: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
1591: error_msg := FND_MESSAGE.get;
1592: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1593: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_DB_EXCEPTION', error_msg);
1594: return;
1595: END;
1596: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1593: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_DB_EXCEPTION', error_msg);

1589: END IF;
1590: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
1591: error_msg := FND_MESSAGE.get;
1592: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1593: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_DB_EXCEPTION', error_msg);
1594: return;
1595: END;
1596: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1597: xtr_debug_pkg.debug('<

Line 1606: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,

1602: xtr_debug_pkg.debug('EXCEPTION:Build_Remote_Query');
1603: END IF;
1604: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_EXCEPTION');
1605: error_msg := FND_MESSAGE.get;
1606: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1607: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_EXCEPTION', error_msg);
1608: END Build_Remote_Query;
1609:
1610: /* ---------------------------------------------------------------------

Line 1607: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_EXCEPTION', error_msg);

1603: END IF;
1604: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_EXCEPTION');
1605: error_msg := FND_MESSAGE.get;
1606: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1607: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_EXCEPTION', error_msg);
1608: END Build_Remote_Query;
1609:
1610: /* ---------------------------------------------------------------------
1611: | PUBLIC PROCEDURE |

Line 1634: IF (XTR_CASH_FCST.G_trx_type = 'API') THEN

1630: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1631: xtr_debug_pkg.debug('>>XTR_CSH_FCST_POP.Populate_Cells');
1632: END IF;
1633:
1634: IF (XTR_CASH_FCST.G_trx_type = 'API') THEN
1635: Build_AP_Invoice_Query;
1636: ELSIF (XTR_CASH_FCST.G_trx_type = 'APP') THEN
1637: Build_AP_Pay_Query;
1638: ELSIF (XTR_CASH_FCST.G_trx_type = 'ARI') THEN

Line 1636: ELSIF (XTR_CASH_FCST.G_trx_type = 'APP') THEN

1632: END IF;
1633:
1634: IF (XTR_CASH_FCST.G_trx_type = 'API') THEN
1635: Build_AP_Invoice_Query;
1636: ELSIF (XTR_CASH_FCST.G_trx_type = 'APP') THEN
1637: Build_AP_Pay_Query;
1638: ELSIF (XTR_CASH_FCST.G_trx_type = 'ARI') THEN
1639: Build_AR_Invoice_Query;
1640: ELSIF (XTR_CASH_FCST.G_trx_type = 'ARR') THEN

Line 1638: ELSIF (XTR_CASH_FCST.G_trx_type = 'ARI') THEN

1634: IF (XTR_CASH_FCST.G_trx_type = 'API') THEN
1635: Build_AP_Invoice_Query;
1636: ELSIF (XTR_CASH_FCST.G_trx_type = 'APP') THEN
1637: Build_AP_Pay_Query;
1638: ELSIF (XTR_CASH_FCST.G_trx_type = 'ARI') THEN
1639: Build_AR_Invoice_Query;
1640: ELSIF (XTR_CASH_FCST.G_trx_type = 'ARR') THEN
1641: Build_AR_Receipt_Query;
1642: ELSIF (XTR_CASH_FCST.G_trx_type = 'PAY') THEN

Line 1640: ELSIF (XTR_CASH_FCST.G_trx_type = 'ARR') THEN

1636: ELSIF (XTR_CASH_FCST.G_trx_type = 'APP') THEN
1637: Build_AP_Pay_Query;
1638: ELSIF (XTR_CASH_FCST.G_trx_type = 'ARI') THEN
1639: Build_AR_Invoice_Query;
1640: ELSIF (XTR_CASH_FCST.G_trx_type = 'ARR') THEN
1641: Build_AR_Receipt_Query;
1642: ELSIF (XTR_CASH_FCST.G_trx_type = 'PAY') THEN
1643: Build_Pay_Exp_Query;
1644: ELSIF (XTR_CASH_FCST.G_trx_type = 'POP') THEN

Line 1642: ELSIF (XTR_CASH_FCST.G_trx_type = 'PAY') THEN

1638: ELSIF (XTR_CASH_FCST.G_trx_type = 'ARI') THEN
1639: Build_AR_Invoice_Query;
1640: ELSIF (XTR_CASH_FCST.G_trx_type = 'ARR') THEN
1641: Build_AR_Receipt_Query;
1642: ELSIF (XTR_CASH_FCST.G_trx_type = 'PAY') THEN
1643: Build_Pay_Exp_Query;
1644: ELSIF (XTR_CASH_FCST.G_trx_type = 'POP') THEN
1645: Build_PO_Orders_Query;
1646: ELSIF (XTR_CASH_FCST.G_trx_type = 'POR') THEN

Line 1644: ELSIF (XTR_CASH_FCST.G_trx_type = 'POP') THEN

1640: ELSIF (XTR_CASH_FCST.G_trx_type = 'ARR') THEN
1641: Build_AR_Receipt_Query;
1642: ELSIF (XTR_CASH_FCST.G_trx_type = 'PAY') THEN
1643: Build_Pay_Exp_Query;
1644: ELSIF (XTR_CASH_FCST.G_trx_type = 'POP') THEN
1645: Build_PO_Orders_Query;
1646: ELSIF (XTR_CASH_FCST.G_trx_type = 'POR') THEN
1647: Build_PO_Req_Query;
1648: ELSIF (XTR_CASH_FCST.G_trx_type = 'OEO') THEN

Line 1646: ELSIF (XTR_CASH_FCST.G_trx_type = 'POR') THEN

1642: ELSIF (XTR_CASH_FCST.G_trx_type = 'PAY') THEN
1643: Build_Pay_Exp_Query;
1644: ELSIF (XTR_CASH_FCST.G_trx_type = 'POP') THEN
1645: Build_PO_Orders_Query;
1646: ELSIF (XTR_CASH_FCST.G_trx_type = 'POR') THEN
1647: Build_PO_Req_Query;
1648: ELSIF (XTR_CASH_FCST.G_trx_type = 'OEO') THEN
1649: Build_Sales_Order_Query;
1650: ELSIF (XTR_CASH_FCST.G_trx_type = 'OII') THEN

Line 1648: ELSIF (XTR_CASH_FCST.G_trx_type = 'OEO') THEN

1644: ELSIF (XTR_CASH_FCST.G_trx_type = 'POP') THEN
1645: Build_PO_Orders_Query;
1646: ELSIF (XTR_CASH_FCST.G_trx_type = 'POR') THEN
1647: Build_PO_Req_Query;
1648: ELSIF (XTR_CASH_FCST.G_trx_type = 'OEO') THEN
1649: Build_Sales_Order_Query;
1650: ELSIF (XTR_CASH_FCST.G_trx_type = 'OII') THEN
1651: Build_Remote_Query;
1652: ELSIF (XTR_CASH_FCST.G_trx_type = 'OIO') THEN

Line 1650: ELSIF (XTR_CASH_FCST.G_trx_type = 'OII') THEN

1646: ELSIF (XTR_CASH_FCST.G_trx_type = 'POR') THEN
1647: Build_PO_Req_Query;
1648: ELSIF (XTR_CASH_FCST.G_trx_type = 'OEO') THEN
1649: Build_Sales_Order_Query;
1650: ELSIF (XTR_CASH_FCST.G_trx_type = 'OII') THEN
1651: Build_Remote_Query;
1652: ELSIF (XTR_CASH_FCST.G_trx_type = 'OIO') THEN
1653: Build_Remote_Query;
1654: END IF;

Line 1652: ELSIF (XTR_CASH_FCST.G_trx_type = 'OIO') THEN

1648: ELSIF (XTR_CASH_FCST.G_trx_type = 'OEO') THEN
1649: Build_Sales_Order_Query;
1650: ELSIF (XTR_CASH_FCST.G_trx_type = 'OII') THEN
1651: Build_Remote_Query;
1652: ELSIF (XTR_CASH_FCST.G_trx_type = 'OIO') THEN
1653: Build_Remote_Query;
1654: END IF;
1655:
1656: END Populate_Cells;