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

Line 158: v_segments IN fnd_flex_ext.SegmentArray,

154: v_oo_id IN NUMBER,
155: v_cart_id IN NUMBER,
156: v_account_id IN NUMBER default NULL,
157: v_n_segments IN NUMBER default NULL,
158: v_segments IN fnd_flex_ext.SegmentArray,
159: v_account_num IN VARCHAR2 default NULL,
160: v_allocation_type IN VARCHAR2 default NULL,
161: v_allocation_value IN NUMBER default NULL,
162: v_line_quantity IN NUMBER default NULL) is

Line 425: v_segments IN fnd_flex_ext.SegmentArray,

421: v_distribution_id IN NUMBER,
422: v_line_number IN NUMBER,
423: v_account_id IN NUMBER default NULL,
424: v_n_segments IN NUMBER default NULL,
425: v_segments IN fnd_flex_ext.SegmentArray,
426: v_account_num IN VARCHAR2 default NULL,
427: v_allocation_type IN VARCHAR2 default NULL,
428: v_allocation_value IN NUMBER default NULL,
429: v_line_quantity IN NUMBER default NULL) is

Line 481: v_segment_bind fnd_flex_ext.SegmentArray;

477: /* New Vars added to take care of Binary Vars code ***/
478:
479: v_cursor_id INTEGER;
480:
481: v_segment_bind fnd_flex_ext.SegmentArray;
482:
483: begin
484:
485: if icx_sec.validatesession(c_commit => FALSE) then

Line 620: v_segments OUT fnd_flex_ext.SegmentArray,

616: v_structure IN NUMBER,
617: v_cart_line_id IN NUMBER,
618: v_cart_line_number IN NUMBER default NULL,
619: v_n_segments OUT NUMBER,
620: v_segments OUT fnd_flex_ext.SegmentArray,
621: v_account_id OUT NUMBER) is
622: v_delimiter varchar2(10);
623: l_n_segments NUMBER := NULL;
624: l_segments fnd_flex_ext.SegmentArray;

Line 624: l_segments fnd_flex_ext.SegmentArray;

620: v_segments OUT fnd_flex_ext.SegmentArray,
621: v_account_id OUT NUMBER) is
622: v_delimiter varchar2(10);
623: l_n_segments NUMBER := NULL;
624: l_segments fnd_flex_ext.SegmentArray;
625: l_account_id NUMBER := NULL;
626: l_ret_cd BOOLEAN;
627: v_error_message varchar2(1000);
628:

Line 632: v_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',v_structure);

628:
629: begin
630:
631: -- get con-seg delimiter
632: v_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',v_structure);
633: l_account_id := fnd_flex_ext.get_ccid('SQLGL',
634: 'GL#',
635: v_structure,
636: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),

Line 633: l_account_id := fnd_flex_ext.get_ccid('SQLGL',

629: begin
630:
631: -- get con-seg delimiter
632: v_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',v_structure);
633: l_account_id := fnd_flex_ext.get_ccid('SQLGL',
634: 'GL#',
635: v_structure,
636: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),
637: v_account_num);

Line 642: l_ret_cd := fnd_flex_ext.get_segments('SQLGL',

638:
639: if l_account_id is not NULL then
640:
641: v_account_id := l_account_id;
642: l_ret_cd := fnd_flex_ext.get_segments('SQLGL',
643: 'GL#',
644: v_structure,
645: l_account_id,
646: v_n_segments,

Line 678: v_segments IN fnd_flex_ext.SegmentArray,

674:
675: /* get account id,con-catenated segments based on segments */
676: PROCEDURE get_acct_by_segs(v_cart_id IN NUMBER,
677: v_line_number IN NUMBER,
678: v_segments IN fnd_flex_ext.SegmentArray,
679: v_structure IN NUMBER,
680: v_cart_line_id IN NUMBER,
681: v_cart_line_number IN NUMBER default NULL,
682: v_n_segments OUT NUMBER,

Line 696: v_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',v_structure);

692:
693: begin
694:
695: -- get con-seg delimiter
696: v_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',v_structure);
697: l_n_segments := v_segments.COUNT;
698: v_n_segments := l_n_segments;
699:
700: l_account_num := fnd_flex_ext.concatenate_segments(l_n_segments,

Line 700: l_account_num := fnd_flex_ext.concatenate_segments(l_n_segments,

696: v_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',v_structure);
697: l_n_segments := v_segments.COUNT;
698: v_n_segments := l_n_segments;
699:
700: l_account_num := fnd_flex_ext.concatenate_segments(l_n_segments,
701: v_segments,
702: v_delimiter);
703: v_account_num := l_account_num;
704:

Line 707: l_account_id := fnd_flex_ext.get_ccid('SQLGL',

703: v_account_num := l_account_num;
704:
705: if l_account_num is not NULL then
706:
707: l_account_id := fnd_flex_ext.get_ccid('SQLGL',
708: 'GL#',
709: v_structure,
710: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),
711: l_account_num);

Line 741: v_segments OUT fnd_flex_ext.SegmentArray,

737: v_structure IN NUMBER,
738: v_cart_line_id IN NUMBER,
739: v_cart_line_number IN NUMBER default NULL,
740: v_n_segments OUT NUMBER,
741: v_segments OUT fnd_flex_ext.SegmentArray,
742: v_account_num OUT VARCHAR2) is
743:
744: v_delimiter varchar2(10);
745: l_n_segments NUMBER := NULL;

Line 746: l_segments fnd_flex_ext.SegmentArray;

742: v_account_num OUT VARCHAR2) is
743:
744: v_delimiter varchar2(10);
745: l_n_segments NUMBER := NULL;
746: l_segments fnd_flex_ext.SegmentArray;
747: l_ret_cd BOOLEAN;
748: v_error_message varchar2(1000);
749:
750: begin

Line 752: v_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',v_structure);

748: v_error_message varchar2(1000);
749:
750: begin
751: -- get con-seg delimiter
752: v_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',v_structure);
753:
754: -- get segments and put into the plsql table
755: l_ret_cd := fnd_flex_ext.get_segments('SQLGL',
756: 'GL#',

Line 755: l_ret_cd := fnd_flex_ext.get_segments('SQLGL',

751: -- get con-seg delimiter
752: v_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',v_structure);
753:
754: -- get segments and put into the plsql table
755: l_ret_cd := fnd_flex_ext.get_segments('SQLGL',
756: 'GL#',
757: v_structure,
758: v_account_id,
759: l_n_segments,

Line 780: v_account_num := fnd_flex_ext.concatenate_segments(n_segments => l_n_segments,

776:
777: v_n_segments := l_n_segments;
778: v_segments := l_segments;
779:
780: v_account_num := fnd_flex_ext.concatenate_segments(n_segments => l_n_segments,
781: segments => l_segments,
782: delimiter => v_delimiter);
783:
784: end if;

Line 822: v_segments fnd_flex_ext.SegmentArray;

818: v_expense_account number;
819: v_exist number;
820: v_return_code varchar2(200);
821: v_n_segments number;
822: v_segments fnd_flex_ext.SegmentArray;
823: v_account_id number := NULL;
824: l_line_number number := NULL;
825:
826: cursor get_dist_num(cartline_id number,oo_id number) is

Line 884: v_account_id := fnd_flex_ext.get_ccid('SQLGL',

880: l_dist_number := v_line_number;
881: end if;
882:
883: /* get the account id */
884: v_account_id := fnd_flex_ext.get_ccid('SQLGL',
885: 'GL#',
886: v_structure,
887: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),
888: v_account_num);

Line 941: v_segments IN fnd_flex_ext.SegmentArray,

937: * if distiribution id is not passed.*/
938: PROCEDURE update_account(v_cart_id IN NUMBER,
939: v_cart_line_id IN NUMBER,
940: v_oo_id IN NUMBER,
941: v_segments IN fnd_flex_ext.SegmentArray,
942: v_distribution_id IN NUMBER default NULL,
943: v_line_number IN NUMBER default NULL,
944: v_allocation_type IN VARCHAR2 default NULL,
945: v_allocation_value IN NUMBER default NULL,

Line 1092: v_segments fnd_flex_ext.SegmentArray;

1088: v_line_number number;
1089: v_exist number;
1090: v_return_code varchar2(200);
1091: v_n_segments number;
1092: v_segments fnd_flex_ext.SegmentArray;
1093:
1094: CURSOR line_default_account is
1095: SELECT default_code_combination_id employee_default_account_id
1096: from hr_employees_current_v

Line 1237: v_segments OUT fnd_flex_ext.SegmentArray) IS

1233: PROCEDURE get_default_segs (v_cart_id IN NUMBER,
1234: v_cart_line_id IN NUMBER,
1235: v_emp_id IN NUMBER,
1236: v_oo_id IN NUMBER,
1237: v_segments OUT fnd_flex_ext.SegmentArray) IS
1238:
1239: v_error_message varchar(1000);
1240: v_structure number;
1241: v_expense_account number;

Line 1326: l_ret_cd := fnd_flex_ext.get_segments('SQLGL',

1322: close item_expense_account;
1323: end if;
1324:
1325: if v_account_id is not NULL then
1326: l_ret_cd := fnd_flex_ext.get_segments('SQLGL',
1327: 'GL#',
1328: v_structure,
1329: v_account_id,
1330: v_n_segments,

Line 1336: v_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',v_structure);

1332: end if;
1333:
1334: elsif v_account_num is not NULL then
1335:
1336: v_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',v_structure);
1337: v_account_id := fnd_flex_ext.get_ccid('SQLGL',
1338: 'GL#',
1339: v_structure,
1340: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),

Line 1337: v_account_id := fnd_flex_ext.get_ccid('SQLGL',

1333:
1334: elsif v_account_num is not NULL then
1335:
1336: v_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',v_structure);
1337: v_account_id := fnd_flex_ext.get_ccid('SQLGL',
1338: 'GL#',
1339: v_structure,
1340: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),
1341: v_account_num);

Line 1344: l_ret_cd := fnd_flex_ext.get_segments('SQLGL',

1340: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),
1341: v_account_num);
1342: if v_account_id is not NULL then
1343:
1344: l_ret_cd := fnd_flex_ext.get_segments('SQLGL',
1345: 'GL#',
1346: v_structure,
1347: v_account_id,
1348: v_n_segments,

Line 1385: v_segments fnd_flex_ext.SegmentArray;

1381: v_oo_id IN NUMBER,
1382: v_distribution_id IN NUMBER,
1383: v_line_number IN NUMBER) is
1384:
1385: v_segments fnd_flex_ext.SegmentArray;
1386: v_n_segments number;
1387: v_structure number;
1388: v_cart_line_number number;
1389: v_error_message varchar2(2000);

Line 1435: l_ret_cd := fnd_flex_ext.get_segments('SQLGL',

1431: fetch get_account_id into v_account_id;
1432: close get_account_id;
1433:
1434: if v_account_id is not NULL then
1435: l_ret_cd := fnd_flex_ext.get_segments('SQLGL',
1436: 'GL#',
1437: v_structure,
1438: v_account_id,
1439: v_n_segments,