DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on FND_FLEX_EXT

Line 875: segarray fnd_flex_ext.segmentarray;

871: j number;
872: i number;
873: nsegs number;
874: l_popul boolean;
875: segarray fnd_flex_ext.segmentarray;
876: --segarray segment_array;
877: tmp_seg_arr seg_arr_type;
878: concat varchar2(2000);
879: l_chart number;

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

958: --
959: -- Now we have the all segment values in correct order in segarray.
960: l_acctid_validated := TRUE; --Bug#4247753
961: --
962: if fnd_flex_ext.get_combination_id(APPLICATION_SHORT_NAME => 'SQLGL',
963: KEY_FLEX_CODE => 'GL#',
964: STRUCTURE_NUMBER => l_chart,
965: N_SEGMENTS => nsegs,
966: VALIDATION_DATE => l_trxdate,/*Bug#5176266*/

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

984: inv_log_util.trace('Distribution acct id error '|| l_error_exp, 'INV_TXN_MANAGER_GRP','1');
985: END IF;
986: RETURN FALSE;
987: end if;
988: --x_acctid := fnd_flex_ext.concatenate_segments(nsegs,segarray, str.segment_separator);
989:
990: EXCEPTION
991: WHEN NO_DATA_FOUND THEN
992: FND_MESSAGE.set_name('INV','INV-Database corrupt');

Line 1018: l_segs1 fnd_flex_ext.segmentarray;

1014: RETURN BOOLEAN
1015: IS
1016: l_nseg NUMBER;
1017: l_seglist fnd_flex_key_api.segment_list;
1018: l_segs1 fnd_flex_ext.segmentarray;
1019: l_fftype fnd_flex_key_api.flexfield_type;
1020: l_ffstru fnd_flex_key_api.structure_type;
1021: l_segment_type fnd_flex_key_api.segment_type;
1022: -- Local array to hold the data for getting the cancatenated segment.

Line 1023: l_segmentarray fnd_flex_ext.segmentarray;

1019: l_fftype fnd_flex_key_api.flexfield_type;
1020: l_ffstru fnd_flex_key_api.structure_type;
1021: l_segment_type fnd_flex_key_api.segment_type;
1022: -- Local array to hold the data for getting the cancatenated segment.
1023: l_segmentarray fnd_flex_ext.segmentarray;
1024: l_itemsegs VARCHAR2(32000);
1025: l_delim VARCHAR2(1);
1026: l_result BOOLEAN := FALSE;
1027: BEGIN

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

1091: l_segmentarray(l_loop) := l_segs1(To_number(Substr(l_segment_type.column_name, 8)));
1092: END LOOP;
1093: -- Bug Fix#4747090
1094: -- Gets the encoded cancatenated string
1095: l_itemsegs := fnd_flex_ext.concatenate_segments(n_segments => l_nseg,
1096: segments => l_segmentarray,
1097: delimiter => l_delim);
1098: l_result := FND_FLEX_KEYVAL.Validate_Segs(
1099: OPERATION => 'FIND_COMBINATION',

Line 1139: segarray fnd_flex_ext.segmentarray;

1135: l_ffstru fnd_flex_key_api.structure_type;
1136: l_segment_type fnd_flex_key_api.segment_type;
1137: l_structure_list fnd_flex_key_api.structure_list;
1138: l_chart NUMBER;
1139: segarray fnd_flex_ext.segmentarray;
1140: tmp_seg_arr seg_arr_type;
1141: i NUMBER;
1142: j NUMBER;
1143: l_app_shortname VARCHAR2(20);

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

1231: --
1232: -- Bug 3273172 Added DATA_SET => p_orgid to the below FND call
1233: -- Changed for bug 3346767
1234: IF (p_srctype = 6) THEN
1235: l_result := fnd_flex_ext.get_combination_id(APPLICATION_SHORT_NAME => l_app_shortname,
1236: KEY_FLEX_CODE => l_flex_code,
1237: STRUCTURE_NUMBER => l_struct_number,
1238: VALIDATION_DATE => sysdate,
1239: N_SEGMENTS => l_nseg,

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

1240: SEGMENTS => segarray,
1241: COMBINATION_ID => x_trxsrc,
1242: DATA_SET => p_orgid);
1243: ELSE
1244: l_result := fnd_flex_ext.get_combination_id(APPLICATION_SHORT_NAME => l_app_shortname,
1245: KEY_FLEX_CODE => l_flex_code,
1246: STRUCTURE_NUMBER => l_struct_number,
1247: VALIDATION_DATE => sysdate,
1248: N_SEGMENTS => l_nseg,

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

4707: -- getloc
4708: -- Description
4709: -- Private function to get Locator id using Flex API's
4710: -- Uses FND_FLEX_KEY_API (AFFFKAIS/B.pls) and
4711: -- FND_FLEX_EXT (AFFFEXTS/B.pls)
4712: --
4713: -- Assumes that only Id's are populated in the MTI segments
4714: --
4715: -- Returns

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

4717: -- Output Parameters
4718: -- x_locid locator or null if error occurred
4719: ******************************************************************/
4720:
4721: FUNCTION getloc(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_locctrl NUMBER, p_segmentarray fnd_flex_ext.segmentarray) return BOOLEAN is
4722: l_nseg NUMBER;
4723: l_seglist fnd_flex_key_api.segment_list;
4724: l_fftype fnd_flex_key_api.flexfield_type;
4725: l_ffstru fnd_flex_key_api.structure_type;

Line 4738: l_segmentarray fnd_flex_ext.segmentarray;

4734: l_val BOOLEAN := FALSE;
4735: DYNAMIC CONSTANT NUMBER := 3;
4736: l_operation VARCHAR2(100);
4737: -- Local array to hold the data for getting the cancatenated segment.
4738: l_segmentarray fnd_flex_ext.segmentarray;
4739: BEGIN
4740:
4741: fnd_flex_key_api.set_session_mode('seed_data');
4742:

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

4767: l_segmentarray(l_loop) := p_segmentarray(To_number(Substr(l_segment_type.column_name, 8)));
4768: END LOOP;
4769: -- Bug Fix#4747090
4770: -- Gets the encoded cancatenated string
4771: l_locator := fnd_flex_ext.concatenate_segments(n_segments => l_nseg,
4772: segments => l_segmentarray,
4773: delimiter => l_delim);
4774: IF (l_debug = 1) THEN
4775: inv_log_util.trace('Locator is : ' || l_locator, 'INV_TXN_MANAGER_GRP','1');

Line 4840: l_segs1 fnd_flex_ext.segmentArray;

4836: -- Output Parameters
4837: -- x_locator locator or null if error occurred
4838: ******************************************************************/
4839: FUNCTION getlocid(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_subinv VARCHAR2, p_rowid VARCHAR2, p_locctrl NUMBER) return BOOLEAN is
4840: l_segs1 fnd_flex_ext.segmentArray;
4841: l_error_exp VARCHAR2(250);
4842: l_locid number;
4843: begin
4844:

Line 4918: l_segs1 fnd_flex_ext.segmentArray;

4914: -- x_locator locator or null if error occurred
4915: ******************************************************************/
4916:
4917: FUNCTION getxlocid(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_subinv VARCHAR2, p_rowid VARCHAR2, p_locctrl NUMBER) return BOOLEAN is
4918: l_segs1 fnd_flex_ext.segmentArray;
4919: l_error_exp VARCHAR2(250);
4920: l_locid number;
4921: begin
4922:

Line 4997: l_segs1 fnd_flex_ext.segmentArray;

4993: -- Output Parameters
4994: -- x_locator locator or null if error occurred
4995: ******************************************************************/
4996: FUNCTION getplocid(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_subinv VARCHAR2, p_rowid VARCHAR2, p_locctrl NUMBER) return BOOLEAN is
4997: l_segs1 fnd_flex_ext.segmentArray;
4998: l_error_exp VARCHAR2(250);
4999: l_locid number;
5000: begin
5001:

Line 5080: l_segs1 fnd_flex_ext.segmentArray;

5076: -- x_locator locator or null if error occurred
5077: ******************************************************************/
5078:
5079: FUNCTION getxplocid(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_subinv VARCHAR2, p_rowid VARCHAR2, p_locctrl NUMBER) return BOOLEAN is
5080: l_segs1 fnd_flex_ext.segmentArray;
5081: l_error_exp VARCHAR2(250);
5082: l_locid number;
5083: begin
5084: