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 ECE_FLATFILE_PVT

Line 852: p_key_tbl IN ece_flatfile_pvt.Interface_tbl_type,

848: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
849: p_return_status OUT NOCOPY VARCHAR2,
850: p_msg_count OUT NOCOPY NUMBER,
851: p_msg_data OUT NOCOPY VARCHAR2,
852: p_key_tbl IN ece_flatfile_pvt.Interface_tbl_type,
853: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type) IS
854:
855: l_api_name CONSTANT VARCHAR2(30) := 'populate_plsql_tbl_with_extval';
856: l_api_version_number CONSTANT NUMBER := 1.0;

Line 853: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type) IS

849: p_return_status OUT NOCOPY VARCHAR2,
850: p_msg_count OUT NOCOPY NUMBER,
851: p_msg_data OUT NOCOPY VARCHAR2,
852: p_key_tbl IN ece_flatfile_pvt.Interface_tbl_type,
853: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type) IS
854:
855: l_api_name CONSTANT VARCHAR2(30) := 'populate_plsql_tbl_with_extval';
856: l_api_version_number CONSTANT NUMBER := 1.0;
857:

Line 1073: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1069: THEN
1070: if EC_DEBUG.G_debug_level = 3 then
1071: EC_DEBUG.PL(3, 'ext1 :', ext1);
1072: end if;
1073: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1074: (p_gateway_tbl => p_tbl,
1075: p_conversion_group => p_tbl(i).conversion_group_id,
1076: p_sequence_num => 1,
1077: p_Pos => l_ext_pos);

Line 1089: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1085: THEN
1086: if EC_DEBUG.G_debug_level = 3 then
1087: EC_DEBUG.PL(3, 'ext2 :', ext2);
1088: end if;
1089: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1090: (p_gateway_tbl => p_tbl,
1091: p_conversion_group => p_tbl(i).conversion_group_id,
1092: p_sequence_num => 2,
1093: p_Pos => l_ext_pos);

Line 1105: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1101: THEN
1102: if EC_DEBUG.G_debug_level = 3 then
1103: EC_DEBUG.PL(3, 'ext3 :', ext3);
1104: end if;
1105: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1106: (p_gateway_tbl => p_tbl,
1107: p_conversion_group => p_tbl(i).conversion_group_id,
1108: p_sequence_num => 3,
1109: p_Pos => l_ext_pos);

Line 1121: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1117: THEN
1118: if EC_DEBUG.G_debug_level = 3 then
1119: EC_DEBUG.PL(3, 'ext4 :', ext4);
1120: end if;
1121: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1122: (p_gateway_tbl => p_tbl,
1123: p_conversion_group => p_tbl(i).conversion_group_id,
1124: p_sequence_num => 4,
1125: p_Pos => l_ext_pos);

Line 1137: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1133: THEN
1134: if EC_DEBUG.G_debug_level = 3 then
1135: EC_DEBUG.PL(3, 'ext5 :', ext5);
1136: end if;
1137: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1138: (p_gateway_tbl => p_tbl,
1139: p_conversion_group => p_tbl(i).conversion_group_id,
1140: p_sequence_num => 5,
1141: p_Pos => l_ext_pos);

Line 1153: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1149: -- there is no category code assigned to the interface column and
1150: -- the external value1 is null.
1151:
1152: ELSIF (p_tbl(i).conversion_seq = 0) THEN
1153: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1154: (p_gateway_tbl => p_tbl,
1155: p_conversion_group => p_tbl(i).conversion_group_id,
1156: p_sequence_num => 1,
1157: p_Pos => l_ext_pos);

Line 1466: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1462: THEN
1463: if EC_DEBUG.G_debug_level = 3 then
1464: EC_DEBUG.PL(3, 'ext1 :', ext1);
1465: end if;
1466: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1467: (p_level => p_level,
1468: p_conversion_group => p_tbl(i).conversion_group_id,
1469: p_sequence_num => 1,
1470: p_Pos => l_ext_pos);

Line 1482: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1478: THEN
1479: if EC_DEBUG.G_debug_level = 3 then
1480: EC_DEBUG.PL(3, 'ext2 :', ext2);
1481: end if;
1482: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1483: (p_level => p_level,
1484: p_conversion_group => p_tbl(i).conversion_group_id,
1485: p_sequence_num => 2,
1486: p_Pos => l_ext_pos);

Line 1498: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1494: THEN
1495: if EC_DEBUG.G_debug_level = 3 then
1496: EC_DEBUG.PL(3, 'ext3 :', ext3);
1497: end if;
1498: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1499: (p_level => p_level,
1500: p_conversion_group => p_tbl(i).conversion_group_id,
1501: p_sequence_num => 3,
1502: p_Pos => l_ext_pos);

Line 1514: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1510: THEN
1511: if EC_DEBUG.G_debug_level = 3 then
1512: EC_DEBUG.PL(3, 'ext4 :', ext4);
1513: end if;
1514: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1515: (p_level => p_level,
1516: p_conversion_group => p_tbl(i).conversion_group_id,
1517: p_sequence_num => 4,
1518: p_Pos => l_ext_pos);

Line 1530: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1526: THEN
1527: if EC_DEBUG.G_debug_level = 3 then
1528: EC_DEBUG.PL(3, 'ext5 :', ext5);
1529: end if;
1530: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1531: (p_level => p_level,
1532: p_conversion_group => p_tbl(i).conversion_group_id,
1533: p_sequence_num => 5,
1534: p_Pos => l_ext_pos);

Line 1546: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1542: -- there is no category code assigned to the interface column and
1543: -- the external value1 is null.
1544:
1545: ELSIF (p_tbl(i).conversion_sequence = 0) THEN
1546: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1547: (p_level => p_level,
1548: p_conversion_group => p_tbl(i).conversion_group_id,
1549: p_sequence_num => 1,
1550: p_Pos => l_ext_pos);

Line 1614: p_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

1610: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1611: p_return_status OUT NOCOPY VARCHAR2,
1612: p_msg_count OUT NOCOPY NUMBER,
1613: p_msg_data OUT NOCOPY VARCHAR2,
1614: p_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
1615: p_apps_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type) IS
1616:
1617: l_api_name CONSTANT VARCHAR2(30) := 'populate_plsql_tbl_with_intval';
1618: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1615: p_apps_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type) IS

1611: p_return_status OUT NOCOPY VARCHAR2,
1612: p_msg_count OUT NOCOPY NUMBER,
1613: p_msg_data OUT NOCOPY VARCHAR2,
1614: p_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
1615: p_apps_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type) IS
1616:
1617: l_api_name CONSTANT VARCHAR2(30) := 'populate_plsql_tbl_with_intval';
1618: l_api_version_number CONSTANT NUMBER := 1.0;
1619:

Line 1742: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1738: -- We're going to go through each of the Conversion Seqs and
1739: -- see if they exist or not.
1740:
1741: -- 1
1742: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1743: (p_gateway_tbl => p_apps_tbl,
1744: p_conversion_group => p_apps_tbl(j).conversion_group_id,
1745: p_sequence_num => 1,
1746: p_Pos => l_int_data_loc_pos);

Line 1756: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1752: end if;
1753: END IF;
1754:
1755: -- 2
1756: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1757: (p_gateway_tbl => p_apps_tbl,
1758: p_conversion_group => p_apps_tbl(j).conversion_group_id,
1759: p_sequence_num => 2,
1760: p_Pos => l_int_data_loc_pos);

Line 1770: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1766: end if;
1767: END IF;
1768:
1769: -- 3
1770: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1771: (p_gateway_tbl => p_apps_tbl,
1772: p_conversion_group => p_apps_tbl(j).conversion_group_id,
1773: p_sequence_num => 3,
1774: p_Pos => l_int_data_loc_pos);

Line 1784: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1780: end if;
1781: END IF;
1782:
1783: -- 4
1784: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1785: (p_gateway_tbl => p_apps_tbl,
1786: p_conversion_group => p_apps_tbl(j).conversion_group_id,
1787: p_sequence_num => 4,
1788: p_Pos => l_int_data_loc_pos);

Line 1798: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1794: end if;
1795: END IF;
1796:
1797: -- 5
1798: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1799: (p_gateway_tbl => p_apps_tbl,
1800: p_conversion_group => p_apps_tbl(j).conversion_group_id,
1801: p_sequence_num => 5,
1802: p_Pos => l_int_data_loc_pos);

Line 1978: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

1974: ELSIF (p_apps_tbl(j).xref_category_id is NULL AND
1975: p_apps_tbl(j).conversion_seq = 0 AND
1976: p_apps_tbl(j).value is NULL) THEN
1977:
1978: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1979: (
1980: p_gateway_tbl => p_apps_tbl,
1981: p_conversion_group => p_apps_tbl(j).conversion_group_id,
1982: p_sequence_num => 1,

Line 2156: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

2152:
2153: IF p_apps_tbl(j).conversion_sequence = 0 AND
2154: p_apps_tbl(j).value is NULL THEN
2155:
2156: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
2157: (
2158: p_level => p_level,
2159: p_conversion_group => p_apps_tbl(j).conversion_group_id,
2160: p_sequence_num => 1,

Line 2205: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

2201: -- We're going to go through each of the Conversion Seqs and
2202: -- see if they exist or not.
2203:
2204: -- 1
2205: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
2206: (
2207: p_level => p_level ,
2208: p_conversion_group => p_apps_tbl(j).conversion_group_id,
2209: p_sequence_num => 1,

Line 2218: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

2214: c_ext_value1 := p_apps_tbl(l_int_data_loc_pos).value;
2215: END IF;
2216:
2217: -- 2
2218: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
2219: (
2220: p_level => p_level ,
2221: p_conversion_group => p_apps_tbl(j).conversion_group_id,
2222: p_sequence_num => 2,

Line 2231: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

2227: c_ext_value2 := p_apps_tbl(l_int_data_loc_pos).value;
2228: END IF;
2229:
2230: -- 3
2231: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
2232: (
2233: p_level => p_level ,
2234: p_conversion_group => p_apps_tbl(j).conversion_group_id,
2235: p_sequence_num => 3,

Line 2244: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

2240: c_ext_value3 := p_apps_tbl(l_int_data_loc_pos).value;
2241: END IF;
2242:
2243: -- 4
2244: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
2245: (
2246: p_level => p_level ,
2247: p_conversion_group => p_apps_tbl(j).conversion_group_id,
2248: p_sequence_num => 4,

Line 2257: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

2253: c_ext_value4 := p_apps_tbl(l_int_data_loc_pos).value;
2254: END IF;
2255:
2256: -- 5
2257: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
2258: (
2259: p_level => p_level ,
2260: p_conversion_group => p_apps_tbl(j).conversion_group_id,
2261: p_sequence_num => 5,

Line 2456: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

2452: if EC_DEBUG.G_debug_level >= 3 then
2453: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);
2454: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);
2455: end if;
2456: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
2457: (
2458: p_level => p_level,
2459: p_conversion_group => p_apps_tbl(j).conversion_group_id,
2460: p_sequence_num => 1,