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.EC_CODE_CONVERSION_PVT dependencies on EC_UTILS

Line 1221: p_tbl IN OUT NOCOPY ec_utils.mapping_tbl,

1217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1218: p_return_status OUT NOCOPY VARCHAR2,
1219: p_msg_count OUT NOCOPY NUMBER,
1220: p_msg_data OUT NOCOPY VARCHAR2,
1221: p_tbl IN OUT NOCOPY ec_utils.mapping_tbl,
1222: p_level IN NUMBER) IS
1223:
1224: l_api_name CONSTANT VARCHAR2(30) := 'populate_plsql_tbl_with_extval';
1225: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1306: FOR i IN ec_utils.g_int_levels(p_level).file_start_pos..ec_utils.g_int_levels(p_level).file_end_pos

1302: -- table to fill in the ext1-5 value
1303: -- *******************************************************
1304: icount := p_tbl.COUNT;
1305:
1306: FOR i IN ec_utils.g_int_levels(p_level).file_start_pos..ec_utils.g_int_levels(p_level).file_end_pos
1307: LOOP
1308: IF (p_tbl(i).xref_category_id IS NOT NULL) THEN
1309: -- use this xref_id, go to ece_xref_category to find out all the
1310: -- enabled keys

Line 1332: FOR k IN ec_utils.g_int_levels(j).file_start_pos..ec_utils.g_int_levels(j).file_end_pos

1328: -- Bug 2828072
1329: IF ckey1_used_flag = 'Y' AND
1330: p_tbl(i).xref_key1_source_column IS NOT NULL THEN
1331: FOR j IN REVERSE 1..p_level LOOP
1332: FOR k IN ec_utils.g_int_levels(j).file_start_pos..ec_utils.g_int_levels(j).file_end_pos
1333: LOOP
1334: IF p_tbl(i).xref_key1_source_column =
1335: p_tbl(k).interface_column_name THEN
1336: key1 := p_tbl(k).value;

Line 1350: FOR k IN ec_utils.g_int_levels(j).file_start_pos..ec_utils.g_int_levels(j).file_end_pos

1346:
1347: IF ckey2_used_flag = 'Y' AND
1348: p_tbl(i).xref_key2_source_column IS NOT NULL THEN
1349: FOR j IN REVERSE 1..p_level LOOP
1350: FOR k IN ec_utils.g_int_levels(j).file_start_pos..ec_utils.g_int_levels(j).file_end_pos
1351: LOOP
1352: IF p_tbl(i).xref_key2_source_column =
1353: p_tbl(k).interface_column_name THEN
1354: key2 := p_tbl(k).value;

Line 1367: FOR k IN ec_utils.g_int_levels(j).file_start_pos..ec_utils.g_int_levels(j).file_end_pos

1363:
1364: IF ckey3_used_flag = 'Y' AND
1365: p_tbl(i).xref_key3_source_column IS NOT NULL THEN
1366: FOR j IN REVERSE 1..p_level LOOP
1367: FOR k IN ec_utils.g_int_levels(j).file_start_pos..ec_utils.g_int_levels(j).file_end_pos
1368: LOOP
1369: IF p_tbl(i).xref_key3_source_column =
1370: p_tbl(k).interface_column_name THEN
1371: key3 := p_tbl(k).value;

Line 1384: FOR k IN ec_utils.g_int_levels(j).file_start_pos..ec_utils.g_int_levels(j).file_end_pos

1380:
1381: IF ckey4_used_flag = 'Y' AND
1382: p_tbl(i).xref_key4_source_column IS NOT NULL THEN
1383: FOR j IN REVERSE 1..p_level LOOP
1384: FOR k IN ec_utils.g_int_levels(j).file_start_pos..ec_utils.g_int_levels(j).file_end_pos
1385: LOOP
1386: IF p_tbl(i).xref_key4_source_column =
1387: p_tbl(k).interface_column_name THEN
1388: key4 := p_tbl(k).value;

Line 1401: FOR k IN ec_utils.g_int_levels(j).file_start_pos..ec_utils.g_int_levels(j).file_end_pos

1397:
1398: IF ckey5_used_flag = 'Y' AND
1399: p_tbl(i).xref_key5_source_column IS NOT NULL THEN
1400: FOR j IN REVERSE 1..p_level LOOP
1401: FOR k IN ec_utils.g_int_levels(j).file_start_pos..ec_utils.g_int_levels(j).file_end_pos
1402: LOOP
1403: IF p_tbl(i).xref_key5_source_column =
1404: p_tbl(k).interface_column_name THEN
1405: key5 := p_tbl(k).value;

