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.AP_WEB_ACCTG_PKG dependencies on FND_FLEX_EXT

Line 38: l_segments FND_FLEX_EXT.SEGMENTARRAY;

34:
35: l_debug_info varchar2(200);
36:
37: l_chart_of_accounts_id number := p_chart_of_accounts_id;
38: l_segments FND_FLEX_EXT.SEGMENTARRAY;
39: l_num_of_segments NUMBER;
40: l_cost_ctr_seg_num NUMBER;
41:
42: BEGIN

Line 57: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL',

53:
54: -----------------------------------------------------
55: l_debug_info := 'Retrieve segments from code combination id';
56: -----------------------------------------------------
57: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL',
58: 'GL#',
59: l_chart_of_accounts_id,
60: p_ccid,
61: l_num_of_segments,

Line 233: l_default_emp_segments FND_FLEX_EXT.SEGMENTARRAY;

229:
230: l_flex_segment_delimiter varchar2(1);
231: l_cost_center_seg_num number;
232: l_num_segments number;
233: l_default_emp_segments FND_FLEX_EXT.SEGMENTARRAY;
234: l_appcol_name fnd_id_flex_segments_vl.application_column_name%type;
235: l_seg_name fnd_id_flex_segments_vl.segment_name%type;
236: l_prompt fnd_id_flex_segments_vl.form_left_prompt%type;
237: l_value_set_name fnd_flex_value_sets.flex_value_set_name%type;

Line 248: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

244: -- used to prepare the concatenated segment from segment array to a string.
245: -----------------------------------------------------
246: l_debug_info := 'Get segment delimiter';
247: -----------------------------------------------------
248: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
249: 'SQLGL',
250: 'GL#',
251: p_chart_of_accounts_id);
252:

