APPS.EAM_ACTIVITYSUPN_PUB dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 611: /* For checking the association_id exists in the mtl_eam_asset_activities table */

607: RETURN false;
608: END Validate_ParentChildAssets ;
609:
610:
611: /* For checking the association_id exists in the mtl_eam_asset_activities table */
612: FUNCTION Validate_AssociationId (p_association_id NUMBER)
613: RETURN boolean
614: IS
615: l_status varchar2(10);

Line 619: FROM mtl_eam_asset_activities

615: l_status varchar2(10);
616: BEGIN
617:
618: SELECT 'Exists' INTO l_status
619: FROM mtl_eam_asset_activities
620: WHERE ACTIVITY_ASSOCIATION_ID = p_association_id;
621:
622: if (l_status = 'Exists') then
623: RETURN true;

Line 663: FROM mtl_eam_asset_activities

659:
660: IF p_tmpl_flag = 'Y' THEN
661: SELECT inventory_item_id , organization_id , tmpl_flag
662: INTO l_parent_assoc , l_parent_organization_id, l_tmpl_flag_p
663: FROM mtl_eam_asset_activities
664: WHERE activity_association_id = p_parent_association_id;
665:
666: SELECT inventory_item_id , organization_id , tmpl_flag
667: INTO l_child_assoc , l_child_organization_id, l_tmpl_flag_c

Line 668: FROM mtl_eam_asset_activities

664: WHERE activity_association_id = p_parent_association_id;
665:
666: SELECT inventory_item_id , organization_id , tmpl_flag
667: INTO l_child_assoc , l_child_organization_id, l_tmpl_flag_c
668: FROM mtl_eam_asset_activities
669: WHERE activity_association_id = p_child_association_id;
670: ELSE
671: SELECT inventory_item_id , serial_number , organization_id, tmpl_flag
672: INTO l_parent_assoc , l_parent_ser_num , l_parent_organization_id, l_tmpl_flag_p

Line 673: FROM mtl_eam_asset_activities

669: WHERE activity_association_id = p_child_association_id;
670: ELSE
671: SELECT inventory_item_id , serial_number , organization_id, tmpl_flag
672: INTO l_parent_assoc , l_parent_ser_num , l_parent_organization_id, l_tmpl_flag_p
673: FROM mtl_eam_asset_activities
674: WHERE activity_association_id = p_parent_association_id;
675:
676: SELECT inventory_item_id , serial_number , organization_id, tmpl_flag
677: INTO l_child_assoc , l_child_ser_num , l_child_organization_id, l_tmpl_flag_c

Line 678: FROM mtl_eam_asset_activities

674: WHERE activity_association_id = p_parent_association_id;
675:
676: SELECT inventory_item_id , serial_number , organization_id, tmpl_flag
677: INTO l_child_assoc , l_child_ser_num , l_child_organization_id, l_tmpl_flag_c
678: FROM mtl_eam_asset_activities
679: WHERE activity_association_id = p_child_association_id;
680: END IF;
681:
682: IF (l_parent_assoc = l_child_assoc AND

Line 710: from mtl_eam_asset_activities

706: */
707:
708: select maintenance_object_id, maintenance_object_type, tmpl_flag
709: into l_parent_object_id, l_parent_object_type, l_tmpl_flag_p
710: from mtl_eam_asset_activities
711: WHERE activity_association_id = p_parent_association_id;
712:
713: select maintenance_object_id, maintenance_object_type, tmpl_flag
714: into l_child_object_id, l_child_object_type, l_tmpl_flag_c

Line 715: from mtl_eam_asset_activities

711: WHERE activity_association_id = p_parent_association_id;
712:
713: select maintenance_object_id, maintenance_object_type, tmpl_flag
714: into l_child_object_id, l_child_object_type, l_tmpl_flag_c
715: from mtl_eam_asset_activities
716: WHERE activity_association_id = p_child_association_id;
717:
718:
719: IF (((l_tmpl_flag_p IS NULL OR l_tmpl_flag_p IN ('N'))