Line 2054: p_apps_tbl IN OUT NOCOPY ec_utils.mapping_tbl,

2050: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2051: p_return_status OUT NOCOPY VARCHAR2,
2052: p_msg_count OUT NOCOPY NUMBER,
2053: p_msg_data OUT NOCOPY VARCHAR2,
2054: p_apps_tbl IN OUT NOCOPY ec_utils.mapping_tbl,
2055: p_level IN NUMBER
2056: ) IS
2057:
2058:

Line 2142: for j in ec_utils.g_ext_levels(p_level).file_start_pos..ec_utils.g_ext_levels(p_level).file_end_pos

2138: -- *******************************************************
2139: -- Move data from interface to source PL/SQL table
2140: -- These are data that do not need xref.
2141: -- *******************************************************
2142: for j in ec_utils.g_ext_levels(p_level).file_start_pos..ec_utils.g_ext_levels(p_level).file_end_pos
2143: LOOP
2144:
2145: -- This is to copy the external value1 to internal value if
2146: -- there is no category code assigned to the interface column and

Line 2312: FOR i in ec_utils.g_ext_levels(k).file_start_pos..ec_utils.g_ext_levels(k).file_end_pos

2308: -- Bug 2828072
2309: IF ckey1_used_flag = 'Y' AND
2310: p_apps_tbl(j).xref_key1_source_column IS NOT NULL THEN
2311: FOR k IN REVERSE 1..p_level LOOP
2312: FOR i in ec_utils.g_ext_levels(k).file_start_pos..ec_utils.g_ext_levels(k).file_end_pos
2313: LOOP
2314: IF p_apps_tbl(j).xref_key1_source_column =
2315: p_apps_tbl(i).interface_column_name THEN
2316: key1 := p_apps_tbl(i).value;

Line 2331: FOR i in ec_utils.g_ext_levels(k).file_start_pos..ec_utils.g_ext_levels(k).file_end_pos

2327: -- 2
2328: IF ckey2_used_flag = 'Y' AND
2329: p_apps_tbl(j).xref_key2_source_column IS NOT NULL THEN
2330: FOR k IN REVERSE 1..p_level LOOP
2331: FOR i in ec_utils.g_ext_levels(k).file_start_pos..ec_utils.g_ext_levels(k).file_end_pos
2332: LOOP
2333: IF p_apps_tbl(j).xref_key2_source_column =
2334: p_apps_tbl(i).interface_column_name THEN
2335: key2 := p_apps_tbl(i).value;

Line 2349: FOR i in ec_utils.g_ext_levels(k).file_start_pos..ec_utils.g_ext_levels(k).file_end_pos

2345: -- 3
2346: IF ckey3_used_flag = 'Y' AND
2347: p_apps_tbl(j).xref_key3_source_column IS NOT NULL THEN
2348: FOR k IN REVERSE 1..p_level LOOP
2349: FOR i in ec_utils.g_ext_levels(k).file_start_pos..ec_utils.g_ext_levels(k).file_end_pos
2350: LOOP
2351: IF p_apps_tbl(j).xref_key3_source_column =
2352: p_apps_tbl(i).interface_column_name THEN --bug 4136922
2353: key3 := p_apps_tbl(i).value;

Line 2367: FOR i in ec_utils.g_ext_levels(k).file_start_pos..ec_utils.g_ext_levels(k).file_end_pos

2363: -- 4
2364: IF ckey4_used_flag = 'Y' AND
2365: p_apps_tbl(j).xref_key4_source_column IS NOT NULL THEN
2366: FOR k IN REVERSE 1..p_level LOOP
2367: FOR i in ec_utils.g_ext_levels(k).file_start_pos..ec_utils.g_ext_levels(k).file_end_pos
2368: LOOP
2369: IF p_apps_tbl(j).xref_key4_source_column =
2370: p_apps_tbl(i).interface_column_name THEN
2371: key4 := p_apps_tbl(i).value;

Line 2385: FOR i in ec_utils.g_ext_levels(k).file_start_pos..ec_utils.g_ext_levels(k).file_end_pos

2381: -- 5
2382: IF ckey5_used_flag = 'Y' AND
2383: p_apps_tbl(j).xref_key5_source_column IS NOT NULL THEN
2384: FOR k IN REVERSE 1..p_level LOOP
2385: FOR i in ec_utils.g_ext_levels(k).file_start_pos..ec_utils.g_ext_levels(k).file_end_pos
2386: LOOP
2387: IF p_apps_tbl(j).xref_key5_source_column =
2388: p_apps_tbl(i).interface_column_name THEN
2389: key5 := p_apps_tbl(i).value;