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