3:
4: --
5: -- GLOBAL VARIABLES
6: --
7: TYPE RowInfoRec is record ( forecast_row_id CE_FORECAST_ROWS.forecast_row_id%TYPE,
8: set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE,
9: chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE,
10: code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE);
11: TYPE RowInfoTab is table of RowInfoRec index by BINARY_INTEGER;
4: --
5: -- GLOBAL VARIABLES
6: --
7: TYPE RowInfoRec is record ( forecast_row_id CE_FORECAST_ROWS.forecast_row_id%TYPE,
8: set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE,
9: chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE,
10: code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE);
11: TYPE RowInfoTab is table of RowInfoRec index by BINARY_INTEGER;
12: G_glc_rowinfo RowInfoTab;
5: -- GLOBAL VARIABLES
6: --
7: TYPE RowInfoRec is record ( forecast_row_id CE_FORECAST_ROWS.forecast_row_id%TYPE,
8: set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE,
9: chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE,
10: code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE);
11: TYPE RowInfoTab is table of RowInfoRec index by BINARY_INTEGER;
12: G_glc_rowinfo RowInfoTab;
13: --
6: --
7: TYPE RowInfoRec is record ( forecast_row_id CE_FORECAST_ROWS.forecast_row_id%TYPE,
8: set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE,
9: chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE,
10: code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE);
11: TYPE RowInfoTab is table of RowInfoRec index by BINARY_INTEGER;
12: G_glc_rowinfo RowInfoTab;
13: --
14: --Run-Time Parameters
22: G_rp_src_currency FND_CURRENCIES.currency_code%TYPE;
23: G_rp_exchange_type GL_DAILY_RATES.conversion_type%TYPE;
24: G_rp_exchange_date GL_DAILY_RATES.conversion_date%TYPE;
25: G_rp_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
26: G_rp_rownum_from CE_FORECAST_ROWS.row_number%TYPE;
27: G_rp_rownum_to CE_FORECAST_ROWS.row_number%TYPE;
28: G_rp_calendar_name GL_PERIOD_SETS.period_set_name%TYPE;
29: G_rp_amount_threshold NUMBER;
30: G_rp_project_id NUMBER;
23: G_rp_exchange_type GL_DAILY_RATES.conversion_type%TYPE;
24: G_rp_exchange_date GL_DAILY_RATES.conversion_date%TYPE;
25: G_rp_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
26: G_rp_rownum_from CE_FORECAST_ROWS.row_number%TYPE;
27: G_rp_rownum_to CE_FORECAST_ROWS.row_number%TYPE;
28: G_rp_calendar_name GL_PERIOD_SETS.period_set_name%TYPE;
29: G_rp_amount_threshold NUMBER;
30: G_rp_project_id NUMBER;
31: G_rp_sub_request VARCHAR2(30);
57: G_debug_file VARCHAR2(100);
58:
59: --row info
60: G_rowid VARCHAR2(30);
61: G_forecast_row_id CE_FORECAST_ROWS.forecast_row_id%TYPE;
62: G_row_number CE_FORECAST_ROWS.row_number%TYPE;
63: G_trx_type CE_FORECAST_ROWS.trx_type%TYPE;
64: G_lead_time CE_FORECAST_ROWS.lead_time%TYPE;
65: G_forecast_method CE_FORECAST_ROWS.forecast_method%TYPE;
58:
59: --row info
60: G_rowid VARCHAR2(30);
61: G_forecast_row_id CE_FORECAST_ROWS.forecast_row_id%TYPE;
62: G_row_number CE_FORECAST_ROWS.row_number%TYPE;
63: G_trx_type CE_FORECAST_ROWS.trx_type%TYPE;
64: G_lead_time CE_FORECAST_ROWS.lead_time%TYPE;
65: G_forecast_method CE_FORECAST_ROWS.forecast_method%TYPE;
66: G_discount_option CE_FORECAST_ROWS.discount_option%TYPE;
59: --row info
60: G_rowid VARCHAR2(30);
61: G_forecast_row_id CE_FORECAST_ROWS.forecast_row_id%TYPE;
62: G_row_number CE_FORECAST_ROWS.row_number%TYPE;
63: G_trx_type CE_FORECAST_ROWS.trx_type%TYPE;
64: G_lead_time CE_FORECAST_ROWS.lead_time%TYPE;
65: G_forecast_method CE_FORECAST_ROWS.forecast_method%TYPE;
66: G_discount_option CE_FORECAST_ROWS.discount_option%TYPE;
67: G_include_float_flag CE_FORECAST_ROWS.include_float_flag%TYPE;
60: G_rowid VARCHAR2(30);
61: G_forecast_row_id CE_FORECAST_ROWS.forecast_row_id%TYPE;
62: G_row_number CE_FORECAST_ROWS.row_number%TYPE;
63: G_trx_type CE_FORECAST_ROWS.trx_type%TYPE;
64: G_lead_time CE_FORECAST_ROWS.lead_time%TYPE;
65: G_forecast_method CE_FORECAST_ROWS.forecast_method%TYPE;
66: G_discount_option CE_FORECAST_ROWS.discount_option%TYPE;
67: G_include_float_flag CE_FORECAST_ROWS.include_float_flag%TYPE;
68: G_order_status CE_FORECAST_ROWS.order_status%TYPE;
61: G_forecast_row_id CE_FORECAST_ROWS.forecast_row_id%TYPE;
62: G_row_number CE_FORECAST_ROWS.row_number%TYPE;
63: G_trx_type CE_FORECAST_ROWS.trx_type%TYPE;
64: G_lead_time CE_FORECAST_ROWS.lead_time%TYPE;
65: G_forecast_method CE_FORECAST_ROWS.forecast_method%TYPE;
66: G_discount_option CE_FORECAST_ROWS.discount_option%TYPE;
67: G_include_float_flag CE_FORECAST_ROWS.include_float_flag%TYPE;
68: G_order_status CE_FORECAST_ROWS.order_status%TYPE;
69: G_order_date_type CE_FORECAST_ROWS.order_date_type%TYPE;
62: G_row_number CE_FORECAST_ROWS.row_number%TYPE;
63: G_trx_type CE_FORECAST_ROWS.trx_type%TYPE;
64: G_lead_time CE_FORECAST_ROWS.lead_time%TYPE;
65: G_forecast_method CE_FORECAST_ROWS.forecast_method%TYPE;
66: G_discount_option CE_FORECAST_ROWS.discount_option%TYPE;
67: G_include_float_flag CE_FORECAST_ROWS.include_float_flag%TYPE;
68: G_order_status CE_FORECAST_ROWS.order_status%TYPE;
69: G_order_date_type CE_FORECAST_ROWS.order_date_type%TYPE;
70: G_code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE;
63: G_trx_type CE_FORECAST_ROWS.trx_type%TYPE;
64: G_lead_time CE_FORECAST_ROWS.lead_time%TYPE;
65: G_forecast_method CE_FORECAST_ROWS.forecast_method%TYPE;
66: G_discount_option CE_FORECAST_ROWS.discount_option%TYPE;
67: G_include_float_flag CE_FORECAST_ROWS.include_float_flag%TYPE;
68: G_order_status CE_FORECAST_ROWS.order_status%TYPE;
69: G_order_date_type CE_FORECAST_ROWS.order_date_type%TYPE;
70: G_code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE;
71: G_set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE;
64: G_lead_time CE_FORECAST_ROWS.lead_time%TYPE;
65: G_forecast_method CE_FORECAST_ROWS.forecast_method%TYPE;
66: G_discount_option CE_FORECAST_ROWS.discount_option%TYPE;
67: G_include_float_flag CE_FORECAST_ROWS.include_float_flag%TYPE;
68: G_order_status CE_FORECAST_ROWS.order_status%TYPE;
69: G_order_date_type CE_FORECAST_ROWS.order_date_type%TYPE;
70: G_code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE;
71: G_set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE;
72: G_org_id CE_FORECAST_ROWS.org_id%TYPE;
65: G_forecast_method CE_FORECAST_ROWS.forecast_method%TYPE;
66: G_discount_option CE_FORECAST_ROWS.discount_option%TYPE;
67: G_include_float_flag CE_FORECAST_ROWS.include_float_flag%TYPE;
68: G_order_status CE_FORECAST_ROWS.order_status%TYPE;
69: G_order_date_type CE_FORECAST_ROWS.order_date_type%TYPE;
70: G_code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE;
71: G_set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE;
72: G_org_id CE_FORECAST_ROWS.org_id%TYPE;
73: G_legal_entity_id CE_FORECAST_ROWS.legal_entity_id%TYPE;
66: G_discount_option CE_FORECAST_ROWS.discount_option%TYPE;
67: G_include_float_flag CE_FORECAST_ROWS.include_float_flag%TYPE;
68: G_order_status CE_FORECAST_ROWS.order_status%TYPE;
69: G_order_date_type CE_FORECAST_ROWS.order_date_type%TYPE;
70: G_code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE;
71: G_set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE;
72: G_org_id CE_FORECAST_ROWS.org_id%TYPE;
73: G_legal_entity_id CE_FORECAST_ROWS.legal_entity_id%TYPE;
74: G_chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE;
67: G_include_float_flag CE_FORECAST_ROWS.include_float_flag%TYPE;
68: G_order_status CE_FORECAST_ROWS.order_status%TYPE;
69: G_order_date_type CE_FORECAST_ROWS.order_date_type%TYPE;
70: G_code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE;
71: G_set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE;
72: G_org_id CE_FORECAST_ROWS.org_id%TYPE;
73: G_legal_entity_id CE_FORECAST_ROWS.legal_entity_id%TYPE;
74: G_chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE;
75: G_budget_name CE_FORECAST_ROWS.budget_name%TYPE;
68: G_order_status CE_FORECAST_ROWS.order_status%TYPE;
69: G_order_date_type CE_FORECAST_ROWS.order_date_type%TYPE;
70: G_code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE;
71: G_set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE;
72: G_org_id CE_FORECAST_ROWS.org_id%TYPE;
73: G_legal_entity_id CE_FORECAST_ROWS.legal_entity_id%TYPE;
74: G_chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE;
75: G_budget_name CE_FORECAST_ROWS.budget_name%TYPE;
76: G_encumbrance_type_id CE_FORECAST_ROWS.encumbrance_type_id%TYPE;
69: G_order_date_type CE_FORECAST_ROWS.order_date_type%TYPE;
70: G_code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE;
71: G_set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE;
72: G_org_id CE_FORECAST_ROWS.org_id%TYPE;
73: G_legal_entity_id CE_FORECAST_ROWS.legal_entity_id%TYPE;
74: G_chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE;
75: G_budget_name CE_FORECAST_ROWS.budget_name%TYPE;
76: G_encumbrance_type_id CE_FORECAST_ROWS.encumbrance_type_id%TYPE;
77: G_roll_forward_type CE_FORECAST_ROWS.roll_forward_type%TYPE;
70: G_code_combination_id CE_FORECAST_ROWS.code_combination_id%TYPE;
71: G_set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE;
72: G_org_id CE_FORECAST_ROWS.org_id%TYPE;
73: G_legal_entity_id CE_FORECAST_ROWS.legal_entity_id%TYPE;
74: G_chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE;
75: G_budget_name CE_FORECAST_ROWS.budget_name%TYPE;
76: G_encumbrance_type_id CE_FORECAST_ROWS.encumbrance_type_id%TYPE;
77: G_roll_forward_type CE_FORECAST_ROWS.roll_forward_type%TYPE;
78: G_roll_forward_period CE_FORECAST_ROWS.roll_forward_period%TYPE;
71: G_set_of_books_id CE_FORECAST_ROWS.set_of_books_id%TYPE;
72: G_org_id CE_FORECAST_ROWS.org_id%TYPE;
73: G_legal_entity_id CE_FORECAST_ROWS.legal_entity_id%TYPE;
74: G_chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE;
75: G_budget_name CE_FORECAST_ROWS.budget_name%TYPE;
76: G_encumbrance_type_id CE_FORECAST_ROWS.encumbrance_type_id%TYPE;
77: G_roll_forward_type CE_FORECAST_ROWS.roll_forward_type%TYPE;
78: G_roll_forward_period CE_FORECAST_ROWS.roll_forward_period%TYPE;
79: G_include_dispute_flag CE_FORECAST_ROWS.include_dispute_flag%TYPE;
72: G_org_id CE_FORECAST_ROWS.org_id%TYPE;
73: G_legal_entity_id CE_FORECAST_ROWS.legal_entity_id%TYPE;
74: G_chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE;
75: G_budget_name CE_FORECAST_ROWS.budget_name%TYPE;
76: G_encumbrance_type_id CE_FORECAST_ROWS.encumbrance_type_id%TYPE;
77: G_roll_forward_type CE_FORECAST_ROWS.roll_forward_type%TYPE;
78: G_roll_forward_period CE_FORECAST_ROWS.roll_forward_period%TYPE;
79: G_include_dispute_flag CE_FORECAST_ROWS.include_dispute_flag%TYPE;
80: G_sales_stage_id CE_FORECAST_ROWS.sales_stage_id%TYPE;
73: G_legal_entity_id CE_FORECAST_ROWS.legal_entity_id%TYPE;
74: G_chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE;
75: G_budget_name CE_FORECAST_ROWS.budget_name%TYPE;
76: G_encumbrance_type_id CE_FORECAST_ROWS.encumbrance_type_id%TYPE;
77: G_roll_forward_type CE_FORECAST_ROWS.roll_forward_type%TYPE;
78: G_roll_forward_period CE_FORECAST_ROWS.roll_forward_period%TYPE;
79: G_include_dispute_flag CE_FORECAST_ROWS.include_dispute_flag%TYPE;
80: G_sales_stage_id CE_FORECAST_ROWS.sales_stage_id%TYPE;
81: G_channel_code CE_FORECAST_ROWS.channel_code%TYPE;
74: G_chart_of_accounts_id CE_FORECAST_ROWS.chart_of_accounts_id%TYPE;
75: G_budget_name CE_FORECAST_ROWS.budget_name%TYPE;
76: G_encumbrance_type_id CE_FORECAST_ROWS.encumbrance_type_id%TYPE;
77: G_roll_forward_type CE_FORECAST_ROWS.roll_forward_type%TYPE;
78: G_roll_forward_period CE_FORECAST_ROWS.roll_forward_period%TYPE;
79: G_include_dispute_flag CE_FORECAST_ROWS.include_dispute_flag%TYPE;
80: G_sales_stage_id CE_FORECAST_ROWS.sales_stage_id%TYPE;
81: G_channel_code CE_FORECAST_ROWS.channel_code%TYPE;
82: G_win_probability CE_FORECAST_ROWS.win_probability%TYPE;
75: G_budget_name CE_FORECAST_ROWS.budget_name%TYPE;
76: G_encumbrance_type_id CE_FORECAST_ROWS.encumbrance_type_id%TYPE;
77: G_roll_forward_type CE_FORECAST_ROWS.roll_forward_type%TYPE;
78: G_roll_forward_period CE_FORECAST_ROWS.roll_forward_period%TYPE;
79: G_include_dispute_flag CE_FORECAST_ROWS.include_dispute_flag%TYPE;
80: G_sales_stage_id CE_FORECAST_ROWS.sales_stage_id%TYPE;
81: G_channel_code CE_FORECAST_ROWS.channel_code%TYPE;
82: G_win_probability CE_FORECAST_ROWS.win_probability%TYPE;
83: G_sales_forecast_status CE_FORECAST_ROWS.sales_forecast_status%TYPE;
76: G_encumbrance_type_id CE_FORECAST_ROWS.encumbrance_type_id%TYPE;
77: G_roll_forward_type CE_FORECAST_ROWS.roll_forward_type%TYPE;
78: G_roll_forward_period CE_FORECAST_ROWS.roll_forward_period%TYPE;
79: G_include_dispute_flag CE_FORECAST_ROWS.include_dispute_flag%TYPE;
80: G_sales_stage_id CE_FORECAST_ROWS.sales_stage_id%TYPE;
81: G_channel_code CE_FORECAST_ROWS.channel_code%TYPE;
82: G_win_probability CE_FORECAST_ROWS.win_probability%TYPE;
83: G_sales_forecast_status CE_FORECAST_ROWS.sales_forecast_status%TYPE;
84: G_functional_currency FND_CURRENCIES.currency_code%TYPE;
77: G_roll_forward_type CE_FORECAST_ROWS.roll_forward_type%TYPE;
78: G_roll_forward_period CE_FORECAST_ROWS.roll_forward_period%TYPE;
79: G_include_dispute_flag CE_FORECAST_ROWS.include_dispute_flag%TYPE;
80: G_sales_stage_id CE_FORECAST_ROWS.sales_stage_id%TYPE;
81: G_channel_code CE_FORECAST_ROWS.channel_code%TYPE;
82: G_win_probability CE_FORECAST_ROWS.win_probability%TYPE;
83: G_sales_forecast_status CE_FORECAST_ROWS.sales_forecast_status%TYPE;
84: G_functional_currency FND_CURRENCIES.currency_code%TYPE;
85: G_customer_profile_class_id CE_FORECAST_ROWS.customer_profile_class_id%TYPE;
78: G_roll_forward_period CE_FORECAST_ROWS.roll_forward_period%TYPE;
79: G_include_dispute_flag CE_FORECAST_ROWS.include_dispute_flag%TYPE;
80: G_sales_stage_id CE_FORECAST_ROWS.sales_stage_id%TYPE;
81: G_channel_code CE_FORECAST_ROWS.channel_code%TYPE;
82: G_win_probability CE_FORECAST_ROWS.win_probability%TYPE;
83: G_sales_forecast_status CE_FORECAST_ROWS.sales_forecast_status%TYPE;
84: G_functional_currency FND_CURRENCIES.currency_code%TYPE;
85: G_customer_profile_class_id CE_FORECAST_ROWS.customer_profile_class_id%TYPE;
86: G_bank_account_id CE_FORECAST_ROWS.bank_account_id%TYPE;
79: G_include_dispute_flag CE_FORECAST_ROWS.include_dispute_flag%TYPE;
80: G_sales_stage_id CE_FORECAST_ROWS.sales_stage_id%TYPE;
81: G_channel_code CE_FORECAST_ROWS.channel_code%TYPE;
82: G_win_probability CE_FORECAST_ROWS.win_probability%TYPE;
83: G_sales_forecast_status CE_FORECAST_ROWS.sales_forecast_status%TYPE;
84: G_functional_currency FND_CURRENCIES.currency_code%TYPE;
85: G_customer_profile_class_id CE_FORECAST_ROWS.customer_profile_class_id%TYPE;
86: G_bank_account_id CE_FORECAST_ROWS.bank_account_id%TYPE;
87: G_receipt_method_id CE_FORECAST_ROWS.receipt_method_id%TYPE;
81: G_channel_code CE_FORECAST_ROWS.channel_code%TYPE;
82: G_win_probability CE_FORECAST_ROWS.win_probability%TYPE;
83: G_sales_forecast_status CE_FORECAST_ROWS.sales_forecast_status%TYPE;
84: G_functional_currency FND_CURRENCIES.currency_code%TYPE;
85: G_customer_profile_class_id CE_FORECAST_ROWS.customer_profile_class_id%TYPE;
86: G_bank_account_id CE_FORECAST_ROWS.bank_account_id%TYPE;
87: G_receipt_method_id CE_FORECAST_ROWS.receipt_method_id%TYPE;
88: G_payment_method CE_FORECAST_ROWS.payment_method%TYPE;
89: G_pay_group CE_FORECAST_ROWS.pay_group%TYPE;
82: G_win_probability CE_FORECAST_ROWS.win_probability%TYPE;
83: G_sales_forecast_status CE_FORECAST_ROWS.sales_forecast_status%TYPE;
84: G_functional_currency FND_CURRENCIES.currency_code%TYPE;
85: G_customer_profile_class_id CE_FORECAST_ROWS.customer_profile_class_id%TYPE;
86: G_bank_account_id CE_FORECAST_ROWS.bank_account_id%TYPE;
87: G_receipt_method_id CE_FORECAST_ROWS.receipt_method_id%TYPE;
88: G_payment_method CE_FORECAST_ROWS.payment_method%TYPE;
89: G_pay_group CE_FORECAST_ROWS.pay_group%TYPE;
90: G_payment_priority CE_FORECAST_ROWS.payment_priority%TYPE;
83: G_sales_forecast_status CE_FORECAST_ROWS.sales_forecast_status%TYPE;
84: G_functional_currency FND_CURRENCIES.currency_code%TYPE;
85: G_customer_profile_class_id CE_FORECAST_ROWS.customer_profile_class_id%TYPE;
86: G_bank_account_id CE_FORECAST_ROWS.bank_account_id%TYPE;
87: G_receipt_method_id CE_FORECAST_ROWS.receipt_method_id%TYPE;
88: G_payment_method CE_FORECAST_ROWS.payment_method%TYPE;
89: G_pay_group CE_FORECAST_ROWS.pay_group%TYPE;
90: G_payment_priority CE_FORECAST_ROWS.payment_priority%TYPE;
91: G_vendor_type CE_FORECAST_ROWS.vendor_type%TYPE;
84: G_functional_currency FND_CURRENCIES.currency_code%TYPE;
85: G_customer_profile_class_id CE_FORECAST_ROWS.customer_profile_class_id%TYPE;
86: G_bank_account_id CE_FORECAST_ROWS.bank_account_id%TYPE;
87: G_receipt_method_id CE_FORECAST_ROWS.receipt_method_id%TYPE;
88: G_payment_method CE_FORECAST_ROWS.payment_method%TYPE;
89: G_pay_group CE_FORECAST_ROWS.pay_group%TYPE;
90: G_payment_priority CE_FORECAST_ROWS.payment_priority%TYPE;
91: G_vendor_type CE_FORECAST_ROWS.vendor_type%TYPE;
92: G_app_short_name CE_FORECAST_ROWS.trx_type%TYPE;
85: G_customer_profile_class_id CE_FORECAST_ROWS.customer_profile_class_id%TYPE;
86: G_bank_account_id CE_FORECAST_ROWS.bank_account_id%TYPE;
87: G_receipt_method_id CE_FORECAST_ROWS.receipt_method_id%TYPE;
88: G_payment_method CE_FORECAST_ROWS.payment_method%TYPE;
89: G_pay_group CE_FORECAST_ROWS.pay_group%TYPE;
90: G_payment_priority CE_FORECAST_ROWS.payment_priority%TYPE;
91: G_vendor_type CE_FORECAST_ROWS.vendor_type%TYPE;
92: G_app_short_name CE_FORECAST_ROWS.trx_type%TYPE;
93: G_authorization_status CE_FORECAST_ROWS.authorization_status%TYPE;
86: G_bank_account_id CE_FORECAST_ROWS.bank_account_id%TYPE;
87: G_receipt_method_id CE_FORECAST_ROWS.receipt_method_id%TYPE;
88: G_payment_method CE_FORECAST_ROWS.payment_method%TYPE;
89: G_pay_group CE_FORECAST_ROWS.pay_group%TYPE;
90: G_payment_priority CE_FORECAST_ROWS.payment_priority%TYPE;
91: G_vendor_type CE_FORECAST_ROWS.vendor_type%TYPE;
92: G_app_short_name CE_FORECAST_ROWS.trx_type%TYPE;
93: G_authorization_status CE_FORECAST_ROWS.authorization_status%TYPE;
94: G_type CE_FORECAST_ROWS.type%TYPE;
87: G_receipt_method_id CE_FORECAST_ROWS.receipt_method_id%TYPE;
88: G_payment_method CE_FORECAST_ROWS.payment_method%TYPE;
89: G_pay_group CE_FORECAST_ROWS.pay_group%TYPE;
90: G_payment_priority CE_FORECAST_ROWS.payment_priority%TYPE;
91: G_vendor_type CE_FORECAST_ROWS.vendor_type%TYPE;
92: G_app_short_name CE_FORECAST_ROWS.trx_type%TYPE;
93: G_authorization_status CE_FORECAST_ROWS.authorization_status%TYPE;
94: G_type CE_FORECAST_ROWS.type%TYPE;
95: G_budget_type CE_FORECAST_ROWS.budget_type%TYPE;
88: G_payment_method CE_FORECAST_ROWS.payment_method%TYPE;
89: G_pay_group CE_FORECAST_ROWS.pay_group%TYPE;
90: G_payment_priority CE_FORECAST_ROWS.payment_priority%TYPE;
91: G_vendor_type CE_FORECAST_ROWS.vendor_type%TYPE;
92: G_app_short_name CE_FORECAST_ROWS.trx_type%TYPE;
93: G_authorization_status CE_FORECAST_ROWS.authorization_status%TYPE;
94: G_type CE_FORECAST_ROWS.type%TYPE;
95: G_budget_type CE_FORECAST_ROWS.budget_type%TYPE;
96: G_budget_version CE_FORECAST_ROWS.budget_version%TYPE;
89: G_pay_group CE_FORECAST_ROWS.pay_group%TYPE;
90: G_payment_priority CE_FORECAST_ROWS.payment_priority%TYPE;
91: G_vendor_type CE_FORECAST_ROWS.vendor_type%TYPE;
92: G_app_short_name CE_FORECAST_ROWS.trx_type%TYPE;
93: G_authorization_status CE_FORECAST_ROWS.authorization_status%TYPE;
94: G_type CE_FORECAST_ROWS.type%TYPE;
95: G_budget_type CE_FORECAST_ROWS.budget_type%TYPE;
96: G_budget_version CE_FORECAST_ROWS.budget_version%TYPE;
97: G_include_hold_flag CE_FORECAST_ROWS.include_hold_flag%TYPE;
90: G_payment_priority CE_FORECAST_ROWS.payment_priority%TYPE;
91: G_vendor_type CE_FORECAST_ROWS.vendor_type%TYPE;
92: G_app_short_name CE_FORECAST_ROWS.trx_type%TYPE;
93: G_authorization_status CE_FORECAST_ROWS.authorization_status%TYPE;
94: G_type CE_FORECAST_ROWS.type%TYPE;
95: G_budget_type CE_FORECAST_ROWS.budget_type%TYPE;
96: G_budget_version CE_FORECAST_ROWS.budget_version%TYPE;
97: G_include_hold_flag CE_FORECAST_ROWS.include_hold_flag%TYPE;
98: G_include_net_cash_flag CE_FORECAST_ROWS.include_net_cash_flag%TYPE;
91: G_vendor_type CE_FORECAST_ROWS.vendor_type%TYPE;
92: G_app_short_name CE_FORECAST_ROWS.trx_type%TYPE;
93: G_authorization_status CE_FORECAST_ROWS.authorization_status%TYPE;
94: G_type CE_FORECAST_ROWS.type%TYPE;
95: G_budget_type CE_FORECAST_ROWS.budget_type%TYPE;
96: G_budget_version CE_FORECAST_ROWS.budget_version%TYPE;
97: G_include_hold_flag CE_FORECAST_ROWS.include_hold_flag%TYPE;
98: G_include_net_cash_flag CE_FORECAST_ROWS.include_net_cash_flag%TYPE;
99: G_budget_version_id CE_FORECAST_ROWS.budget_version_id%TYPE;
92: G_app_short_name CE_FORECAST_ROWS.trx_type%TYPE;
93: G_authorization_status CE_FORECAST_ROWS.authorization_status%TYPE;
94: G_type CE_FORECAST_ROWS.type%TYPE;
95: G_budget_type CE_FORECAST_ROWS.budget_type%TYPE;
96: G_budget_version CE_FORECAST_ROWS.budget_version%TYPE;
97: G_include_hold_flag CE_FORECAST_ROWS.include_hold_flag%TYPE;
98: G_include_net_cash_flag CE_FORECAST_ROWS.include_net_cash_flag%TYPE;
99: G_budget_version_id CE_FORECAST_ROWS.budget_version_id%TYPE;
100: G_payroll_id CE_FORECAST_ROWS.payroll_id%TYPE;
93: G_authorization_status CE_FORECAST_ROWS.authorization_status%TYPE;
94: G_type CE_FORECAST_ROWS.type%TYPE;
95: G_budget_type CE_FORECAST_ROWS.budget_type%TYPE;
96: G_budget_version CE_FORECAST_ROWS.budget_version%TYPE;
97: G_include_hold_flag CE_FORECAST_ROWS.include_hold_flag%TYPE;
98: G_include_net_cash_flag CE_FORECAST_ROWS.include_net_cash_flag%TYPE;
99: G_budget_version_id CE_FORECAST_ROWS.budget_version_id%TYPE;
100: G_payroll_id CE_FORECAST_ROWS.payroll_id%TYPE;
101: G_company_code CE_FORECAST_ROWS.company_code%TYPE;
94: G_type CE_FORECAST_ROWS.type%TYPE;
95: G_budget_type CE_FORECAST_ROWS.budget_type%TYPE;
96: G_budget_version CE_FORECAST_ROWS.budget_version%TYPE;
97: G_include_hold_flag CE_FORECAST_ROWS.include_hold_flag%TYPE;
98: G_include_net_cash_flag CE_FORECAST_ROWS.include_net_cash_flag%TYPE;
99: G_budget_version_id CE_FORECAST_ROWS.budget_version_id%TYPE;
100: G_payroll_id CE_FORECAST_ROWS.payroll_id%TYPE;
101: G_company_code CE_FORECAST_ROWS.company_code%TYPE;
102: G_exclude_indic_exp CE_FORECAST_ROWS.exclude_indic_exp%TYPE;
95: G_budget_type CE_FORECAST_ROWS.budget_type%TYPE;
96: G_budget_version CE_FORECAST_ROWS.budget_version%TYPE;
97: G_include_hold_flag CE_FORECAST_ROWS.include_hold_flag%TYPE;
98: G_include_net_cash_flag CE_FORECAST_ROWS.include_net_cash_flag%TYPE;
99: G_budget_version_id CE_FORECAST_ROWS.budget_version_id%TYPE;
100: G_payroll_id CE_FORECAST_ROWS.payroll_id%TYPE;
101: G_company_code CE_FORECAST_ROWS.company_code%TYPE;
102: G_exclude_indic_exp CE_FORECAST_ROWS.exclude_indic_exp%TYPE;
103: G_xtr_bank_account CE_FORECAST_ROWS.xtr_bank_account%TYPE;
96: G_budget_version CE_FORECAST_ROWS.budget_version%TYPE;
97: G_include_hold_flag CE_FORECAST_ROWS.include_hold_flag%TYPE;
98: G_include_net_cash_flag CE_FORECAST_ROWS.include_net_cash_flag%TYPE;
99: G_budget_version_id CE_FORECAST_ROWS.budget_version_id%TYPE;
100: G_payroll_id CE_FORECAST_ROWS.payroll_id%TYPE;
101: G_company_code CE_FORECAST_ROWS.company_code%TYPE;
102: G_exclude_indic_exp CE_FORECAST_ROWS.exclude_indic_exp%TYPE;
103: G_xtr_bank_account CE_FORECAST_ROWS.xtr_bank_account%TYPE;
104: G_org_payment_method_id CE_FORECAST_ROWS.org_payment_method_id%TYPE;
97: G_include_hold_flag CE_FORECAST_ROWS.include_hold_flag%TYPE;
98: G_include_net_cash_flag CE_FORECAST_ROWS.include_net_cash_flag%TYPE;
99: G_budget_version_id CE_FORECAST_ROWS.budget_version_id%TYPE;
100: G_payroll_id CE_FORECAST_ROWS.payroll_id%TYPE;
101: G_company_code CE_FORECAST_ROWS.company_code%TYPE;
102: G_exclude_indic_exp CE_FORECAST_ROWS.exclude_indic_exp%TYPE;
103: G_xtr_bank_account CE_FORECAST_ROWS.xtr_bank_account%TYPE;
104: G_org_payment_method_id CE_FORECAST_ROWS.org_payment_method_id%TYPE;
105: G_external_source_type CE_FORECAST_ROWS.external_source_type%TYPE;
98: G_include_net_cash_flag CE_FORECAST_ROWS.include_net_cash_flag%TYPE;
99: G_budget_version_id CE_FORECAST_ROWS.budget_version_id%TYPE;
100: G_payroll_id CE_FORECAST_ROWS.payroll_id%TYPE;
101: G_company_code CE_FORECAST_ROWS.company_code%TYPE;
102: G_exclude_indic_exp CE_FORECAST_ROWS.exclude_indic_exp%TYPE;
103: G_xtr_bank_account CE_FORECAST_ROWS.xtr_bank_account%TYPE;
104: G_org_payment_method_id CE_FORECAST_ROWS.org_payment_method_id%TYPE;
105: G_external_source_type CE_FORECAST_ROWS.external_source_type%TYPE;
106: G_criteria_category CE_FORECAST_ROWS.criteria_category%TYPE;
99: G_budget_version_id CE_FORECAST_ROWS.budget_version_id%TYPE;
100: G_payroll_id CE_FORECAST_ROWS.payroll_id%TYPE;
101: G_company_code CE_FORECAST_ROWS.company_code%TYPE;
102: G_exclude_indic_exp CE_FORECAST_ROWS.exclude_indic_exp%TYPE;
103: G_xtr_bank_account CE_FORECAST_ROWS.xtr_bank_account%TYPE;
104: G_org_payment_method_id CE_FORECAST_ROWS.org_payment_method_id%TYPE;
105: G_external_source_type CE_FORECAST_ROWS.external_source_type%TYPE;
106: G_criteria_category CE_FORECAST_ROWS.criteria_category%TYPE;
107: G_criteria1 CE_FORECAST_ROWS.criteria1%TYPE;
100: G_payroll_id CE_FORECAST_ROWS.payroll_id%TYPE;
101: G_company_code CE_FORECAST_ROWS.company_code%TYPE;
102: G_exclude_indic_exp CE_FORECAST_ROWS.exclude_indic_exp%TYPE;
103: G_xtr_bank_account CE_FORECAST_ROWS.xtr_bank_account%TYPE;
104: G_org_payment_method_id CE_FORECAST_ROWS.org_payment_method_id%TYPE;
105: G_external_source_type CE_FORECAST_ROWS.external_source_type%TYPE;
106: G_criteria_category CE_FORECAST_ROWS.criteria_category%TYPE;
107: G_criteria1 CE_FORECAST_ROWS.criteria1%TYPE;
108: G_criteria2 CE_FORECAST_ROWS.criteria2%TYPE;
101: G_company_code CE_FORECAST_ROWS.company_code%TYPE;
102: G_exclude_indic_exp CE_FORECAST_ROWS.exclude_indic_exp%TYPE;
103: G_xtr_bank_account CE_FORECAST_ROWS.xtr_bank_account%TYPE;
104: G_org_payment_method_id CE_FORECAST_ROWS.org_payment_method_id%TYPE;
105: G_external_source_type CE_FORECAST_ROWS.external_source_type%TYPE;
106: G_criteria_category CE_FORECAST_ROWS.criteria_category%TYPE;
107: G_criteria1 CE_FORECAST_ROWS.criteria1%TYPE;
108: G_criteria2 CE_FORECAST_ROWS.criteria2%TYPE;
109: G_criteria3 CE_FORECAST_ROWS.criteria3%TYPE;
102: G_exclude_indic_exp CE_FORECAST_ROWS.exclude_indic_exp%TYPE;
103: G_xtr_bank_account CE_FORECAST_ROWS.xtr_bank_account%TYPE;
104: G_org_payment_method_id CE_FORECAST_ROWS.org_payment_method_id%TYPE;
105: G_external_source_type CE_FORECAST_ROWS.external_source_type%TYPE;
106: G_criteria_category CE_FORECAST_ROWS.criteria_category%TYPE;
107: G_criteria1 CE_FORECAST_ROWS.criteria1%TYPE;
108: G_criteria2 CE_FORECAST_ROWS.criteria2%TYPE;
109: G_criteria3 CE_FORECAST_ROWS.criteria3%TYPE;
110: G_criteria4 CE_FORECAST_ROWS.criteria4%TYPE;
103: G_xtr_bank_account CE_FORECAST_ROWS.xtr_bank_account%TYPE;
104: G_org_payment_method_id CE_FORECAST_ROWS.org_payment_method_id%TYPE;
105: G_external_source_type CE_FORECAST_ROWS.external_source_type%TYPE;
106: G_criteria_category CE_FORECAST_ROWS.criteria_category%TYPE;
107: G_criteria1 CE_FORECAST_ROWS.criteria1%TYPE;
108: G_criteria2 CE_FORECAST_ROWS.criteria2%TYPE;
109: G_criteria3 CE_FORECAST_ROWS.criteria3%TYPE;
110: G_criteria4 CE_FORECAST_ROWS.criteria4%TYPE;
111: G_criteria5 CE_FORECAST_ROWS.criteria5%TYPE;
104: G_org_payment_method_id CE_FORECAST_ROWS.org_payment_method_id%TYPE;
105: G_external_source_type CE_FORECAST_ROWS.external_source_type%TYPE;
106: G_criteria_category CE_FORECAST_ROWS.criteria_category%TYPE;
107: G_criteria1 CE_FORECAST_ROWS.criteria1%TYPE;
108: G_criteria2 CE_FORECAST_ROWS.criteria2%TYPE;
109: G_criteria3 CE_FORECAST_ROWS.criteria3%TYPE;
110: G_criteria4 CE_FORECAST_ROWS.criteria4%TYPE;
111: G_criteria5 CE_FORECAST_ROWS.criteria5%TYPE;
112: G_criteria6 CE_FORECAST_ROWS.criteria6%TYPE;
105: G_external_source_type CE_FORECAST_ROWS.external_source_type%TYPE;
106: G_criteria_category CE_FORECAST_ROWS.criteria_category%TYPE;
107: G_criteria1 CE_FORECAST_ROWS.criteria1%TYPE;
108: G_criteria2 CE_FORECAST_ROWS.criteria2%TYPE;
109: G_criteria3 CE_FORECAST_ROWS.criteria3%TYPE;
110: G_criteria4 CE_FORECAST_ROWS.criteria4%TYPE;
111: G_criteria5 CE_FORECAST_ROWS.criteria5%TYPE;
112: G_criteria6 CE_FORECAST_ROWS.criteria6%TYPE;
113: G_criteria7 CE_FORECAST_ROWS.criteria7%TYPE;
106: G_criteria_category CE_FORECAST_ROWS.criteria_category%TYPE;
107: G_criteria1 CE_FORECAST_ROWS.criteria1%TYPE;
108: G_criteria2 CE_FORECAST_ROWS.criteria2%TYPE;
109: G_criteria3 CE_FORECAST_ROWS.criteria3%TYPE;
110: G_criteria4 CE_FORECAST_ROWS.criteria4%TYPE;
111: G_criteria5 CE_FORECAST_ROWS.criteria5%TYPE;
112: G_criteria6 CE_FORECAST_ROWS.criteria6%TYPE;
113: G_criteria7 CE_FORECAST_ROWS.criteria7%TYPE;
114: G_criteria8 CE_FORECAST_ROWS.criteria8%TYPE;
107: G_criteria1 CE_FORECAST_ROWS.criteria1%TYPE;
108: G_criteria2 CE_FORECAST_ROWS.criteria2%TYPE;
109: G_criteria3 CE_FORECAST_ROWS.criteria3%TYPE;
110: G_criteria4 CE_FORECAST_ROWS.criteria4%TYPE;
111: G_criteria5 CE_FORECAST_ROWS.criteria5%TYPE;
112: G_criteria6 CE_FORECAST_ROWS.criteria6%TYPE;
113: G_criteria7 CE_FORECAST_ROWS.criteria7%TYPE;
114: G_criteria8 CE_FORECAST_ROWS.criteria8%TYPE;
115: G_criteria9 CE_FORECAST_ROWS.criteria9%TYPE;
108: G_criteria2 CE_FORECAST_ROWS.criteria2%TYPE;
109: G_criteria3 CE_FORECAST_ROWS.criteria3%TYPE;
110: G_criteria4 CE_FORECAST_ROWS.criteria4%TYPE;
111: G_criteria5 CE_FORECAST_ROWS.criteria5%TYPE;
112: G_criteria6 CE_FORECAST_ROWS.criteria6%TYPE;
113: G_criteria7 CE_FORECAST_ROWS.criteria7%TYPE;
114: G_criteria8 CE_FORECAST_ROWS.criteria8%TYPE;
115: G_criteria9 CE_FORECAST_ROWS.criteria9%TYPE;
116: G_criteria10 CE_FORECAST_ROWS.criteria10%TYPE;
109: G_criteria3 CE_FORECAST_ROWS.criteria3%TYPE;
110: G_criteria4 CE_FORECAST_ROWS.criteria4%TYPE;
111: G_criteria5 CE_FORECAST_ROWS.criteria5%TYPE;
112: G_criteria6 CE_FORECAST_ROWS.criteria6%TYPE;
113: G_criteria7 CE_FORECAST_ROWS.criteria7%TYPE;
114: G_criteria8 CE_FORECAST_ROWS.criteria8%TYPE;
115: G_criteria9 CE_FORECAST_ROWS.criteria9%TYPE;
116: G_criteria10 CE_FORECAST_ROWS.criteria10%TYPE;
117: G_criteria11 CE_FORECAST_ROWS.criteria11%TYPE;
110: G_criteria4 CE_FORECAST_ROWS.criteria4%TYPE;
111: G_criteria5 CE_FORECAST_ROWS.criteria5%TYPE;
112: G_criteria6 CE_FORECAST_ROWS.criteria6%TYPE;
113: G_criteria7 CE_FORECAST_ROWS.criteria7%TYPE;
114: G_criteria8 CE_FORECAST_ROWS.criteria8%TYPE;
115: G_criteria9 CE_FORECAST_ROWS.criteria9%TYPE;
116: G_criteria10 CE_FORECAST_ROWS.criteria10%TYPE;
117: G_criteria11 CE_FORECAST_ROWS.criteria11%TYPE;
118: G_criteria12 CE_FORECAST_ROWS.criteria12%TYPE;
111: G_criteria5 CE_FORECAST_ROWS.criteria5%TYPE;
112: G_criteria6 CE_FORECAST_ROWS.criteria6%TYPE;
113: G_criteria7 CE_FORECAST_ROWS.criteria7%TYPE;
114: G_criteria8 CE_FORECAST_ROWS.criteria8%TYPE;
115: G_criteria9 CE_FORECAST_ROWS.criteria9%TYPE;
116: G_criteria10 CE_FORECAST_ROWS.criteria10%TYPE;
117: G_criteria11 CE_FORECAST_ROWS.criteria11%TYPE;
118: G_criteria12 CE_FORECAST_ROWS.criteria12%TYPE;
119: G_criteria13 CE_FORECAST_ROWS.criteria13%TYPE;
112: G_criteria6 CE_FORECAST_ROWS.criteria6%TYPE;
113: G_criteria7 CE_FORECAST_ROWS.criteria7%TYPE;
114: G_criteria8 CE_FORECAST_ROWS.criteria8%TYPE;
115: G_criteria9 CE_FORECAST_ROWS.criteria9%TYPE;
116: G_criteria10 CE_FORECAST_ROWS.criteria10%TYPE;
117: G_criteria11 CE_FORECAST_ROWS.criteria11%TYPE;
118: G_criteria12 CE_FORECAST_ROWS.criteria12%TYPE;
119: G_criteria13 CE_FORECAST_ROWS.criteria13%TYPE;
120: G_criteria14 CE_FORECAST_ROWS.criteria14%TYPE;
113: G_criteria7 CE_FORECAST_ROWS.criteria7%TYPE;
114: G_criteria8 CE_FORECAST_ROWS.criteria8%TYPE;
115: G_criteria9 CE_FORECAST_ROWS.criteria9%TYPE;
116: G_criteria10 CE_FORECAST_ROWS.criteria10%TYPE;
117: G_criteria11 CE_FORECAST_ROWS.criteria11%TYPE;
118: G_criteria12 CE_FORECAST_ROWS.criteria12%TYPE;
119: G_criteria13 CE_FORECAST_ROWS.criteria13%TYPE;
120: G_criteria14 CE_FORECAST_ROWS.criteria14%TYPE;
121: G_criteria15 CE_FORECAST_ROWS.criteria15%TYPE;
114: G_criteria8 CE_FORECAST_ROWS.criteria8%TYPE;
115: G_criteria9 CE_FORECAST_ROWS.criteria9%TYPE;
116: G_criteria10 CE_FORECAST_ROWS.criteria10%TYPE;
117: G_criteria11 CE_FORECAST_ROWS.criteria11%TYPE;
118: G_criteria12 CE_FORECAST_ROWS.criteria12%TYPE;
119: G_criteria13 CE_FORECAST_ROWS.criteria13%TYPE;
120: G_criteria14 CE_FORECAST_ROWS.criteria14%TYPE;
121: G_criteria15 CE_FORECAST_ROWS.criteria15%TYPE;
122: G_use_average_payment_days CE_FORECAST_ROWS.use_average_payment_days%TYPE;
115: G_criteria9 CE_FORECAST_ROWS.criteria9%TYPE;
116: G_criteria10 CE_FORECAST_ROWS.criteria10%TYPE;
117: G_criteria11 CE_FORECAST_ROWS.criteria11%TYPE;
118: G_criteria12 CE_FORECAST_ROWS.criteria12%TYPE;
119: G_criteria13 CE_FORECAST_ROWS.criteria13%TYPE;
120: G_criteria14 CE_FORECAST_ROWS.criteria14%TYPE;
121: G_criteria15 CE_FORECAST_ROWS.criteria15%TYPE;
122: G_use_average_payment_days CE_FORECAST_ROWS.use_average_payment_days%TYPE;
123: G_apd_period CE_FORECAST_ROWS.period%TYPE;
116: G_criteria10 CE_FORECAST_ROWS.criteria10%TYPE;
117: G_criteria11 CE_FORECAST_ROWS.criteria11%TYPE;
118: G_criteria12 CE_FORECAST_ROWS.criteria12%TYPE;
119: G_criteria13 CE_FORECAST_ROWS.criteria13%TYPE;
120: G_criteria14 CE_FORECAST_ROWS.criteria14%TYPE;
121: G_criteria15 CE_FORECAST_ROWS.criteria15%TYPE;
122: G_use_average_payment_days CE_FORECAST_ROWS.use_average_payment_days%TYPE;
123: G_apd_period CE_FORECAST_ROWS.period%TYPE;
124: G_order_type_id CE_FORECAST_ROWS.order_type_id%TYPE;
117: G_criteria11 CE_FORECAST_ROWS.criteria11%TYPE;
118: G_criteria12 CE_FORECAST_ROWS.criteria12%TYPE;
119: G_criteria13 CE_FORECAST_ROWS.criteria13%TYPE;
120: G_criteria14 CE_FORECAST_ROWS.criteria14%TYPE;
121: G_criteria15 CE_FORECAST_ROWS.criteria15%TYPE;
122: G_use_average_payment_days CE_FORECAST_ROWS.use_average_payment_days%TYPE;
123: G_apd_period CE_FORECAST_ROWS.period%TYPE;
124: G_order_type_id CE_FORECAST_ROWS.order_type_id%TYPE;
125: G_use_payment_terms CE_FORECAST_ROWS.use_payment_terms%TYPE;
118: G_criteria12 CE_FORECAST_ROWS.criteria12%TYPE;
119: G_criteria13 CE_FORECAST_ROWS.criteria13%TYPE;
120: G_criteria14 CE_FORECAST_ROWS.criteria14%TYPE;
121: G_criteria15 CE_FORECAST_ROWS.criteria15%TYPE;
122: G_use_average_payment_days CE_FORECAST_ROWS.use_average_payment_days%TYPE;
123: G_apd_period CE_FORECAST_ROWS.period%TYPE;
124: G_order_type_id CE_FORECAST_ROWS.order_type_id%TYPE;
125: G_use_payment_terms CE_FORECAST_ROWS.use_payment_terms%TYPE;
126: G_include_temp_labor_flag CE_FORECAST_ROWS.include_temp_labor_flag%TYPE;
119: G_criteria13 CE_FORECAST_ROWS.criteria13%TYPE;
120: G_criteria14 CE_FORECAST_ROWS.criteria14%TYPE;
121: G_criteria15 CE_FORECAST_ROWS.criteria15%TYPE;
122: G_use_average_payment_days CE_FORECAST_ROWS.use_average_payment_days%TYPE;
123: G_apd_period CE_FORECAST_ROWS.period%TYPE;
124: G_order_type_id CE_FORECAST_ROWS.order_type_id%TYPE;
125: G_use_payment_terms CE_FORECAST_ROWS.use_payment_terms%TYPE;
126: G_include_temp_labor_flag CE_FORECAST_ROWS.include_temp_labor_flag%TYPE;
127: --
120: G_criteria14 CE_FORECAST_ROWS.criteria14%TYPE;
121: G_criteria15 CE_FORECAST_ROWS.criteria15%TYPE;
122: G_use_average_payment_days CE_FORECAST_ROWS.use_average_payment_days%TYPE;
123: G_apd_period CE_FORECAST_ROWS.period%TYPE;
124: G_order_type_id CE_FORECAST_ROWS.order_type_id%TYPE;
125: G_use_payment_terms CE_FORECAST_ROWS.use_payment_terms%TYPE;
126: G_include_temp_labor_flag CE_FORECAST_ROWS.include_temp_labor_flag%TYPE;
127: --
128: G_sob_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
121: G_criteria15 CE_FORECAST_ROWS.criteria15%TYPE;
122: G_use_average_payment_days CE_FORECAST_ROWS.use_average_payment_days%TYPE;
123: G_apd_period CE_FORECAST_ROWS.period%TYPE;
124: G_order_type_id CE_FORECAST_ROWS.order_type_id%TYPE;
125: G_use_payment_terms CE_FORECAST_ROWS.use_payment_terms%TYPE;
126: G_include_temp_labor_flag CE_FORECAST_ROWS.include_temp_labor_flag%TYPE;
127: --
128: G_sob_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
129: G_parent_process BOOLEAN;
122: G_use_average_payment_days CE_FORECAST_ROWS.use_average_payment_days%TYPE;
123: G_apd_period CE_FORECAST_ROWS.period%TYPE;
124: G_order_type_id CE_FORECAST_ROWS.order_type_id%TYPE;
125: G_use_payment_terms CE_FORECAST_ROWS.use_payment_terms%TYPE;
126: G_include_temp_labor_flag CE_FORECAST_ROWS.include_temp_labor_flag%TYPE;
127: --
128: G_sob_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
129: G_parent_process BOOLEAN;
130: G_overdue_column_id NUMBER;