Line 273: if (NOT FND_FLEX_EXT.GET_SEGMENTS(

269: -- code combination id.
270: -----------------------------------------------------
271: l_debug_info := 'Get employee default segments';
272: -----------------------------------------------------
273: if (NOT FND_FLEX_EXT.GET_SEGMENTS(
274: 'SQLGL',
275: 'GL#',
276: p_chart_of_accounts_id,
277: p_default_emp_ccid,

Line 333: l_concatenated_segments := FND_FLEX_EXT.concatenate_segments(l_num_segments,

329: -- (l_default_emp_segments) to a string(l_concatenated_segments).
330: -----------------------------------------------------
331: l_debug_info := 'Concatenate segments';
332: -----------------------------------------------------
333: l_concatenated_segments := FND_FLEX_EXT.concatenate_segments(l_num_segments,
334: l_default_emp_segments,
335: l_flex_segment_delimiter);
336:
337: /* -----------------------------------------------------------------------+

Line 411: l_exp_type_template_array FND_FLEX_EXT.SEGMENTARRAY;

407: l_chart_of_accounts_id number;
408: l_flex_segment_delimiter varchar2(1);
409: l_cost_center_seg_num number;
410: l_num_segments number;
411: l_exp_type_template_array FND_FLEX_EXT.SEGMENTARRAY;
412: l_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
413:
414: BEGIN
415:

Line 428: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

424: -- used to prepare the concatenated segment from segment array to a string.
425: -----------------------------------------------------
426: l_debug_info := 'Get segment delimeter';
427: -----------------------------------------------------
428: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
429: 'SQLGL',
430: 'GL#',
431: l_chart_of_accounts_id);
432:

Line 469: l_num_segments := FND_FLEX_EXT.Breakup_Segments(l_FlexConcactenated,

465:
466: -----------------------------------------------------
467: l_debug_info := 'Break up segments';
468: -----------------------------------------------------
469: l_num_segments := FND_FLEX_EXT.Breakup_Segments(l_FlexConcactenated,
470: l_flex_segment_delimiter,
471: l_exp_type_template_array);
472:
473: IF nvl(l_num_segments,0) = 0 THEN

Line 573: l_segment_array FND_FLEX_EXT.SEGMENTARRAY;

569: c integer;
570: l_concat_segments VARCHAR2(1000);
571: rows integer;
572: l_num_segments NUMBER;
573: l_segment_array FND_FLEX_EXT.SEGMENTARRAY;
574: l_flex_segment_delimiter varchar2(1);
575:
576: cursor cflex(p_chart_accounts_id IN NUMBER) is
577: SELECT flex.application_column_name

Line 593: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

589: -- used to prepare the concatenated segment from segment array to a string.
590: -----------------------------------------------------
591: l_debug_info := 'Get segment delimiter';
592: -----------------------------------------------------
593: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
594: 'SQLGL',
595: 'GL#',
596: p_chart_of_accounts_id);
597:

Line 668: l_num_segments := FND_FLEX_EXT.Breakup_Segments(l_concat_segments,

664:
665: --------------------------------------------------------------
666: l_debug_info:='Break Up Segments';
667: --------------------------------------------------------------
668: l_num_segments := FND_FLEX_EXT.Breakup_Segments(l_concat_segments,
669: l_flex_segment_delimiter,
670: l_segment_array);
671:
672:

Line 710: l_segments FND_FLEX_EXT.SEGMENTARRAY;

706:
707: l_debug_info VARCHAR2(100);
708:
709: l_flex_segment_delimiter VARCHAR2(1);
710: l_segments FND_FLEX_EXT.SEGMENTARRAY;
711:
712: BEGIN
713:
714: IF (p_chart_of_accounts_id is null) THEN

Line 722: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

718:
719: ----------------------------------------
720: l_debug_info := 'Get Segment Delimiter like .';
721: ----------------------------------------
722: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
723: 'SQLGL',
724: 'GL#',
725: p_chart_of_accounts_id);
726:

Line 732: l_debug_info := 'Convert AP_OIE_KFF_SEGMENTS_T to FND_FLEX_EXT.SEGMENTARRAY';

728: RAISE AP_WEB_OA_MAINFLOW_PKG.G_EXC_ERROR;
729: END IF; /* l_flex_segment_delimiter IS NULL */
730:
731: ------------------------------------------------------------------------
732: l_debug_info := 'Convert AP_OIE_KFF_SEGMENTS_T to FND_FLEX_EXT.SEGMENTARRAY';
733: ------------------------------------------------------------------------
734: FOR i IN 1..p_segments.count LOOP
735: l_segments(i) := p_segments(i);
736: END LOOP;

Line 739: l_debug_info := 'calling FND_FLEX_EXT.concatenate_segments';

735: l_segments(i) := p_segments(i);
736: END LOOP;
737:
738: ------------------------------------------------------------------------
739: l_debug_info := 'calling FND_FLEX_EXT.concatenate_segments';
740: ------------------------------------------------------------------------
741: p_concatenated_segments := FND_FLEX_EXT.concatenate_segments(l_segments.count,
742: l_segments,
743: l_flex_segment_delimiter);

Line 741: p_concatenated_segments := FND_FLEX_EXT.concatenate_segments(l_segments.count,

737:
738: ------------------------------------------------------------------------
739: l_debug_info := 'calling FND_FLEX_EXT.concatenate_segments';
740: ------------------------------------------------------------------------
741: p_concatenated_segments := FND_FLEX_EXT.concatenate_segments(l_segments.count,
742: l_segments,
743: l_flex_segment_delimiter);
744:
745: EXCEPTION

Line 774: l_default_emp_segments FND_FLEX_EXT.SEGMENTARRAY;

770: l_default_emp_ccid AP_WEB_DB_EXPRPT_PKG.expHdr_employeeCCID;
771: l_chart_of_accounts_id NUMBER;
772: l_cost_center_seg_num NUMBER;
773: l_flex_segment_delimiter VARCHAR2(1);
774: l_default_emp_segments FND_FLEX_EXT.SEGMENTARRAY;
775: l_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.FLEX_CONCACTENATED%TYPE;
776: l_exp_type_template_array FND_FLEX_EXT.SEGMENTARRAY;
777: l_exp_line_acct_segs_array FND_FLEX_EXT.SEGMENTARRAY;
778: l_num_segments NUMBER:=NULL;

Line 776: l_exp_type_template_array FND_FLEX_EXT.SEGMENTARRAY;

772: l_cost_center_seg_num NUMBER;
773: l_flex_segment_delimiter VARCHAR2(1);
774: l_default_emp_segments FND_FLEX_EXT.SEGMENTARRAY;
775: l_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.FLEX_CONCACTENATED%TYPE;
776: l_exp_type_template_array FND_FLEX_EXT.SEGMENTARRAY;
777: l_exp_line_acct_segs_array FND_FLEX_EXT.SEGMENTARRAY;
778: l_num_segments NUMBER:=NULL;
779: l_concatenated_segments varchar2(2000);
780:

Line 777: l_exp_line_acct_segs_array FND_FLEX_EXT.SEGMENTARRAY;

773: l_flex_segment_delimiter VARCHAR2(1);
774: l_default_emp_segments FND_FLEX_EXT.SEGMENTARRAY;
775: l_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.FLEX_CONCACTENATED%TYPE;
776: l_exp_type_template_array FND_FLEX_EXT.SEGMENTARRAY;
777: l_exp_line_acct_segs_array FND_FLEX_EXT.SEGMENTARRAY;
778: l_num_segments NUMBER:=NULL;
779: l_concatenated_segments varchar2(2000);
780:
781: BEGIN

Line 849: IF (NOT FND_FLEX_EXT.GET_SEGMENTS(

845: -----------------------------------------------------------------
846: l_debug_info := 'Get employee default ccid account segments';
847: -----------------------------------------------------------------
848: IF (l_default_emp_ccid IS NOT NULL) THEN
849: IF (NOT FND_FLEX_EXT.GET_SEGMENTS(
850: 'SQLGL',
851: 'GL#',
852: l_chart_of_accounts_id,
853: l_default_emp_ccid,

Line 877: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

873:
874: ----------------------------------------
875: l_debug_info := 'Get Segment Delimiter like .';
876: ----------------------------------------
877: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
878: 'SQLGL',
879: 'GL#',
880: l_chart_of_accounts_id);
881:

Line 896: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL',

892:
893: ----------------------------------------
894: l_debug_info := 'Convert p_ccid into a segment array';
895: ----------------------------------------
896: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL',
897: 'GL#',
898: l_chart_of_accounts_id,
899: p_ccid,
900: l_num_segments,

Line 938: l_num_segments := FND_FLEX_EXT.Breakup_Segments(l_FlexConcactenated,

934:
935: --------------------------------------------------------------
936: l_debug_info:='Break Up Segments';
937: --------------------------------------------------------------
938: l_num_segments := FND_FLEX_EXT.Breakup_Segments(l_FlexConcactenated,
939: l_flex_segment_delimiter,
940: l_exp_type_template_array);
941: END IF;
942:

Line 1007: l_concatenated_segments := FND_FLEX_EXT.concatenate_segments(l_num_segments,

1003: --------------------------------------------------------------
1004: l_debug_info := 'Retrieve new ccid';
1005: --------------------------------------------------------------
1006: -- Work around for bug 1569108
1007: l_concatenated_segments := FND_FLEX_EXT.concatenate_segments(l_num_segments,
1008: l_exp_line_acct_segs_array,
1009: l_flex_segment_delimiter);
1010:
1011: ------------------------------------------------------------------------

Line 1143: l_segments FND_FLEX_EXT.SEGMENTARRAY;

1139: l_pa_CCID gl_code_combinations.code_combination_id%TYPE;
1140: lv_concat_segs VARCHAR2(2000);
1141: lv_concat_ids VARCHAR2(2000);
1142: lv_concat_description VARCHAR2(2000);
1143: l_segments FND_FLEX_EXT.SEGMENTARRAY;
1144: ln_segment_count NUMBER := 0;
1145: lv_flex_segment_delimiter VARCHAR2(1);
1146: lb_gms_accounting_created BOOLEAN := false;
1147:

Line 1373: lv_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL','GL#',pa_rec.chart_of_accounts_id);

1369:
1370: -----------------------------------------------------
1371: l_debug_info := 'Get segment delimeter';
1372: -----------------------------------------------------
1373: lv_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL','GL#',pa_rec.chart_of_accounts_id);
1374:
1375: -----------------------------------------------------
1376: l_debug_info := 'Break up segments';
1377: -----------------------------------------------------

Line 1378: ln_segment_count := FND_FLEX_EXT.Breakup_Segments(lv_concat_segs, lv_flex_segment_delimiter, l_segments);

1374:
1375: -----------------------------------------------------
1376: l_debug_info := 'Break up segments';
1377: -----------------------------------------------------
1378: ln_segment_count := FND_FLEX_EXT.Breakup_Segments(lv_concat_segs, lv_flex_segment_delimiter, l_segments);
1379:
1380: -----------------------------------------------------
1381: l_debug_info := 'Assign values to p_new_segments';
1382: -----------------------------------------------------

Line 1734: l_segments FND_FLEX_EXT.SEGMENTARRAY;

1730: p_seg_value OUT NOCOPY VARCHAR2) IS
1731: l_EmpInfoRec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;
1732: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
1733: l_dep_seg_num NUMBER;
1734: l_segments FND_FLEX_EXT.SEGMENTARRAY;
1735: l_num_of_segments NUMBER;
1736: BEGIN
1737: -- Fetch the Employee Info
1738: IF (AP_WEB_DB_HR_INT_PKG.GetEmployeeInfo(p_employee_id, l_EmpInfoRec)) THEN

Line 1750: IF (FND_FLEX_EXT.GET_SEGMENTS('SQLGL',

1746: IF (GetDependentSegment(p_vset_name, l_chart_of_accounts_id, l_dep_seg_num)) THEN
1747: NULL;
1748: END IF;
1749: -- Get the segments
1750: IF (FND_FLEX_EXT.GET_SEGMENTS('SQLGL',
1751: 'GL#',
1752: l_chart_of_accounts_id,
1753: l_EmpInfoRec.emp_ccid,
1754: l_num_of_segments,