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.JTF_ASSIGN_PUB dependencies on JTF_VARCHAR2_TABLE_100

Line 228: l_resource_type IN JTF_VARCHAR2_TABLE_100,

224:
225: PROCEDURE table_copy_in
226: (
227: l_engineer_id IN JTF_NUMBER_TABLE,
228: l_resource_type IN JTF_VARCHAR2_TABLE_100,
229: l_primary_flag IN JTF_VARCHAR2_TABLE_100,
230: l_resource_class IN JTF_VARCHAR2_TABLE_100,
231: l_con_preferred_engineers_tbl OUT NOCOPY JTF_ASSIGN_PUB.prfeng_tbl_type
232: )

Line 229: l_primary_flag IN JTF_VARCHAR2_TABLE_100,

225: PROCEDURE table_copy_in
226: (
227: l_engineer_id IN JTF_NUMBER_TABLE,
228: l_resource_type IN JTF_VARCHAR2_TABLE_100,
229: l_primary_flag IN JTF_VARCHAR2_TABLE_100,
230: l_resource_class IN JTF_VARCHAR2_TABLE_100,
231: l_con_preferred_engineers_tbl OUT NOCOPY JTF_ASSIGN_PUB.prfeng_tbl_type
232: )
233: IS

Line 230: l_resource_class IN JTF_VARCHAR2_TABLE_100,

226: (
227: l_engineer_id IN JTF_NUMBER_TABLE,
228: l_resource_type IN JTF_VARCHAR2_TABLE_100,
229: l_primary_flag IN JTF_VARCHAR2_TABLE_100,
230: l_resource_class IN JTF_VARCHAR2_TABLE_100,
231: l_con_preferred_engineers_tbl OUT NOCOPY JTF_ASSIGN_PUB.prfeng_tbl_type
232: )
233: IS
234:

Line 1726: l_resource_type JTF_VARCHAR2_TABLE_100;

1722: l_msg_count NUMBER;
1723: l_msg_data VARCHAR2(2000);
1724:
1725: l_engineer_id JTF_NUMBER_TABLE;
1726: l_resource_type JTF_VARCHAR2_TABLE_100;
1727: l_primary_flag JTF_VARCHAR2_TABLE_100;
1728: l_resource_class JTF_VARCHAR2_TABLE_100;
1729:
1730: l_current_record INTEGER := 0;

Line 1727: l_primary_flag JTF_VARCHAR2_TABLE_100;

1723: l_msg_data VARCHAR2(2000);
1724:
1725: l_engineer_id JTF_NUMBER_TABLE;
1726: l_resource_type JTF_VARCHAR2_TABLE_100;
1727: l_primary_flag JTF_VARCHAR2_TABLE_100;
1728: l_resource_class JTF_VARCHAR2_TABLE_100;
1729:
1730: l_current_record INTEGER := 0;
1731: l_current_rec INTEGER := 0;

Line 1728: l_resource_class JTF_VARCHAR2_TABLE_100;

1724:
1725: l_engineer_id JTF_NUMBER_TABLE;
1726: l_resource_type JTF_VARCHAR2_TABLE_100;
1727: l_primary_flag JTF_VARCHAR2_TABLE_100;
1728: l_resource_class JTF_VARCHAR2_TABLE_100;
1729:
1730: l_current_record INTEGER := 0;
1731: l_current_rec INTEGER := 0;
1732: l_pref_record INTEGER := 0;

Line 1806: l_resource_type JTF_VARCHAR2_TABLE_100;

1802: DECLARE
1803:
1804: l_con_preferred_engineers_tbl OKS_ENTITLEMENTS_PUB.prfeng_tbl_type;
1805: l_engineer_id JTF_NUMBER_TABLE;
1806: l_resource_type JTF_VARCHAR2_TABLE_100;
1807: l_primary_flag JTF_VARCHAR2_TABLE_100;
1808: l_resource_class JTF_VARCHAR2_TABLE_100;
1809: l_return_status VARCHAR2(10);
1810: l_msg_count NUMBER;

Line 1807: l_primary_flag JTF_VARCHAR2_TABLE_100;

1803:
1804: l_con_preferred_engineers_tbl OKS_ENTITLEMENTS_PUB.prfeng_tbl_type;
1805: l_engineer_id JTF_NUMBER_TABLE;
1806: l_resource_type JTF_VARCHAR2_TABLE_100;
1807: l_primary_flag JTF_VARCHAR2_TABLE_100;
1808: l_resource_class JTF_VARCHAR2_TABLE_100;
1809: l_return_status VARCHAR2(10);
1810: l_msg_count NUMBER;
1811: l_msg_data VARCHAR2(2000);

Line 1808: l_resource_class JTF_VARCHAR2_TABLE_100;

1804: l_con_preferred_engineers_tbl OKS_ENTITLEMENTS_PUB.prfeng_tbl_type;
1805: l_engineer_id JTF_NUMBER_TABLE;
1806: l_resource_type JTF_VARCHAR2_TABLE_100;
1807: l_primary_flag JTF_VARCHAR2_TABLE_100;
1808: l_resource_class JTF_VARCHAR2_TABLE_100;
1809: l_return_status VARCHAR2(10);
1810: l_msg_count NUMBER;
1811: l_msg_data VARCHAR2(2000);
1812:

Line 1853: l_resource_type := JTF_VARCHAR2_TABLE_100();

1849:
1850: IF l_con_preferred_engineers_tbl IS NULL OR
1851: l_con_preferred_engineers_tbl.count = 0 THEN
1852: l_engineer_id := JTF_NUMBER_TABLE();
1853: l_resource_type := JTF_VARCHAR2_TABLE_100();
1854: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1855: l_resource_class := JTF_VARCHAR2_TABLE_100();
1856:
1857: ELSE

Line 1854: l_primary_flag := JTF_VARCHAR2_TABLE_100();

1850: IF l_con_preferred_engineers_tbl IS NULL OR
1851: l_con_preferred_engineers_tbl.count = 0 THEN
1852: l_engineer_id := JTF_NUMBER_TABLE();
1853: l_resource_type := JTF_VARCHAR2_TABLE_100();
1854: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1855: l_resource_class := JTF_VARCHAR2_TABLE_100();
1856:
1857: ELSE
1858: l_engineer_id := JTF_NUMBER_TABLE();

Line 1855: l_resource_class := JTF_VARCHAR2_TABLE_100();

1851: l_con_preferred_engineers_tbl.count = 0 THEN
1852: l_engineer_id := JTF_NUMBER_TABLE();
1853: l_resource_type := JTF_VARCHAR2_TABLE_100();
1854: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1855: l_resource_class := JTF_VARCHAR2_TABLE_100();
1856:
1857: ELSE
1858: l_engineer_id := JTF_NUMBER_TABLE();
1859: l_resource_type := JTF_VARCHAR2_TABLE_100();

Line 1859: l_resource_type := JTF_VARCHAR2_TABLE_100();

1855: l_resource_class := JTF_VARCHAR2_TABLE_100();
1856:
1857: ELSE
1858: l_engineer_id := JTF_NUMBER_TABLE();
1859: l_resource_type := JTF_VARCHAR2_TABLE_100();
1860: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1861: l_resource_class := JTF_VARCHAR2_TABLE_100();
1862:
1863: IF l_con_preferred_engineers_tbl.count > 0 THEN

Line 1860: l_primary_flag := JTF_VARCHAR2_TABLE_100();

1856:
1857: ELSE
1858: l_engineer_id := JTF_NUMBER_TABLE();
1859: l_resource_type := JTF_VARCHAR2_TABLE_100();
1860: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1861: l_resource_class := JTF_VARCHAR2_TABLE_100();
1862:
1863: IF l_con_preferred_engineers_tbl.count > 0 THEN
1864: l_engineer_id.extend(l_con_preferred_engineers_tbl.count);

Line 1861: l_resource_class := JTF_VARCHAR2_TABLE_100();

1857: ELSE
1858: l_engineer_id := JTF_NUMBER_TABLE();
1859: l_resource_type := JTF_VARCHAR2_TABLE_100();
1860: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1861: l_resource_class := JTF_VARCHAR2_TABLE_100();
1862:
1863: IF l_con_preferred_engineers_tbl.count > 0 THEN
1864: l_engineer_id.extend(l_con_preferred_engineers_tbl.count);
1865: l_resource_type.extend(l_con_preferred_engineers_tbl.count);

Line 2148: l_resource_type JTF_VARCHAR2_TABLE_100;

2144: l_msg_count NUMBER;
2145: l_msg_data VARCHAR2(2000);
2146:
2147: l_engineer_id JTF_NUMBER_TABLE;
2148: l_resource_type JTF_VARCHAR2_TABLE_100;
2149:
2150: l_current_record INTEGER := 0;
2151: l_current_rec INTEGER := 0;
2152: l_pref_record INTEGER := 0;

Line 2697: l_resource_type JTF_VARCHAR2_TABLE_100;

2693: l_assign_resources_sr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
2694: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2695:
2696: l_engineer_id JTF_NUMBER_TABLE;
2697: l_resource_type JTF_VARCHAR2_TABLE_100;
2698:
2699: l_return_status VARCHAR2(10);
2700: l_msg_count NUMBER;
2701: l_msg_data VARCHAR2(2000);