DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on FND_FLEX_EXT

Line 885: segarray fnd_flex_ext.segmentarray;

881: j number;
882: i number;
883: nsegs number;
884: l_popul boolean;
885: segarray fnd_flex_ext.segmentarray;
886: --segarray segment_array;
887: tmp_seg_arr seg_arr_type;
888: concat varchar2(2000);
889: l_chart number;

Line 972: if fnd_flex_ext.get_combination_id(APPLICATION_SHORT_NAME => 'SQLGL',

968: --
969: -- Now we have the all segment values in correct order in segarray.
970: l_acctid_validated := TRUE; --Bug#4247753
971: --
972: if fnd_flex_ext.get_combination_id(APPLICATION_SHORT_NAME => 'SQLGL',
973: KEY_FLEX_CODE => 'GL#',
974: STRUCTURE_NUMBER => l_chart,
975: N_SEGMENTS => nsegs,
976: VALIDATION_DATE => l_trxdate,/*Bug#5176266*/

Line 998: --x_acctid := fnd_flex_ext.concatenate_segments(nsegs,segarray, str.segment_separator);

994: inv_log_util.trace('Distribution acct id error '|| l_error_exp, 'INV_TXN_MANAGER_GRP','1');
995: END IF;
996: RETURN FALSE;
997: end if;
998: --x_acctid := fnd_flex_ext.concatenate_segments(nsegs,segarray, str.segment_separator);
999:
1000: EXCEPTION
1001: WHEN NO_DATA_FOUND THEN
1002: FND_MESSAGE.set_name('INV','INV-Database corrupt');

Line 1028: l_segs1 fnd_flex_ext.segmentarray;

1024: RETURN BOOLEAN
1025: IS
1026: l_nseg NUMBER;
1027: l_seglist fnd_flex_key_api.segment_list;
1028: l_segs1 fnd_flex_ext.segmentarray;
1029: l_fftype fnd_flex_key_api.flexfield_type;
1030: l_ffstru fnd_flex_key_api.structure_type;
1031: l_segment_type fnd_flex_key_api.segment_type;
1032: -- Local array to hold the data for getting the cancatenated segment.

Line 1033: l_segmentarray fnd_flex_ext.segmentarray;

1029: l_fftype fnd_flex_key_api.flexfield_type;
1030: l_ffstru fnd_flex_key_api.structure_type;
1031: l_segment_type fnd_flex_key_api.segment_type;
1032: -- Local array to hold the data for getting the cancatenated segment.
1033: l_segmentarray fnd_flex_ext.segmentarray;
1034: l_itemsegs VARCHAR2(32000);
1035: l_delim VARCHAR2(1);
1036: l_result BOOLEAN := FALSE;
1037: BEGIN

Line 1105: l_itemsegs := fnd_flex_ext.concatenate_segments(n_segments => l_nseg,

1101: l_segmentarray(l_loop) := l_segs1(To_number(Substr(l_segment_type.column_name, 8)));
1102: END LOOP;
1103: -- Bug Fix#4747090
1104: -- Gets the encoded cancatenated string
1105: l_itemsegs := fnd_flex_ext.concatenate_segments(n_segments => l_nseg,
1106: segments => l_segmentarray,
1107: delimiter => l_delim);
1108: l_result := FND_FLEX_KEYVAL.Validate_Segs(
1109: OPERATION => 'FIND_COMBINATION',

Line 1149: segarray fnd_flex_ext.segmentarray;

1145: l_ffstru fnd_flex_key_api.structure_type;
1146: l_segment_type fnd_flex_key_api.segment_type;
1147: l_structure_list fnd_flex_key_api.structure_list;
1148: l_chart NUMBER;
1149: segarray fnd_flex_ext.segmentarray;
1150: tmp_seg_arr seg_arr_type;
1151: i NUMBER;
1152: j NUMBER;
1153: l_app_shortname VARCHAR2(20);

Line 1245: l_result := fnd_flex_ext.get_combination_id(APPLICATION_SHORT_NAME => l_app_shortname,

1241: --
1242: -- Bug 3273172 Added DATA_SET => p_orgid to the below FND call
1243: -- Changed for bug 3346767
1244: IF (p_srctype = 6) THEN
1245: l_result := fnd_flex_ext.get_combination_id(APPLICATION_SHORT_NAME => l_app_shortname,
1246: KEY_FLEX_CODE => l_flex_code,
1247: STRUCTURE_NUMBER => l_struct_number,
1248: VALIDATION_DATE => sysdate,
1249: N_SEGMENTS => l_nseg,

Line 1254: l_result := fnd_flex_ext.get_combination_id(APPLICATION_SHORT_NAME => l_app_shortname,

1250: SEGMENTS => segarray,
1251: COMBINATION_ID => x_trxsrc,
1252: DATA_SET => p_orgid);
1253: ELSE
1254: l_result := fnd_flex_ext.get_combination_id(APPLICATION_SHORT_NAME => l_app_shortname,
1255: KEY_FLEX_CODE => l_flex_code,
1256: STRUCTURE_NUMBER => l_struct_number,
1257: VALIDATION_DATE => sysdate,
1258: N_SEGMENTS => l_nseg,

Line 5088: -- FND_FLEX_EXT (AFFFEXTS/B.pls)

5084: -- getloc
5085: -- Description
5086: -- Private function to get Locator id using Flex API's
5087: -- Uses FND_FLEX_KEY_API (AFFFKAIS/B.pls) and
5088: -- FND_FLEX_EXT (AFFFEXTS/B.pls)
5089: --
5090: -- Assumes that only Id's are populated in the MTI segments
5091: --
5092: -- Returns

Line 5098: FUNCTION getloc(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_locctrl NUMBER, p_segmentarray fnd_flex_ext.segmentarray) return BOOLEAN is

5094: -- Output Parameters
5095: -- x_locid locator or null if error occurred
5096: ******************************************************************/
5097:
5098: FUNCTION getloc(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_locctrl NUMBER, p_segmentarray fnd_flex_ext.segmentarray) return BOOLEAN is
5099: l_nseg NUMBER;
5100: l_seglist fnd_flex_key_api.segment_list;
5101: l_fftype fnd_flex_key_api.flexfield_type;
5102: l_ffstru fnd_flex_key_api.structure_type;

Line 5115: l_segmentarray fnd_flex_ext.segmentarray;

5111: l_val BOOLEAN := FALSE;
5112: DYNAMIC CONSTANT NUMBER := 3;
5113: l_operation VARCHAR2(100);
5114: -- Local array to hold the data for getting the cancatenated segment.
5115: l_segmentarray fnd_flex_ext.segmentarray;
5116: BEGIN
5117:
5118: fnd_flex_key_api.set_session_mode('seed_data');
5119:

Line 5148: l_locator := fnd_flex_ext.concatenate_segments(n_segments => l_nseg,

5144: l_segmentarray(l_loop) := p_segmentarray(To_number(Substr(l_segment_type.column_name, 8)));
5145: END LOOP;
5146: -- Bug Fix#4747090
5147: -- Gets the encoded cancatenated string
5148: l_locator := fnd_flex_ext.concatenate_segments(n_segments => l_nseg,
5149: segments => l_segmentarray,
5150: delimiter => l_delim);
5151: IF (l_debug = 1) THEN
5152: inv_log_util.trace('Locator is : ' || l_locator, 'INV_TXN_MANAGER_GRP','1');

Line 5217: l_segs1 fnd_flex_ext.segmentArray;

5213: -- Output Parameters
5214: -- x_locator locator or null if error occurred
5215: ******************************************************************/
5216: FUNCTION getlocid(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_subinv VARCHAR2, p_rowid VARCHAR2, p_locctrl NUMBER) return BOOLEAN is
5217: l_segs1 fnd_flex_ext.segmentArray;
5218: l_error_exp VARCHAR2(250);
5219: l_locid number;
5220: begin
5221:

Line 5295: l_segs1 fnd_flex_ext.segmentArray;

5291: -- x_locator locator or null if error occurred
5292: ******************************************************************/
5293:
5294: FUNCTION getxlocid(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_subinv VARCHAR2, p_rowid VARCHAR2, p_locctrl NUMBER) return BOOLEAN is
5295: l_segs1 fnd_flex_ext.segmentArray;
5296: l_error_exp VARCHAR2(250);
5297: l_locid number;
5298: begin
5299:

Line 5375: l_segs1 fnd_flex_ext.segmentArray;

5371: -- x_locator locator or null if error occurred
5372: ******************************************************************/
5373: /** Altered the changes made in the bug 7323175 for the bug 12922489*/
5374: /*FUNCTION getplocid(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_subinv VARCHAR2, p_rowid VARCHAR2, p_locctrl NUMBER) return BOOLEAN is
5375: l_segs1 fnd_flex_ext.segmentArray;
5376: l_error_exp VARCHAR2(250);
5377: l_locid number;
5378: begin
5379:

Line 5458: l_segs1 fnd_flex_ext.segmentArray;

5454: -- x_locator locator or null if error occurred
5455: ******************************************************************/
5456: /** Altered the changes made in the bug 7323175 for the bug 12922489*/
5457: /*FUNCTION getxplocid(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_subinv VARCHAR2, p_rowid VARCHAR2, p_locctrl NUMBER) return BOOLEAN is
5458: l_segs1 fnd_flex_ext.segmentArray;
5459: l_error_exp VARCHAR2(250);
5460: l_locid number;
5461: begin
5462: