DBA Data[Home] [Help]

APPS.JTF_ASSIGN_PUB dependencies on JTF_NUMBER_TABLE

Line 227: l_engineer_id IN JTF_NUMBER_TABLE,

223: /* Procedure to write back data from Tables to Table Type variable */
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

Line 1725: l_engineer_id JTF_NUMBER_TABLE;

1721: l_return_status VARCHAR2(10);
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:

Line 1805: l_engineer_id JTF_NUMBER_TABLE;

1801: '
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);

Line 1852: l_engineer_id := JTF_NUMBER_TABLE();

1848: INTO local variables to process */
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:

Line 1858: l_engineer_id := JTF_NUMBER_TABLE();

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();
1860: l_primary_flag := JTF_VARCHAR2_TABLE_100();
1861: l_resource_class := JTF_VARCHAR2_TABLE_100();
1862:

Line 2147: l_engineer_id JTF_NUMBER_TABLE;

2143: l_return_status VARCHAR2(10);
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;

Line 2696: l_engineer_id JTF_NUMBER_TABLE;

2692: l_assign_resources_rec JTF_TERRITORY_PUB.JTF_Task_Rec_Type;
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;