DBA Data[Home] [Help]

APPS.ECE_RULES_PKG dependencies on FND_VSET

Line 1209: l_valueset fnd_vset.valueset_r;

1205:
1206: xProgress VARCHAR2(80);
1207: l_valueset_name ece_rule_valueset.valueset_name%TYPE;
1208: l_valueset_id NUMBER := -1;
1209: l_valueset fnd_vset.valueset_r;
1210: l_format fnd_vset.valueset_dr;
1211: l_rowcount NUMBER;
1212: l_value fnd_vset.value_dr;
1213:

Line 1210: l_format fnd_vset.valueset_dr;

1206: xProgress VARCHAR2(80);
1207: l_valueset_name ece_rule_valueset.valueset_name%TYPE;
1208: l_valueset_id NUMBER := -1;
1209: l_valueset fnd_vset.valueset_r;
1210: l_format fnd_vset.valueset_dr;
1211: l_rowcount NUMBER;
1212: l_value fnd_vset.value_dr;
1213:
1214: found BOOLEAN;

Line 1212: l_value fnd_vset.value_dr;

1208: l_valueset_id NUMBER := -1;
1209: l_valueset fnd_vset.valueset_r;
1210: l_format fnd_vset.valueset_dr;
1211: l_rowcount NUMBER;
1212: l_value fnd_vset.value_dr;
1213:
1214: found BOOLEAN;
1215: match BOOLEAN := false;
1216: no_value_set EXCEPTION;

Line 1265: fnd_vset.get_valueset (l_valueset_id, l_valueset, l_format);

1261: xProgress := 'ECERULEB-80-1030';
1262: close c_flex_valueset_id;
1263:
1264: xProgress := 'ECERULEB-80-1040';
1265: fnd_vset.get_valueset (l_valueset_id, l_valueset, l_format);
1266:
1267: xProgress := 'ECERULEB-80-1050';
1268: fnd_vset.get_value_init (l_valueset, TRUE);
1269:

Line 1268: fnd_vset.get_value_init (l_valueset, TRUE);

1264: xProgress := 'ECERULEB-80-1040';
1265: fnd_vset.get_valueset (l_valueset_id, l_valueset, l_format);
1266:
1267: xProgress := 'ECERULEB-80-1050';
1268: fnd_vset.get_value_init (l_valueset, TRUE);
1269:
1270: xProgress := 'ECERULEB-80-1060';
1271: fnd_vset.get_value (l_valueset, l_rowcount, found, l_value);
1272:

Line 1271: fnd_vset.get_value (l_valueset, l_rowcount, found, l_value);

1267: xProgress := 'ECERULEB-80-1050';
1268: fnd_vset.get_value_init (l_valueset, TRUE);
1269:
1270: xProgress := 'ECERULEB-80-1060';
1271: fnd_vset.get_value (l_valueset, l_rowcount, found, l_value);
1272:
1273: while (found) loop
1274: if ec_debug.G_debug_level = 3 then
1275: ec_debug.pl (3, 'valueset_value', l_value.value);

Line 1285: fnd_vset.get_value (l_valueset, l_rowcount, found, l_value);

1281: exit;
1282: end if;
1283:
1284: xProgress := 'ECERULEB-80-1080';
1285: fnd_vset.get_value (l_valueset, l_rowcount, found, l_value);
1286: end loop;
1287:
1288: xProgress := 'ECERULEB-80-1090';
1289: if (match) then

Line 1298: fnd_vset.get_value_end (l_valueset);

1294: ec_debug.pl (3, 'EC', 'ECE_VALUE_NOT_IN_VALUESET');
1295: end if;
1296:
1297: xProgress := 'ECERULEB-80-1100';
1298: fnd_vset.get_value_end (l_valueset);
1299:
1300: if (x_valid_rule = 'N') then
1301: xProgress := 'ECERULEB-80-1110';
1302: fnd_message.set_name ('EC', 'ECE_VALUESET');