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

Line 1142: seg_low fnd_flex_ext.SegmentArray;

1138: v_proj_ref_enabled Number := Null;
1139: Rec Boolean := FALSE;
1140: comma varchar2(1) := '''';
1141:
1142: seg_low fnd_flex_ext.SegmentArray;
1143: seg_high fnd_flex_ext.SegmentArray;
1144:
1145: Cursor CUR1(v_struct_num Number) is
1146: select a.application_column_name, b.format_type

Line 1143: seg_high fnd_flex_ext.SegmentArray;

1139: Rec Boolean := FALSE;
1140: comma varchar2(1) := '''';
1141:
1142: seg_low fnd_flex_ext.SegmentArray;
1143: seg_high fnd_flex_ext.SegmentArray;
1144:
1145: Cursor CUR1(v_struct_num Number) is
1146: select a.application_column_name, b.format_type
1147: from FND_ID_FLEX_SEGMENTS_VL a, FND_FLEX_VALUE_SETS b

Line 1170: v_delim := fnd_flex_ext.get_delimiter('INV','MTLL', v_flex_num);

1166: Select project_reference_enabled into v_proj_ref_enabled
1167: from MTL_PARAMETERS
1168: where organization_id = X_org_id;
1169:
1170: v_delim := fnd_flex_ext.get_delimiter('INV','MTLL', v_flex_num);
1171:
1172: v_num := fnd_flex_ext.breakup_segments( X_locator_lo, v_delim, seg_low);
1173: v_num := fnd_flex_ext.breakup_segments( X_locator_hi, v_delim, seg_high);
1174:

Line 1172: v_num := fnd_flex_ext.breakup_segments( X_locator_lo, v_delim, seg_low);

1168: where organization_id = X_org_id;
1169:
1170: v_delim := fnd_flex_ext.get_delimiter('INV','MTLL', v_flex_num);
1171:
1172: v_num := fnd_flex_ext.breakup_segments( X_locator_lo, v_delim, seg_low);
1173: v_num := fnd_flex_ext.breakup_segments( X_locator_hi, v_delim, seg_high);
1174:
1175:
1176: -- bug 4662395 set the profile mfg_organization_id so

Line 1173: v_num := fnd_flex_ext.breakup_segments( X_locator_hi, v_delim, seg_high);

1169:
1170: v_delim := fnd_flex_ext.get_delimiter('INV','MTLL', v_flex_num);
1171:
1172: v_num := fnd_flex_ext.breakup_segments( X_locator_lo, v_delim, seg_low);
1173: v_num := fnd_flex_ext.breakup_segments( X_locator_hi, v_delim, seg_high);
1174:
1175:
1176: -- bug 4662395 set the profile mfg_organization_id so
1177: -- the call to MTL_PROJECT_V will return data.

Line 1267: seg_low fnd_flex_ext.SegmentArray;

1263: v_flex_num Number := Null;
1264: Rec Boolean := FALSE;
1265: comma varchar2(1) := '''';
1266:
1267: seg_low fnd_flex_ext.SegmentArray;
1268: seg_high fnd_flex_ext.SegmentArray;
1269:
1270:
1271:

Line 1268: seg_high fnd_flex_ext.SegmentArray;

1264: Rec Boolean := FALSE;
1265: comma varchar2(1) := '''';
1266:
1267: seg_low fnd_flex_ext.SegmentArray;
1268: seg_high fnd_flex_ext.SegmentArray;
1269:
1270:
1271:
1272: Cursor CUR1(v_struct_num Number) is

Line 1292: v_delim := fnd_flex_ext.get_delimiter('INV','MSTK',v_flex_num);

1288: Select id_flex_num into v_flex_num
1289: from fnd_id_flex_structures
1290: where id_flex_code = 'MSTK';
1291:
1292: v_delim := fnd_flex_ext.get_delimiter('INV','MSTK',v_flex_num);
1293: v_num := fnd_flex_ext.breakup_segments( X_item_lo, v_delim, seg_low);
1294: v_num := fnd_flex_ext.breakup_segments( X_item_hi, v_delim, seg_high);
1295:
1296: -- Building the where clause

Line 1293: v_num := fnd_flex_ext.breakup_segments( X_item_lo, v_delim, seg_low);

1289: from fnd_id_flex_structures
1290: where id_flex_code = 'MSTK';
1291:
1292: v_delim := fnd_flex_ext.get_delimiter('INV','MSTK',v_flex_num);
1293: v_num := fnd_flex_ext.breakup_segments( X_item_lo, v_delim, seg_low);
1294: v_num := fnd_flex_ext.breakup_segments( X_item_hi, v_delim, seg_high);
1295:
1296: -- Building the where clause
1297:

Line 1294: v_num := fnd_flex_ext.breakup_segments( X_item_hi, v_delim, seg_high);

1290: where id_flex_code = 'MSTK';
1291:
1292: v_delim := fnd_flex_ext.get_delimiter('INV','MSTK',v_flex_num);
1293: v_num := fnd_flex_ext.breakup_segments( X_item_lo, v_delim, seg_low);
1294: v_num := fnd_flex_ext.breakup_segments( X_item_hi, v_delim, seg_high);
1295:
1296: -- Building the where clause
1297:
1298: for CUR2 in CUR1(v_flex_num) Loop

Line 1469: v_delim := fnd_flex_ext.get_delimiter('INV',v_flex_code, v_flex_num);

1465: -- the call to MTL_PROJECT_V will return data.
1466:
1467: FND_PROFILE.put('MFG_ORGANIZATION_ID',X_org_id);
1468:
1469: v_delim := fnd_flex_ext.get_delimiter('INV',v_flex_code, v_flex_num);
1470:
1471: str1 := '||'''||v_delim||'''||';
1472:
1473: for CUR2 in CUR1(v_flex_code) Loop