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.FV_GTAS_INTERFACE dependencies on FV_GTAS_FED_ACCOUNTS

Line 140: PROCEDURE populate_fv_gtas_fed_accounts;

136: message_line IN VARCHAR2);
137:
138: PROCEDURE delete_fed_accounts(p_set_of_books_id IN VARCHAR2,
139: p_period_year IN VARCHAR2);
140: PROCEDURE populate_fv_gtas_fed_accounts;
141: PROCEDURE update_gtas_run(p_period_year in VARCHAR2,
142: p_set_of_books_id in VARCHAR2);
143: FUNCTION get_acct_type(p_acct_num IN VARCHAR2)
144: RETURN VARCHAR2;

Line 2227: FROM fv_gtas_fed_accounts

2223: --identify ccids later in the balances view used for reporting
2224: BEGIN
2225: SELECT '2'
2226: INTO l_exception_status_l(i)
2227: FROM fv_gtas_fed_accounts
2228: WHERE set_of_books_id = gbl_set_of_books_id
2229: AND account_number = l_account_number
2230: AND fiscal_year = gbl_fiscal_year;
2231:

Line 2700: -- FV_GTAS_FED_ACCOUNTS table.

2696: -- FV_GTAS_ATTRIBUTES Table.
2697: -- For each such account, find if it is a child account. If yes, insert
2698: -- this account along with its parent and fed_nonfed, authority_type,
2699: -- bud_impact_ind and trading_partner attributes into
2700: -- FV_GTAS_FED_ACCOUNTS table.
2701: -- Otherwise, if the account is a Parent Account, find all the child
2702: -- accounts and insert them into FV_GTAS_FED_ACCOUNTS table along
2703: -- with all above attributes.
2704: -- Before populating the fv gtas fed accounts table, delete all rows for

Line 2702: -- accounts and insert them into FV_GTAS_FED_ACCOUNTS table along

2698: -- this account along with its parent and fed_nonfed, authority_type,
2699: -- bud_impact_ind and trading_partner attributes into
2700: -- FV_GTAS_FED_ACCOUNTS table.
2701: -- Otherwise, if the account is a Parent Account, find all the child
2702: -- accounts and insert them into FV_GTAS_FED_ACCOUNTS table along
2703: -- with all above attributes.
2704: -- Before populating the fv gtas fed accounts table, delete all rows for
2705: -- sob id and period year.
2706: --------------------------------------------------------------------------------

Line 2704: -- Before populating the fv gtas fed accounts table, delete all rows for

