APPS.FV_YE_CLOSE dependencies on FND_FLEX_EXT

Line 59: vt_segments Fnd_Flex_Ext.SegmentArray;

55: vg_bal_seq_amt NUMBER;
56: vg_gl_bal_amt NUMBER;
57: vg_coy_dr NUMBER;
58: vg_coy_cr NUMBER;
59: vt_segments Fnd_Flex_Ext.SegmentArray;
60: vg_jrnl_group_id NUMBER;
61: vg_interface_run_id NUMBER;
62:
63: e_error EXCEPTION;

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

2302: vl_acct := vg_to_acct;
2303: vl_remaining_bal := vg_bal_seq_amt;
2304: vl_processing_type := 0;
2305:
2306: IF NOT Fnd_Flex_Ext.Get_Combination_Id('SQLGL', 'GL#',
2307: vg_coa_id, SYSDATE, vg_num_segs,
2308: vt_segments, vl_ccid) THEN
2309: IF (vl_remaining_bal <> 0) THEN
2310: RAISE e_invalid;

Line 2401: v_cross_val_msg := fnd_flex_ext.get_message;

2397: RETURN;
2398:
2399: WHEN e_invalid THEN
2400: vp_retcode := 2;
2401: v_cross_val_msg := fnd_flex_ext.get_message;
2402: vl_delimeter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#',vg_coa_id) ;
2403: vl_acct_combi := fnd_flex_ext.concatenate_segments(vg_num_segs,
2404: vt_segments, vl_delimeter);
2405:

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

2398:
2399: WHEN e_invalid THEN
2400: vp_retcode := 2;
2401: v_cross_val_msg := fnd_flex_ext.get_message;
2402: vl_delimeter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#',vg_coa_id) ;
2403: vl_acct_combi := fnd_flex_ext.concatenate_segments(vg_num_segs,
2404: vt_segments, vl_delimeter);
2405:
2406: vp_errbuf := 'The '||'"'||'To Account combination :'|| vl_acct_combi||'"'

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

2399: WHEN e_invalid THEN
2400: vp_retcode := 2;
2401: v_cross_val_msg := fnd_flex_ext.get_message;
2402: vl_delimeter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#',vg_coa_id) ;
2403: vl_acct_combi := fnd_flex_ext.concatenate_segments(vg_num_segs,
2404: vt_segments, vl_delimeter);
2405:
2406: vp_errbuf := 'The '||'"'||'To Account combination :'|| vl_acct_combi||'"'
2407: ||' violates Cross-Validation/Security rule ' ||

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

2444: 'determing the segments for the ccid '||TO_CHAR(ccid));
2445: END IF;
2446:
2447:
2448: IF NOT fnd_flex_ext.get_segments('SQLGL','GL#',vg_coa_id,ccid,vl_num_segs,
2449: vt_segments) THEN
2450: raise e_invalid;
2451: END IF;
2452:

Line 2641: segs Fnd_Flex_Ext.SegmentArray) IS

2637: dr_cr VARCHAR2,
2638: read_flag VARCHAR2,
2639: remaining_bal NUMBER,
2640: processing_type NUMBER,
2641: segs Fnd_Flex_Ext.SegmentArray) IS
2642:
2643: CURSOR flex_fields IS
2644: SELECT application_column_name
2645: FROM fnd_id_flex_segments

Line 2655: vl_segments Fnd_Flex_Ext.SegmentArray;

2651: vl_report_seq NUMBER;
2652: vl_period_dr NUMBER;
2653: vl_period_cr NUMBER;
2654: l_module_name VARCHAR2(200) ;
2655: vl_segments Fnd_Flex_Ext.SegmentArray;
2656: vl_segnum NUMBER;
2657: l_column_name fnd_id_flex_segments.application_column_name%TYPE;
2658: l_n_segments NUMBER ;
2659: