DBA Data[Home] [Help]

APPS.FV_YE_CLOSE dependencies on FND_FLEX_EXT

Line 67: vt_segments Fnd_Flex_Ext.SegmentArray;

63: vg_bal_seq_amt NUMBER;
64: vg_gl_bal_amt NUMBER;
65: vg_coy_dr NUMBER;
66: vg_coy_cr NUMBER;
67: vt_segments Fnd_Flex_Ext.SegmentArray;
68: vg_jrnl_group_id NUMBER;
69: vg_interface_run_id NUMBER;
70:
71: e_error EXCEPTION;

Line 2355: IF NOT Fnd_Flex_Ext.Get_Combination_Id('SQLGL', 'GL#',

2351: vl_acct := vg_to_acct;
2352: vl_remaining_bal := vg_bal_seq_amt;
2353: vl_processing_type := 0;
2354:
2355: IF NOT Fnd_Flex_Ext.Get_Combination_Id('SQLGL', 'GL#',
2356: vg_coa_id, SYSDATE, vg_num_segs,
2357: vt_segments, vl_ccid) THEN
2358: IF (vl_remaining_bal <> 0) THEN
2359: RAISE e_invalid;

Line 2450: v_cross_val_msg := fnd_flex_ext.get_message;

2446: RETURN;
2447:
2448: WHEN e_invalid THEN
2449: vp_retcode := 2;
2450: v_cross_val_msg := fnd_flex_ext.get_message;
2451: vl_delimeter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#',vg_coa_id) ;
2452: vl_acct_combi := fnd_flex_ext.concatenate_segments(vg_num_segs,
2453: vt_segments, vl_delimeter);
2454:

Line 2451: vl_delimeter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#',vg_coa_id) ;

2447:
2448: WHEN e_invalid THEN
2449: vp_retcode := 2;
2450: v_cross_val_msg := fnd_flex_ext.get_message;
2451: vl_delimeter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#',vg_coa_id) ;
2452: vl_acct_combi := fnd_flex_ext.concatenate_segments(vg_num_segs,
2453: vt_segments, vl_delimeter);
2454:
2455: vp_errbuf := 'The '||'"'||'To Account combination :'|| vl_acct_combi||'"'

Line 2452: vl_acct_combi := fnd_flex_ext.concatenate_segments(vg_num_segs,

2448: WHEN e_invalid THEN
2449: vp_retcode := 2;
2450: v_cross_val_msg := fnd_flex_ext.get_message;
2451: vl_delimeter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#',vg_coa_id) ;
2452: vl_acct_combi := fnd_flex_ext.concatenate_segments(vg_num_segs,
2453: vt_segments, vl_delimeter);
2454:
2455: vp_errbuf := 'The '||'"'||'To Account combination :'|| vl_acct_combi||'"'
2456: ||' violates Cross-Validation/Security rule ' ||

Line 2497: IF NOT fnd_flex_ext.get_segments('SQLGL','GL#',vg_coa_id,ccid,vl_num_segs,

2493: 'determing the segments for the ccid '||TO_CHAR(ccid));
2494: END IF;
2495:
2496:
2497: IF NOT fnd_flex_ext.get_segments('SQLGL','GL#',vg_coa_id,ccid,vl_num_segs,
2498: vt_segments) THEN
2499: raise e_invalid;
2500: END IF;
2501:

Line 2690: segs Fnd_Flex_Ext.SegmentArray) IS

2686: dr_cr VARCHAR2,
2687: read_flag VARCHAR2,
2688: remaining_bal NUMBER,
2689: processing_type NUMBER,
2690: segs Fnd_Flex_Ext.SegmentArray) IS
2691:
2692: CURSOR flex_fields IS
2693: SELECT application_column_name
2694: FROM fnd_id_flex_segments

Line 2704: vl_segments Fnd_Flex_Ext.SegmentArray;

2700: vl_report_seq NUMBER;
2701: vl_period_dr NUMBER;
2702: vl_period_cr NUMBER;
2703: l_module_name VARCHAR2(200) ;
2704: vl_segments Fnd_Flex_Ext.SegmentArray;
2705: vl_segnum NUMBER;
2706: l_column_name fnd_id_flex_segments.application_column_name%TYPE;
2707: l_n_segments NUMBER ;
2708: