APPS.IBE_M_IBC_INT_PVT dependencies on IBC_ASSOCIATIONS

Line 359: FROM ibc_associations

355: l_temp NUMBER;
356: CURSOR c_get_assoc_objects(c_content_item_id NUMBER,
357: c_label_code VARCHAR2) IS
358: SELECT ASSOCIATED_OBJECT_VAL1
359: FROM ibc_associations
360: WHERE content_item_id = c_content_item_id
361: AND association_type_code = c_label_code;
362:
363: CURSOR c_label_flag(c_content_item_id NUMBER,

Line 373: FROM IBC_ASSOCIATIONS

369:
370: CURSOR c_associations_flag(c_content_item_id NUMBER,
371: c_association_type_code VARCHAR2) IS
372: SELECT 1
373: FROM IBC_ASSOCIATIONS
374: WHERE content_item_id = c_content_item_id
375: AND association_type_code = c_association_type_code;
376:
377: CURSOR c_association_flag(c_content_item_id NUMBER,

Line 380: FROM IBC_ASSOCIATIONS

376:
377: CURSOR c_association_flag(c_content_item_id NUMBER,
378: c_association_type_code VARCHAR2, c_assoc_object VARCHAR2) IS
379: SELECT 1
380: FROM IBC_ASSOCIATIONS
381: WHERE content_item_id = c_content_item_id
382: AND association_type_code = c_association_type_code
383: AND associated_object_val1 = c_assoc_object;
384:

Line 518: IBE_UTIL.debug('Calling Ibc_Associations_Grp.Move_Associations');

514: IBE_UTIL.debug('l_move_flag = '||l_move_flag);
515: END IF;
516: IF (l_move_flag = 'Y') THEN
517: IF (l_debug = 'Y') THEN
518: IBE_UTIL.debug('Calling Ibc_Associations_Grp.Move_Associations');
519: END IF;
520: Ibc_Associations_Grp.Move_Associations (
521: p_api_version => 1.0,
522: p_init_msg_list => FND_API.G_FALSE,

Line 520: Ibc_Associations_Grp.Move_Associations (

516: IF (l_move_flag = 'Y') THEN
517: IF (l_debug = 'Y') THEN
518: IBE_UTIL.debug('Calling Ibc_Associations_Grp.Move_Associations');
519: END IF;
520: Ibc_Associations_Grp.Move_Associations (
521: p_api_version => 1.0,
522: p_init_msg_list => FND_API.G_FALSE,
523: p_commit => FND_API.G_FALSE,
524: p_old_content_item_ids => l_old_item_ids,

Line 536: IBE_UTIL.debug('After calling Ibc_Associations_Grp.Move_Associations:'

532: x_return_status => x_return_status,
533: x_msg_count => x_msg_count,
534: x_msg_data => x_msg_data);
535: IF (l_debug = 'Y') THEN
536: IBE_UTIL.debug('After calling Ibc_Associations_Grp.Move_Associations:'
537: ||x_return_status);
538: END IF;
539: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
540: IF (l_debug = 'Y') THEN

Line 541: IBE_UTIL.debug('Error in Ibc_Associations_Grp.Move_Associations');

537: ||x_return_status);
538: END IF;
539: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
540: IF (l_debug = 'Y') THEN
541: IBE_UTIL.debug('Error in Ibc_Associations_Grp.Move_Associations');
542: for i in 1..x_msg_count loop
543: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
544: IBE_UTIL.debug(l_msg_data);
545: end loop;

Line 550: IBE_UTIL.debug('Error in Ibc_Associations_Grp.Move_Associations');

546: END IF;
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
549: IF (l_debug = 'Y') THEN
550: IBE_UTIL.debug('Error in Ibc_Associations_Grp.Move_Associations');
551: for i in 1..x_msg_count loop
552: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
553: IBE_UTIL.debug(l_msg_data);
554: end loop;

Line 873: FROM IBC_ASSOCIATIONS

869: l_temp NUMBER;
870: CURSOR c_associations_flag(c_content_item_id NUMBER,
871: c_association_type_code VARCHAR2) IS
872: SELECT 1
873: FROM IBC_ASSOCIATIONS
874: WHERE content_item_id = c_content_item_id
875: AND association_type_code = c_association_type_code;
876:
877: l_debug VARCHAR2(1);