2700: -- FV_GTAS_FED_ACCOUNTS table.
2701: -- Otherwise, if the account is a Parent Account, find all the child
2702: -- accounts and insert them into FV_GTAS_FED_ACCOUNTS table along
2703: -- with all above attributes.
2704: -- Before populating the fv gtas fed accounts table, delete all rows for
2705: -- sob id and period year.
2706: --------------------------------------------------------------------------------
2707: PROCEDURE GET_FEDERAL_ACCOUNTS (p_err_buff OUT NOCOPY VARCHAR2,
2708: p_err_code OUT NOCOPY NUMBER,

Line 2771: --Delete from fv_gtas_fed_accounts for the parameters

2767: log(l_module_name, 'Error in get_segment_names procedure: '||gbl_error_buf);
2768: RETURN;
2769: END IF;
2770:
2771: --Delete from fv_gtas_fed_accounts for the parameters
2772: --before populating
2773: DELETE_FED_ACCOUNTS(p_sob_id, p_run_year) ;
2774:
2775:

Line 2849: POPULATE_FV_GTAS_FED_ACCOUNTS;

2845:
2846: log(l_module_name, 'g_is_acct_parent: '||g_is_acct_parent);
2847:
2848: -- Account is a child account, insert it into GTAS_FED_ACCOUNTS
2849: POPULATE_FV_GTAS_FED_ACCOUNTS;
2850:
2851:
2852: IF gbl_error_code <> 0 THEN
2853: p_err_code := gbl_error_code;

Line 2855: log(l_module_name, 'Error in populate_fv_gtas_fed_accounts procedure: '||

2851:
2852: IF gbl_error_code <> 0 THEN
2853: p_err_code := gbl_error_code;
2854: p_err_buff := gbl_error_buf;
2855: log(l_module_name, 'Error in populate_fv_gtas_fed_accounts procedure: '||
2856: gbl_error_buf);
2857: RETURN;
2858: END IF;
2859:

Line 2863: -- and insert them into FV_GTAS_FED_ACCOUNTS table if not already present.

2859:
2860: EXCEPTION
2861: WHEN NO_DATA_FOUND THEN
2862: -- If parent not found, then account itself is a parent, find all its child accounts
2863: -- and insert them into FV_GTAS_FED_ACCOUNTS table if not already present.
2864:
2865: g_is_acct_parent := 'Y';
2866: vg_sgl_acct_number := vg_acct_number;
2867:

Line 2887: POPULATE_FV_GTAS_FED_ACCOUNTS;

2883: log(l_module_name, 'fnd_flex_values_rec LOOP Begins...... ');
2884: vg_acct_number := fnd_flex_values_rec.flex_value;
2885: log(l_module_name, 'vg_acct_number: '||vg_acct_number);
2886:
2887: POPULATE_FV_GTAS_FED_ACCOUNTS;
2888:
2889: IF gbl_error_code <> 0 THEN
2890: p_err_code := gbl_error_code;
2891: p_err_buff := gbl_error_buf;

Line 2892: log(l_module_name, 'Error in populate_fv_gtas_fed_accounts procedure: '||

2888:
2889: IF gbl_error_code <> 0 THEN
2890: p_err_code := gbl_error_code;
2891: p_err_buff := gbl_error_buf;
2892: log(l_module_name, 'Error in populate_fv_gtas_fed_accounts procedure: '||
2893: gbl_error_buf);
2894: RETURN;
2895: END IF;
2896:

Line 2944: DELETE FROM fv_gtas_fed_accounts

2940: log(l_module_name, 'IN '||l_module_name);
2941: log(l_module_name, 'p_set_of_books_id: '||p_set_of_books_id);
2942: log(l_module_name, 'p_period_year: '||p_period_year);
2943:
2944: DELETE FROM fv_gtas_fed_accounts
2945: WHERE set_of_books_id = p_set_of_books_id
2946: AND fiscal_year = p_period_year;
2947:
2948: EXCEPTION

Line 2958: PROCEDURE POPULATE_FV_GTAS_FED_ACCOUNTS IS

2954: 'When others error in DELETE_FED_ACCOUNTS - '||SQLERRM;
2955: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_error_buf);
2956: END DELETE_FED_ACCOUNTS;
2957: --------------------------------------------------------------------------------
2958: PROCEDURE POPULATE_FV_GTAS_FED_ACCOUNTS IS
2959: l_module_name VARCHAR2(200):= g_module_name||'POPULATE_FV_GTAS_FED_ACCOUNTS';
2960:
2961: vl_authority_type_flag fv_gtas_fed_accounts.authority_type_flag%TYPE;
2962: vl_bud_impact_ind_flag fv_gtas_fed_accounts.budget_impact_ind_flag%TYPE;

Line 2959: l_module_name VARCHAR2(200):= g_module_name||'POPULATE_FV_GTAS_FED_ACCOUNTS';

2955: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_error_buf);
2956: END DELETE_FED_ACCOUNTS;
2957: --------------------------------------------------------------------------------
2958: PROCEDURE POPULATE_FV_GTAS_FED_ACCOUNTS IS
2959: l_module_name VARCHAR2(200):= g_module_name||'POPULATE_FV_GTAS_FED_ACCOUNTS';
2960:
2961: vl_authority_type_flag fv_gtas_fed_accounts.authority_type_flag%TYPE;
2962: vl_bud_impact_ind_flag fv_gtas_fed_accounts.budget_impact_ind_flag%TYPE;
2963: vl_trading_partner_flag fv_gtas_fed_accounts.trading_partner_flag%TYPE;

Line 2961: vl_authority_type_flag fv_gtas_fed_accounts.authority_type_flag%TYPE;

2957: --------------------------------------------------------------------------------
2958: PROCEDURE POPULATE_FV_GTAS_FED_ACCOUNTS IS
2959: l_module_name VARCHAR2(200):= g_module_name||'POPULATE_FV_GTAS_FED_ACCOUNTS';
2960:
2961: vl_authority_type_flag fv_gtas_fed_accounts.authority_type_flag%TYPE;
2962: vl_bud_impact_ind_flag fv_gtas_fed_accounts.budget_impact_ind_flag%TYPE;
2963: vl_trading_partner_flag fv_gtas_fed_accounts.trading_partner_flag%TYPE;
2964: vl_fed_non_fed_flag fv_gtas_fed_accounts.fed_non_fed_flag%TYPE;
2965: l_ledger_name gl_ledgers_v.name%TYPE;

Line 2962: vl_bud_impact_ind_flag fv_gtas_fed_accounts.budget_impact_ind_flag%TYPE;

2958: PROCEDURE POPULATE_FV_GTAS_FED_ACCOUNTS IS
2959: l_module_name VARCHAR2(200):= g_module_name||'POPULATE_FV_GTAS_FED_ACCOUNTS';
2960:
2961: vl_authority_type_flag fv_gtas_fed_accounts.authority_type_flag%TYPE;
2962: vl_bud_impact_ind_flag fv_gtas_fed_accounts.budget_impact_ind_flag%TYPE;
2963: vl_trading_partner_flag fv_gtas_fed_accounts.trading_partner_flag%TYPE;
2964: vl_fed_non_fed_flag fv_gtas_fed_accounts.fed_non_fed_flag%TYPE;
2965: l_ledger_name gl_ledgers_v.name%TYPE;
2966: l_dummy NUMBER;

Line 2963: vl_trading_partner_flag fv_gtas_fed_accounts.trading_partner_flag%TYPE;

2959: l_module_name VARCHAR2(200):= g_module_name||'POPULATE_FV_GTAS_FED_ACCOUNTS';
2960:
2961: vl_authority_type_flag fv_gtas_fed_accounts.authority_type_flag%TYPE;
2962: vl_bud_impact_ind_flag fv_gtas_fed_accounts.budget_impact_ind_flag%TYPE;
2963: vl_trading_partner_flag fv_gtas_fed_accounts.trading_partner_flag%TYPE;
2964: vl_fed_non_fed_flag fv_gtas_fed_accounts.fed_non_fed_flag%TYPE;
2965: l_ledger_name gl_ledgers_v.name%TYPE;
2966: l_dummy NUMBER;
2967:

Line 2964: vl_fed_non_fed_flag fv_gtas_fed_accounts.fed_non_fed_flag%TYPE;

2960:
2961: vl_authority_type_flag fv_gtas_fed_accounts.authority_type_flag%TYPE;
2962: vl_bud_impact_ind_flag fv_gtas_fed_accounts.budget_impact_ind_flag%TYPE;
2963: vl_trading_partner_flag fv_gtas_fed_accounts.trading_partner_flag%TYPE;
2964: vl_fed_non_fed_flag fv_gtas_fed_accounts.fed_non_fed_flag%TYPE;
2965: l_ledger_name gl_ledgers_v.name%TYPE;
2966: l_dummy NUMBER;
2967:
2968: BEGIN

Line 3029: FROM fv_gtas_fed_accounts

3025: BEGIN
3026: SELECT fed_non_fed_flag, authority_type_flag, budget_impact_ind_flag, trading_partner_flag
3027: INTO vl_fed_non_fed_flag, vl_authority_type_flag, vl_bud_impact_ind_flag,
3028: vl_trading_partner_flag
3029: FROM fv_gtas_fed_accounts
3030: WHERE account_number = vg_acct_number
3031: AND set_of_books_id = gbl_set_of_books_id
3032: AND fiscal_year = gbl_fiscal_year; --vg_sob_id;
3033:

Line 3050: UPDATE fv_gtas_fed_accounts

3046: IF g_is_acct_parent = 'N' THEN
3047:
3048: log(l_module_name, 'Updating account: '||vg_acct_number);
3049:
3050: UPDATE fv_gtas_fed_accounts
3051: SET fed_non_fed_flag = vg_fed_nonfed_flag,
3052: authority_type_flag = vg_authority_type_flag,
3053: budget_impact_ind_flag = vg_bud_impact_ind_flag,
3054: trading_partner_flag = vg_trading_partner_flag

Line 3072: INSERT INTO fv_gtas_fed_accounts

3068: END IF;
3069: EXCEPTION
3070: WHEN NO_DATA_FOUND THEN
3071:
3072: INSERT INTO fv_gtas_fed_accounts
3073: (account_number,
3074: sgl_account_number,
3075: set_of_books_id,
3076: fed_non_fed_flag,

Line 3113: ' -- Error in Populate_Fv_gtas_Fed_Accounts procedure';

3109: EXCEPTION
3110: WHEN OTHERS THEN
3111: gbl_error_code := SQLCODE;
3112: gbl_error_buf := SQLERRM ||
3113: ' -- Error in Populate_Fv_gtas_Fed_Accounts procedure';
3114: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||
3115: '.exception1',gbl_error_buf);
3116:
3117: END POPULATE_FV_GTAS_FED_ACCOUNTS;

Line 3117: END POPULATE_FV_GTAS_FED_ACCOUNTS;

3113: ' -- Error in Populate_Fv_gtas_Fed_Accounts procedure';
3114: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||
3115: '.exception1',gbl_error_buf);
3116:
3117: END POPULATE_FV_GTAS_FED_ACCOUNTS;
3118: --------------------------------------------------------------------------------
3119: PROCEDURE UPDATE_GTAS_RUN(p_period_year in VARCHAR2,
3120: p_set_of_books_id in VARCHAR2) IS
3121: