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 1689: l_resource_type JTF_VARCHAR2_TABLE_100;

1685: l_msg_count NUMBER;
1686: l_msg_data VARCHAR2(2000);
1687:
1688: l_engineer_id JTF_NUMBER_TABLE;
1689: l_resource_type JTF_VARCHAR2_TABLE_100;
1690: l_primary_flag JTF_VARCHAR2_TABLE_100;
1691: l_resource_class JTF_VARCHAR2_TABLE_100;
1692:
1693: l_current_record INTEGER := 0;

Line 1690: l_primary_flag JTF_VARCHAR2_TABLE_100;

1686: l_msg_data VARCHAR2(2000);
1687:
1688: l_engineer_id JTF_NUMBER_TABLE;
1689: l_resource_type JTF_VARCHAR2_TABLE_100;
1690: l_primary_flag JTF_VARCHAR2_TABLE_100;
1691: l_resource_class JTF_VARCHAR2_TABLE_100;
1692:
1693: l_current_record INTEGER := 0;
1694: l_current_rec INTEGER := 0;

Line 1691: l_resource_class JTF_VARCHAR2_TABLE_100;

1687:
1688: l_engineer_id JTF_NUMBER_TABLE;
1689: l_resource_type JTF_VARCHAR2_TABLE_100;
1690: l_primary_flag JTF_VARCHAR2_TABLE_100;
1691: l_resource_class JTF_VARCHAR2_TABLE_100;
1692:
1693: l_current_record INTEGER := 0;
1694: l_current_rec INTEGER := 0;
1695: l_pref_record INTEGER := 0;

Line 1769: l_resource_type JTF_VARCHAR2_TABLE_100;

1765: DECLARE
1766:
1767: l_con_preferred_engineers_tbl OKS_ENTITLEMENTS_PUB.prfeng_tbl_type;
1768: l_engineer_id JTF_NUMBER_TABLE;
1769: l_resource_type JTF_VARCHAR2_TABLE_100;
1770: l_primary_flag JTF_VARCHAR2_TABLE_100;
1771: l_resource_class JTF_VARCHAR2_TABLE_100;
1772: l_return_status VARCHAR2(10);
1773: l_msg_count NUMBER;

Line 1770: l_primary_flag JTF_VARCHAR2_TABLE_100;

1766:
1767: l_con_preferred_engineers_tbl OKS_ENTITLEMENTS_PUB.prfeng_tbl_type;
1768: l_engineer_id JTF_NUMBER_TABLE;
1769: l_resource_type JTF_VARCHAR2_TABLE_100;
1770: l_primary_flag JTF_VARCHAR2_TABLE_100;
1771: l_resource_class JTF_VARCHAR2_TABLE_100;
1772: l_return_status VARCHAR2(10);
1773: l_msg_count NUMBER;
1774: l_msg_data VARCHAR2(2000);

Line 1771: l_resource_class JTF_VARCHAR2_TABLE_100;

1767: l_con_preferred_engineers_tbl OKS_ENTITLEMENTS_PUB.prfeng_tbl_type;
1768: l_engineer_id JTF_NUMBER_TABLE;
1769: l_resource_type JTF_VARCHAR2_TABLE_100;
1770: l_primary_flag JTF_VARCHAR2_TABLE_100;
1771: l_resource_class JTF_VARCHAR2_TABLE_100;
1772: l_return_status VARCHAR2(10);
1773: l_msg_count NUMBER;
1774: l_msg_data VARCHAR2(2000);
1775:

Line 1816: l_resource_type := JTF_VARCHAR2_TABLE_100();

1812:
1813: IF l_con_preferred_engineers_tbl IS NULL OR
1814: l_con_preferred_engineers_tbl.count = 0 THEN
1815: l_engineer_id := JTF_NUMBER_TABLE();
1816: l_resource_type := JTF_VARCHAR2_TABLE_100();
1817: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1818: l_resource_class := JTF_VARCHAR2_TABLE_100();
1819:
1820: ELSE

Line 1817: l_primary_flag := JTF_VARCHAR2_TABLE_100();

1813: IF l_con_preferred_engineers_tbl IS NULL OR
1814: l_con_preferred_engineers_tbl.count = 0 THEN
1815: l_engineer_id := JTF_NUMBER_TABLE();
1816: l_resource_type := JTF_VARCHAR2_TABLE_100();
1817: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1818: l_resource_class := JTF_VARCHAR2_TABLE_100();
1819:
1820: ELSE
1821: l_engineer_id := JTF_NUMBER_TABLE();

Line 1818: l_resource_class := JTF_VARCHAR2_TABLE_100();

1814: l_con_preferred_engineers_tbl.count = 0 THEN
1815: l_engineer_id := JTF_NUMBER_TABLE();
1816: l_resource_type := JTF_VARCHAR2_TABLE_100();
1817: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1818: l_resource_class := JTF_VARCHAR2_TABLE_100();
1819:
1820: ELSE
1821: l_engineer_id := JTF_NUMBER_TABLE();
1822: l_resource_type := JTF_VARCHAR2_TABLE_100();

Line 1822: l_resource_type := JTF_VARCHAR2_TABLE_100();

1818: l_resource_class := JTF_VARCHAR2_TABLE_100();
1819:
1820: ELSE
1821: l_engineer_id := JTF_NUMBER_TABLE();
1822: l_resource_type := JTF_VARCHAR2_TABLE_100();
1823: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1824: l_resource_class := JTF_VARCHAR2_TABLE_100();
1825:
1826: IF l_con_preferred_engineers_tbl.count > 0 THEN

Line 1823: l_primary_flag := JTF_VARCHAR2_TABLE_100();

1819:
1820: ELSE
1821: l_engineer_id := JTF_NUMBER_TABLE();
1822: l_resource_type := JTF_VARCHAR2_TABLE_100();
1823: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1824: l_resource_class := JTF_VARCHAR2_TABLE_100();
1825:
1826: IF l_con_preferred_engineers_tbl.count > 0 THEN
1827: l_engineer_id.extend(l_con_preferred_engineers_tbl.count);

Line 1824: l_resource_class := JTF_VARCHAR2_TABLE_100();

1820: ELSE
1821: l_engineer_id := JTF_NUMBER_TABLE();
1822: l_resource_type := JTF_VARCHAR2_TABLE_100();
1823: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1824: l_resource_class := JTF_VARCHAR2_TABLE_100();
1825:
1826: IF l_con_preferred_engineers_tbl.count > 0 THEN
1827: l_engineer_id.extend(l_con_preferred_engineers_tbl.count);
1828: l_resource_type.extend(l_con_preferred_engineers_tbl.count);

Line 2111: l_resource_type JTF_VARCHAR2_TABLE_100;

2107: l_msg_count NUMBER;
2108: l_msg_data VARCHAR2(2000);
2109:
2110: l_engineer_id JTF_NUMBER_TABLE;
2111: l_resource_type JTF_VARCHAR2_TABLE_100;
2112:
2113: l_current_record INTEGER := 0;
2114: l_current_rec INTEGER := 0;
2115: l_pref_record INTEGER := 0;

Line 2660: l_resource_type JTF_VARCHAR2_TABLE_100;

2656: l_assign_resources_sr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
2657: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2658:
2659: l_engineer_id JTF_NUMBER_TABLE;
2660: l_resource_type JTF_VARCHAR2_TABLE_100;
2661:
2662: l_return_status VARCHAR2(10);
2663: l_msg_count NUMBER;
2664: l_msg_data VARCHAR2(2000);