APPS.AMS_WEBMARKETING_PVT dependencies on JTF_NUMBER_TABLE

Line 119: x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,

115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_placement_mp_id IN NUMBER,
118: p_web_mp_rec IN web_mp_track_rec_type := g_miss_web_mp_track_rec,
119: x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
120: p_content_item_id IN NUMBER,
121: p_citem_version_id IN NUMBER,
122: p_association_type IN VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,

Line 131: l_placement_citem_id_tbl JTF_NUMBER_TABLE;

127:
128: L_API_NAME CONSTANT VARCHAR2(30) := 'WEBMARKETING_PLCE_CITEMS';
129: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
130: l_object_version_number NUMBER := 1;
131: l_placement_citem_id_tbl JTF_NUMBER_TABLE;
132: l_placement_citem_count NUMBER;
133: l_citem_ver_id NUMBER;
134: l_placement_citem_id NUMBER;
135: l_assoc_object1 VARCHAR2(30);

Line 215: l_placement_citem_id_tbl := JTF_NUMBER_TABLE();

211: FETCH c_citem_ver_id INTO l_citem_ver_id;
212: CLOSE c_citem_ver_id;
213:
214:
215: l_placement_citem_id_tbl := JTF_NUMBER_TABLE();
216: x_placement_citem_id_tbl := JTF_NUMBER_TABLE();
217: FOR citem_rec IN c_plce_citems ( l_citem_ver_id)
218: LOOP
219: -- Populate the Tables Now

Line 216: x_placement_citem_id_tbl := JTF_NUMBER_TABLE();

212: CLOSE c_citem_ver_id;
213:
214:
215: l_placement_citem_id_tbl := JTF_NUMBER_TABLE();
216: x_placement_citem_id_tbl := JTF_NUMBER_TABLE();
217: FOR citem_rec IN c_plce_citems ( l_citem_ver_id)
218: LOOP
219: -- Populate the Tables Now
220: -- Call Table Handlers (AMS_WEB_PLCE_CITEM_ASSOC )

Line 355: -- Populate the JTF Number Table

351: THEN
352: COMMIT WORK;
353: END IF;
354:
355: -- Populate the JTF Number Table
356: /*
357:
358: l_placement_citem_id_tbl := JTF_NUMBER_TABLE();
359: for i in 1..l_placement_citem_id_tbl.COUNT

Line 358: l_placement_citem_id_tbl := JTF_NUMBER_TABLE();

354:
355: -- Populate the JTF Number Table
356: /*
357:
358: l_placement_citem_id_tbl := JTF_NUMBER_TABLE();
359: for i in 1..l_placement_citem_id_tbl.COUNT
360: loop
361: x_placement_citem_id_tbl.EXTEND;
362: x_placement_citem_id_tbl(i) := l_placement_citem_id_tbl(i);

Line 673: x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,

669: p_commit IN VARCHAR2 := FND_API.G_FALSE,
670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
671: p_web_mp_rec IN web_mp_track_rec_type := g_miss_web_mp_track_rec,
672: x_placement_mp_id OUT NOCOPY NUMBER,
673: x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
674: x_msg_count OUT NOCOPY NUMBER,
675: x_msg_data OUT NOCOPY VARCHAR2,
676: x_return_status OUT NOCOPY VARCHAR2
677: ) IS

Line 689: l_placement_citem_id_tbl JTF_NUMBER_TABLE;

685: l_rowid VARCHAR2(100);
686: l_content_type_code VARCHAR2(100);
687: L_CITEM_VERSION_ID NUMBER;
688: l_publish_flag Varchar2(1);
689: l_placement_citem_id_tbl JTF_NUMBER_TABLE;
690:
691: CURSOR c_mp_id IS
692: SELECT AMS_WEB_PLCE_MP_B_S.NEXTVAL
693: FROM dual;