DBA Data[Home] [Help]

APPS.AMS_ADI_CAMP_SCHED_PVT dependencies on JTF_NUMBER_TABLE

Line 517: x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,

513: p_placement_title IN VARCHAR2,
514: p_activity_id IN NUMBER,
515: p_schedule_id IN NUMBER,
516: x_placement_mp_id OUT NOCOPY NUMBER,
517: x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
518: x_msg_count OUT NOCOPY NUMBER,
519: x_msg_data OUT NOCOPY VARCHAR2,
520: x_return_status OUT NOCOPY VARCHAR2
521: );

Line 585: l_placement_citem_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

581: l_assoc_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
582: l_assoc_objects1 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
583:
584: l_placement_mp_id NUMBER;
585: l_placement_citem_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
586: l_ctd_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
587: l_tmp_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
588: l_activity_type_code VARCHAR2(30);
589: l_ctd_id NUMBER;

Line 586: l_ctd_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

582: l_assoc_objects1 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
583:
584: l_placement_mp_id NUMBER;
585: l_placement_citem_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
586: l_ctd_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
587: l_tmp_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
588: l_activity_type_code VARCHAR2(30);
589: l_ctd_id NUMBER;
590: l_primary_flag VARCHAR2(1);

Line 587: l_tmp_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

583:
584: l_placement_mp_id NUMBER;
585: l_placement_citem_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
586: l_ctd_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
587: l_tmp_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
588: l_activity_type_code VARCHAR2(30);
589: l_ctd_id NUMBER;
590: l_primary_flag VARCHAR2(1);
591: l_ctd_act_product_id NUMBER;

Line 1435: l_placement_citem_id_tbl := JTF_NUMBER_TABLE();

1431: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1432: ' Now calling Associate_Web_Planner API');
1433: END IF;
1434:
1435: l_placement_citem_id_tbl := JTF_NUMBER_TABLE();
1436:
1437: Associate_Web_Planner(
1438: p_application_id => l_wpAppIds(i),
1439: p_placement_id => l_wpPlceIds(i),

Line 1561: l_tmp_tbl := JTF_NUMBER_TABLE();

1557: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1558: ' Now calling AMS_ADI_CTD_PVT.CREATE_CTDS API');
1559: END IF;
1560:
1561: l_tmp_tbl := JTF_NUMBER_TABLE();
1562: l_tmp_tbl.extend;
1563: l_tmp_tbl(1) := -1;
1564:
1565: AMS_ADI_CTD_PVT.CREATE_CTDS(

Line 2065: x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,

2061: p_placement_title IN VARCHAR2,
2062: p_activity_id IN NUMBER,
2063: p_schedule_id IN NUMBER,
2064: x_placement_mp_id OUT NOCOPY NUMBER,
2065: x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
2066: x_msg_count OUT NOCOPY NUMBER,
2067: x_msg_data OUT NOCOPY VARCHAR2,
2068: x_return_status OUT NOCOPY VARCHAR2
2069: )